Mybatis中的statementType="STATEMENT"使用注意

今天遇到如下问题

 

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 '?,?' at line 6
; bad SQL grammar []; nested exception is 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 '?,?' at line 6

才知  mybatis 使用了   statementType="STATEMENT" 属性

 

 

	<select id="getUserReginAllList" parameterType="java.util.Map"
		statementType="STATEMENT" resultType="UserReginLogEntity">
		select * from userregin${tableTime} where 1=1
		<if test="id!=null">
			and uid like concat('%','${id}','%')
		</if>
		<if test="serverId!=-1">
			and serverId = ${serverId}
		</if>
		 limit #{skip},#{take}
	</select>

 

 

 

 

 

如果使用了

statementType="STATEMENT"(非预编译) , #{xxx}  的#就不能用了  需要换成${xxx}

 

我觉得mybatis传值是map的  在mapper中取值最好用${}

 

  最后附一个学习连接http://www.mybatis.org/mybatis-3/zh/sqlmap-xml.html 点击打开链接