본문 바로가기

카테고리 없음

association collection

반응형

<resultMap type="OrderAllVO" id="orderListResultMap">
        <association property="orderVo" column="orderNo" javaType="OrderVO">
            <id column="orderno" property="orderNo" jdbcType="BIGINT" />
            <result column="customerId" property="customerId" jdbcType="VARCHAR" />
            <result column="totalPrice" property="totalPrice" jdbcType="BIGINT" />
            <result column="deliveryStatus" property="deliveryStatus"
                jdbcType="VARCHAR" />
            <result column="orderDate" property="orderDate" jdbcType="TIMESTAMP" />
            <result column="deliveryDate" property="deliveryDate"
                jdbcType="TIMESTAMP" />
            <result column="paymentEndDate" property="paymentEndDate"
                jdbcType="TIMESTAMP" />
            <result column="message" property="message" jdbcType="VARCHAR" />
            <result column="customerName" property="customerName"
                jdbcType="VARCHAR" />
            <result column="hp" property="hp" jdbcType="VARCHAR" />
            <result column="zipcode" property="zipcode" jdbcType="VARCHAR" />
            <result column="address" property="address" jdbcType="VARCHAR" />
            <result column="addressDetail" property="addressDetail"
                jdbcType="VARCHAR" />
        </association>
        <collection property="orderDetailsList" column="orderNo"
            javaType="ArrayList" ofType="map" select="selectOrderDetailsView"></collection>
    </resultMap>
Colored by Color Scripter



반응형