Part1:
1:创建数据库
create table users(
user_id int primary key auto_increment,
user_name varchar(20) not null,
user_age int not null
);
insert into users(user_id,user_name,user_age) values(null,'张三',20),(null,'李四',18);
实体准备
2:ResultMapper简单映射
<mapper namespace="com.biem.mapper.StuMapper">
<select id="findStuById" parameterType="int" resultType="Stu">
select * from users where uid = #{uid}
</select>
<resultMap id="StuMap" type="Stu">
<id property="id" column="uid"/>
<result property="name" column="uname"/>
<result property="age" column="uage"/>
</resultMap>
</mapper>
测试语句:
@Test
public void testfindStuById(){
SqlSession session = MybatisUtil.openSession();
StuMapper mapper =session.getMapper(StuMapper.class);
Stu stu = mapper.findStuById(1);
System.out.println("stu = " + stu);
session.close();
}
执行结果:
part 2:
demo1方案1:别名设置:
<select id="StuMap" resultType="Stu">
select
user_id as "id",
user_name as "name",
user_age as "age"
from tbl_user
where user_id=#{id}
</select>
demo方案2:显式配置 ResultMap
<resultMap id="StuMap" type="Stu">
<id property="id" column="user_id"/>
<result property="name" column="user_name"/>
<result property="age" column="user_age"/>
</resultMap>
<select id="StuMap" resultMap="StuResultMap">
select
user_id, user_name, user_age
from users
where user_id=#{id}
</select>