AbstractWrapper:
/**
* 使用构造器 条件查询
*/
@Test
public void selectOne() {
AbstractWrapper wrapper = new QueryWrapper<>();
wrapper.eq("nick_name", "测试一下");
//区间查询
//wrapper.between("member_id",1,90);
MemberInfo result = memberInfoMapper.selectOne(wrapper);
System.out.println(result);
}
QueryWrapper
/**
* 排序查询
*/
@Test
public void selectOrderList() {
QueryWrapper<ShippingAddress> wrapper = new QueryWrapper<>();
//根据id排序 orderByAsc:升序 orderByDesc:降序
wrapper.orderByAsc("member_id");
List<ShippingAddress> addressList = shippingAddressMapper.selectList(wrapper);
addressList.forEach(System.out::println);
}
/**
* 模糊查询
*/
@Test
public void selectList() {
QueryWrapper<ShippingAddress> wrapper = new QueryWrapper<>();
//模糊包含
//wrapper.like("detail_address","广东");
//右模糊查询 向左查起
wrapper.likeRight("detail_address", "广");
List<Map<String, Object>> map = shippingAddressMapper.selectMaps(wrapper);
map.forEach(System.out::println);
}
/**
* 条件查询
*/
@Test
public void selectObjs() {
QueryWrapper<ShippingAddress> wrapper = new QueryWrapper<>();
//查询id <100的数据 select * from shipping_address where member_id in (你的sql)
wrapper.inSql("member_id", "select member_id from shipping_address where member_id<100");
List<Object> objectList = shippingAddressMapper.selectObjs(wrapper);
System.out.println(objectList);
}
UpdateWrapper
/**
* 编辑信息
*/
@Test
public void update() {
MemberInfo memberInfo = new MemberInfo();
UpdateWrapper updateWrapper = new UpdateWrapper();
memberInfo.setMemberId(memberInfo.getMemberId());
updateWrapper.set("nick_name", "程序图");
//updateWrapper.setSql("nick_name = '老李头'");
memberInfoMapper.update(memberInfo, updateWrapper);
}
个别参数说明:
/**
* eq:等于 ne: 不等于
* gt:大于 ge:大于或等于
* lt:小于 le: 小或于或等于
* like:模糊查询(包含) notLike(不包含) likeLeft:模糊左查询 likeRight:模糊右查询
* isNull:为空 isNoNull:不为空
* orderByAsc:升序 orderByDesc:降序
* between:区间查询 age between 18 and 30
*/
详细文档请前往pius官网或者MyBatis-Plus v3.3.2 使用教程