商品查询需要组合条件加分页查询
l 组合条件:品牌,审核状态,商品名称,需要动态 sql
select * from(select a. * , rownum rm from(select * from eb_item ei ei.brand_id = # {
brandId
}
and ei.audit_status = # {
auditStatus
}
and ei.show_status = # {
showStatus
}
and ei.item_name like '%${itemName}%'order by ei.item_id desc) a
来源: http://blog.csdn.net/qq_32332777/article/details/79053076