public static List<Employee> getData(Connection con, ResultSet rs) throws Exception {
List<Employee> list = new ArrayList<Employee>();
try {
con.setAutoCommit(false);
while (rs.next()) {
int employeeId = rs.getInt("employeeId");
String employeeNo = rs.getString("employeeNo");
String name = rs.getString("name");
String sex = rs.getString("sex");
Date birthday = rs.getDate("birthday");
String nationality = rs.getString("nationality");
String education = rs.getString("education");
String profession = rs.getString("profession");
String departmentNameSrc = rs.getString("departmentName");
String position = rs.getString("position");
float baseMoney = rs.getFloat("baseMoney");
float overtime = rs.getFloat("overtime");
float age = rs.getFloat("age");
float check1 = rs.getFloat("check1");
float absent = rs.getFloat("absent");
float safety = rs.getFloat("safety");
Employee employee = new Employee();
employee.setEmployeeId(employeeId);
employee.setEmployeeNo(employeeNo);
employee.setName(name);
employee.setSex(sex);
employee.setBirthday(birthday);
employee.setNationality(nationality);
employee.setEducation(education);
employee.setProfession(profession);
employee.setDepartmentNameSrc(departmentNameSrc);
employee.setPosition(position);
employee.setBaseMoney(baseMoney);
employee.setOvertime(overtime);
employee.setAge(age);
employee.setCheck1(check1);
employee.setAbsent(absent);
employee.setSafety(safety);
list.add(employee);
}
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
