利用MyBatis进行不同条件的like模糊查询的方法

public class SearchType {

  private String type;

  private String condition;

  public String getType() {
    return type;
  }

  public void setType(String type) {
    this.type = type;
  }

  public String getCondition() {
    return condition;
  }

  public void setCondition(String condition) {
    this.cOndition= condition;
  }
}

public List searchUser(String type,String condition) {

    SearchType search = new SearchType();
    search.setCondition(condition);
    search.setType(type);

    //模糊查询各字段

      List list = userMapper.selectWithConditionLike(search);
      return list;

  }

  select userid ,username ,we_name ,we_number ,tel_number ,updateTime ,invite_number ,purchased_total 
  from mk_user
  where ${type} like CONCAT(CONCAT('%',#{condition}),'%')

 

SELECT count(*) FROM table WHERE (table_a LIKE paramsValue) 

paramsValue = "%" + paramsValue + "%"