public static ArrayList<Member> searchMemberByName(String name){
		
		try {
			   if(conn == null || conn.isClosed()){
			    conn = DatabaseConnection.getConnection();
			   }
			  } catch (SQLException e1) {
			   // TODO Auto-generated catch block
			   e1.printStackTrace();
			  }
		
		ArrayList<Member> members = new ArrayList<Member>();
		try {
			PreparedStatement stmnt = conn.prepareStatement("SELECT * FROM Members WHERE name LIKE ?");
			stmnt.setString(1, name + "%");
			ResultSet res;
			res = stmnt.executeQuery();
			while(res.next()){
				adress = AdressDAO.getAdressByID(res.getInt("address_id"));
				member = new Member(res.getString("name"),res.getString("first_name"),res.getString("phone_num"),adress,res.getInt("member_id"));
				members.add(member);
			}
		}
			catch(SQLException e){
				e.printStackTrace();
				
				
			}
		
		return members;
	}