Mybatis入门案例

Mybatis入门案例

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>cn.zm</groupId>
    <artifactId>Mybatis_2</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>jar</packaging>

    <dependencies>

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

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.18</version>
        </dependency>

        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13-rc-2</version>
        </dependency>


    </dependencies>


</project>

		// 1. 读取配制文件,使用类加载器，不推荐使用绝对路径和相对路径
        InputStream is = MyBatisTest.class.getClassLoader().getResourceAsStream("SqlMapConfig.xml");
        // 2. 创建一个SqlSessionFactory工厂，Mybatis使用了构建者模式
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); //SqlSessionFactoryBuilder就是构建者
        SqlSessionFactory factory = builder.build(is);
        // 3. 使用工厂生产SqlSession对象,降低了类间的关系（解耦）
        SqlSession sqlSession= factory.openSession();
        // 4. 使用SqlSession创建Dao接口的代理对象，使用了代理模式，实现了不修改代码，而能够增强功能
        IUserDao userDao = sqlSession.getMapper(IUserDao.class);
        // 5. 使用代理对象执行方法
        List<User> users = userDao.findAll();
        for (User user : users) {
            System.out.println(user);
        }
        // 6. 释放资源
        try {
            sqlSession.close();
            is.close();
        } catch (IOException e) {
            e.printStackTrace();
        }