Mybatis 使用

1.引入依赖

<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>x.x.x</version>
</dependency>

2.配置mybatis-config

<?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 resource="config/jdbc.properties"></properties>

    <settings>
        <!--    开启驼峰命名映射-->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
<!--        开启mybatis日志功能-->
        <setting name="logImpl" value="LOG4J"/>
    </settings>
<!--         包别名-->
    <typeAliases>
        <package name="cn.kgc.mybatis.entity"/>
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
<!--            数据库连接池参数配置-->
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
<!-- 通过包名   映射文件位置-->
    <mappers>
        <package name="cn.kgc.mybatis.mapper"/>
    </mappers>
</configuration>

3.配置mybatis-mapper

<?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.kgc.mybatis.mapper.TeMapper">

    <select id=" 映射数据库名 " parameterType=" 映射数据库类实例所在位置全类名 ">
             <!--    数据库操作   -->
    </select>

    
</mapper>

4.构建 SqlSessionFactory

//获取资源
 InputStream resourceAsStream = Resources.getResourceAsStream("config/mybatis-config.xml");
 //创建工厂对象
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(resourceAsStream);
 SqlSession sqlSession = factory.openSession();
 System.out.println("sqlSession = " + sqlSession);