mybatis从数据库中取数据且分组,返回分组数据

mapper.xml文件

    
        
        
        
        
        
        
        
    
        

        select id, type,status,production_id
        FROM task
        where status=0 and production_id
        in (select production_id from task)

 所需对象 WcsSzylTaskList

public class WcsSzylTaskList {
    private long productionId;

    private List wcsSzylTasks;

    public List getWcsSzylTasks() {
        return wcsSzylTasks;
    }

    public void setWcsSzylTasks(List wcsSzylTasks) {
        this.wcsSzylTasks = wcsSzylTasks;
    }

    public long getProductionId() {
        return productionId;
    }

    public void setProductionId(long productionId) {
        this.productionId = productionId;
    }
}

 所需对象WcsSzylTask

public class WcsSzylTask {
    private long id;
    private long productionId;
    private int type;
    private int status;
    private long taskChainId;

    public long getTaskChainId() {
        return taskChainId;
    }

    public void setTaskChainId(long taskChainId) {
        this.taskChainId = taskChainId;
    }

    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

    public long getProductionId() {
        return productionId;
    }

    public void setProductionId(long productionId) {
        this.productionId = productionId;
    }

    public int getType() {
        return type;
    }

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

    public int getStatus() {
        return status;
    }

    public void setStatus(int status) {
        this.status = status;
    }
}