81,092
社区成员
发帖
与我相关
我的任务
分享
public List findByProperty(String propertyName, Object value) {
log.debug("finding CmHoliday instance with property: " + propertyName
+ ", value: " + value);
try {
String queryString = "from CmHoliday as model where model."
+ propertyName + "= ?";
return getHibernateTemplate().find(queryString, value);
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
}
/**
* 根据节假日编号、开始日期和截止日期模糊查询
* @param holidayId
* @param holidayStartingTime0
* @param holidayStartingTime1
* @param holidayDeadLine0
* @param holidayDeadLine1
* @return List
*/
public List findByCondition(String holidayId, String holidayStartingTime0, String holidayStartingTime1, String holidayDeadLine0, String holidayDeadLine1) {
DetachedCriteria detachedCriteria = DetachedCriteria.forClass(CmHoliday.class);
detachedCriteria.add(Restrictions.like("holidayId", holidayId, MatchMode.ANYWHERE));
if(holidayStartingTime0 != null && !holidayStartingTime0.equals("")) {
Date holidayStartingTime = Date.valueOf(holidayStartingTime0);
detachedCriteria.add(Restrictions.ge("holidayStartingTime", holidayStartingTime));
}
if(holidayStartingTime1 != null && !holidayStartingTime1.equals("")) {
Date holidayStartingTime = Date.valueOf(holidayStartingTime1);
detachedCriteria.add(Restrictions.le("holidayStartingTime", holidayStartingTime));
}
if(holidayDeadLine0 != null && !holidayDeadLine0.equals("")) {
Date holidayDeadLine = Date.valueOf(holidayDeadLine0);
detachedCriteria.add(Restrictions.ge("holidayDeadLine", holidayDeadLine));
}
if(holidayDeadLine1 != null && !holidayDeadLine1.equals("")) {
Date holidayDeadLine = Date.valueOf(holidayDeadLine1);
detachedCriteria.add(Restrictions.le("holidayDeadLine", holidayDeadLine));
}
List searchedList = findByCriteria(detachedCriteria);
return searchedList;
}