Mybatis(一）配置文件，日志，测试运行-创新互联

1.创建maven项目及以下文件

pom.xml

mysql mysql-connector-java8.0.16org.mybatis  mybatis3.5.3junit   junit4.13.1test

2.mybatis-config.xml:mybatis核心文件，名字自取

3.实体类Dept,接口DeptMapper(dao层)，及配置文件DeptMapper.xml

Dept类：注意不要使用lombok，占内存，会被骂的

public class Dept {
    private int deptno;
    private String dname;
    private String 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 + '\'' +
                '}';
    }
}

DeptMapper:

public interface DeptMapper {
    ListfindAll();
}

DeptMapper.xml:

select  *from dept;

4.测试运行：

public class Test {
    public static void main(String[] args) throws IOException {
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(inputStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        ListfindAll = sqlSession.selectList("findAll");
        for (Dept dept : findAll){
            System.out.println(dept);
        }
        sqlSession.close();
    }
}

5.配置日志log4j.properties.注意log4j不要写错，甚至大小写也不要写错.

两种方式，现在一般都用log4j2了

1)log4j.properties

log4jlog4j1.2.17

#定义全局日志级别调试阶段推荐debug
log4j.rootLogger=debug,stdout

#stdout,logfile
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.err
log4j.appender.stdout.layout=org.apache.log4j.SimpleLayout

log4j.appender.logfile=org.apache.log4j.FileAppender
log4j.appender.logfile.File=d:/msb.log
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %l %F %p %m%n

2) log4j2.xml

org.apache.logging.log4jlog4j-core2.12.1

你是否还在寻找稳定的海外服务器提供商？创新互联www.cdcxhl.cn海外机房具备T级流量清洗系统配攻击溯源，准确流量调度确保服务器高可用性，企业级服务器适合批量采购，新人活动首月15元起，快前往官网查看详情吧