mybatis mapper.xml sql
当parameterType为String时
任何参数都必须为_parameter
正确写法:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.stu.mapper.UserMapper">
<select id="logconfirm" parameterType="String" resultType="String">
select password from user where username=#{_parameter}
</select>
</mapper>
之前写的是
然后提示错误There is no getter of 'username' in java.lang.string
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.stu.mapper.UserMapper">
<select id="logconfirm" parameterType="String" resultType="String">
select password from user where username=#{username}
</select>
</mapper>