resultType
使用resultType进行输出映射,只有查询出来的列名和pojo中的属性名一致,该列才可以映射成功。
如果查询出来的列名和pojo中的属性名全不一致,就没有创建pojo对象
只要查询出来的列名和pojo属性名有一个一致,就会创建pojo对象
输出简单类型
需求:
用户信息的综合查询的列表总数,通过查询总数和上面用户综合查询的列表才可以实现分页
mapper.xml
<!--
用户信息的综合查询总数
parameterType:和findUserList一样
resultType:输出的结果类型
-->
<select id="findUserCount" parameterType="UserQueryVo" resultType="int">
select COUNT(*) from user where user.sex = #{userCustom.sex} and user.username LIKE '%${userCustom.username}%'
</select>
mapper.java
//用户信息总数的查询
public int findUserCount(UserQueryVo userQueryVo) throws Exception;
测试代码
@Test
public void testFindUseCount() throws Exception {
SqlSession sqlSession = sqlSessionFactory.openSession();
//创建一个UserMapper的对象,mybatis自动生成mapper代理对象
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
//创建pojo包装对象
UserQueryVo userQueryVo = new UserQueryVo();
//创建pojo扩展对象
UserCustom userCustom = new UserCustom();
userCustom.setSex("1");
userCustom.setUsername("测试");
//将pojo扩展对象set进pojo包装对象
userQueryVo.setUserCustom(userCustom);
//调用UserMapper的方法
int count = userMapper.findUserCount(userQueryVo);
System.out.println(count);
}
小结
查询出来的结果集只有一行且一列,可以使用简单类型进行输出映射。
不管输出的pojo对象是单个对象还是一个对象集合,在mapper.xml里面的resultType里,都是指定的对象名称
但是在mapper.java接口类中指定返回值的类型不一样
根据selectOne还是selectList来确定的
resultMap
mybatis中使用resultMap完成高级输出结果映射
使用方法
如果查出来的列名和pojo的属性名不一致,通过定义一个resultMap对列名和pojo属性名之间做一个映射关系。
1、定义resultMap
2、使用resultMap作为statement的输出映射类型
需求;将下面的sql使用UserCustom完成映射
SELECT id id_,username username_ FROM USER WHERE id = #{id}
可以发现,User类中属性名与上面sql查询的列名并不一致
下面是我们使用resultMap做一个映射的方法:
1.定义resultMap
<!--
定义resultMap
将SELECT id id_,username username_ FROM USER和User属性类做一个映射
type:resultMap最终所映射的的java对象类型,可以使用别名
id:对resultMap的一个唯一标识
-->
<resultMap id="userResultMap" type="user">
<!--
id表示查询结果集中的唯一标识
column:查询出来的列名
property:type所指定的pojo属性名
最终resultMap对这个column和property做一个映射关系
-->
<id column="id_" property="id" />
<!--
result表示对普通名的定义
-->
<result column="username_" property="username" />
</resultMap>
2.使用resultMap作为输出类型
<!--
使用resultMap作为输出映射
resultMap:指定我们定义的resultMap的ID
如果此resultMap定义在其他的mapper配置文件内,前面需要加上一个namespace
-->
<select id="findUserByIdResultMap" parameterType="int" resultMap="userResultMap">
SELECT id id_,username username_ FROM USER WHERE id = #{id}
</select>
加入接口类方法
//使用resultMap映射输出结果
public User findUserByIdResultMap(int id) throws Exception;
3.测试
@Test
public void testFindUserByIdResultMap() throws Exception {
SqlSession sqlSession = sqlSessionFactory.openSession();
//创建一个UserMapper的对象,mybatis自动生成mapper代理对象
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
//调用UserMapper的方法
User user = userMapper.findUserByIdResultMap(28);
System.out.println(user);
}
4.运行结果
DEBUG [main] - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG [main] - Class not found: org.jboss.vfs.VFS
DEBUG [main] - JBoss 6 VFS API is not available in this environment.
DEBUG [main] - Class not found: org.jboss.vfs.VirtualFile
DEBUG [main] - VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.
DEBUG [main] - Using VFS adapter org.apache.ibatis.io.DefaultVFS
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo
DEBUG [main] - Reader entry: User.class
DEBUG [main] - Reader entry: UserCustom.class
DEBUG [main] - Reader entry: UserQueryVo.class
DEBUG [main] - Listing file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/User.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/User.class
DEBUG [main] - Reader entry: ���� 4 L
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/UserCustom.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/UserCustom.class
DEBUG [main] - Reader entry: ���� 4
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/UserQueryVo.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/pojo/UserQueryVo.class
DEBUG [main] - Reader entry: ���� 4
DEBUG [main] - Checking to see if class pojo.User matches criteria [is assignable to Object]
DEBUG [main] - Checking to see if class pojo.UserCustom matches criteria [is assignable to Object]
DEBUG [main] - Checking to see if class pojo.UserQueryVo matches criteria [is assignable to Object]
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - PooledDataSource forcefully closed/removed all connections.
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper
DEBUG [main] - Reader entry: UserMapper.class
DEBUG [main] - Reader entry: UserMapper.xml
DEBUG [main] - Listing file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/UserMapper.class
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/UserMapper.class
DEBUG [main] - Reader entry: ���� 4 findUserByIdResultMap (I)Lpojo/User;
DEBUG [main] - Find JAR URL: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/UserMapper.xml
DEBUG [main] - Not a JAR: file:/E:/%e5%a4%a7%e5%ad%a6%e9%a1%b9%e7%9b%ae/IDEA%20Project/mybatis/out/production/mybatis/mapper/UserMapper.xml
DEBUG [main] - Reader entry: <?xml version="1.0" encoding="UTF-8" ?>
DEBUG [main] - Checking to see if class mapper.UserMapper matches criteria [is assignable to Object]
DEBUG [main] - Opening JDBC Connection
DEBUG [main] - Created connection 662736689.
DEBUG [main] - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@27808f31]
DEBUG [main] - ==> Preparing: SELECT id id_,username username_ FROM USER WHERE id = ?
DEBUG [main] - ==> Parameters: 28(Integer)
DEBUG [main] - <== Total: 1
User{id=28, username='fjnmbb124', sex='null', birthday=null, address='null'}
Process finished with exit code 0
总结
使用resultType进行输出映射,只有查询出来的列名和pojo中的属性名一致,该列才可以映射成功。
如果查出来的列名和pojo的属性名不一致,通过定义一个resultMap对列名和pojo属性名之间做一个映射关系。