13-Mybatis封装输出结果之二 -- resultMap

最新推荐文章于 2022-04-02 23:49:37 发布

前路无畏

最新推荐文章于 2022-04-02 23:49:37 发布

阅读量1.4w

点赞数

分类专栏： Mybatis 文章标签： mybatis resultMap as

本文链接：https://blog.csdn.net/fsjwin/article/details/109674185

版权

Mybatis 专栏收录该内容

25 篇文章 8 订阅

订阅专栏

上一篇：12-Mybatis封装输出结果之一 – resultType （含typeAliases）https://blog.csdn.net/fsjwin/article/details/109673170

处理使用resultType之外，也可以使用resultMap，即当我们java类的属性名和数据库的名字不一致的时候可以一用。

1.resultMap解决属性值和表列名不一致的情况

1.1 StudentDao

    public MyStudent selectStudentResultMap(Integer id);

1.2 StudentDao.xml

   <resultMap id="myStudent" type="com.yuhl.domain.MyStudent">
        <id property="myid" column="id"/>
        <result property="myname" column="name"/>
        <result property="myage" column="age"/>
        <result property="myemail" column="email"/>

    </resultMap>
    <!-- ResultMap 表中类名和类中属性名不一致的时候-->
    <select id="selectStudentResultMap"  resultMap="myStudent">
        select id,name,email,age from student where id = #{id}
    </select>

1.3 测试

  @Test
    public void test14() {
        SqlSession sqlsession = MybatisUtil.getSqlsession();
        StudentDao studentDao = sqlsession.getMapper(StudentDao.class);
        //可以吧查询的条件放进去，也可以使用一个单独的类ParaObject类封装就可以了。
        MyStudent myStudent = studentDao.selectStudentResultMap(1001);
        System.out.println(myStudent);
    }

1.4 测试结果

Checking to see if class com.yuhl.vo.StudentVo matches criteria [is assignable to Object]
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
Opening JDBC Connection
Created connection 188576144.
==>  Preparing: select id,name,email,age from student where id = ?
==> Parameters: 1001(Integer)
<==    Columns: id, name, email, age
<==        Row: 1001, 张三, zhangsan@qq.com, 20
<==      Total: 1
MyStudent{myid=1001, myname='张三', myemail='zhangsan@qq.com', myage=20}

2.属性值和表列名不一致第二种解决方案as

2.1 StudentDao

 public MyStudent selectStudentResultMap2(Integer id);

2.2 StudentDao.xml

  <resultMap id="myStudent" type="com.yuhl.domain.MyStudent">
        <id property="myid" column="id"/>
        <result property="myname" column="name"/>
        <result property="myage" column="age"/>
        <result property="myemail" column="email"/>
    <select id="selectStudentResultMap2"  resultType="com.yuhl.domain.MyStudent">
        select id as myid,name as myname,email as myemail,age as myage from student where id = #{id}
    </select>

2.3 测试

 @Test
    public void test15() {
        SqlSession sqlsession = MybatisUtil.getSqlsession();
        StudentDao studentDao = sqlsession.getMapper(StudentDao.class);
        //可以吧查询的条件放进去，也可以使用一个单独的类ParaObject类封装就可以了。
        MyStudent myStudent = studentDao.selectStudentResultMap2(1001);
        System.out.println(myStudent);
    }

2.4 测试结果

Checking to see if class com.yuhl.vo.StudentVo matches criteria [is assignable to Object]
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
Opening JDBC Connection
Created connection 188576144.
==>  Preparing: select id as myid,name as myname,email as myemail,age as myage from student where id = ?
==> Parameters: 1001(Integer)
<==    Columns: myid, myname, myemail, myage
<==        Row: 1001, 张三, zhangsan@qq.com, 20
<==      Total: 1
MyStudent{myid=1001, myname='张三', myemail='zhangsan@qq.com', myage=20}