通用mapper——方法及实例

Iterator与Iterable

iterator为Java中的迭代器对象，是能够对List这样的集合进行迭代遍历的底层依赖。而iterable接口里定义了返回iterator的方法，相当于对iterator的封装，同时实现了iterable接口的类可以支持for each循环。

1.andIn()：

public Example.Criteria andIn(String property, Iterable values) {
			//column	表字段名 
			// user.id in(1,2,3)
            this.addCriterion(this.column(property) + " in", values, this.property(property));
            return (Example.Criteria)this;
        }

2.andEqualTo()：

public Example.Criteria andEqualTo(String property, Object value) {
			//id = 1
            this.addCriterion(this.column(property) + " =", value, this.property(property));
            return (Example.Criteria)this;
        }

andIn()、andEqualTo实例

public BaseResponse<List<User>> test( @PathVariable String batchNo){
        Example example = new Example(User.class);
        List<String> list = new ArrayList<>();
        list.add("开炉");
        list.add("装炉");
        /*
        select batch_no,step_name,_operate_data from user 
        where batch_no = {batchNo} and step_name("开炉","装炉")
        */
        Example.Criteria criteria = example.createCriteria().andEqualTo("batchNo",batchNo)
        								.andIn("stepName",list);
        example.selectProperties("batchNo","stepName","operateData");
        List<User> users= UserMapper.selectByExample(example);
        return new BaseResponse<>(users);
    }