<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
카테고리 없음
association collection
반응형
반응형