VO中的字段
Emp
private String id;
private String e_id;
private String e_head;
private String e_name;
private String e_sex;
private Dep d_id;
private String e_tell;
private String e_address;
Dep
private String d_id;
private String d_name;
DAO中的代码
public List<中的代码Emp> queryAllEmp() {
List<Emp> emps = new ArrayList<Emp>();
Connection conn = null;
Statement st = null;
ResultSet rs = null;
String sql = "select id,e_id,e_head,e_name,e_sex,dep.d_name,e_tell,e_address from emp,dep" +
"where emp.d_id=dep.d_id";
try {
conn = DBConnection.getInstance().getConnection();
st = conn.createStatement();
rs = st.executeQuery(sql);
while (rs.next()) {
Emp emp = new Emp();
emp.setId(rs.getString("id"));
emp.setE_id(rs.getString("e_id"));
emp.setE_head(rs.getString("e_head"));
emp.setE_name(rs.getString("e_name"));
emp.setE_sex(rs.getString("e_sex"));
emp.setD_id(rs.getString("d_id"));
emp.setE_tell(rs.getString("e_tell"));
emp.setE_address(rs.getString("e_address"));
emps.add(emp);
}
} catch (Exception e) {
e.printStackTrace();
} finally{
DBConnection.getInstance().close(rs, st, conn);
}
return emps;
}
想查出emp里面的字段和外键d_id对应的d_name
求指教怎么改,应该是什么样的一个思路