myBatis带条件的三种查询方式

1) 定义查询条件实体类
复制代码

package com.mybatis.entity;

public class QryPartParam {

private String partCode; //要查询的商品编码
private String partName; //要查询的商品名称
private float salePriceLow; //价格区间--起始价格
private float salePriceHigh; //价格区间--结束价格

public String getPartCode() {
    return partCode;
}
public void setPartCode(String partCode) {
    this.partCode=partCode;
}

public String getPartName() {
    return partName;
}
public void setPartName(String partName) {
    this.partName=partName;
}

public String getSalePriceLow() {
    return salePriceLow;
}
public void setSalePriceLow(String salePriceLow) {
    this.salePriceLow=salePriceLow;
}

public String getSalePriceHigh() {
    return salePriceHigh;
}
public void setSalePriceHigh(String SalePriceHigh) {
    this.SalePriceHigh=SalePriceHigh;
}

}

复制代码

    2）在com.mybatis.dao.PartDao中增加接口函数

public List getPartInfoByUser(QryPartParam qryPartParam);

    3）在com.mybatis.dao.mapper.PartMapper中增加其实现方法。

复制代码

SELECT * FROM tbInfoPart
WHERE PartCode = #{partCode}
AND PartName LIKE ‘%’+#{partName}+’%’
AND SalePrice