MybatisPlus — ActiveRecord(活动记录)
>> 上一篇我们讲到MybatisPlus中使用条件构造器—EntityWrapperMybatis Plus — 条件构造器
>> 这一篇主要来介绍MybatisPlus中使用ActiveRecord(活动记录)
了解:
使用AR模式
AR 基本 CRUD
-
1) 插入操作
public boolean insert()
/** * AR 插入操作 */ @Test public void testARInsert() { Employee employee = new Employee(); employee.setLastName("ccc"); employee.setEmail("ccc@qq.com"); employee.setGender(1); boolean result = employee.insert(); //直接通过实例调用方法 System.out.println("result:" +result ); }
-
2)修改操作
public boolean updateById()
/** * AR 修改操作 */ @Test public void testARUpdate() { Employee employee = new Employee(); employee.setId(2); employee.setLastName("tom"); employee.setEmail("tom@qq.com"); employee.setGender(1); boolean result = employee.updateById(); System.out.println("result:" +result ); }
-
3)删除操作
public boolean deleteById()
public boolean deleteById(Serializable id)
public boolean delete(Wrapper wrapper)
/** * AR 删除操作 * * 注意: 删除不存在的数据 逻辑上也是属于成功的. */ @Test public void testARDelete() { Employee employee = new Employee(); boolean result = employee.deleteById(2); System.out.println(result); employee.setId(2); boolean result1 = employee.deleteById(); System.out.println(result1); boolean result2 = employee.delete(new EntityWrapper<Employee>().like("last_name", "c")); System.out.println(result2); }
-
4)查询操作
public T selectById()
public T selectById(Serializable id)
public List selectAll()
public List selectList(Wrapper wrapper)
public int selectCount(Wrapper wrapper)
/** * AR 查询操作 */ @Test public void testARSelect() { Employee employee = new Employee(); Employee result1 = employee.selectById(14); System.out.println(result1); employee.setId(2); Employee result = employee.selectById(); System.out.println(result); List<Employee> emps = employee.selectAll(); System.out.println(emps); List<Employee > employees= employee.selectList(new EntityWrapper<Employee>().like("last_name", "c")); System.out.println(employees); Integer result2 = employee.selectCount(new EntityWrapper<Employee>().eq("gender", 0)); System.out.println("result: " +result2); }
-
5)分页复杂操作
public Page selectPage(Page page, Wrapper wrapper)
/** * AR 分页复杂操作 */ @Test public void testARPage() { Employee employee = new Employee(); Page<Employee> page = employee.selectPage(new Page<Employee>(1, 1), new EntityWrapper<Employee>().like("last_name", "c")); List<Employee> emps = page.getRecords(); System.out.println(emps); }