Mybatis初始化

Mybatis入门配置

1、导入Mybatis依赖（jar包）（包括log4j依赖，下面有提到）

<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>3.4.6</version>
</dependency>
<!-- https://mvnrepository.com/artifact/log4j/log4j -->
<dependency>
  <groupId>log4j</groupId>
  <artifactId>log4j</artifactId>
  <version>1.2.17</version>
</dependency>

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>

  <!-- 引入外部资源文件(数据库配置文件等、) -->
  <properties resource="db.properties"></properties>
  <!-- 设置  -->
  <settings>
    <!-- 缓存，开启全局缓存 -->
    <setting name="cacheEnabled" value="true"/>
    <!--日志配置标准日志文件   LOG4J log4j日志（需要写log4j配置文件）-->
    <setting name="logImpl" value="STDOUT_LOGGING"/>
    <!-- 将数据库中的user_id和实体类中的userId映射 -->
    <setting name="mapUnderscoreToCamelCase" value="true"/>
  </settings>
  <!--  设置别名  -->
  <typeAliases>
    <!-- 对每一个实体类起一个别名-->
    <typeAlias type="com.yph.pojo.User" alias="User"/>
    <!-- 对com.yph.pojo包下每一个实体类起一个别名-->
    <package name="com.yph.pojo"/>
  </typeAliases>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
      </dataSource>
    </environment>
  </environments>

  <mappers>
    <!-- 接口和xml的映射 -->
    <mapper resource="yph/dao/UserMapper.xml"/>
  </mappers>

</configuration>

3、Log4j一些基础配置：

#将等级为DEBUG的日志信息输出到console和file这两个目的地，console和file的定义在下面的代码
log4j.rootLogger=DEBUG,console,file

#控制台输出的相关设置
log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.Target = System.out
log4j.appender.console.Threshold=DEBUG
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=[%c]-%m%n

#文件输出的相关设置
log4j.appender.file = org.apache.log4j.RollingFileAppender
log4j.appender.file.File=./log/yph.log
log4j.appender.file.MaxFileSize=10mb
log4j.appender.file.Threshold=DEBUG
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=[%p][%d{yy-MM-dd}][%c]%m%n

#日志输出级别
log4j.logger.org.mybatis=DEBUG
log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG

4、实体类：

public class User {
  private int id;
  private String name;
  private String pwd;
}

5、UserMapper接口编写

public interface UserMapper {
  //查询所有用户
  List<User> getUserList();
}

6、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="com.yph.dao.UserMapper">
  <!-- 每一个语句对应接口中的一个方法 -->
  <select id="getUserList" resultType="User">
    select * from mybatis.user;
  </select>
</mapper>

7、Mybatis工具类：

public class MybatisUtil {
  private static  SqlSessionFactory sqlSessionFactory;
  static {
    InputStream inputStream = null;
    try {
      String resource = "mybatis-config.xml";
      inputStream = Resources.getResourceAsStream(resource);
      sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    } catch (IOException e) {
      e.printStackTrace();
    }
  }
  public static SqlSession getSqlSession(){
    return sqlSessionFactory.openSession();
  }
}

8、测试类：

@Test
public void getUserList(){
  //根据工具类获取SqlSession对象
  SqlSession session= MybatisUtil.getSqlSession();
  //获取UserMapper对象。 
  UserMapper userMapper= session.getMapper(UserMapper.class);
  //调用方法，获取返回值
  List<User> userList= userMapper.getUserList();
  for(User user:userList){
    System.out.println(user.toString());
  }
  session.close();
}