mybatis配置对象包含对象以及List

来源:互联网 发布:淘宝上下架规则2017 编辑:程序博客网 时间:2024/06/01 08:03

这里隐藏get set方法

public class BatchManagerViewVo  implements Serializable{/*** @Description: serialVersionUID : TODO*/ private static final long serialVersionUID = 1L;private List<ResourcesItemDto> resourceItem;private List<PriceInfoDto> priceInfo;/**     * 主键(PM200600001)     */    @Id    @Column(name = "ID")    private String id;    public List<ResourcesItemDto> getResourceItem() {return resourceItem;}public void setResourceItem(List<ResourcesItemDto> resourceItem) {this.resourceItem = resourceItem;}public List<PriceInfoDto> getPriceInfo() {return priceInfo;}public void setPriceInfo(List<PriceInfoDto> priceInfo) {this.priceInfo = priceInfo;}/**     * 场次名称     */    @Column(name = "BATCH_NAME")    private String batchName;    /**     * 会员名称     */    @Column(name = "MEMBER_NAME")    private String memberName;    /**     * 发起竞价的会员代码     */    @Column(name = "MEMBER_CODE")    private String memberCode;    /**     * 委托状态:0-已生成,1-已发布,2.竞价中 3-已撤消,4--已作废,5-已完成     */    @Column(name = "BATCH_STATE")    private String batchState;    /**     * 委托申请时间     */    @Column(name = "BATCH_DATE")    private Date batchDate;    /**     * 结束时间     */    @Column(name = "END_TIME")    private Date endTime;    /**     * 开始时间     */    @Column(name = "START_TIME")    private Date startTime;    /**     * 履约保证金是否已经支付 1 - 已经支付 0 - 未支付(只有此状态为1才允许开始拍卖)     */    @Column(name = "BOND_PAYMENT_STATUS")    private String bondPaymentStatus;    /**     * 结算方式:1-场外结算(默认) 2- 场内结算     */    @Column(name = "SETTLEMENT_MODE")    private String settlementMode;    /**     * 作废时间     */    @Column(name = "INVALID_DATE")    private Date invalidDate;    /**     * 审核操作员     */    @Column(name = "AUDIT_OPERATOR")    private String auditOperator;    /**     * 终止操作员     */    @Column(name = "STOP_OPERATOR")    private String stopOperator;    /**     * 作废操作员     */    @Column(name = "INVALID_OPERATOR")    private String invalidOperator;    /**     * 申请操作员     */    @Column(name = "APPLY_OPERATOR")    private String applyOperator;    /**     * 公告日     */    @Column(name = "ANNOUNCEMENT_DAY")    private Date announcementDay;    /**     * 竞价日     */    @Column(name = "BID_DAY")    private Date bidDay;    /**     * 买方保证金     */    @Column(name = "BUYER_DEPOSIT")    private BigDecimal buyerDeposit;    /**     * 卖家保证金     */    @Column(name = "SELLER_BOND")    private BigDecimal sellerBond;    /**     * 强制终止理由     */    @Column(name = "FORCED_TERMINATION_REASON")    private String forcedTerminationReason;    /**     * 终止委托审核理由(待定)     */    @Column(name = "AUDIT_STOP_REASON")    private String auditStopReason;    /**     * 终止委托审核时间(待定)     */    @Column(name = "AUDIT_STOP_DATE")    private Date auditStopDate;    /**     * 终止委托申请理由(待定)     */    @Column(name = "APPLY_STOP_REASON")    private String applyStopReason;    /**     * 终止委托申请时间(待定)     */    @Column(name = "APPLY_STOP_DATE")    private Date applyStopDate;    /**     * 拒绝审核委托理由(待定)     */    @Column(name = "REFUSE_AUDIT_REASON")    private String refuseAuditReason;    /**     * 委托审核时间(待定)     */    @Column(name = "AUDIT_TIME")    private Date auditTime;    /**     * 定向竞价0否1是1     */    @Column(name = "IS_DIRECTIONAL_BID")    private String isDirectionalBid;    /**     * 定向的原因,当场次定向时必须输入     */    @Column(name = "DIRECTIONAL_REASON")    private String directionalReason;    /**     * 是否需要发送短信0不发送1发送     */    @Column(name = "IS_SEND_MESSAGE")    private String isSendMessage;    /**     * 是否显示中标价格     */    @Column(name = "IS_SHOW_DEAL_PRICE")    private String isShowDealPrice;    /**     * 是否显示定价     */    @Column(name = "IS_SHOW_ORDER_PRICE")    private String isShowOrderPrice;    /**     * 是否显示中标会员     */    @Column(name = "IS_SHOW_DEAL_MEMBER")    private String isShowDealMember;    /**     * 最少响应人数     */    @Column(name = "MINIMUM_RESPONSE")    private String minimumResponse;    /**     * 是否显示成交结果     */    @Column(name = "ISSHOWDEALRESULT")    private String isshowdealresult;    /**     * 竞价模式:1-公开增价,2自由报价,3-荷式竞价     */    @Column(name = "BIDDING_TYPE")    private String biddingType;    /**     * 报盘方式:1-单价,2-总价     */    @Column(name = "OFFER_TYPE")    private String offerType;    /**     * 是否显示起拍价 1显示(默认) 2不显示      */    @Column(name = "IS_SHOW_STARTING_PIRCE")    private String isShowStartingPirce;    /**     * 域名     */    @Column(name = "DOAMIN")    private String doamin;    /**     * 协议     */    @Column(name = "EDITMENT")    private String editment;} 


 <select id="findSellerBatchInfo" parameterType="com.ouyeel.chem.bdt.search.BatchManagerSerachModel" resultMap="batchInfoMap">  select   batch.ID,  batch.BATCH_NAME,  batch.BATCH_STATE batch_state,  batch.START_TIME batch_start_time,  batch.END_TIME batch_end_time,  batch.IS_DIRECTIONAL_BID batch_is_direc,  batch.BUYER_DEPOSIT batch_buyer_deposit,  batch.BIDDING_TYPE batch_bidding_type,  batch.OFFER_TYPE batch_offer_type,  batch.BATCH_DATE batch_date,  batch.ANNOUNCEMENT_DAY batch_announ,  batch.BID_DAY batch_bid_day,  price.id price_id,   price.STARTING_PIRCE price_starting_price,  price.BIDDING_GRADIENT price_bidding_gradient,  price.TAX_RATE price_tax_rate,  price.TAX_FREE_PRICE price_tax_free_price,  price.RESERVE_PRICE price_reserve_price,  item.PRODUCT_NAME item_product_name,  item.PRODUCT_NO item_product_no,  item.PACKAGES item_packages,  item.ORIGIN_PLACE item_origin_place,  item.WAREHOUSE_NAME item_warehouse,  item.PIECE_UNIT item_piece_unit,  item.TRADING_WEIGHT item_trading_weight  from bdt_batch batch  left join bdt_resources_item item on item.batch_id = batch.id left join bdt_price_info price on price.batch_id = batch.id and item.id = price.item_id  where batch.member_code = #{memberCode,jdbcType=VARCHAR}<!--  and batch.id = 'P170508005' -->  <if test="id != null and id != '' ">  and batch.id like '%${id}%'  </if>  <if test="startTime != null and startTime != '' ">  and batch.batch_date >= #{startTime,jdbcType=TIMESTAMP}  </if>  <if test="endTime != null and endTime != '' ">  and batch.batch_date <= #{endTime,jdbcType=TIMESTAMP}  </if>  <if test="batchState != null and batchState != '' ">  and batch.batch_state = #{batchState,jdbcType=VARCHAR}  </if><if test="sidx != null and sidx != '' ">  order by batch.${sidx} ${sord}  </if>  <if test="sidx == null or sidx ==''">  order by batch.id desc  </if>  </select>

