- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
PreparedStatement pst = conn.prepareStatement(
"SELECT * FROM employeeskill, employee " +
"WHERE employee.id_EmployeeDetail = employeeskill.id_EmployeeDetail " +
"AND employeeskill.name = ?");
pst.setString(1, employeeSkillName);
ResultSet res = pst.executeQuery();
while (res.next()){
Employee empl = new Employee(res.getLong(6), res.getString(7),
res.getString(8), res.getString(9), res.getString(10),
res.getString(11), res.getString(12), res.getLong(13));
list.add(empl);