- package cn.gzsxt.mp.test;
- import java.util.List;
- import org.apache.ibatis.session.RowBounds;
- import org.junit.Test;
- import org.junit.runner.RunWith;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.context.annotation.ComponentScan;
- import org.springframework.test.context.ContextConfiguration;
- import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
- import com.baomidou.mybatisplus.mapper.EntityWrapper;
- import cn.gzsxt.mp.mapper.UserMapper;
- import cn.gzsxt.mp.pojo.User;
- @RunWith(SpringJUnit4ClassRunner.class)
- @ContextConfiguration(locations={
- "classpath:spring-data.xml"
- })
- @ComponentScan(basePackages={
- "cn.gzsxt.mp"
- })
- public class UserMapperTEST {
- @Autowired
- private UserMapper userMapper;
- // 插入一条记录
- @Test
- public void insert(){
- User user = new User();
- user.setAge(18);
- user.setEmail("[email protected]");
- user.setName("张三");
- userMapper.insert(user);
- }
- // 根据 id 查询
- @Test
- public void selectById(){
- User user = userMapper.selectById(1);
- System.out.println("用户 id:"+user.getId()+", 用户姓名:"+user.getName()+", 用户邮箱:"+user.getEmail());
- }
- // 根据用户名查找
- @Test
- public void selectByName(){
- EntityWrapper<User> wrapper = new EntityWrapper<>();
- wrapper.eq("name", "张三");
- List<User> users = userMapper.selectList(wrapper);
- for (User user : users) {
- System.out.println("用户 id:"+user.getId()+", 用户姓名:"+user.getName()+", 用户邮箱:"+user.getEmail());
- }
- }
- // 查询用户列表
- @Test
- public void selectAll(){
- List<User> users = userMapper.selectList(null);
- for (User user : users) {
- System.out.println("用户 id:"+user.getId()+", 用户姓名:"+user.getName()+", 用户邮箱:"+user.getEmail());
- }
- }
- // 分页查询, 第 2 页, 每页 3 条
- @Test
- public void selectAndPage(){
- RowBounds rowBounds = new RowBounds((2-1)*3, 3);
- List<User> users = userMapper.selectPage(rowBounds, null);
- for (User user : users) {
- System.out.println("用户 id:"+user.getId()+", 用户姓名:"+user.getName()+", 用户邮箱:"+user.getEmail());
- }
- }
来源: http://www.bubuko.com/infodetail-3036139.html