MyBatis入门（二）

核心流程介绍

       我们都知道MyBtis是对JDBC的简易封装，它的出现某种程度了是为了消除所有的 JDBC代码和参数的手工设置以及结果集的封装问题；不管怎样，JDBC的那一套还是不会变的，只是做了抽象、封装、归类等；所以想要理解MyBatis的执行流程，那我们就不得不先预习一下JDBC的执行流程。

JDBC执行六部走 ->

1. 注册驱动
2. 获取Connection连接
3. 执行预编译
4. 执行SQL
5. 封装结果集
6. 释放资源
   

---

1、环境说明：

1. jdk 8 +
2. MySQL 5.7.19
3. maven-3.6.0
4. IDEA
   

---

2、MyBatis第一个程序：

    2.1 数据库 data_base

CREATE DATABASE `mybatis`;
	USE `mybatis`;
	DROP TABLE IF EXISTS `user`; 
	CREATE TABLE `user` ( `id` int(20) NOT NULL,
	`name` varchar(30) DEFAULT NULL, 
	`pwd` varchar(30) DEFAULT NULL, 
	PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8; 

insert into `user`(`id`,`name`,`pwd`) values (1,'张三','123456'),
											 (2,'李四','abcdef'),
											 (3,'王五','987654');

---

    2.2 在Maven中配置，pom.xml

<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.47</version>
</dependency> 

---

    2.3 在Maven添加静态资源导出过滤配置

<!--在build中配置resources，来防止我们资源导出失败的问题-->
    <build>
        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
            <resource>
                <!--在src/main/java的目录下可以包含**/*.properties和**/*.xml-->
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

    2.4 mybatis-config.xml

<?xml version="1.0" encoding="UTF8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<!--configuration核心配置文件-->
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=GMT"/>
                <property name="username" value="root"/>
                <property name="password" value="123123"/>
            </dataSource>
        </environment>
    </environments>

    <!--每一个Mapper.xml都需要在Mybatis核心配置文件中注册!-->
    <mappers>
        <mapper resource="com/junjail/dao/UserMapper.xml"/>
    </mappers>
</configuration>

---

    2.5 MybatisUtils.java 数据库加载工具类

public class MybatisUtils {
    private static SqlSessionFactory sqlSessionFactory;

    static {
        try {
            //1、使用mybatis获取sqlSessionFactory对象
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    //既然有了 SqlSessionFactory，顾名思义，我们可以从中获得 SqlSession 的实例。
    // SqlSession 提供了在数据库执行 SQL 命令所需的所有方法。
    // 你可以通过 SqlSession 实例来直接执行已映射的 SQL 语句。

    public static SqlSession getSQlSession() {
        SqlSession sqlSession = sqlSessionFactory.openSession();
        return sqlSession;
    }
}

    2.6 User.java 实体类

public class User { 
	private int id; //id 
	private String name; //姓名 
	private String pwd; //密码 
	
	//构造,有参,无参 
	//set/get 
	//toString()
}

---

    2.7 Mapper.java 接口类

public interface UserMapper { 
	List<User> selectUser();
 } 

---

    2.8 Mapper.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.kuang.dao.UserMapper"> 
	<select id="selectUser" resultType="com.kuang.pojo.User"> 
		select * from user 
	</select>
</mapper> 

---

    2.9 Junit 包测试

public class MyTest { 
	@Test public void selectUser() { 
		SqlSession session = MybatisUtils.getSession(); 
		//方法一:
		//List<User> users = ession.selectList("com.kuang.mapper.UserMapper.selectUser"); 
		//方法二: 
		UserMapper mapper = session.getMapper(UserMapper.class); 
		List<User> users = mapper.selectUser(); 
		
		for (User user: users) { 
			System.out.println(user);
		}
		session.close();
	}
}