mybatis快速入门--自学日志

1.进入MySQL数据库，创建mydb1数据库，创建mytb表--字段和数据如下

num	char(6)
name	varchar(10)
age	int(11)
addr	varchar(12)

1001	chen	100	guangdong
1002	liu	100	hunan
1004	li	23	hunan
1005	wang	42	shanxi

2.进入IDEA创建maven项目---mybatisdemo，默认进入pom.xml，添加依赖的jar包，具体的jar包坐标如下：

<?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>com.example</groupId>
    <artifactId>mybatis-demo</artifactId>
    <version>1.0-SNAPSHOT</version>
    <dependencies>
        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
        <!--导入mybatis包坐标，连接数据库-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>
        <!--导入MySQL包坐标，连接数据库-->
        <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.16</version>
        </dependency>
        <!--导入junit包坐标，测试用-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13</version>
            <scope>test</scope>
        </dependency>
        <!--导入org.slf4j包坐标，logback日志组件依赖的jar包-->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>1.7.5</version>
        </dependency>
        <!--导入logback-core包坐标，logback日志组件依赖的jar包-->
        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-core</artifactId>
            <version>1.2.3</version>
        </dependency>
        <!--导入logback-classic包坐标，logback日志组件依赖的jar包-->
        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-classic</artifactId>
            <version>1.2.3</version>
        </dependency>
    </dependencies>
</project>

3.在IDEA的mybatisdemo项目的src/main/resources下创建logback.xml配置文件，具体代码如下

<!--定义日志文件的存储地址 value中一定要使用绝对路径-->

<?xml version="1.0" encoding="UTF-8"?>

<!-- 配置文件修改时重新加载，默认true -->
<configuration scan="true">
    
    <!--定义日志文件的存储地址 value中一定要使用绝对路径-->
    <property name="CATALINA_BASE" value="D:/idealogs/logs"></property>
    
    <!-- 控制台输出 -->
    <appender name="CONSOLE" class="ch.qos.logback.core.ConsoleAppender">
        <encoder charset="UTF-8">
            <!-- 输出日志记录格式 -->
            <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
        </encoder>
    </appender>
 
    <!-- 第一个文件输出,每天产生一个文件 -->
    <appender name="FILE1" class="ch.qos.logback.core.rolling.RollingFileAppender">
        <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
            <!-- 输出文件路径+文件名 -->
            <fileNamePattern>${CATALINA_BASE}/aa.%d{yyyyMMdd}.log</fileNamePattern>
            <!-- 保存30天的日志 -->
            <maxHistory>30</maxHistory>
        </rollingPolicy>
        <encoder charset="UTF-8">
            <!-- 输出日志记录格式 -->
            <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
        </encoder>
    </appender>
 
    <!-- 第二个文件输出,每天产生一个文件 -->
    <appender name="FILE2" class="ch.qos.logback.core.rolling.RollingFileAppender">
        <file>${CATALINA_BASE}/bb.log</file>
        <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
            <fileNamePattern>${CATALINA_BASE}/bb.%d{yyyyMMdd}.log</fileNamePattern>
            <maxHistory>30</maxHistory>
        </rollingPolicy>
        <encoder charset="UTF-8">
            <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
        </encoder>
    </appender>
    
    <appender name="CUSTOM" class="ch.qos.logback.core.rolling.RollingFileAppender">
        <file>${CATALINA_BASE}/custom.log</file>
        <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
            <!-- daily rollover -->
            <fileNamePattern>${CATALINA_BASE}/custom.%d{yyyy-MM-dd}.log</fileNamePattern>
            <!-- keep 30 days' worth of history -->
            <maxHistory>30</maxHistory>
        </rollingPolicy>
        <encoder charset="UTF-8">
            <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
        </encoder>
    </appender>
    
    <!-- 设置日志输出级别 -->
    <root level="ERROR">
        <appender-ref ref="CONSOLE" />
    </root>
    <logger name="file1" level="DEBUG">
        <appender-ref ref="FILE1" />
    </logger>
    <logger name="file1" level="INFO">
        <appender-ref ref="FILE2" />
    </logger>
    <!-- 自定义logger -->
    <logger name="custom" level="INFO">
        <appender-ref ref="CUSTOM" />
    </logger>
</configuration>

4.在IDEA的mybatisdemo项目的src/main/resources下创建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>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <!--数据库连接驱动，url，用户名，密码-->
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql:///mydb1?useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--加载sql的映射器,将自己配置好的mytbMapper.xml 复制过来，直接选中文件名 ctrl+c-->
        <mapper resource="mytbMapper.xml"/>
    </mappers>
</configuration>

5.在IDEA的mybatisdemo项目的src/main/resources下创建mytbMaper.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">
<!--namespace:名称空间,,id:sql语句的唯一标识,resultType要返回的类型，设置为自己需要的，
接着创建使用的User类-->
<mapper namespace="test">
    <select id="selectall" resultType="com.chen.pojo.User">
    <!--执行的sql语句-->
        select * from mytb;
    </select>

</mapper>

6.在IDEA的mybatisdemo项目的src/main/java下创建com.chen.pojo包下创建User类，具体如下：

package com.chen.pojo;
//接受查询到的数据表的信息
public class User {
    private Integer num;//根据mytb表来设定字段，使用Integer 包装类更合适。
    private String name;
    private Integer age;
    private String addr;
//提供带参构造器
    public User(Integer num, String name, Integer age, String addr) {
        this.num = num;
        this.name = name;
        this.age = age;
        this.addr = addr;
    }
//提供toString 做输出
    @Override
    public String toString() {
        return "User{" +
                "num=" + num +
                ", name='" + name + '\'' +
                ", age=" + age +
                ", addr='" + addr + '\'' +
                '}';
    }
}

7.在IDEA的mybatisdemo项目的src/main/java下创建com.chen.pojo包下创建MybatisTest类,作为连接数据库的测试，具体如下：

public class MybatisDemo {
    public static void main(String[] args) throws IOException {

        //加载mybatis的核心配置文件，获取会话工厂
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new     SqlSessionFactoryBuilder().build(inputStream);

        //获取sqlsession 对象
        SqlSession sqlSession = sqlSessionFactory.openSession();

        //执行sql--test.selectall就是mytbMapper的  名称空间.id
        //User就是之前创建的接收数据库表的类
        List<User> mytb = sqlSession.selectList("test.selectall");

        //输出结果
        System.out.println(mytb);

        //关闭服务
        sqlSession.close();
    }

}

8.进入MySQL，设置好匹配的时区，修改时区：set global time_zone='+8:00';

最后运行即可得出查询结果！