03.mybatis-plus通用的增删改查操作

最新推荐文章于 2024-08-12 15:02:11 发布

Adela0916

最新推荐文章于 2024-08-12 15:02:11 发布

阅读量348

点赞数

分类专栏： MyBatis-Plus

本文链接：https://blog.csdn.net/Adela0916/article/details/115284994

版权

MyBatis-Plus 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

插入操作

1）Integer insert(T entity)；
2）Integer insertAllColumn(T entity)

/**
     * 测试 通用插入操作
     */
    @Test
    public void testInsert(){
        Employee employee = new Employee();
        employee.setAge(20);
        employee.setEmail("mp2@163.com");
        employee.setGender(1);
        employee.setLastName("mp2");
        Integer res = employeeMapper.insert(employee);
        System.out.println("result:"+res);
        Integer key = employee.getId();
        System.out.println("key:"+key);
    }

更新操作

Integer updateById(@Param("et") T entity);
Integer updateAllColumnById(@Param("et") T entity)

 /**
     * 通用更新操作
     */
    @Test
    public void testUpdateById(){
        Employee employee = new Employee();
        employee.setLastName("green1");
        employee.setId(7);
        //employee.setGender(0);
        employee.setEmail("234567@qq.com");
        //Integer res = employeeMapper.updateById(employee);
        Integer res = employeeMapper.updateAllColumnById(employee);
        System.out.println(res);
    }

查询操作

T selectById(Serializable id);
T selectOne(@Param("ew") T entity);
List<T> selectBatchIds(List<? extends Serializable> idList);
List<T> selectByMap(@Param("cm") Map<String, Object> columnMap);
List<T> selectPage(RowBounds rowBounds, @Param("ew") Wrapper<T> wrapper);

 /**
     * 通用查询
     */
    @Test
    public void testSelect(){
//        //通过id查询
//        Employee employee1 = employeeMapper.selectById(7);
//        System.out.println(employee1);
//        //通过多个列进行查询
//        Employee employee2 = new Employee();
//        employee2.setId(7);
//        employee2.setLastName("green1");
//        Employee employee3 = employeeMapper.selectOne(employee2);
//        System.out.println(employee3);
        //根据多个id查询
//        List<Integer> ids = new ArrayList<Integer>();
//        ids.add(3);
//        ids.add(4);
//        ids.add(5);
//        List<Employee> employees = employeeMapper.selectBatchIds(ids);
//        System.out.println(employees);

        //4.通过map封装条件查询
//        Map<String,Object> columnMap = new HashMap<String,Object>();
//        columnMap.put("last_name","Tom");
//        columnMap.put("gender",1);
//        List<Employee> employees2 = employeeMapper.selectByMap(columnMap);
//        System.out.println(employees2);

        //分页查找
        List<Employee> employees = employeeMapper.selectPage(new Page(2, 2), null);
        System.out.println(employees);
    }

删除操作

Integer deleteById(Serializable id);
Integer deleteByMap(@Param(“cm”) Map<String, Object> columnMap);
Integer deleteBatchIds(List<? extends Serializable> idList);

 /**
     * 通用 删除
     */
    @Test
    public void testDelete(){
        //1.根据id删除一条记录
//        Integer res = employeeMapper.deleteById(7);
//        System.out.println(res);
        //根据多列删除记录
//        Map<String,Object> maps = new HashMap<String, Object>();
//        maps.put("last_name","mp2");
//        maps.put("gender",1);
//        Integer res = employeeMapper.deleteByMap(maps);
//        System.out.println(res);
        List<Integer> list = new ArrayList<Integer>();
        list.add(4);
        list.add(5);
        Integer res = employeeMapper.deleteBatchIds(list);
        System.out.println(res);
    }