MyBatis

MyBatis概念

持久层(DAO)框架
官网：https://mybatis.org/mybatis-3/zh/index.html

MyBatis开发步骤

1. 在pom.xml中添加MyBatis依赖的基本坐标
2. 创建数据表，e.g  user
3. 新建实体类，e.g  java  com.cn.domain.User
4. 新建映射文件，e.g  resources  com.cn.mapper.UserMapper.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="userMapper">
  <select id="selectAllUser" resultType="com.cn.domain.User">
    select * from user 
  </select>
</mapper>

5. 新建核心文件，e.g resources  SqlMapConfig.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="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="com/cn/mapper/UserMapper.xml"/>
  </mappers>
</configuration>

6. 测试

InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

SqlSession session = sqlSessionFactory.openSession();
List<User> userList = session.selectList("userMapper.selectAllUser");
System.out.println(userList);
session.close();