<?xml version="1.0" encoding="utf-8"?>
<configuration debug="false">
<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
<encoder>
<pattern>%d %level [%thread] %logger[%L] -> %m%n</pattern>
</encoder>
</appender>
<root level="info">
<appender-ref ref="STDOUT" />
</root>
<logger name="com.abc.mapper" level="debug">
</logger>
</configuration>
Mybatis 中分页可以使用 PageHelper 插件,该插件方便好用,具体使用方法及配置说用可参考官网文档:https://pagehelper.github.io。
package com.abc.mapper;
import com.abc.entity.Student;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import java.io.IOException;
import java.io.InputStream;
import java.time.LocalDateTime;
import java.util.List;
import java.util.Map;
public class StudentMapperCase {
private Logger logger = LoggerFactory.getLogger(StudentMapperCase.class);
private SqlSession sqlSession;
@Before
public void before() throws IOException {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
sqlSession = sqlSessionFactory.openSession();
}
@After
public void after() {
sqlSession.close();
}
@Test
public void insert() {
StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
Student student = new Student();
student.setCreateTime(LocalDateTime.now());
student.setName("李白");
student.setAge(30);
student.setHomeAddress("长安");
mapper.insert(student);
sqlSession.commit();
logger.info("id={}", student.getId());
}
@Test
public void update() {
Student student = new Student();
student.setId(261L);
student.setName("李白2");
StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
mapper.update(student);
sqlSession.commit();
}
@Test
public void selectById() {
StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
Student student = mapper.selectById(261L);
logger.info(student.toString());
}
@Test
public void select() {
StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
List<Student> students = mapper.select("%李%", "%长%");
logger.info(students.toString());
}
@Test
public void selectForPage() {
StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
PageHelper.startPage(1, 5);
List<Student> students = mapper.select("%李%", "");
PageInfo<Map<String, String>> pageInfo = new PageInfo(st