Question

Mybatis 分页问题 parameterType="java.util.Map"

<select id="selectUserByPage" resultMap="BaseResultMap" parameterType="java.util.Map">
select <include refid="Base_Column_List" />
from sys_user limit #{startCount},#{endCount}
</select>
<resultMap id="BaseResultMap" type="com.sky.yipin.entity.SysUser">
<id column="id" property="id" jdbcType="INTEGER" />
<result column="username" property="username" jdbcType="VARCHAR" />
<result column="phone" property="phone" jdbcType="VARCHAR" />
<result column="email" property="email" jdbcType="VARCHAR" />
<result column="password" property="password" jdbcType="VARCHAR" />
<result column="user_type" property="userType" jdbcType="VARCHAR" />
</resultMap>
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 'null,null' at line 3

Answer 1

你的startCount 和 endCount没有传进来 所以显示null null 所以这条sql语句执行报错

追问

谢谢，我解决了，是传进去的类型错了