MyBatis-Plus学习-part3 通用CRUD

Mapper

/**
 * @author Ezerbel
 *	
 *	基于Mybatis： 在Mapper接口中编写CRUD相关方法，提供Mapper接口所对应的SQL映射文件以及方法对应的SQL语句
 *	基于MP： 让XxxMapper接口继承BaseMapper接口即可。
 */
public interface EmployeeMapper extends BaseMapper<Employee>{}

插入

@Test
public void testCommonInsert() {
	Employee employee = new Employee();
//		employee.setAge(10);
//		employee.setEmail("Lilith@sina.com");
	employee.setGender(1);
	employee.setLastName("Lilith");
	employee.setSalary(20000.0);
	//没有值的属性不进行任何写入，保留数据内部默认值
	Integer insertRes = employeeMapper.insert(employee);
	//没有值的属性，写入该属性类型对应的默认值
	//Integer insertRes = employeeMapper.insertAllColumn(employee);
	System.out.println("insertRes ======= " + insertRes);
	
	//获取当前数据在数据库中的主键值
	Integer id = employee.getId();
	System.out.println("id ====== " + id);
}

更新

	@Test
	public void testCommonUpdate() {
		Employee employee = new Employee();
//		employee.setAge(99);
		employee.setLastName("Luxs");
		employee.setId(35);
//		employee.setGender(0);
		employee.setEmail("Luxs@Sina.com");
		Integer res = employeeMapper.updateById(employee);//entity中，没有值的属性，不做任何更改
		//Integer res = employeeMapper.updateAllColumnById(employee);//对于entity中，没有值的的属性，写入该属性类型默认值
		System.out.println("res ======== " + res);
	}

查找

@Test
public void testCommonSelect1(){
	//通过id查询
	Employee employee = employeeMapper.selectById(19);
	System.out.println(employee);
}
@Test
public void testCommonSelect2() {
	//2.通过多个列查询 id + lastName
	Employee employee = new Employee();
//		employee.setId(4);
	employee.setLastName("Jerry");
	Employee res = employeeMapper.selectOne(employee);
	System.out.println(res);
}
@Test
public void testCommonSelect3() {
	//3.通过多个id进行查询
	List<Integer> idList = new ArrayList<>();
	idList.add(1);
	idList.add(3);
	idList.add(5);
	List<Employee> employees = employeeMapper.selectBatchIds(idList);
	employees.forEach(System.out::println);
}
@Test
public void testCommonSelect4() {
	//4.通过Map封装条件查询
	Map<String, Object> columMap= new HashMap<>();
	//注意要写表中的列名，而不是类中的属性名
	columMap.put("last_name", "Tom");
	columMap.put("gender", 1);
	List<Employee> emps = employeeMapper.selectByMap(columMap);
	emps.forEach(System.out::println);
}
@Test
public void testCommonSelect5() {
	//5.分页查询,没有分页插件的情况下，并没有使用limit，而是借助于roubounds，使用缓存
	List<Employee> emps = employeeMapper.selectPage(new Page<>(3, 2), null);
	emps.forEach(System.out::println);
}

删除

@Test
public void testCommonDelete1() {
	//1.通过id删除
	Integer deleteById = employeeMapper.deleteById(20);
	System.out.println(deleteById);
}
@Test
public void testCommonDelete2() {
	//2.通过Map封装条件删除
	Map<String, Object> map = new HashMap<>();
	map.put("last_name", "Lux");
	map.put("gender", 1);
	Integer res = employeeMapper.deleteByMap(map);
	System.out.println("res ========== " + res);
}
@Test
public void testCommonDelete3() {
	//3. 批量删除
	List<Integer> idList= new ArrayList<>();
	idList.add(22);
	Integer delRes = employeeMapper.deleteBatchIds(idList);	
	System.out.println("delRes ==== " + delRes);
}

@Test
public void testDataSource() throws Exception {
	DataSource ds = ioc.getBean("dataSource",DataSource.class);
	Connection conn = ds.getConnection();
	System.out.println(conn);
	System.out.println("Finished!!!");
}