**别名**
<?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.mapper.InsUserMapper" >
<resultMap id="user" type="com.po.InsUser">
<result column="userId" property="userId"></result>
<result column="userName" property="userName"></result>
<result column="password" property="passWord"></result>
<result column="CUST_ID" property="CUST_ID"></result>
<result column="state" property="state"></result>
</resultMap>
<select id="checkLogin" parameterType="com.po.InsUser" resultMap="user">
SELECT userId ,userName,passWord from ins_user_100 where userName=#{userName} AND passWord=#{passWord}
</select>
</mapper>
mybatis字段取别名
最新推荐文章于 2024-08-09 01:11:55 发布