Mybatis(5):使用sql映射文件,将返回结果封装为ResulMap
来源:互联网 发布:vmware 端口转发 编辑:程序博客网 时间:2024/05/29 03:02
四部曲:
1.写接口 + 2.写映射sql + 3.把mapper注册到mybatis的配置文件 + 4.写单元测试和运行
今天通过使用Mybatis框架·,将MySQL查询得到的数据封装为ResulMap,并映射到实体类User.java。这个过程是通过设置<select ></select >的resultMap属性为<resultMap></resultMap>的id,从而调用了它。
下面是具体的代码:
(1)首先新建一个User.java文件,作为这次的实体类,注意一定要有setter方法(mybatis通过setter访问器进行读取):
package com.smbms.entities;import java.util.Date;import java.util.List;public class User {private Integer id;private String userCode;private String userName;private String userPassword;private Integer gender;private Date birthday;private String phone;private String address ;private Integer userRole;private Integer createdBy;private Date creationDate;private Integer modifyBy;private Date modifyDate;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getUserCode() {return userCode;}public void setUserCode(String userCode) {this.userCode = userCode;}public String getUserName() {return userName;}public void setUserName(String userName) {this.userName = userName;}public String getUserPassword() {return userPassword;}public void setUserPassword(String userPassword) {this.userPassword = userPassword;}public Integer getGender() {return gender;}public void setGender(Integer gender) {this.gender = gender;}public Date getBirthday() {return birthday;}public void setBirthday(Date birthday) {this.birthday = birthday;}public String getPhone() {return phone;}public void setPhone(String phone) {this.phone = phone;}public String getAddress() {return address;}public void setAddress(String address) {this.address = address;}public Integer getUserRole() {return userRole;}public void setUserRole(Integer userRole) {this.userRole = userRole;}public Integer getCreatedBy() {return createdBy;}public void setCreatedBy(Integer createdBy) {this.createdBy = createdBy;}public Date getCreationDate() {return creationDate;}public void setCreationDate(Date creationDate) {this.creationDate = creationDate;}public Integer getModifyBy() {return modifyBy;}public void setModifyBy(Integer modifyBy) {this.modifyBy = modifyBy;}public Date getModifyDate() {return modifyDate;}public void setModifyDate(Date modifyDate) {this.modifyDate = modifyDate;}public User(Integer id, String userCode, String userName, String userPassword, Integer gender, Date birthday,String phone, String address, Integer userRole, Integer createdBy, Date creationDate, Integer modifyBy,Date modifyDate) {super();this.id = id;this.userCode = userCode;this.userName = userName;this.userPassword = userPassword;this.gender = gender;this.birthday = birthday;this.phone = phone;this.address = address;this.userRole = userRole;this.createdBy = createdBy;this.creationDate = creationDate;this.modifyBy = modifyBy;this.modifyDate = modifyDate;}public User() {super();// TODO 自动生成的构造函数存根}@Overridepublic String toString() {return "User [id=" + id + ", userCode=" + userCode + ", userName=" + userName + ", userPassword=" + userPassword+ ", gender=" + gender + ", birthday=" + birthday + ", phone=" + phone + ", address=" + address+ ", userRole=" + userRole + ", createdBy=" + createdBy + ", creationDate=" + creationDate+ ", modifyBy=" + modifyBy + ", modifyDate=" + modifyDate + "]";}}
(2)然后,新建一个接口类 UserMapper.java,定义一个新的方法 public List<User> getUserList(User user) ;:
package com.smbms.dao;import java.util.List;import java.util.Map;import org.apache.ibatis.annotations.Param;import com.smbms.entities.User;public interface UserMapper {public List<User> getUserList(User user);}
【业务模型传递参数到sql执行查询操作:parameterType = "com.smbms.entities.User“;】
【数据库返回的结果到业务模型,调用了 resultMap:resultMap="userlist" 】
<?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.smbms.dao.UserMapper"> <select id="getUserList" resultMap="userlist" parameterType="com.smbms.entities.User">select u.*,r.rolename from smbms_user u ,smbms_role r where u.username like CONCAT('%',#{username},'%') and u.userRole = #{userRole} and u.userRole = r.id</select><resultMap type="com.smbms.entities.User" id="userlist"><result property="id" column="id"/><result property="userCode" column="userCode"/><result property="userName" column="username"/><result property="phone" column="phone"/><result property="birthday" column="birthday"/><result property="gender" column="gender"/><result property="userRole" column="userRole"/><result property="userRoleName" column="userRoleName"/></resultMap> </mapper>
(4)编写测试用例,导入JUnit4.jar后,可以新建测试用例UserTest.java:
package com.smbms.entities;import java.io.IOException;import java.io.InputStream;import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Date;import java.util.HashMap;import java.util.List;import java.util.Map;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.Test;import com.smbms.dao.ProviderMapper;import com.smbms.dao.UserMapper;public class UserTest {public SqlSession getSqlSession() throws IOException{String resource = "mybatis-config.xml";InputStream inputStream = Resources.getResourceAsStream(resource);SqlSessionFactory build = new SqlSessionFactoryBuilder().build(inputStream);SqlSession openSession = build.openSession();return openSession;}
//使用resultMap完成查询结果的展现@Testpublic void test06() throws IOException{User user = new User();user.setUserName("mmb");user.setUserRole(110);SqlSession session = getSqlSession();UserMapper mapper = session.getMapper(UserMapper.class);List<User> userByUsername = mapper.getUserList(user);for(User user1:userByUsername){System.out.println("+*+:" +user1.getUserRoleName()+user1.getPhone()+user1.getUserCode()+user1.getUserName()+user1.getUserRole());}}
}
由此完成一个小Demo。
注意之处:
(1)ResulMap 具有两个元素:type 和 id ,type对应结果映射的实体类,id 是Map的唯一标识;
(2)result 是 ResulMap 下的标签元素,具有两个属性:property 和 column, column 对应于数据库的列名,property 对应于实体类定义的属性变量。
阅读全文
0 0
- Mybatis(5):使用sql映射文件,将返回结果封装为ResulMap
- Mybatis(6):返回结果封装ResulMap的高级属性--association标签
- Mybatis(7):返回结果封装ResulMap的高级属性--Collection标签
- Mybatis高级结果映射ResulMap与ResultType,collection与association
- Mybatis 返回结果映射
- mybatis sql返回结果为空值
- hibernate将sql或hql查询结果集映射为实体类 不需要映射文件
- Mybatis 连表查询,返回结果封装为Map
- Mybatis 连表查询,返回结果封装为Map
- hibnernate 将sql结果集封装为实体对象
- mybatis详解-(15)返回结果封装
- Hibernate之使用sql语句查询多个表,返回多种字段,将返回结果映射到自定义的普通pojo类中
- mybatis查询数据库返回结果为空
- MyBatis -- sql映射文件详解
- mybatis sql 映射文件问题
- Mybatis映射文件SQL讲解
- Mybatis SQL映射文件讲解
- MyBatis-SQL映射文件-总结
- 格拉姆施密特求正交基
- Tensorflow分批量读取tfrecords
- 【C++】C++封装、继承、多态小结
- npm基本使用
- Disruptor(无锁并发框架)-发布
- Mybatis(5):使用sql映射文件,将返回结果封装为ResulMap
- EL表达式向select中赋值
- 泊松分布
- hdu1358—Period(循环串)
- 举例说明h权重标签在seo优化中的具体运用
- 我的web之旅
- HDOJ 2010 水仙花数
- centos 7 下编译安装python3.6.1
- linux守护进程