MyBatis框架的使用及源码分析(一) 使用与配置

注意：本《MyBatis框架的使用及源码分析》素有章节只单纯地描述mybatis源码，不涵盖mybatis-spring的源码。

1、我们先来看一个例子，简单的了解一下mybatis的mapper接口方式的使用。

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 java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;

public class TestApp {
    public static void main(String[] args) throws IOException {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        try {
          UserInfoMapper mapper = sqlSession.getMapper(UserInfoMapper.class);
          UserInfo userInfoById = mapper.getUserInfoById(1L);
          System.out.println(userInfoById);
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            sqlSession.close();
        }

    }
}

2、数据库表 user

DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `sex` int(1) NULL DEFAULT NULL COMMENT '性别',
  `create_date` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES (1, '小王', 0, '2019-11-05 10:06:36');
INSERT INTO `user_info` VALUES (2, '小明', 0, '2019-11-05 10:06:36');
INSERT INTO `user_info` VALUES (4, '小红', 1, '2019-11-05 10:06:36');
INSERT INTO `user_info` VALUES (8, '小孙', 0, '2019-11-05 10:02:20');
INSERT INTO `user_info` VALUES (9, '三叶', 1, '2019-11-05 10:06:36');
INSERT INTO `user_info` VALUES (10, '梨花', 1, '2019-11-05 10:47:52');

 

3、UserInfo.java

public class UserInfo {
  Long id;
  /**
   * 名字
   */
  private String userName;
}

4、UserInfoMaper.java

public interface UserInfoMapper {
  UserInfo getUserInfoById(Long id);
}

5、UserInfoMapper.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="org.apache.ibatis.mybatisTest.UserInfoMapper" >

  <sql id="Base_Column_List" >
        id, user_name, sex, create_date
    </sql>

  <resultMap id="BaseResultMap" type="org.apache.ibatis.mybatisTest.UserInfo">
    <id column="id" jdbcType="BIGINT" property="id" />
    <result column="user_name" jdbcType="VARCHAR" property="userName" />
  </resultMap>

  <select id="getUserInfoById" resultMap="BaseResultMap" parameterType="Long">
    select  <include refid="Base_Column_List"></include>
    from user_info
    where id = #{id}
  </select>
</mapper>

6、mybatis-config.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>

  <!--定义属性值-->
  <properties>
        <!--不推荐使用Driver-->
        <!--<property name="driver" value="com.mysql.jdbc.Driver"/>-->
        <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/springboot?useUnicode=true"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
    </properties>

    <settings>
        <setting name="cacheEnabled" value="true"/>
        <!--<setting name="defaultExecutorType" value="SIMPLE"/> 设置执行器的类型，可以参考ExecutorType类-->
    </settings>

    <!-- 类型别名 -->
    <typeAliases>
        <typeAlias alias="userInfo" type="org.apache.ibatis.mybatisTest.UserInfo"/>
    </typeAliases>

    <!--环境-->
    <environments default="development">
        <environment id="development"><!--采用jdbc 的事务管理模式-->
            <transactionManager type="JDBC">
                <property name="..." value="..."/>
            </transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>

    <!--映射器  告诉 MyBatis 到哪里去找到这些语句-->
    <mappers>
        <mapper resource="UserInfoMapper.xml"/>
    </mappers>

</configuration>

 

上面几个类，在后面的章节中，都会用到，最好本地确定能启动起来。这样也方便调试。

后面会分别解析如何加载mybatis.xml配置文件，如何解析Mapper.xml和解析Mppaer如何被代理了。

 

 

本文转自：https://www.cnblogs.com/zsg88/p/7533894.html