SSM—mybatis框架-日志log4j-分页

1、log4j

1.1、老规矩，要使用，先拿来，我们先引入第三方依赖jar包

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

1.2、在mybatis-config.xml中设置log4j

老规矩，注意settings标签的位置！如果没有properties标签，那么settings标签就是第一个位置！

    <settings>
        <setting name="logImpl" value="LOG4J"/>
    </settings>

1.3、在resources文件夹下创建log4j.properties

注意日志位置！
log4j.appender.D.File = D://logs/log.log

log4j.rootLogger = debug,stdout,D
#System out Console
log4j.appender.stdout = org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target = System.out
log4j.appender.stdout.layout = org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern = [%p] %d{yyyy-MM-dd HH:mm:ss,SSS} %m%n

#System out File
log4j.appender.D = org.apache.log4j.FileAppender
log4j.appender.D = org.apache.log4j.DailyRollingFileAppender
log4j.appender.D.File = D://logs/log.log
log4j.appender.D.Append = true
log4j.appender.D.layout = org.apache.log4j.PatternLayout
log4j.appender.D.layout.ConversionPattern = %d{yyyy-MM-dd HH:mm:ss}  [ %t:%r ] - [ %p ] -[%l] %m%n

1.4、测试！

如果有问题的话，小伙伴们重新编译一下maven！

[DEBUG] 2021-04-07 13:20:52,551 Logging initialized using ‘class org.apache.ibatis.logging.log4j.Log4jImpl’ adapter.
[DEBUG] 2021-04-07 13:20:52,636 PooledDataSource forcefully closed/removed all connections.
[DEBUG] 2021-04-07 13:20:52,636 PooledDataSource forcefully closed/removed all connections.
[DEBUG] 2021-04-07 13:20:52,636 PooledDataSource forcefully closed/removed all connections.
[DEBUG] 2021-04-07 13:20:52,637 PooledDataSource forcefully closed/removed all connections.
[DEBUG] 2021-04-07 13:20:52,738 Opening JDBC Connection
[DEBUG] 2021-04-07 13:20:52,930 Created connection 1653844940.
[DEBUG] 2021-04-07 13:20:52,931 Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@6293abcc]
[DEBUG] 2021-04-07 13:20:52,934 ==> Preparing: select * from cars
[DEBUG] 2021-04-07 13:20:52,983 ==> Parameters:
[DEBUG] 2021-04-07 13:20:53,019 <== Total: 3
[Cars(id=1, name=玛莎拉肚, phone=13611111111, out_date=Fri Apr 02 19:54:40 CST 2021), Cars(id=2, name=玛莎拉蒂, phone=11122233344, out_date=Mon Apr 05 15:18:56 CST 2021), Cars(id=3, name=朱丽叶, phone=11122233344, out_date=Mon Apr 05 15:21:48 CST 2021)]

2、分页

2.1、limit分页

limit n
limit m,n
limit m offset n

细看limit：https://blog.csdn.net/qq_44126024/article/details/112781297?spm=1001.2014.3001.5501

2.2、mybatis分页

核心还是写sql，

步骤

1. 接口
2. Mapper.xml
3. 测试

接口！

public interface CarsMapper {

    List<Cars> getCarsByLimit(Map<String,Object> map);

}

Mapper.xml

    <select id="getCarsByLimit" resultType="cars" parameterType="map">
        select * from cars limit #{startIndex},#{pigeSize}
    </select>

测试！ limit 0,1

@Test
    public void getCarsByLimit(){
        HashMap<String, Object> map = new HashMap<String, Object>();
        map.put("startIndex",0);
        map.put("pigeSize",1);
        List<Cars> carsList = mapper.getCarsByLimit(map);
        System.out.println(carsList);
    }

结果！

[Cars(id=1, name=玛莎拉肚, phone=13611111111, out_date=Fri Apr 02 19:54:40 CST 2021)]

测试 limit 0,2

[Cars(id=1, name=玛莎拉肚, phone=13611111111, out_date=Fri Apr 02 19:54:40 CST 2021), Cars(id=2, name=玛莎拉蒂, phone=11122233344, out_date=Mon Apr 05 15:18:56 CST 2021)]

测试 limit 1,3

[Cars(id=2, name=玛莎拉蒂, phone=11122233344, out_date=Mon Apr 05 15:18:56 CST 2021), Cars(id=3, name=朱丽叶, phone=11122233344, out_date=Mon Apr 05 15:21:48 CST 2021)]