<resultMap type="com.ouyeel.chem.bdt.entity.vo.BatchManagerViewVo" id="batchInfoMap">        <!-- association字面意思关联,这里只专门做一对一关联; property表示是com.mybatis.bean.StudentTemp中的属性名称;             javaType表示该属性是什么类型对象 -->        <!-- property 表示com.mybatis.bean.Class中的属性; column 表示表中的列名 -->        <id property="id" column="id"/>    <result property="batchName" column="batch_name"/>    <result property="startTime" column="batch_start_time"/>    <result property="endTime" column="batch_end_time"/>    <result property="isDirectionalBid" column="batch_is_direc"/>    <result property="batchState" column="batch_state"/>    <result property="buyerDeposit" column="batch_buyer_deposit"/>    <result property="biddingType" column="batch_bidding_type"/>    <result property="offerType" column="batch_offer_type"/>    <result property="batchDate" column="batch_date"/>    <result property="announcementDay" column="batch_announ"/>    <result property="bidDay" column="batch_bid_day"/>        <!-- property表示集合类型属性名称,ofType表示集合中的对象是什么类型 -->        <collection property="priceInfo" ofType="com.ouyeel.chem.bdt.entity.PriceInfoDto">            <id property="id" column="price_id"/>       <result property="startingPirce" column="price_starting_price"/>       <result property="biddingGradient" column="price_bidding_gradient"/>       <result property="taxRate" column="price_tax_rate"/>       <result property="taxFreePrice" column="price_tax_free_price"/>       <result property="reservePrice" column="price_reserve_price"/>        </collection>       <!--  property表示集合类型属性名称,ofType表示集合中的对象是什么类型 -->        <collection property="resourceItem" ofType="com.ouyeel.chem.bdt.entity.ResourcesItemDto">       <result property="productName" column="item_product_name"/>       <result property="productNo" column="item_product_no"/>       <result property="packages" column="item_packages"/>       <result property="originPlace" column="item_origin_place"/>       <result property="warehouseName" column="item_warehouse"/>       <result property="pieceUnit" column="item_piece_unit"/>       <result property="tradingWeight" column="item_trading_weight"/>        </collection>  </resultMap>

1 0