我有两节课
class Deptartment{
int deptid,String deptname;
List
现在我如何使用spring jdbc模板填充Department对象?
最佳答案
为了帮助Sean Patrick Floyd,这是他的解决方案,只需一个查询:
final MapsqlException {
Integer deptId = rs.getInt("deptid");
Department d = (Department) departments.get(deptId);
if (d == null) {
String deptName = rs.getString("deptname");
d = new Department();
d.setDeptId(deptId);
d.setDeptName(deptName);
departments.put(deptId,d);
}
Employee employee = new Employee();
employee.setEmpId(rs.getInt("empid"));
employee.setEmpName(rs.getString("empname"));
employee.setDeptId(deptId);
d.getEmployees().add(employee);
return employee;
}
});
List
它恰好更短,更有效.