select(String... sqlSelect)  
select(Predicate<TableFieldInfo> predicate)  
select(Class<T> entityClass, Predicate<TableFieldInfo> predicate)

select("id", "name", "age") 

select(i ‐> i.getProperty().startsWith("test")) 

select(User.class, info ‐> !info.getColumn().equals("manager_id") 
&& !info.getColumn().equals("create_time"))

//測(cè)試根據(jù)ID查詢
@Test
public void testSelectById(){
	User user = userMapper.selectById(2L);
	System.out.println(user);
}

//測(cè)試批量查詢
@Test
public void testSelectByBatchIds(){
	List<User> users = userMapper.selectBatchIds(Arrays.asList(1, 2, 3));
	users.forEach(System.out::println);
}

//按條件查詢之使用map操作
@Test
public void testSelectByMap(){
	Map map = new HashMap();
	map.put("name","哈利油");
	map.put("age",18);
 
	List list = userMapper.selectByMap(map);
	list.forEach(System.out::println);
}

//注冊(cè)分頁(yè)插件
@Bean
public PaginationInterceptor paginationInterceptor(){
	return new PaginationInterceptor();
}

@Test
public void testPage(){
	//參數(shù)1：當(dāng)前頁(yè)，參數(shù)2：頁(yè)面大小
	Page<User> page = new Page<>(1,5);
	//用于排序
	page.setDesc("id");
	IPage<User> userIPage = userMapper.selectPage(page, null);
 
	userIPage.getRecords().forEach(System.out::println);
	System.out.println(userIPage.getTotal());
}

//測(cè)試刪除
@Test
public void testDeleteById(){
	userMapper.deleteById(1L);
}

//通過(guò)id批量刪除
@Test
public void testDeleteBatchId(){
	userMapper.deleteBatchIds(Arrays.asList(2L,3L));
}

@Test
public void testDeleteMap(){
	Map map = new HashMap();
	map.put("name","哈利油");
	userMapper.deleteByMap(map);
}

//注冊(cè)邏輯刪除組件
@Bean
public ISqlInjector sqlInjector(){
	return new LogicSqlInjector();
}

mybatis-plus.global-config.db-config.logic-delete-value=1
mybatis-plus.global-config.db-config.logic-not-delete-value=0