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(); //这个为空?
这是什么原因啊。求解
...全文
743 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
xwn_2016 2018-05-17
  • 打赏
  • 举报
回复
ResultSet rs = this.pstmt.executeQuery(); 改成 ResultSet rs = this.pstmt.execute();试试
YUDG 2018-05-17
  • 打赏
  • 举报
回复
SQL语句错了,你看后台打印出来什么了。你把sql语句打印一下,然后用数据库软件执行一下,看看有没有结果~
迷蒙的青色 2018-05-17
  • 打赏
  • 举报
回复
二楼我的sql语句执行就是我想要的结果

81,090

社区成员

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