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; }