new method in MyDatabase

    public String[] searchMember(String Name){
        String[] Name3 = new String[1000];
        try{
            Class.forName("com.mysql.jdbc.Driver");
            String name = "it_56070014";
            String password = "4a3DskLl2b";
            String url = "jdbc:mysql://database.it.kmitl.ac.th:3306/it_56070014?useUnicode=true&characterEncoding=UTF-8";
            Connection conn = DriverManager.getConnection(url, name, password);
            Statement stmt = conn.createStatement();
            String[] Name2 = Name.split(" ");
            String sql="";
            if(Name2.length==2){
                sql = "SELECT DISTINCT members.member_id ,members.first_name, members.last_name, members.email ,members.degree ,members.phone from members "
                       + "INNER JOIN accounts "
                       + "on members.member_id = accounts.member_id "
                       + "where (accounts.role='teacher' "
                       + "OR accounts.role='dean') "
                       + "AND ( "
                       + "first_name like '%" + Name2[0] + "%' "
                       + "AND last_name like '%" + Name2[1] + "%');";


            }else if(Name2.length==1){
                sql = "SELECT DISTINCT members.member_id ,members.first_name, members.last_name, members.email ,members.degree ,members.phone from members "
                       + "INNER JOIN accounts "
                       + "on members.member_id = accounts.member_id "
                       + "where (accounts.role='teacher' "
                       + "OR accounts.role='dean') "
                       + "AND ( "
                       + "first_name like '%" + Name2[0] + "%' "
                       + "OR last_name like '%" + Name2[0] + "%');";
            }else{
                return null;
            }
            ResultSet rs = stmt.executeQuery(sql);
        int i=0;
        while(rs.next()){
            Name3[i] = rs.getString("first_name");
            Name3[i] += " ";
            Name3[i] += rs.getString("last_name");
            Name3[i] += " ";
            Name3[i] += rs.getString("degree");
            Name3[i] += " ";
            Name3[i] += rs.getString("email");
            Name3[i] += " ";
            Name3[i] += rs.getString("phone");
            i++;
        }
        }catch(Exception e){
            e.printStackTrace();
        }
        if(Name3.length==0){
            return null;
        }
        return Name3;
    }