注解方式查询

一的一方的查询

	/**
     * @Description 查询设备实物异常出入库登记报表列表（查询所有的一对多）
     * @Param [equipAbnormalIoDto]  头部查询设备实物异常出入库登记报表的条件
     * @return java.util.List<com.zoomlion.rmp.dto.devicehandover.EquipAbnormalIoDto> 设备实物异常出入库登记报表列表（查询所有的一对多）
     **/
    @Select({
            "<script>",
            "select * from rmp_equip_abnormal_io where 1=1",

            "<if test=\"null != code and '' != code\">",
            "and code = #{code,jdbcType=VARCHAR}",
            "</if>",

            "<if test=\"null != deviceTypeCode and '' != deviceTypeCode\">",
            "and device_type_code = #{deviceTypeCode,jdbcType=VARCHAR}",
            "</if>",

            "<if test=\"null != normalState and '' != normalState\">",
            "and normal_state = #{deviceTypeCode,jdbcType=INTEGER}",
            "</if>",

            "<if test=\"null != registerType and '' != registerType\">",
            "and register_type = #{registerType,jdbcType=INTEGER}",
            "</if>",

            "<if test=\"null != registerTime and '' != registerTime\">",
            "and register_time between #{startDate,jdbcType=DATE} and #{endDate,jdbcType=DATE}",
            "</if>",

            "</script>"
    })
    @Results(id = "equipAbnormalIoDtos",value = {
            @Result(id = true, property = "id", column = "id", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "code", column = "code", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "registerName", column = "register_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "registerDept", column = "register_dept", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "repositoryName", column = "repository_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "reason", column = "reason", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "registerTime", column = "register_time", javaType = Date.class, jdbcType = JdbcType.DATE),
            @Result(property = "comment", column = "comment", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "deviceTypeCode", column = "device_type_code", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "deviceModelCode", column = "device_model_code", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "deviceCode", column = "device_code", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "vehicleVinNumber", column = "vehicle_vin_number", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "regionCode", column = "region_code", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "recycleResponseName", column = "recycle_response_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "recycleResponsePhone", column = "recycle_response_phone", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "registerType", column = "register_type", javaType = Integer.class, jdbcType = JdbcType.INTEGER),
            @Result(property = "materialNumber", column = "material_number", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "normalState", column = "normal_state", javaType = Integer.class, jdbcType = JdbcType.INTEGER),
            @Result(property = "saveNo", column = "save_no", javaType = Integer.class, jdbcType = JdbcType.INTEGER),
            @Result(property = "createBy", column = "create_by", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "createDate", column = "create_date", javaType = Date.class, jdbcType = JdbcType.DATE),
            @Result(property = "isActive", column = "is_active", javaType = String.class, jdbcType = JdbcType.CHAR),
            @Result(property = "updateBy", column = "update_by", javaType = String.class, jdbcType = JdbcType.VARCHAR),
            @Result(property = "updateDate", column = "update_date", javaType = Date.class, jdbcType = JdbcType.DATE),
            @Result(property = "equipAbnormalHandles", javaType =List.class, column = "code", many = @Many(select = "com.zoomlion.rmp.mapper.devicehandover.EquipAbnormalHandleMapper.equipAbnormalHandleListByCode"))
    })
    List<EquipAbnormalIoDto> equipAbnormalIoDtolist(EquipAbnormalIoDto equipAbnormalIoDto);

多的一方 list的查询

	/**
     * @return java.util.List<com.zoomlion.rmp.dto.devicehandover.EquipAbnormalIoDto> 设备实物异常出入库登记报表列表（查询所有的一对多）
     * @Description 查询设备实物异常出入库登记报表列表中的异常单据处理记录（查询所有的一对多）
     * @Param [equipAbnormalIoDto]  头部查询设备实物异常出入库登记报表的条件（异常单据处理记录）
     **/
    @Select("select * from rmp_equip_abnormal_handle where io_code=#{code}")
    List<EquipAbnormalHandle> equipAbnormalHandleListByCode(String code);

一的一方的实体类

package com.zoomlion.rmp.entity.devicehandover;

import com.fasterxml.jackson.annotation.JsonFormat;
import com.zoomlion.rmp.entity.RmpBaseEntity;

import javax.persistence.Column;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;

@Table(name = "rmp_equip_abnormal_handle")
public class EquipAbnormalHandle extends RmpBaseEntity {
    /**
     * 唯一标识
     */
    @Id
    private String id;

    /**
     * 出入库登记单号
     */
    @Column(name = "io_code")
    private String ioCode;

    /**
     * 异常处理方案
     */
    @Column(name = "abnormal_scheme")
    private String abnormalScheme;

    /**
     * 异常处理结果 0已完成，1未完成
     */
    @Column(name = "abnormal_result")
    private Integer abnormalResult;

    /**
     * 管理操作人
     */
    @Column(name = "manage_name")
    private String manageName;

    /**
     * 操作时间
     */
    @Column(name = "handle_time")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date handleTime;

    /**
     * 登记单号
     */
    @Column(name = "register_code")
    private String registerCode;

    /**
     * 创建者
     */
    @Column(name = "create_by")
    private String createBy;

    /**
     * 创建时间
     */
    @Column(name = "create_date")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date createDate;

    /**
     * 删除标识
     */
    @Column(name = "is_active")
    private String isActive;

    /**
     * 更新人
     */
    @Column(name = "update_by")
    private String updateBy;

    /**
     * 更新日期
     */
    @Column(name = "update_date")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date updateDate;

    public EquipAbnormalHandle(String id, String ioCode, String abnormalScheme, Integer abnormalResult, String manageName, Date handleTime, String registerCode, String createBy, Date createDate, String isActive, String updateBy, Date updateDate) {
        this.id = id;
        this.ioCode = ioCode;
        this.abnormalScheme = abnormalScheme;
        this.abnormalResult = abnormalResult;
        this.manageName = manageName;
        this.handleTime = handleTime;
        this.registerCode = registerCode;
        this.createBy = createBy;
        this.createDate = createDate;
        this.isActive = isActive;
        this.updateBy = updateBy;
        this.updateDate = updateDate;
    }

    public EquipAbnormalHandle() {
        super();
    }

    /**
     * 获取唯一标识
     *
     * @return id - 唯一标识
     */
    public String getId() {
        return id;
    }

    /**
     * 设置唯一标识
     *
     * @param id 唯一标识
     */
    public void setId(String id) {
        this.id = id == null ? null : id.trim();
    }

    /**
     * 获取出入库登记单号
     *
     * @return io_code - 出入库登记单号
     */
    public String getIoCode() {
        return ioCode;
    }

    /**
     * 设置出入库登记单号
     *
     * @param ioCode 出入库登记单号
     */
    public void setIoCode(String ioCode) {
        this.ioCode = ioCode == null ? null : ioCode.trim();
    }

    /**
     * 获取异常处理方案
     *
     * @return abnormal_scheme - 异常处理方案
     */
    public String getAbnormalScheme() {
        return abnormalScheme;
    }

    /**
     * 设置异常处理方案
     *
     * @param abnormalScheme 异常处理方案
     */
    public void setAbnormalScheme(String abnormalScheme) {
        this.abnormalScheme = abnormalScheme == null ? null : abnormalScheme.trim();
    }

    /**
     * 获取异常处理结果 0已完成，1未完成
     *
     * @return abnormal_result - 异常处理结果 0已完成，1未完成
     */
    public Integer getAbnormalResult() {
        return abnormalResult;
    }

    /**
     * 设置异常处理结果 0已完成，1未完成
     *
     * @param abnormalResult 异常处理结果 0已完成，1未完成
     */
    public void setAbnormalResult(Integer abnormalResult) {
        this.abnormalResult = abnormalResult;
    }

    /**
     * 获取管理操作人
     *
     * @return manage_name - 管理操作人
     */
    public String getManageName() {
        return manageName;
    }

    /**
     * 设置管理操作人
     *
     * @param manageName 管理操作人
     */
    public void setManageName(String manageName) {
        this.manageName = manageName == null ? null : manageName.trim();
    }

    /**
     * 获取操作时间
     *
     * @return handle_time - 操作时间
     */
    public Date getHandleTime() {
        return handleTime;
    }

    /**
     * 设置操作时间
     *
     * @param handleTime 操作时间
     */
    public void setHandleTime(Date handleTime) {
        this.handleTime = handleTime;
    }

    /**
     * 获取登记单号
     *
     * @return register_code - 登记单号
     */
    public String getRegisterCode() {
        return registerCode;
    }

    /**
     * 设置登记单号
     *
     * @param registerCode 登记单号
     */
    public void setRegisterCode(String registerCode) {
        this.registerCode = registerCode == null ? null : registerCode.trim();
    }

    /**
     * 获取创建者
     *
     * @return create_by - 创建者
     */
    public String getCreateBy() {
        return createBy;
    }

    /**
     * 设置创建者
     *
     * @param createBy 创建者
     */
    public void setCreateBy(String createBy) {
        this.createBy = createBy == null ? null : createBy.trim();
    }

    /**
     * 获取创建时间
     *
     * @return create_date - 创建时间
     */
    public Date getCreateDate() {
        return createDate;
    }

    /**
     * 设置创建时间
     *
     * @param createDate 创建时间
     */
    public void setCreateDate(Date createDate) {
        this.createDate = createDate;
    }

    /**
     * 获取删除标识
     *
     * @return is_active - 删除标识
     */
    public String getIsActive() {
        return isActive;
    }

    /**
     * 设置删除标识
     *
     * @param isActive 删除标识
     */
    public void setIsActive(String isActive) {
        this.isActive = isActive == null ? null : isActive.trim();
    }

    /**
     * 获取更新人
     *
     * @return update_by - 更新人
     */
    public String getUpdateBy() {
        return updateBy;
    }

    /**
     * 设置更新人
     *
     * @param updateBy 更新人
     */
    public void setUpdateBy(String updateBy) {
        this.updateBy = updateBy == null ? null : updateBy.trim();
    }

    /**
     * 获取更新日期
     *
     * @return update_date - 更新日期
     */
    public Date getUpdateDate() {
        return updateDate;
    }

    /**
     * 设置更新日期
     *
     * @param updateDate 更新日期
     */
    public void setUpdateDate(Date updateDate) {
        this.updateDate = updateDate;
    }
}

一的那一方的dto层

package com.zoomlion.rmp.dto.devicehandover;

import com.fasterxml.jackson.annotation.JsonFormat;
import com.zoomlion.rmp.entity.devicehandover.EquipAbnormalHandle;
import com.zoomlion.rmp.entity.devicehandover.EquipAbnormalIo;

import javax.persistence.Transient;
import java.util.Date;
import java.util.List;

/**
 * @author 小思
 * @PackageName:com.zoomlion.rmp.dto.devicehandover
 * @ClassName: EquipAbnormalIoDto
 * @Description: 设备实物出入库Dto
 * @date 2019/1/30 11:10
 * @Version: 1.0
 */
public class EquipAbnormalIoDto extends EquipAbnormalIo {
    //登记开始日期 该属性不为数据库表字段，但又是必须使用的
    @Transient
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date startDate;

    //登记结束日期 该属性不为数据库表字段，但又是必须使用的
    @Transient
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date endDate;

    /**
     * @Description 设备出入库对应的异常信息
     * @Param
     * @return
     **/
    @Transient
    private List<EquipAbnormalHandle> equipAbnormalHandles;

    public List<EquipAbnormalHandle> getEquipAbnormalHandles() {
        return equipAbnormalHandles;
    }

    public void setEquipAbnormalHandles(List<EquipAbnormalHandle> equipAbnormalHandles) {
        this.equipAbnormalHandles = equipAbnormalHandles;
    }

    public Date getStartDate() {
        return startDate;
    }

    public void setStartDate(Date startDate) {
        this.startDate = startDate;
    }

    public Date getEndDate() {
        return endDate;
    }

    public void setEndDate(Date endDate) {
        this.endDate = endDate;
    }

    @Override
    public String toString() {
        return "EquipAbnormalIoDto{" +
                "startDate=" + startDate +
                ", endDate=" + endDate +
                ", equipAbnormalHandles=" + equipAbnormalHandles +
                '}';
    }
}