小白mybatis源码看这一遍就够了（1）| 前言

mybatis源码分析系列：

1. mybatis源码看这一遍就够了（1）| 前言
2. mybatis源码看这一遍就够了（2）| getMapper
3. mybatis源码看这一遍就够了（3）| Configuration及解析配置文件
4. mybatis源码看这一遍就够了（4）| SqlSession.select调用分析
5. mybatis源码看这一遍就够了（5）| 与springboot整合

前言这一章主要是为后面分析源码做铺垫，也好回忆下，这篇章将从操作jdbc到操作mybatis的简单demo入手。

在分析mybatis源码前，我们首先先来回忆下jdk提供的sql操作步骤和mybatis的入门例子

---

准备数据表和数据：

CREATE TABLE `user` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `age` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

 

一、jdbc中数据库的操作

1.引入pom

   <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.15</version>
        </dependency>
    </dependencies>

2.简单入门例子：

public class JdbcTest {
    @Test
    public void test() throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");
        Properties pro = new Properties();
        pro.setProperty("user","root");
        pro.setProperty("password","123456");
        Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC",pro);
        //Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC","root","123456");
        //Statement statement = connection.createStatement();
        PreparedStatement statement = connection.prepareStatement("select * from user");
        statement.execute();
        ResultSet resultSet = statement.getResultSet();
        //ResultSet resultSet = statement.executeQuery("select * from user");
        while (resultSet.next()){
            System.out.println(resultSet.getString("name")+":"+resultSet.getInt("age"));
        }
        resultSet.close();
        statement.close();
        connection.close();
    }
}

3.结果打印：

以上是我们在jdk下操作数据库的简单操作流程，第一步加载mysql驱动，第二步创建mysql数据库连接，第三步创建Statement，第四步执行sql语句，第五步获取执行结果，第六步关闭所有。

好了下面我们来看看mybatis的入门例子

 

二、mybatis入门例子

1.引入pom:

 <dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.2</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.46</version>
        </dependency>
    </dependencies>

2.创建configuration.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="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
              <property name="driver" value="com.mysql.jdbc.Driver"/>
              <property name="url" value="jdbc:mysql://127.0.0.1:3306/test"/>
              <property name="username" value="root"/>
              <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="mybatis/UserMapper.xml"/>
    </mappers>
</configuration>

3.创建UserMapper.xml,将文件放在我们创建的mybatis目录

<?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.cwh.test.dao.UserDao">
    <select id="select" resultType="com.cwh.test.entity.User">
      select * from user
    </select>
</mapper>

这里的namespace路径对应的是我们UserDao的全名，也就是包名+类名

4.创建UserDao

public interface UserDao {
    List<User> select();
}

5.执行操作：

   @Test
    public void selectUser() throws IOException {
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader("configuration.xml"));
        SqlSession sqlSession = sqlSessionFactory.openSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        List<User> users = mapper.select();
        System.out.println(users);

    }

6.结果打印：

 

以上是我们在mybatis操作数据库时的操作步骤，第一步new SqlSessionFactoryBuilder()；第二步通过SqlSessionFactoryBuilder读取配置文件configuration.xml并创建SqlSessionFactory；第三步用过SqlSessionFactory获取SqlSession;第四步获取代理UserDao;第五步执行sql获取结果。其实这里第四步第五步可以简略如以下操作：

@Test
    public void selectUser2() throws IOException {
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader("configuration.xml"));
        SqlSession sqlSession = sqlSessionFactory.openSession();
        List<User> users = sqlSession.selectList("com.cwh.test.dao.UserDao.select");
        System.out.println(users);

    }

直接sqlSession.selectList("com.cwh.test.dao.UserDao.select");这里对应就是UserMapper.xml的namespace+.id;这样完全就省略创建UserDao;那这两种有什么不同或相同呢？下章mybatis源码看这一遍就够了（2）我们就这个问题来进行分析