QueryWrapper的基本用法
话不多说,直接上代码
public void mybatisPlusTest(Long id, String startTime, String endTime) {
// eqWrapper.eq("id",id) --->> where id = id;
// SELECT id,pre_amount,opt_type,amount,src_userinfo,withdrawal_amount,opt_biz_id,target_uid,logtime,src_uid FROM return_commission_log WHERE (id = ?)
QueryWrapper<ReturnCommissionLog> eqWrapper = new QueryWrapper<>();
List<ReturnCommissionLog> eqList = returnCommissionLogMapper.selectList(eqWrapper.eq("id",id));
// leWrapper.le("id",id) --->> where id <= id;
// SELECT id,pre_amount,opt_type,amount,src_userinfo,withdrawal_amount,opt_biz_id,target_uid,logtime,src_uid FROM return_commission_log WHERE (id <= ?)
QueryWrapper<ReturnCommissionLog> leWrapper = new QueryWrapper<>();
List<