Mybatis 的基本配置

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>cn.edu.nynu</groupId>
    <artifactId>Charters4_Work</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
    </properties>

        <dependencies>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.11</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.5.2</version>
            </dependency>
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>test</scope>
            </dependency>

            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>
           
        </dependencies>

        <build>
            <resources>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>

                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>true</filtering>
                </resource>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>

                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>true</filtering>
                </resource>
            </resources>
        </build>

</project>

如果要加入Spring 框架，就加入一下依赖

<dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>5.0.5.RELEASE</version>
</dependency>

---

resources

log4j.properties

#??????
# 1??log4j??????
# 2?mybatis-config.xml????? <setting name="logImpl" value="LOG4jJ"/>
# 3.log4j.logger.cn.edu.nynu.mapper=stdout????????mapper.xml???namespace
# 4.??c???????
#???  ????DEBUG?INFO?WARN?ERROR?FATAL 2?????????
log4j.rootLogger=error,stdout,file

#?????????????debug?stdout,?????mapper.xml???namespace
log4j.logger.cn.edu.nynu.mapper=stdout

#??????
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
#??????
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
#??????,??System.out
log4j.appender.stdout.Target=System.err
#?????????
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy/MM/dd HH:mm:ss,SSS} %m%n

#??????
log4j.appender.file=org.apache.log4j.FileAppender
#??????
log4j.appender.file.layout=org.apache.log4j.PatternLayout
#??????????????,?????C????????C????
log4j.appender.file.File=d:\\log.txt
#?????????
log4j.appender.file.layout.ConversionPattern=%d{yyyy/MM/dd HH\:mm\:ss,SSS} %p %m%n

db.properties

mysql.driver=com.mysql.cj.jdbc.Driver
mysql.url=jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false
mysql.username=root
mysql.password=root