6、mybatis-plus查询和删除的方式

一、查询

1、单个byid查询

User user = userMapper.selectByID(1);
System.out.println(user);

2、查询多个ID

list<User> user = userMapper.selectBatchIds(Arrays.asList(1,2,3));
users.forEach(System.out::println);

3、条件查询

HashMap<String, Object> map = new HashMap<>();
//自定义要查询
map.put("name","chenyiyi");

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

4、多个条件查询，map中多个设置即可

HashMap<String, Object> map = new HashMap<>();
//自定义要查询
map.put("name","chenyiyi");
map.put("age",20);

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

5、分页查询

//参数1：当前第几页，参数2：页面大小
Page<User> page = new Page<>(1,5);
userMapper.selectPage(page,null);

page.getRecords().forEach(System.out::println);
System.out.println(page.getTotal()); //打印出总共多少条
//.getPages()//打印出总共多少页，根据页面大小来计算的

二、删除

 1、单个byid删除

int result = userMapper.deletetByID(1);

2、多个ID删除

int result = userMapper.deletetBatchIds(Arrays.asList(1,2,3));

3、条件删除

HashMap<String, Object> map = new HashMap<>();
//自定义要查询
map.put("name","chenyiyi");

int result = userMapper.deleteByMap(map);