[MyBatis]-初学者配置模板

 mybatis官网:mybatis – MyBatis 3 | 简介

  mybatis-config核心配置文件:

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "https://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.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mydb?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=Asia/Shanghai"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="com/duqiaoli/mapper/DeptMapper.xml"/>
    </mappers>

实体类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">
<!--映射文件的功能相当于daoImpl，dao的实现类-->
<!--相当于接口实现类，namespace要指定接口的全限定名-->
<mapper namespace="com.duqiaoli.mapper.DeptMapper">
    <select id="selectDeptList" resultType="com.duqiaoli.pojo.Dept">
        select * from dept
    </select>
</mapper>

测试类(获取sqlSession)文件:

public class Test01 {
    private SqlSession sqlSession;

    @Before
    public void init() {

        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        InputStream stream = null;
        try {
            stream = Resources.getResourceAsStream("mybatisConfig.xml");
        } catch (IOException e) {
            e.printStackTrace();
        }
        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(stream);
        sqlSession = sqlSessionFactory.openSession();
    }

    @Test
    public void testMyBatis() {

        List<Dept> deptList = sqlSession.selectList("selectDeptList");
        for (Dept dept : deptList) {
            System.out.println(dept);
        }
    }

    @After
    public void release() {
        sqlSession.close();

    }