public List<Product> duocha(DataVo voVoVoVo){ Example example = new Example(Product.class); Example.Criteria criteria = example.createCriteria(); if (!"null".equals(voVoVoVo.getProName()) && StringUtils.isNotBlank(voVoVoVo.getProName())) { criteria.andLike("productName", "%"+voVoVoVo.getProName()+"%"); }
if (!"null".equals(voVoVoVo.getMax()) && StringUtils.isNotBlank(voVoVoVo.getMax())) { criteria.andLessThanOrEqualTo("productPrice", voVoVoVo.getMax()); } if (!"null".equals(voVoVoVo.getMin()) && StringUtils.isNotBlank(voVoVoVo.getMin())) { criteria.andGreaterThanOrEqualTo("productPrice", voVoVoVo.getMin()); } return productDAO.selectByExample(example); }
<selectid="mohu"resultType="com.ls.domain.Product"parameterType="com.ls.domain.DataVo"> select * from tb_product <where> <iftest="proName !=null and proName !='null'">
<bindname="gou"value="'%'+proName+'%'"/> and product_name like #{gou} </if> <iftest="max !=null and max!='null'"> and product_price <= #{max} </if> <iftest="min !=null and min!='null'"> and product_price >= #{min} </if> </where> </select> </mapper>