mybatis逆向工程进行不同条件查询的应用处理

来源：互联网发布：mac已导入照片怎么删除编辑：程序博客网时间：2024/05/21 09:55

在沒有critia条件下的应用

select

<iftest="distinct">

distinct

</if>

<includerefid="Base_Column_List"/>

from plat2_receipt

where

addressis not null

and

part_type= "01"

<iftest="receiptTime=0">

and

<![CDATA[ DATE_SUB(CURDATE(), INTERVAL 7 DAY) <=date(receipt_time)]]>

</if>

<iftest="receiptTime=1">

and

DATE_SUB(CURDATE(),INTERVAL 30 DAY)<= date(receipt_time)

</if>

<iftest="receiptType=1">

and

logistic_codeis not null

</if>

<iftest="receiptType=0">

and

logistic_codeis null

</if>

<iftest="orderByClause !=null">

order by ${orderByClause}

</if>

limit #{offset}, #{rows}

</select>

以上是mapper.xml中的文件

Example文件中

privateStringreceiptType;

publicStringgetReceiptType() {

returnreceiptType;

}

publicvoidsetReceiptType(StringreceiptType) {

this.receiptType =receiptType;

}

privateStringrecriptTime;

publicStringgetRecriptTime() {

returnrecriptTime;

}

mapper.xml中sql语句用到的<if test=”字段”>必须和exmaple中定义的字段一致即实体类中的字段

在业务层中

ReceiptExampleexample=newReceiptExample();

example.setOffset(offset);

example.setRows(rows);

example.setOrderByClause("receipt_time desc");

// Criteria cri=example.createCriteria();

// cri.andAddressIsNotNull();

// cri.andPartTypeEqualTo(Constants.DIFFERENT_DRAW);

if(StringUtils.hasText(po.getReceiptType())){

if(po.getReceiptType().equals("0"))

{

example.setReceiptType("0");

}elseif(po.getReceiptType().equals("1"))

{

example.setReceiptType("1");

}

if (po.getReceiptTime()!=null || !"".equals(po.getReceiptTime())) {

if (po.getReceiptTime().equals("0")) {

example.setRecriptTime("0");

}elseif(po.getReceiptTime().equals("1")) {

example.setRecriptTime("1");

}

List<ReceiptPo>receiptList=receiptMapper.selectDataByDifferentTime(example);

for(ReceiptPoreceipt : receiptList)//遍历receiptList

{

DrawPodrawPo=drawMapper.selectByMyDrawLucy(receipt.getPeriodId());

intbetCnt =drawBetService.sumDrawBetCnt(receipt.getPeriodId(),receipt.getCid());

receipt.setCmdtName(drawPo.getCmdtName());

receipt.setBetCount(betCnt);

}

在业务层中

if(StringUtils.hasText(po.getReceiptType())){

if(po.getReceiptType().equals("0"))

{

example.setReceiptType("0");

}elseif(po.getReceiptType().equals("1"))

{

example.setReceiptType("1");

}

通过上述代码决定mapper.xml中的文件sql语句执行条件

0 0