PLSQL数据库Mybatis学习Day01

3.1、核心配置文件

<?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文件 -->
    <properties resource="db.properties" />
  <!-- settings标签 -->
  <settings>
    <!-- 设置MyBatis使用log4j日志支持 -->
    <setting name="logImpl" value="LOG4J"/>
  </settings>

  <!--
  用于指定使用哪一个开发环境
  default : 用于指定使用的环境的id属性值
  -->
  <environments default="dev">
    <!--
    environment : 用于配置开发环境
    id : 环境的唯一标识
    -->
    <environment id="dev">
      <!--
      transactionManager 事务管理器
      type="JDBC" 采用jdbc相同的事务管理机制
      -->
      <transactionManager type="JDBC"/>
      <!--
      dataSource : 用来配置数据库连接参数
      type="POOLED" 采用连接池技术
      -->
      <dataSource type="POOLED">
        <property name="driver" value="oracle.jdbc.driver.OracleDriver"/>
        <property name="url" value="jdbc:oracle:thin:@localhost:1521:XE"/>
        <property name="username" value="SCOTT"/>
        <property name="password" value="YJXXT"/>
      </dataSource>
    </environment>
  </environments>
  <!--扫描SQL映射文件-->
  <mappers>
    <mapper resource="com/yjxxt/mappers/DeptMapper.xml"/>
  </mappers>
</configuration>

3.2、log4j日志

# Set root category priority to INFO and its only appender to CONSOLE. # log4j.rootCategory=DEBUG, CONSOLE log4j.rootCategory=INFO, CONSOLE, LOGFILE # 单独设置SQL语句输出级别为DEBUG # 方法级别设置(SQL语句) # log4j.logger.com.yjxxt.mappers.DeptMapper.queryDept=DEBUG # 类级别设置(SQL映射文件) # log4j.logger.com.yjxxt.mappers.DeptMapper=DEBUG # 类级别设置(SQL映射文件) log4j.logger.com.yjxxt.mappers=DEBUG # CONSOLE is set to be a ConsoleAppender using a PatternLayout. log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout log4j.appender.CONSOLE.layout.ConversionPattern=- %m %n # LOGFILE is set to be a File appender using a PatternLayout. log4j.appender.LOGFILE=org.apache.log4j.FileAppender log4j.appender.LOGFILE.File=d:/test.log log4j.appender.LOGFILE.Append=true log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout log4j.appender.LOGFILE.layout.ConversionPattern=- %m %l %n

3.3.1、IDEA实体类映射表

public class Dept {
    private int deptno;
    private String dname;
    private String loc;

    public Dept() {
    }

    public Dept(int deptno, String dname, String loc) {
        this.deptno = deptno;
        this.dname = dname;
        this.loc = loc;
    }

    public int getDeptno() {
        return deptno;
    }

    public void setDeptno(int deptno) {
        this.deptno = deptno;
    }

    public String getDname() {
        return dname;
    }

    public void setDname(String dname) {
        this.dname = dname;
    }

    public String getLoc() {
        return loc;
    }

    public void setLoc(String loc) {
        this.loc = loc;
    }

    @Override
    public String toString() {
        return "Dept{" +
                "deptno=" + deptno +
                ", dname='" + dname + '\'' +
                ", loc='" + loc + '\'' +
                '}';
    }
}

3.3.2、SQL映射文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/my