How to use JDBC to join and store values in entity

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.LinkedList;
import java.util.List;

import co.jp.******.jdbc.entites.EmployeeBasic;
import co.jp.aaaaaaa.jdbc.entites.EmployeeSkill;

public class AppEntry {

public static void main(String[]args) {
    try{
        connectionTest();
    } catch(ClassNotFoundException | SQLExceptione){
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
}

public static void connectionTest()throws ClassNotFoundException, SQLException {
    Connection conn = null;
    Class.forName("org.postgresql.Driver");
    conn=DriverManager.getConnection("jdbc:postgresql://localhost:5432/test", "postgres", "postgres");
    // insertTest(conn);
    selectTest(conn);

}

public static List <EmployeeBasic>selectTest(Connection conn)throwsSQLException{
    Statement stmt = null;
    ResultSetters = null;

    stmt = conn.createStatement();
    rs = stmt.executeQuery("select\r\n" + 
            US>"*\r\n" + 
            "from\r\n" + 
            "employee_basic\r\n" + 
            "left join\r\n" + 
            US>"employee_skill\r\n" + 
            US>"on\r\n" + 
            "employee_basic.employee_no=employee_skill.employee_no\r\n";

    List<EmployeeBasic>result=new ArrayList<>();

    EmployeeBasic preEntity = null;
    EmployeeBasicity=null;
    while(rs.next()){
        if(preEntity==null){
            entity=new EmployeeBasic();
            entity.employeeNo=rs.getLong("employee_no");
            entity.employeeName=rs.getString("employee_name");
            result.add(entity);
            preEntity=entity;
        } else if(preEntity.employeeNo!=rs.getLong("employee_no")){
            entity=new EmployeeBasic();
            entity.employeeNo=rs.getLong("employee_no");
            entity.employeeName=rs.getString("employee_name");
            result.add(entity);
            preEntity=entity;
        }
        EmployeeSkill skill=new EmployeeSkill();
        skill.skillName=rs.getString("skill_name");
        entity.skills.add(skill);
    }


    return result;
}
}

package co.jp.*******

import java.util.ArrayList;
import java.util.List;

public class EmployeeBasic {

public long employeeNo;
public String employeeName;


publicList<EmployeeSkill>skills=new ArrayList<>();
}

create table employee_basic(
employee_no bigint,
employee_name varchar(32),
primary key (employee_no)
)


create table employee_skill(
   employee_skill_lnk serial,
   employee_no bigint,
   skill_name varchar(32),
   primary key(employee_skill_lnk)
)

insert into employee_basic values(1, 'user1')
insert into employee_basic values(2, 'user2')
insert into employee_skill(employee_no, skill_name) values(1,'sql')
insert into employee_skill(employee_no, skill_name) values(1, 'java')
insert into employee_skill(employee_no, skill_name) values(1, 'cpp')
insert into employee_skill(employee_no, skill_name) values(1,'c#')

select
*
from
employee_basic
left join
employee_skill
on
employee_basic.employee_no=employee_skill.employee_no