List<Clerk> birthdayClerkList = null;
try{
String hql = "from Clerk cle where DATE_FORMAT(cle.birthday,'%m%d') >= " +
"DATE_FORMAT(NOW() ,'%m%d') and DATE_FORMAT(cle.birthday,'%m%d')" +
" <= DATE_FORMAT(DATE_ADD(NOW(),Interval 7 DAY) ,'%m%d')";
//Query query = getSession().createSQLQuery(hql,"cle",Clerk.class);
Query query = getSession().createSQLQuery(hql);
//Query query = getSession().createQuery(hql);
birthdayClerkList = query.list();
//birthdayClerkList = this.find(hql);
}catch (DataAccessException e) {
log.error("Error in getAllBirthdayClerkList.", e);
throw new DaoException("Error in getAllBirthdayClerkList.", e);
}
=============================================================
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: 7 near line 1, column 187 [from com.foundersoftware.ehr.object.hr.Clerk cle where DATE_FORMAT(birthday,'%m%d') >= DATE_FORMAT(NOW() ,'%m%d') and DATE_FORMAT(birthday,'%m%d') <= DATE_FORMAT(DATE_ADD(NOW(),Interval 7 DAY) ,'%m%d')]; nested exception is org.hibernate.hql.ast.QuerySyntaxError: unexpected token: 7 near line 1
报错的大概意思是语法错误
这个问题出在哪?是不是mysql中sql转换成hibernate中hql文的问题,特别是DATE_FORMAT在hibernate中不可使用?
try{
String hql = "from Clerk cle where DATE_FORMAT(cle.birthday,'%m%d') >= " +
"DATE_FORMAT(NOW() ,'%m%d') and DATE_FORMAT(cle.birthday,'%m%d')" +
" <= DATE_FORMAT(DATE_ADD(NOW(),Interval 7 DAY) ,'%m%d')";
//Query query = getSession().createSQLQuery(hql,"cle",Clerk.class);
Query query = getSession().createSQLQuery(hql);
//Query query = getSession().createQuery(hql);
birthdayClerkList = query.list();
//birthdayClerkList = this.find(hql);
}catch (DataAccessException e) {
log.error("Error in getAllBirthdayClerkList.", e);
throw new DaoException("Error in getAllBirthdayClerkList.", e);
}
=============================================================
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: 7 near line 1, column 187 [from com.foundersoftware.ehr.object.hr.Clerk cle where DATE_FORMAT(birthday,'%m%d') >= DATE_FORMAT(NOW() ,'%m%d') and DATE_FORMAT(birthday,'%m%d') <= DATE_FORMAT(DATE_ADD(NOW(),Interval 7 DAY) ,'%m%d')]; nested exception is org.hibernate.hql.ast.QuerySyntaxError: unexpected token: 7 near line 1
报错的大概意思是语法错误
这个问题出在哪?是不是mysql中sql转换成hibernate中hql文的问题,特别是DATE_FORMAT在hibernate中不可使用?
解决方案 »
- 问什么我的程序不能做出排列组合的结果
- Linux下客户端调用服务器端的rmi出现拒绝连接,高手求助!!!!!
- 同步和异步有何异同,在什么情况下分别使用他们?举例说明。
- java如何搜索目录中的文件和文件夹程序?
- (高分求)谁有北大青鸟11月20日的JAVA考试试题啊!!!!!!!!!!!!有的请给出来呀,谢谢呀
- 新手学java,两个小问题,希望大家帮忙解决一下,谢谢!!!
- 哪里有jfreechart-0.9.6.zip的下载,急需!!!!!!!!!!!!!!!
- 关于Java编码规范
- 向新版主求救:如何获得客户的访问带宽?急!在线等待。
- 如何将时间加入数据库?
- 关于SWT中的Text组件显示String的问题
- 用io流复制文件夹(包括文件夹里的文件)--出现的问题,无法创建文件夹
DATE_FORMAT(DATE_ADD(NOW(),Interval 7 DAY) , '%m%d ')
你自己检查下吧,mysql不熟,所以不知道为什么错