正文
MyBatis（七） 自定义映射结果ResultMap
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
（1）接口中对应的方法
public Emp getEmpById(Integer id);
（2）Mapper文件
<resultMap type="com.eu.bean.Emp" id="emp">
<id column="id" property="id"/>
<result column="last_name" property="lastName"/>
<result column="gender" property="geder"/>
<result column="email" property="email"/>
</resultMap> <select id="getEmpById" resultMap="emp">
select * from emp where id = #{id}
</select>
（3）测试
public SqlSessionFactory getSqlSessionFactory() throws IOException {
String resource = "conf/mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
return new SqlSessionFactoryBuilder().build(inputStream);
} @Test
public void testMapper() throws IOException {
SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
//1.获取到sqlsession 不会自动提交数据
SqlSession openSession = sqlSessionFactory.openSession();
EmpDao mapper = openSession.getMapper(EmpDao.class); Emp emp = mapper.getEmpById(4);
System.out.println(emp); //手动提交数据
openSession.commit();
openSession.close();
}
