急！查询SQL的时候报错。

[Diego迭戈]

select ID as id,V_SFZH as sfzh,V_TXZH as txzh,V_TXZHQZ as txzhqz,V_ZWX as zwx,V_ZWM as zwm,V_LXDH as lxdh,date_format(d_lrsj,'%Y-%m-%d') as sqsj,N_QZLB as qzlb,N_SHZT as shzt, V_MDD,V_XGQZZL,V_AMQZZL,V_XGQSGX,V_AMQSGX,N_QZFS,N_QZDS,N_QZQX,N_QZDZ,N_QZLXR,N_QZDH,N_DZBT,N_SZDS,N_SZQX,N_SZDZ,N_SZLXR,N_SZDH from ems_t_qzddxxb where 1>0 and d_lrsj <= ? and d_lrsj >= ? and n_shzt = ? order by D_LRSJ desc
上面的这句是进入查询时的SQL语句
这个是参数列表里的值：[Thu Aug 27 23:59:59 GMT+08:00 2015, Sun Mar 01 00:00:00 GMT+08:00 2015, 1]
下面是报的错！SQL语句我放在数据库中执行可以查出结果，我测试了下 好像是和时间比较的有关系，
----------------------------------------------------------------------------------------------------------------------------------------------------------------
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select ID as id,V_SFZH as sfzh,V_TXZH as txzh,V_TXZHQZ as txzhqz,V_ZWX as zwx,V_ZWM as zwm,V_LXDH as lxdh,date_format(d_lrsj,'%Y-%m-%d') as sqsj,N_QZLB as qzlb,N_SHZT as shzt, V_MDD,V_XGQZZL,V_AMQZZL,V_XGQSGX,V_AMQSGX,N_QZFS,N_QZDS,N_QZQX,N_QZDZ,N_QZLXR,N_QZDH,N_DZBT,N_SZDS,N_SZQX,N_SZDZ,N_SZLXR,N_SZDH from ems_t_qzddxxb where 1>0 and d_lrsj <= ? and d_lrsj >= ? and n_shzt = ? order by D_LRSJ desc]; nested exception is java.sql.SQLException: Column 'V_SFZH' not found.
Caused by: java.sql.SQLException: Column 'V_SFZH' not found.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1167)
at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:5179)
at com.gotop.dao.dao.util.ResultSetDAO.extractData(ResultSetDAO.java:72)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:595)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:530)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:583)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:612)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:620)
at com.gotop.dao.dao.util.HibernatePersistenceManager.find(HibernatePersistenceManager.java:79)
at com.gotop.biz.biz.external.EbmqzBIZImpl.findAll(EbmqzBIZImpl.java:116)
at com.gotop.biz.biz.external.EbmqzBIZImpl$$FastClassByCGLIB$$a71a86f9.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:675)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:616)
at com.gotop.biz.biz.external.EbmqzBIZImpl$$EnhancerByCGLIB$$b56598e6.findAll(<generated>)
at com.gotop.struts.action.external.EbmqzAction.query(EbmqzAction.java:261)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.gotop.servlets.PublicController.doFilter(PublicController.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.gotop.servlets.ReloginFilter.doFilter(ReloginFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.gotop.servlets.EncodingFilter.doFilter(EncodingFilter.java:26)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)

[BUG胡汉三]

引用 楼主 slsw01 的回复:

[Thu Aug 27 23:59:59 GMT+08:00 2015, Sun Mar 01 00:00:00 GMT+08:00 2015, 1]

把你的值转换成字符串类型的试试！

[执笔记忆的空白]

传入的日期是字符串么？ sql里面日期转一下： 比如下面是我的mybatis配置：

<if test="startReqDate != null and startReqDate != ''">
  		<![CDATA[  and DATE(create_time) >= #{startReqDate,jdbcType=TIMESTAMP} ]]>
  	</if>
  	<if test="endReqDate != null and endReqDate != ''">
  		<![CDATA[  and DATE(create_time) <= #{endReqDate,jdbcType=TIMESTAMP} ]]>
  	</if>

[南猿北辙]

帖的有点乱 报错很明显 Caused by: java.sql.SQLException: Column 'V_SFZH' not found. V_SFZH 这个字段没有找到，你确定表里面有这字段？

[Diego迭戈]

引用 1 楼 hzw2312 的回复:

[quote=引用 楼主 slsw01 的回复:]
[Thu Aug 27 23:59:59 GMT+08:00 2015, Sun Mar 01 00:00:00 GMT+08:00 2015, 1]

把你的值转换成字符串类型的试试！[/quote]

我的值是Date型的，数据库中也是date型的。还有就是他是通过Object[] params传值，我不知道怎么取出来

[Diego迭戈]

引用 2 楼 zhuxianxin0118 的回复:

帖的有点乱 报错很明显 Caused by: java.sql.SQLException: Column 'V_SFZH' not found. V_SFZH 这个字段没有找到，你确定表里面有这字段？

想要表达的太多，所以有点乱，但是数据库中确实有这个字段，我把SQL语句直接在数据库中执行，是可以查到值的

[执笔记忆的空白]

引用 4 楼 slsw01 的回复:

我的值是Date型的，数据库中也是date型的。还有就是他是通过Object[] params传值，我不知道怎么取出来

明确第几个字段，就直接强转啊

[Diego迭戈]

引用 3 楼 shijing266 的回复:

传入的日期是字符串么？ sql里面日期转一下：
比如下面是我的mybatis配置：

<if test="startReqDate != null and startReqDate != ''">
  		<![CDATA[  and DATE(create_time) >= #{startReqDate,jdbcType=TIMESTAMP} ]]>
  	</if>
  	<if test="endReqDate != null and endReqDate != ''">
  		<![CDATA[  and DATE(create_time) <= #{endReqDate,jdbcType=TIMESTAMP} ]]>
  	</if>

传入的日期是date型的，数据库中的字段也是Date型的。Object[] params中要怎么样才能把值一个个取出来啊。

[Diego迭戈]

引用 7 楼 slsw01 的回复:

[quote=引用 3 楼 shijing266 的回复:] 传入的日期是字符串么？ sql里面日期转一下： 比如下面是我的mybatis配置：

<if test="startReqDate != null and startReqDate != ''">
  		<![CDATA[  and DATE(create_time) >= #{startReqDate,jdbcType=TIMESTAMP} ]]>
  	</if>
  	<if test="endReqDate != null and endReqDate != ''">
  		<![CDATA[  and DATE(create_time) <= #{endReqDate,jdbcType=TIMESTAMP} ]]>
  	</if>

传入的日期是date型的，数据库中的字段也是Date型的。Object[] params中要怎么样才能把值一个个取出来啊。 [/quote] 我是调用了这个语句去执行的。。。。要怎么转换参数的类型List list = (List) jdbcTemplate.query(sql,params, dao);

[木子0204]

Caused by: java.sql.SQLException: Column 'V_SFZH' not found.

[BUG胡汉三]

引用 4 楼 slsw01 的回复:

我的值是Date型的，数据库中也是date型的。还有就是他是通过Object[] params传值，我不知道怎么取出来

使用SimpleDateFormat来格式化你的时间字符串

public static String getDateStr(Date date){
	SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
	return df.format(date);
}

在调用查询方法之前，先将参数中的两个date类型转换为字符串 params[0] = getDateStr(params[0]); params[1] = getDateStr(params[1]); 按理说应该在添加Object[]之前就把时间转换好了直接放进数组的！希望对你有帮助

[北落师门_Orz]

你用jdbctemplete 要么就是你表字段没有写对，要么就是映射的对象不对吧