/*
* Find all events in the given month and year.
* @param month - 0-11 (0 = January)
* @param year
*/
public List findEventsFor(int month, int year) {
List events = null;
try {
startOperation();
Date firstDay = DateUtils.newDate(month, 1, year);
Date lastDay = DateUtils.newDate(month + 1, 1, year);
StringBuffer sql = new StringBuffer();
sql.append("from Event event where 1=1 and event.startDate >= :firstDay and event.startDate < :lastDay");
Query query = getSession().createQuery(sql.toString()); query.setParameter("firstDay", firstDay);
query.setParameter("lastDay", lastDay);
events = query.list();
getTx().commit();
} catch (HibernateException e) {
handleException(e);
} finally {
HibernateFactory.close(getSession());
}
return events;
}如果在创建Query对象之后,在追加sql会有问题?
parameter username does not exist as a named parameter in
原因也很简单,对象创建完成之后再追加的sqlhibernate是不知道的,此种问题有遇到过的吗?麻烦给出解决方案,谢!StringBuffer sql = new StringBuffer();
sql.append("from Event event where 1=1 ");
Query query = getSession().createQuery(q);
if(null != startData && null != lastDay) {
sql.append("and event.startDate >= :firstDay and event.startDate < :lastDay");
}
query.setParameter("firstDay", firstDay);
query.setParameter("lastDay", lastDay);
解决方案 »
- java Ftp 断点续传下载,不同系统中文乱码和续传错误怎么解决
- 问一个捕获异常的问题
- 已经工作的大虾们进,给没工作的小弟一点建议(来者有分)
- 求助:struts2启动出现这些错误怎么解决啊??
- java设模式学习资源
- 中间层用Spring,持久层为hibernate,请问怎么取得数据库表中主键的值增长了多少(比如:mysql的auto_increment值)
- Struts2+Ext2+jsonplugin文件上传成功后,出现下载页面的问题
- 求webservice中返回值为自定义类数组的问题?[在线等,问题解决马上给分]
- DAO不能注入
- BugFree 是什么?
- fckeditor编辑器问题
- 关于spring的依赖注入 谢谢了
if(null != map) {
if(null != map.get("username") && !"".equals(map.get("username"))) {
queryString.append(" and u.username like :username");
mapString.put("username", "%" + map.get("username").toString() + "%");
}
}
Query query = hibernateTemplate.getSessionFactory().openSession().createQuery(queryString.toString());
Set<Entry<String, String>> set = mapString.entrySet();
Iterator<Entry<String, String>> iter = set.iterator();
while(iter.hasNext()) {
Entry<String, String> entry = iter.next();
String key = entry.getKey();
String value = entry.getValue();
query.setString(key, value);
}
@SuppressWarnings("unchecked")
List<User> userList = query.list();
StringBuffer sql = new StringBuffer();
sql.append("from Event event where 1=1 and event.startDate >= ? and event.startDate < ?);List list = this.getHibernateTemplate().find(queryString, new Object[]{firstDay,lastDay});
不知道行不,可以试一下