# 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 + '\'' +
'}';
}
}