jsp+dao层
迷蒙的青色 2018-05-16 06:51:53 java类
Talent
private Integer id;
private String name;
private String study;
private Integer age;
private String sex;
private String jiguan;
private Integer qwxj;
private String qzyx;
private String phone;
private String email;
private String photo;
private String resume;
private Myproject myprojects;
myproject类
private Integer projectid;
private String cname;
private Integer zprs;
private String workplace;
private String joblb;
private Integer hxrs;
private Date cdate;
private List<Talent> hxr;
都已经省set,,get.
数据层;
@Override
public List<Talent> findAllSplithxr(Integer mid, Integer currentPage, Integer lineSize, String column,
String keyWord) throws Exception {
List<Talent> all = new ArrayList<Talent>();
Talent vo = null;
String sql = "select t.id,t.name,t.study,t.age,t.sex,t.jiguan,t.qwxj,t.qzyx,t.phone,t.email,t.photo,t.resume,m.projectid,m.cname "
+ "from talent t,myproject m" + " where m.projectid=? and t." + column + " like ?"
+ " and t.projectid=m.projectid limit ?,?";
this.pstmt = this.conn.prepareStatement(sql);
this.pstmt.setInt(1, mid);
this.pstmt.setString(2, "%" + keyWord + "%");
this.pstmt.setInt(3, currentPage * lineSize);
this.pstmt.setInt(4, lineSize);
ResultSet rs = this.pstmt.executeQuery();
while (rs.next()) {
vo = new Talent();
vo.setId(rs.getInt(1));
vo.setName(rs.getString(2));
vo.setStudy(rs.getString(3));
vo.setAge(rs.getInt(4));
vo.setSex(rs.getString(5));
vo.setJiguan(rs.getString(6));
vo.setQwxj(rs.getInt(7));
vo.setQzyx(rs.getString(8));
vo.setPhone(rs.getString(9));
vo.setEmail(rs.getString(10));
vo.setPhoto(rs.getString(11));
vo.setResume(rs.getString(12));
Myproject myjects = new Myproject();
myjects.setProjectid(rs.getInt(13));
myjects.setCname(rs.getString(14));
vo.setMyprojects(myjects);
all.add(vo);
}
return all;
}
@Override
public Talent findByIdDetails(Integer id) throws Exception {
Talent vo = null;
String sql = "select t.id,t.name,t.study,t.age,t.sex,t.jiguan,t.qwxj,t.qzyx,t.phone,t.email,t.photo,,t.resume,m.projectid,m.cname "
+ "from talent t,myproject m" + "where t.id=? and t.projectid=m.projectid";
this.pstmt = this.conn.prepareStatement(sql);
this.pstmt.setInt(1, id);
ResultSet rs = this.pstmt.executeQuery();
if (rs.next()) {
vo = new Talent();
vo.setId(rs.getInt(1));
vo.setName(rs.getString(2));
vo.setStudy(rs.getString(3));
vo.setAge(rs.getInt(4));
vo.setSex(rs.getString(5));
vo.setJiguan(rs.getString(6));
vo.setQwxj(rs.getInt(7));
vo.setQzyx(rs.getString(8));
vo.setPhone(rs.getString(9));
vo.setEmail(rs.getString(10));
vo.setPhoto(rs.getString(11));
vo.setResume(rs.getString(12));
Myproject mpj = new Myproject();
mpj.setProjectid(rs.getInt(13));
mpj.setCname(rs.getString(14));
vo.setMyprojects(mpj);
}
return vo;
}
service层
@Override
public Myproject show(Integer mid, Integer currentPage, Integer lineSize, String column, String keyWord)
throws Exception {
try {
Myproject pmjects = DAOFactory.getMyprojectInstance(this.dbc.getConnection()).findByIdDetails(mid);
if (pmjects != null) {
pmjects.setHxr(DAOFactory.getITalentInstance(this.dbc.getConnection()).findAllSplithxr(mid, currentPage,
lineSize, column, keyWord));
}
return pmjects;
} catch (Exception e) {
throw e;
} finally {
this.dbc.close();
}
调用
Myproject mp=ServiceFactory.getIMyprojectInstance().show(1111, 0, 10, "name", names);
//System.out.println(mp.getCname());
//System.out.println(mp.getHxr());
List<Talent> all=mp.getHxr(); //这个为空?
这是什么原因啊。求解