Hibernate
来源:互联网 发布:如何安装python 编辑:程序博客网 时间:2024/06/04 19:58
以前用sql实现联合查询是非常简单的事,只需要写sql语句就可以,第一次遇到hibernate要实现多表联合查询的时候还楞了一下。最后看了下资料,才恍然大悟,hibernate实现多表联合查询跟SQL没多大差别。
下面 是查询的一段代码:
Session session = getHibernateTemplate().getSessionFactory() .getCurrentSession(); StringBuffer sb = new StringBuffer(" select user.username,user.truename,user.sex,user.idnum,user.level,s.sumScore from Score as s,Examuser as user where s.id.userId = user.id "); if(score != null){ if(score.getExamId()!=null && !"".equals(score.getExamId()) && !"null".equals(score.getExamId())){ sb.append(" and s.examId =:examId "); } if(score.getExamPlace()!=null && !"".equals(score.getExamPlace()) && !"null".equals(score.getExamPlace())){ sb.append(" and s.examPlace =:examPlace "); } if(score.getUsername()!=null && !"".equals(score.getUsername()) && !"null".equals(score.getUsername())){ sb.append(" and s.username like:username "); } } sb.append(" order by s.sumScore desc "); Query q = session.createQuery(sb.toString()); if(score != null){ if(score.getExamId()!=null && !"".equals(score.getExamId()) && !"null".equals(score.getExamId())){ q.setParameter("examId",score.getExamId()); } if(score.getExamPlace()!=null && !"".equals(score.getExamPlace()) && !"null".equals(score.getExamPlace())){ q.setParameter("examPlace",score.getExamPlace()); } if(score.getUsername()!=null && !"".equals(score.getUsername()) && !"null".equals(score.getUsername())){ q.setParameter("username","%"+score.getUsername()+"%"); } } List list = q.list();需要将查询的结果集 进行一下转换:
List stuList = scoreService.findAllScore(queryScore, null); // 返回的结果集 if(stuList != null && stuList.size()>0){ list = new LinkedList(); StudentScore st; for(int i = 0; i < stuList.size();i++){ st = new StudentScore(); Object[] object = (Object[])stuList.get(i);// 每行记录不在是一个对象 而是一个数组 String userId = (String)object[0]; String username = (String)object[1]; String truename = (String)object[2]; String sex = (String)object[3]; String idnum = (String)object[4]; String level = (String)object[5]; Double sumScore = Double.parseDouble(String.valueOf(object[6])); String paperId = (String)object[7]; // 重新封装在一个javabean里面 st.setUserId(userId); st.setUsername(username); st.setTruename(truename); st.setIdnum(idnum); st.setLevel(DictSwitch.getValue("DICT_LEVEL",level)); st.setSex(DictSwitch.getValue("DICT_SEX",sex)); st.setPaperId(paperId); st.setSumScore(sumScore); st.setExamplace(DictSwitch.getValue("DICT_EXAMSTATION",examplace)); list.add(st); // 最终封装在list中 传到前台。 }
0 0
- hibernate
- Hibernate
- Hibernate
- Hibernate
- hibernate
- hibernate
- Hibernate
- Hibernate
- Hibernate
- hibernate
- Hibernate
- Hibernate
- hibernate
- hibernate
- hibernate
- Hibernate
- Hibernate
- hibernate
- 亲身经历,Java面试题整理
- 硬盘 SMART 检测参数详解
- JAVA的Date类与Calendar类
- android开发建议
- 移动前端头部标签(HTML5 head meta)
- Hibernate
- Hadoop YARN的伪分布式安装
- Hybird App 之 JSBridge
- UVA11520(p31)----Fill the Square
- GNU C 与 ANSI C的区别
- Java连接数据库
- 【C++】C++发展和特性
- this project needs to migrate WTP metadata 异常解决办法
- 2015年工作总结——①名IT女的日常