![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
hql
rcm5433
这个作者很懒,什么都没留下…
展开
-
多表关联-java层出来
一种方法:无值传递(交给java处理)[code="java"]/** * 根据教师状态查询教师信息列表(可多状态) */ @Override public PaginationSupport getTeacherListByTypes( LinkedHashMap sort, int page, int countPerPage, Integer[] ...2013-11-29 11:07:53 · 169 阅读 · 0 评论 -
多表关联(二)-hql语句查询
[code="java"]String hql="select new com.sinosoft.education.prototype.TeacherInfoBean(" + "ti.teacherId," + "ti.teacherName," + "(select min(pt.teacSchoolStartTime) from ti.sysEduProje...2013-11-29 11:13:48 · 330 阅读 · 0 评论 -
hql语句-根据场所ID查找所有子场所
[code="java"]/** * 根据场所ID查找所有子场所 * @return */ @SuppressWarnings("unchecked") public List findAllParentSysPlace(Long siteId,Integer siteDiffType){ String hql = "select distinct...原创 2013-12-10 23:24:28 · 316 阅读 · 0 评论 -
hql纯sql语句控制-分页
[code="java"]public List find(final String sql,final String[] fields, final Object[] conditionValues,final int page,int prePage){ List list = getHibernateTemplate().executeFind(new Hibe...原创 2013-12-10 23:26:10 · 79 阅读 · 0 评论 -
DetachedCriteria多对多
DetachedCriteria deta = DetachedCriteria.forClass(SysConfTeamInf.class);deta.add(Restrictions.ne("teamConfStatus",ConstantsUtils.DELETE_STATE));deta.createAlias("需要关联的对象", "别名", DetachedCriteria....原创 2014-06-26 10:45:40 · 111 阅读 · 0 评论 -
hql语句对某个字段进行查询并取出最大值
String hql = " select max(cmr.modifyBelong) from SysConfModifyRecord cmr ";原创 2014-02-21 14:14:59 · 918 阅读 · 0 评论