mybatisPlus-增删改查

所有的sql语句都是动态配置

    @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("wddd");
        user.setAge(1);
        user.setEmail("1461760249@qq.com");

        int result = userMapper.insert(user);
        System.out.println(result);
        System.out.println(user);
    }
    @Test //修改
    public void testUpdate(){
        User user = new User();
        user.setId(3L);
        user.setName("KING");
        user.setAge(115);

        int i = userMapper.updateById(user);

        System.out.println(i);
    }
        //测试查询
    @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","洋");
        map.put("age","1");
        List<User>users = userMapper.selectByMap(map);
        users.forEach(System.out::println);
    }
       @Test//测试删除
    public void testDeleteById(){
        userMapper.deleteById(1415156893809377284L);
    }
    @Test//批量删除
    public void testDeleteByIds(){
        userMapper.deleteBatchIds(Arrays.asList(1415156893809377286L,1415156893809377285L));
    }
    @Test//通过map删除
    public void testDeleteByIds1(){
        HashMap<String, Object> map = new HashMap<>();
        map.put("name","看");
        userMapper.deleteByMap(map);
    }