mybatis(配置)

主要：简化数据库连接。

1、导入两个包：mybatis/mysql-connector

<dependencies>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>5.1.42</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.42</version>
    </dependency>
</dependencies>

2、配置主要文件：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>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                //导入包
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                //连接地址
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis_db"/>
                //数据库用户名
                <property name="username" value="root"/>
                //数据库密码
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    //用于映射的XML文件
    <mappers>
        <mapper resource="com/sangeng/dao/UserDao.xml"/>
    </mappers>
</configuration>

3、创建Dao同级包：注意要用/命名，不能使用（.）点号。

例子：com/sanggeng/dao

4、创建dao的xml文件

<?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.sangeng.dao.UserDao">
    <select id="findAll" resultType="com.sangeng.pojo.User">
        select * from user
    </select>

    <select id="findUser" resultType="com.sangeng.pojo.User">
        select * from user where id = 2
    </select>
</mapper>

5、测试类的配置

public class Demo {
    public static void main(String[] args) throws IOException {
        //定义mybatis配件文件路径
        String resource = "mybatis-config.xml";
        //传入配置文件输入流，读取文件获得 SqlSessionFactory对象
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new             
        SqlSessionFactoryBuilder().build(inputStream);
        // 获取SqlSession对象
        SqlSession session = sqlSessionFactory.openSession();
        //获取UserDao实现类对象
        UserDao userDao = session.getMapper(UserDao.class);
        //调用方法测试
        List<User> users = userDao.findAll();
        for (User user:users)
        {
            System.out.println(user);
        }
        //释放资源
        session.close();
    }

}