[MyBatis]-初学者配置模板

r囧r小猫 2023-09-24 14:54 66阅读 0赞

mybatis官网:[mybatis – MyBatis 3 | 简介][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&useUnicode=true&characterEncoding=UTF-8&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">
    
    
    <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();
    
        }

[mybatis _ MyBatis 3 _]: https://mybatis.org/mybatis-3/zh/index.html