Mybatis动态SQL与模糊查询

Mybatis动态SQL与模糊查询

创建User表

CREATE TABLE d_user (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(10),
    age INT(3)
);
insert into d_user(name,age) values('Tom',12);
insert into d_user(name,age) values('Bob',13);
insert into d_user(name,age) values('Jack',18);

需要实现多条件查询用户(姓名模糊匹配, 年龄在指定的最小值到最大值之间)

定义查询条件类ConditionUser，如下：

package mybatis.bean;

public class ConditionUser {

    private String name;
    private int minAge;
    private int maxAge;
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public int getMinAge() {
        return minAge;
    }
    public void setMinAge(int minAge) {
        this.minAge = minAge;
    }
    public int getMaxAge() {
        return maxAge;
    }
    public void setMaxAge(int maxAge) {
        this.maxA