resultType 配置结果类型
项目结构
概念
resultType 属性可以指定结果集的类型,它支持基本类型和实体类类型。
需要注意的是,它和 parameterType 一样,如果注册过类型别名的,可以直接使用别名。没有注册过的必须 使用全限定类名。例如:我们的实体类此时必须是全限定类名
同时,当是实体类名称是,还有一个要求,实体类中的属性名称必须和查询语句中的列名保持一致,否则无法 实现封装。
配置文件
-
pom.xml
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.xiaoge</groupId> <artifactId>mybatisCRUD</artifactId> <version>1.0-SNAPSHOT</version> <packaging>jar</packaging> <dependencies> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.5</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.13</version> </dependency> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.17</version> </dependency> <dependency> <groupId>dom4j</groupId> <artifactId>dom4j</artifactId> <version>1.6.1</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> </dependency> <dependency> <groupId>jaxen</groupId> <artifactId>jaxen</artifactId> <version>1.1.6</version> </dependency> </dependencies> </project>
-
SqlMapConfig.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <!--配置环境--> <environments default="mysql"> <!--配置mysql环境--> <environment id="mysql"> <!--配置事务--> <transactionManager type="JDBC"></transactionManager> <!--配置连接池--> <dataSource type="POOLED"> <property name="driver" value="com.mysql.cj.jdbc.Driver" /> <property name="url" value="jdbc:mysql://127.0.0.1:3306/eesy_mybatis" /> <property name="username" value="root" /> <property name="password" value="123456" /> </dataSource> </environment> </environments> <!--配置映射文件的位置--> <mappers> <mapper resource="com/xiaoge/dao/userDao.xml"></mapper> </mappers> </configuration>
-
UserDao.xml
<?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.xiaoge.dao.UserDao"> <!--查询所有用户操作--> <!--id 执行的方法名--> <!--resultType 是方法的结果类型--> <select id="findAll" resultType="com.xiaoge.domain.User"> select * from user </select> <!--保存用户--> <!--id 执行的方法名--> <!--parameterType 是方法的参数类型--> <!--mybatis的规则 #{类中的属性} 类中的属性是->(getter setter)方法名去掉get或set 将首字母转换成小写--> <!--列 getId 变成 id--> <insert id="saveUser" parameterType="com.xiaoge.domain.User"> <!-- 配置插入操作后, 获取插入数据的id --> <!-- keyColumn: 对应的数据库字段id --> <!-- keyProperty: 对应的实体类属性值id --> <!-- order: after是后做这件事 before是先做这件事 --> <selectKey keyProperty="id" keyColumn="id" resultType="java.lang.Integer" order="AFTER"> select last_insert_id(); </selectKey> insert into user(username, address, sex, birthday) value(#{username}, #{address}, #{sex}, #{birthday}) </insert> <!--更新用户--> <update id="updateUser" parameterType="com.xiaoge.domain.User"> update user set username = #{username}, address = #{address}, sex = #{sex}, birthday = #{birthday} where id = #{id} </update> <!--删除用户 这个参数是(基本类型, 或基本类型的包装类时), 而且只有一个参数, 这里#{占位符} 占位符可以随便写 --> <delete id="deleteUser" parameterType="java.lang.Integer"> delete from user where id = #{userId} </delete> <!--查询条记录信息--> <select id="findById" parameterType="java.lang.Integer" resultType="com.xiaoge.domain.User"> select * from user where id = #{userId} </select> <!--根据用户名模糊查询--> <select id="findByUsername" parameterType="java.lang.String" resultType="com.xiaoge.domain.User"> select * from user where username like #{username} </select> <!--查询总用户数量--> <select id="findTotal" resultType="java.lang.Integer"> select count(*) from user </select> </mapper>
实体类
-
User属性跟数据库字段一一对应
package com.xiaoge.domain; import java.util.Date; /** * @Author: 潇哥 * @DateTime: 2020/3/4 下午4:03 * @Description: TODO */ public class User { private Integer id; private String username; private String address; private String sex; private Date birthday; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public Date getBirthday() { return birthday; } public void setBirthday(Date birthday) { this.birthday = birthday; } @Override public String toString() { return "User{" + "id=" + id + ", username='" + username + '\'' + ", address='" + address + '\'' + ", sex='" + sex + '\'' + ", birthday=" + birthday + '}'; } }
持久层接口
-
UserDao
package com.xiaoge.dao; import com.xiaoge.domain.User; import java.util.List; /** * @Author: 潇哥 * @DateTime: 2020/3/4 下午4:19 * @Description: 用户的持久层接口 */ public interface UserDao { /** * 查询所有用户 * @return */ public List<User> findAll(); }
测试持久层接口方法
-
MybatisTest
package com.xiaoge.test; import com.xiaoge.dao.UserDao; import com.xiaoge.domain.User; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import org.junit.After; import org.junit.Before; import org.junit.Test; import java.io.IOException; import java.io.InputStream; import java.util.Date; import java.util.List; /** * @Author: 潇哥 * @DateTime: 2020/3/4 下午4:22 * @Description: 测试mybatis的crud操作 */ public class MybatisTest { private InputStream is; private SqlSession session; private UserDao userDao; /** * 初始化 获取代理对象 */ @Before // 用于在测试方法之前执行 public void init() throws IOException { // 1. 加载配置文件 is = Resources.getResourceAsStream("SqlMapConfig.xml"); // 2. 获取SqlSessionFactory SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); SqlSessionFactory factory = builder.build(is); // 3. 获取SqlSession对象 session = factory.openSession(); // 4. 获取代理对象 userDao = session.getMapper(UserDao.class); } @After // 用于在测试方法之后执行 public void destroy() throws IOException { // 1. 提交事务(提交事务以后才会映射进数据库, 不提交的话, 它会自动回滚) session.commit(); // 2. 释放资源 if (session != null) { session.close(); } if (is != null) { is.close(); } } /** * 测试查询所有用户信息 * @throws IOException */ @Test public void findAllTest() throws IOException { // 1. 遍历获取所有的用户 List<User> users = userDao.findAll(); for (User user : users) { System.out.println(user); } // 运行结果 User{id=41, username='老王', address='北京', sex='男', birthday=Wed Feb 28 07:47:08 CST 2018} User{id=42, username='小二王', address='北京金燕龙', sex='女', birthday=Sat Mar 03 05:09:37 CST 2018} User{id=43, username='小二王', address='北京金燕龙', sex='女', birthday=Mon Mar 05 01:34:34 CST 2018} User{id=46, username='老王', address='北京', sex='男', birthday=Thu Mar 08 07:37:26 CST 2018} User{id=48, username='小马宝莉', address='北京修正', sex='女', birthday=Fri Mar 09 01:44:00 CST 2018} User{id=53, username='啸哥', address='北京四合院', sex='男', birthday=Fri Mar 06 13:10:42 CST 2020} User{id=54, username='李四 last insertid', address='北京', sex='男', birthday=Fri Mar 06 14:26:40 CST 2020} } }
注意(特殊情况)实体类属性跟数据库字段不对应时
-
User实体类属性跟数据库字段不对应时
package com.xiaoge.domain; import java.util.Date; /** * @Author: 潇哥 * @DateTime: 2020/3/4 下午4:03 * @Description: TODO */ public class User { private Integer userId; private String userName; private String userAddress; private String userSex; private Date userBirthday; public Integer getUserId() { return userId; } public void setUserId(Integer userId) { this.userId = userId; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getUserAddress() { return userAddress; } public void setUserAddress(String userAddress) { this.userAddress = userAddress; } public String getUserSex() { return userSex; } public void setUserSex(String userSex) { this.userSex = userSex; } public Date getUserBirthday() { return userBirthday; } public void setUserBirthday(Date userBirthday) { this.userBirthday = userBirthday; } @Override public String toString() { return "User{" + "userId=" + userId + ", userName='" + userName + '\'' + ", userAddress='" + userAddress + '\'' + ", userSex='" + userSex + '\'' + ", userBirthday=" + userBirthday + '}'; } }
配置文件(注意#{属性} 属性的写法是 把getter 或 setter 方法的get或set去掉把首字母转换成小写: 列 getUserName() —> userName(属性))
-
UserDao.xml
<?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.xiaoge.dao.UserDao"> <!-- 查询所有用户操作 --> <!-- id: 执行的方法名 --> <!-- resultType: 是方法的结果类型 --> <select id="findAll" resultType="com.xiaoge.domain.User"> <!-- 这时候只有userName封装进去 其他都封装不进去 原因是 mysql数据库不区分大小写 --> select * from user </select> <!--保存用户--> <!--id 执行的方法名--> <!--parameterType 是方法的参数类型--> <!--mybatis的规则 #{类中的属性} 类中的属性是->(getter setter)方法名去掉get或set 将首字母转换成小写--> <!--列 getId 变成 id--> <insert id="saveUser" parameterType="com.xiaoge.domain.User"> <!-- 配置插入操作后, 获取插入数据的id --> <!-- keyColumn: 对应的数据库字段id --> <!-- keyProperty: 对应的实体类属性值id --> <!-- order: after是后做这件事 before是先做这件事 --> <selectKey keyProperty="userId" keyColumn="id" resultType="java.lang.Integer" order="AFTER"> select last_insert_id(); </selectKey> insert into user(username, address, sex, birthday) value(#{userName}, #{userAddress}, #{userSex}, #{userBirthday}) </insert> <!--更新用户--> <update id="updateUser" parameterType="com.xiaoge.domain.User"> update user set username = #{userName}, address = #{userAddress}, sex = #{userSex}, birthday = #{userBirthday} where id = #{userId} </update> <!--删除用户 这个参数是(基本类型, 或基本类型的包装类时), 而且只有一个参数, 这里#{占位符} 占位符可以随便写 --> <delete id="deleteUser" parameterType="java.lang.Integer"> delete from user where id = #{userId} </delete> <!--查询条记录信息--> <select id="findById" parameterType="java.lang.Integer" resultType="com.xiaoge.domain.User"> select * from user where id = #{userId} </select> <!--根据用户名模糊查询--> <select id="findByUsername" parameterType="java.lang.String" resultType="com.xiaoge.domain.User"> select * from user where username like #{userName} </select> <!--查询总用户数量--> <select id="findTotal" resultType="java.lang.Integer"> select count(*) from user </select> <!--根据queryVo的条件查询用户--> <select id="findByVo" resultType="com.xiaoge.domain.User" parameterType="com.xiaoge.domain.QueryVo"> select * from user where username like #{user.userName} </select> </mapper>
测试持久层接口方法
-
MybatisTest
package com.xiaoge.test; import com.xiaoge.dao.UserDao; import com.xiaoge.domain.User; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import org.junit.After; import org.junit.Before; import org.junit.Test; import java.io.IOException; import java.io.InputStream; import java.util.Date; import java.util.List; /** * @Author: 潇哥 * @DateTime: 2020/3/4 下午4:22 * @Description: 测试mybatis的crud操作 */ public class MybatisTest { private InputStream is; private SqlSession session; private UserDao userDao; /** * 初始化 获取代理对象 */ @Before // 用于在测试方法之前执行 public void init() throws IOException { // 1. 加载配置文件 is = Resources.getResourceAsStream("SqlMapConfig.xml"); // 2. 获取SqlSessionFactory SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); SqlSessionFactory factory = builder.build(is); // 3. 获取SqlSession对象 session = factory.openSession(); // 4. 获取代理对象 userDao = session.getMapper(UserDao.class); } @After // 用于在测试方法之后执行 public void destroy() throws IOException { // 1. 提交事务(提交事务以后才会映射进数据库, 不提交的话, 它会自动回滚) session.commit(); // 2. 释放资源 if (session != null) { session.close(); } if (is != null) { is.close(); } } /** * 测试查询所有用户信息 * @throws IOException */ @Test public void findAllTest() throws IOException { // 1. 遍历获取所有的用户 List<User> users = userDao.findAll(); for (User user : users) { System.out.println(user); } // 运行结果 User{userId=null, userName='老王', userAddress='null', userSex='null', userBirthday=null} User{userId=null, userName='小二王', userAddress='null', userSex='null', userBirthday=null} User{userId=null, userName='小二王', userAddress='null', userSex='null', userBirthday=null} User{userId=null, userName='老王', userAddress='null', userSex='null', userBirthday=null} User{userId=null, userName='小马宝莉', userAddress='null', userSex='null', userBirthday=null} User{userId=null, userName='啸哥', userAddress='null', userSex='null', userBirthday=null} User{userId=null, userName='李四 last insertid', userAddress='null', userSex='null', userBirthday=null} User{userId=null, userName='王五 last insertid', userAddress='null', userSex='null', userBirthday=null} User{userId=null, userName='李六 last insertid', userAddress='null', userSex='null', userBirthday=null} } }