ibatis 动态SQL问题

leeKitty 沈阳中科智联科技有限公司项目总监 2015-10-20 09:37:41

<select id="texselecttimulist" parameterClass="strsql" resultClass="strsql">

		select * form bs_timu_tab

		<dynamic prepend="where">

			<isNotEmpty prepend="and" property="jiaoshi">

				jiaoshihao=#jiaoshi#

			</isNotEmpty>

			<isNotEqual prepend="and" property="nian" compareValue="0">

				nian=#nian#

			</isNotEqual>

			<isNotEqual prepend="and" property="bei4" compareValue="0">

				bei4 like "%"+#bei4#+"%"

			</isNotEqual>

			<isNotEmpty prepend="and" property="timu">

				timu like "%"+#timu#+"%"

			</isNotEmpty>

		</dynamic>

		

	</select>

这是sql 配置但是执行后报错
org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred while applying a parameter map.
--- Check the texselecttimulist-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: 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 'form bs_timu_tab where jiaoshi='091201077' and nian='' at line 1

大神门这是为什么谢谢

...全文

117 点赞收藏 9

写回复

9 条回复

切换为时间正序

当前发帖距今超过3年，不再开放新的回复

发表回复

leeKitty 2015-10-21

引用 8 楼 rui888 的回复:

你是不是说. 错误是 nian=#nian# 这里是有值的但是提示错误是空的 nian=''

找到错误了 from 关键字写错了谢谢

回复赞

兔子托尼啊 2015-10-21

你是不是说. 错误是 nian=#nian# 这里是有值的但是提示错误是空的 nian=''

回复赞

leeKitty 2015-10-21

找到错误了啊气死我了 from 写错了写成form了 40分加分到80分了来一个讲一个好笑的笑话就结帖

回复赞

leeKitty 2015-10-21

sql 语句 select * 这些都没有了为什么呢大神帮帮忙啊着急啊

回复赞

leeKitty 2015-10-21

我把 nian属性的判断后面的代码全都删掉了


<sql id="sql_select">  
        select *  
    </sql> 
<sql id="sql_where">
		form bs_timu_tab
		<dynamic prepend="where">
			<isNotEmpty prepend="BOGUS" property="jiaoshihao">
				jiaoshihao=#jiaoshihao#
			</isNotEmpty>
			
		</dynamic>
	</sql>

org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the texselecttimulist-InlineParameterMap. --- Check the statement (query failed). --- Cause: 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 'form bs_timu_tab where jiaoshihao='091201077'' at line 1 还是报错错误提示的sql语句我发现没有select *

回复赞

兔子托尼啊 2015-10-21

那么你先不判断 compareValue="0" 直接改 <isNotEmpty prepend="and" property="jiaoshi"> jiaoshihao=#jiaoshi# </isNotEmpty> 这样的看看.

回复赞

leeKitty 2015-10-21

引用 2 楼 rui888 的回复: