Mybatis映射

1 映射文件XXMapper.xml语法：

<mapper namespace="cn.smbms.dao.user.UserMapper">
    <select id="getUserList" …
		……
    </select>
</mapper>

1.1 namespace：命名空间

namespace的命名必须跟某个接口同名

1.2 id: 命名空间中唯一的标识符

接口中的方法与映射文件中的SQL语句id一一对应

1.3 parameterType: 参数类型

传入SQL语句的参数类型

1.4 resultType：返回值类型

SQL语句返回值类型的完整类名或别名

1.5 实战：

需求：根据用户名对用户表进行模糊查询 

1.6 实现：

(1)导入库

smbms_db.sql

(2)创建工程,目录

(3)pom

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.2</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.38</version>
</dependency>

(4)实体类

package cn.xs.entity;

public class User {
    private Integer id;
    private String userCode;
    private String userName;
    private String userPassword;
    private Integer gender;
    private String birthday;
    private String phone;
    private String address;
    private Integer userRole;
    private Integer createdBy;
    private String creationDate;
    private Integer modifyBy;
    private String modifyDate;

    private String userRoleName;

    public String getUserRoleName() {
        return userRoleName;
    }

    public void setUserRoleName(String userRoleName) {
        this.userRoleName = userRoleName;
    }

    public String getCreationDate() {
        return creationDate;
    }

    public void setCreationDate(String creationDate) {
        this.creationDate = creationDate;
    }

    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 String getBirthday() {
        return birthday;
    }

    public void setBirthday(String 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 Integer getModifyBy() {
        return modifyBy;
    }

    public void setModifyBy(Integer modifyBy) {
        this.modifyBy = modifyBy;
    }

    public String getModifyDate() {
        return modifyDate;
    }

    public void setModifyDate(String modifyDate) {
        this.modifyDate = modifyDate;
    }
}

(5)mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN"
        "http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/smbms"/>
                <property name="username" value="root"/>
                <property name="password" value="123"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <mapper resource="cn/xs/mapper/UserMapper.xml"/>
    </mappers>
</configuration>

(6)mapper/UserMapper.java

package cn.xs.mapper;

import cn.kgc.entity.User;

import java.util.List;

public interface UserMapper {
    public List<User> findByName(String userName);
}

(7)mapper/UserMapper.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="cn.xs.mapper.UserMapper">
    <select id="findByName" parameterType="java.lang.String" resultType="cn.xs.entity.User">
        select * from smbms_user where userName like concat('%',#{userName},'%')
    </select>
</mapper>

(8)MyBatisUtil

package cn.smbms.utils;

import java.io.IOException;
import java.io.InputStream;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class MyBatisUtil {
	private static SqlSessionFactory factory;
	
	static{//在静态代码块下，factory只会被创建一次
		System.out.println("static factory===============");
		try {
			InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
			factory = new SqlSessionFactoryBuilder().build(is);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} 
	}
	
	public static SqlSession createSqlSession(){
		return factory.openSession(false);//true 为自动提交事务
	}
	
	public static void closeSqlSession(SqlSession sqlSession){
		if(null != sqlSession) 
			sqlSession.close();
	}
}

(9)TestUserMapper.java

package cn.xs.test;

import cn.kgc.entity.User;
import cn.kgc.mapper.UserMapper;
import cn.kgc.util.MyBatisUtil;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.io.IOException;
import java.util.List;

public class TestUserMapper {
    @Test
    public void testfindByName() throws IOException {
        SqlSession sqlSession = MyBatisUtil.createSqlSession();
        List<User> list = sqlSession.getMapper(UserMapper.class).findByName("孙");
        for(User u:list){
            System.out.println("用户名称:"+u.getUserName()+" 用户密码："+u.getUserPassword());
        }
        sqlSession.close();
    }
}

PS:parameterType 基础数据类型/复杂数据类型

parameterType
(1)基础数据类型:
int、String、Date等
只能传入一个，通过#{参数名}即可获取传入的值
(2)复杂数据类型:
Java实体类、Map等
通过#{属性名}或者#{map的keyName}即可获取传入值

resultMap 描述如何将结果集映射到Java对象

resultType ：直接表示返回类型
基本数据类型
复杂数据类型
resultMap ：对外部resultMap的引用
应用场景：
数据库字段信息与对象属性不一致
复杂的联合查询，自由控制映射结果
二者不能同时存在，本质上都是Map数据结构

核心注意点：insert、update、delete元素均没有resultType属性

resultMap核心思想：

id
一般对应数据库中该行的主键id，设置此项可提高MyBatis性能

result
映射到JavaBean的某个“简单类型”属性

association
映射到JavaBean的某个“复杂类型”属性，比如JavaBean类

collection
映射到JavaBean的某个“复杂类型”属性，比如集合

association核心思想：

association
复杂的类型关联，一对一
内部嵌套
映射一个嵌套JavaBean属性
属性
property：映射数据库列的实体对象的属性
javaType：完整Java类名或者别名
resultMap：引用外部resultMap
子元素
id
result
property：映射数据库列的实体对象的属性
column：数据库列名或者别名

collection核心思想：

collection
复杂类型集合，一对多
内部嵌套
映射一个嵌套结果集到一个列表
属性
property：映射数据库列的实体对象的属性
ofType：完整Java类名或者别名(集合所包括的类型)
resultMap：引用外部resultMap
子元素
id
result
property：映射数据库列的实体对象的属性
column：数据库列名或者别名