本人是个新手,刚学习完ssh,做个实习小项目,遇到点问题一直想不明白,请各位高手帮忙指点。谢谢!
我想要从信息表中按 年和月 取出当月的所有记录,信息表中的字段是 年月日 格式的
代码如下;一直出错,
String queryString = "from WorkInfo w where w.createDate in (";
for(int i=0; i<dates.length; i++) { //dates是当前月份每一天组成的日期类型数组
if(i == dates.length-1) {
queryString += dates[i] + ")";
}else {
queryString += dates[i] + ",";
}
}
List list = getHibernateTemplate().find(queryString);比如输入2012 年 7 月 出现下面的错误信息
org.springframework.orm.hibernate3.HibernateQueryException:
Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 00 near line 1, column 94 [from com.cn.entity.WorkInfo w where w.createDate in (2012-07-01 00:00:00.0,2012-07-02 00:00:00.0,2012-07-03 00:00:00.0,2012-07-04 00:00:00.0,2012-07-05 00:00:00.0,2012-07-06 00:00:00.0,2012-07-07 00:00:00.0,2012-07-08 00:00:00.0,2012-07-09 00:00:00.0,2012-07-10 00:00:00.0,2012-07-11 00:00:00.0,2012-07-12 00:00:00.0,2012-07-13 00:00:00.0,2012-07-14 00:00:00.0,2012-07-15 00:00:00.0,2012-07-16 00:00:00.0,2012-07-17 00:00:00.0,2012-07-18 00:00:00.0,2012-07-19 00:00:00.0,2012-07-20 00:00:00.0,2012-07-21 00:00:00.0,2012-07-22 00:00:00.0,2012-07-23 00:00:00.0,2012-07-24 00:00:00.0,2012-07-25 00:00:00.0,2012-07-26 00:00:00.0,2012-07-27 00:00:00.0,2012-07-28 00:00:00.0,2012-07-29 00:00:00.0,2012-07-30 00:00:00.0,2012-07-31 00:00:00.0)]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1651)
at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:914)
at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:1)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
... 29 more
我想要从信息表中按 年和月 取出当月的所有记录,信息表中的字段是 年月日 格式的
代码如下;一直出错,
String queryString = "from WorkInfo w where w.createDate in (";
for(int i=0; i<dates.length; i++) { //dates是当前月份每一天组成的日期类型数组
if(i == dates.length-1) {
queryString += dates[i] + ")";
}else {
queryString += dates[i] + ",";
}
}
List list = getHibernateTemplate().find(queryString);比如输入2012 年 7 月 出现下面的错误信息
org.springframework.orm.hibernate3.HibernateQueryException:
Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 00 near line 1, column 94 [from com.cn.entity.WorkInfo w where w.createDate in (2012-07-01 00:00:00.0,2012-07-02 00:00:00.0,2012-07-03 00:00:00.0,2012-07-04 00:00:00.0,2012-07-05 00:00:00.0,2012-07-06 00:00:00.0,2012-07-07 00:00:00.0,2012-07-08 00:00:00.0,2012-07-09 00:00:00.0,2012-07-10 00:00:00.0,2012-07-11 00:00:00.0,2012-07-12 00:00:00.0,2012-07-13 00:00:00.0,2012-07-14 00:00:00.0,2012-07-15 00:00:00.0,2012-07-16 00:00:00.0,2012-07-17 00:00:00.0,2012-07-18 00:00:00.0,2012-07-19 00:00:00.0,2012-07-20 00:00:00.0,2012-07-21 00:00:00.0,2012-07-22 00:00:00.0,2012-07-23 00:00:00.0,2012-07-24 00:00:00.0,2012-07-25 00:00:00.0,2012-07-26 00:00:00.0,2012-07-27 00:00:00.0,2012-07-28 00:00:00.0,2012-07-29 00:00:00.0,2012-07-30 00:00:00.0,2012-07-31 00:00:00.0)]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1651)
at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:914)
at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:1)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
... 29 more
解决方案 »
- 在JAVA程序中,调用C/c++写的方法。急!
- 请问:getRequestDispatcher如何把参数也发送给下一个页面?
- 求教关于jsp/servlet的问题(请高手指点一下,不胜感谢)
- 怎么正常显示消息资源中的中文??????????
- 在java应用程序中,如何捕捉servlet的输出??
- 怎么让文字具有提示功能?简单问题!50分!
- 高人讲解java.sql.Date 和 java.util.Date有什么区别?
- applet与servlet实时数据交互的问题
- 关于hibernate的SessionFactory和Session的使用问题
- Java struts2框架中,map类型实例的根对象是什么?
- 用java如何控制弹出窗口在闲置若干秒后自动关闭?
- (我是好人的..真的)如何隐藏自己的IP地址。
ORA-01858: 在要求输入数字处找到非数字字符按照2楼 和 3 楼 说的 试了几次 出现过上面两种 错误
是不是说日期格式不对啊?
我插入oracle数据库时用的是SimpleDateFormat(“yyyy-MM-dd”)
现在查询时我也把上面数组中的日期类型改成一样的了。SQL语句的显示是 Tue Jul 03 00:00:00 CST 2012
是不是插入时的格式和读取出的格式不一样啊?