- 积分
- 919
最后登录1970-1-1
注册时间2009-8-19
在线时间 小时
好友
|
发表于 2010-5-15 20:37:56
|
显示全部楼层
public List getJobByCondition(final int curentPage, final int pageSize,
final String jobName, final int jobKindId, final Date jobSetTime,
final Date jobSetTime2) {
return this.getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
String hql = "from com.hhaccp.hr.entity.ConfigJob as jb where 1=1";
if (jobName != null && jobName != "") {
hql += " and jb.jobName like :jobName";
}
if (jobKindId != 0) {
hql += " and jb.configJobKind=:configJobKind";
}
if (jobSetTime != null && jobSetTime2 != null) {
hql += " and jb.jobSetTime between :jobSetTime and :jobSetTime2";
}
Query query = session.createQuery(hql);
if (jobName != null && jobName != "") {
query.setParameter("jobName", "%" + jobName + "%");
}
if (jobKindId != 0) {
query.setParameter("configJobKind", configJobKindDao
.findById(jobKindId));
}
if (jobSetTime != null && jobSetTime2 != null) {
query.setParameter("jobSetTime", jobSetTime);
query.setParameter("jobSetTime2", jobSetTime2);
}
if (pageSize != 0) {
int beginPage = pageSize * (curentPage - 1);
query.setFirstResult(beginPage);
query.setMaxResults(pageSize);
}
return query.list();
}
});
} |
|