MyBatis入门回顾

简单回顾MyBatis入门

1. 导入jar包，相关jar包有：mybatis、spring-webmvc、mysql-connector-java、spring-jdbc、junit、mybatis-spring、aspectjweaver，以上均为artifactId。

2. 编写实体类，为了方便生成set get方法，可以导入Lombok包（artifactId为lombok），使用@Data注解。

3. mybatis核心配置文件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>

    <typeAliases>
        <package name = "com.xxx.pojo"/>
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>

</configuration> 

4. 编写DAO接口，一般命名为实体类+Mapper，里面写一个查询方法，具体实现写在相应的xml文件中，注意不要忘记mapper的namespace

<?xml version="1.0" encoding="UTF-8"?>
        <!DOCTYPE mapper PUBLIC 
                "-//mybatis.org//DTD Config 3.0//EN" 
                "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xxx.dao.UserMapper">
    <select id="getUserList" resultType="User">
      select * from user
    </select>
</mapper>

5. 在核心配置文件中注册

<mappers>
    <mapper class="com.xxx.mapper.UserMapper"/>
</mappers>

6. 在pom.xml中加上mapper的xml文件的路径

<!--    在build中配置resources ， 来防止我们资源导出失败的问题-->
    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
            </resource>
        </resources>
    </build>

7. 测试

String resource = "mybatis-config.xml";
InputStream in = Resources.getResourceAsStream(resource);
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(in);
SqlSession sqlSession = sessionFactory.openSession(true);

UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List<User> userList = mapper.queryAll();

for (User user : userList) {
    System.out.println(user);
}