ibatis 使用遇到的问题1

来源：互联网发布：免费舆情分析软件编辑：程序博客网时间：2024/06/06 02:44

<sql id="whereStatement">
<dynamic prepend="where">
is_deleted=0
<isNotEmpty prepend="and" property="id"
removeFirstPrepend="true">id=#id#</isNotEmpty>
<isNotEmpty prepend="and" property="searchWord"
removeFirstPrepend="true">search_word like concat('%',#searchWord#,'%')</isNotEmpty>
<isNotEmpty prepend="and" property="showWord"
removeFirstPrepend="true">show_word like concat('%',#showWord#,'%')</isNotEmpty>
<isNotEmpty prepend="and" property="state"
removeFirstPrepend="true">state=#state#</isNotEmpty>
<isNotEmpty prepend="and" property="entryType"
removeFirstPrepend="true">entry_type=#entryType#</isNotEmpty>
<isNotEmpty prepend="and" property="startTime"
removeFirstPrepend="true"><![CDATA[ gmt_end >= #startTime# ]]></isNotEmpty>
<isNotEmpty prepend="and" property="endTime"
removeFirstPrepend="true"><![CDATA[ gmt_start <= #endTime# ]]></isNotEmpty>
</dynamic>
</sql>

ibatis的xml中，
<dynamic> </dynamic>里面千万不能有 is_deleted=0 这种固定的条件，不然会报如下错误：
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'state = 0 and entry_type = 1 and location = 1 and gmt_end >= '2017-04-2' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
研究了好久。。。
还有，ibatis中的sql文件中，一定能加 “ ”空格的地方一定加上，不然不知道什么时候就会因为一个空格报错找不到原因

0 0