Mybatis中入到参数问题
问题:
原因: 传参有多个时发生!!
解决:
解决办法:
(1)直接把值改成数字
<select id="LoginUser" parameterType="String" resultMap="userMap">
SELECT * FROM user where emplnumb = #{0} and password=#{1}
</select>
(2)在变量上加注解@Param
List<Property> selectOrder(@Param("page") Page page,@Param("cid") int cid);
<select id="selectOrder" resultMap="property" >
select * from t_property WHERE category_id = #{cid} order by id asc limit #{page.start} , #{page.count}
</select>