mybatis-plus

mybatis-plus单表增删改查

package com.chen.mybatis_plus;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.chen.mybatis_plus.mapper.UserMapper;
import com.chen.mybatis_plus.pojo.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.Arrays;
import java.util.HashMap;
import java.util.List;

@SpringBootTest
class  MybatisPlusApplicationTests {

	@Autowired
	private UserMapper userMapper;

	@Test
	void contextLoads() {
		//查询全部用户
		List<User> users = userMapper.selectList(null);
		users.forEach(System.out::println);
	}

	//测试插入
	@Test
	public void testInsert(){
		User user = new User();

		user.setName("cg");
		user.setAge(22);
		user.setEmail("770721711@qq.com");

		int result = userMapper.insert(user);
		System.out.println(result);
		System.out.println(user);
	}

	//测试更新
	@Test
	public void testUpdate(){
		//通过条件自动拼接动态sql
		User user = new User();
		user.setId(1301792134571048963L);
		user.setName("ax");
		user.setAge(21);

		int i = userMapper.updateById(user);
		System.out.println(i);

	}

	//测试乐观锁成功。
	@Test
	public void testOptimisticLocker(){
		User user = userMapper.selectById(1L);
		user.setName("cg");
		user.setEmail("123456@qq.com");
		userMapper.updateById(user);
	}



	//测试乐观锁失败。
	//测试查询
	@Test
	public void testSelectById(){
		User user = userMapper.selectById(1L);
		System.out.println(user);
	}
	//测试批量查询
	@Test
	public void testSelectByBatchId(){
		List<User> users = userMapper.selectBatchIds(Arrays.asList(1, 2, 3));
		users.forEach(System.out::println);
	}

	// 条件查询 map
	@Test
	public void testSelectByBatchIds(){
		HashMap<String, Object> map = new HashMap<>();
		map.put("name","cg");

		List<User> users = userMapper.selectByMap(map);
		users.forEach(System.out::println);
	}

	//测试分页查询
	@Test
	public void testPage(){
		Page<User> page = new Page<>(1,10);
		userMapper.selectPage(page,null);

		page .getRecords().forEach(System.out::println);
		System.out.println(page.getTotal());
	}

	//测试删除
	@Test
	public void testDeleteById(){
		userMapper.deleteById(1301792134571048962L);
	}
}

package com.chen.mybatis_plus;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.chen.mybatis_plus.mapper.UserMapper;
import com.chen.mybatis_plus.pojo.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
public class WrapperTest {

    @Autowired
    private UserMapper userMapper;

    @Test
    void contextLoads() {
//        //查询全部用户
//        List<User> users = userMapper.selectList(null);
//        users.forEach(System.out::println);
        //查询name不为空的用户，并且邮箱不为空的用户，年龄大于等于12
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper
                .isNotNull("name")
                .isNotNull("email")
                .ge("age",12);
        userMapper.selectList(wrapper).forEach(System.out::println);
    }

    @Test
    void test2(){
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.eq("name","cg");
        User user = userMapper.selectOne(wrapper);
        System.out.println(user);
    }
}