https://developerhjg.tistory.com/69
https://taetaetae.github.io/2017/04/04/mybatis-useGeneratedKeys/
ibatis 와 mybatis 는 다르다
키값 아이가 테이블 컬럼 plan_id 아니라 객체 planId 값이다.
<resultMap id="planProductMAP" type="erp.web.domain.PlanProductVO">
<result property="no" column="no"/>
<result property="planId" column="plan_id"/>
<result property="bomid" column="bomid"/>
<result property="pcode" column="pcode"/>
<result property="planProductName" column="plan_product_name"/>
<result property="planProductQuantity" column="plan_product_quantity"/>
<result property="deadline" column="deadline"/>
<result property="remarks" column="remarks"/>
</resultMap>
<insert id="insertPlanProduct2" useGeneratedKeys="true" keyProperty="planId" parameterType="erp.web.domain.PlanProductVO" >
INSERT INTO tbl_plan_product(
bomid
,plan_product_name
,plan_product_quantity
,deadline
,remarks
)
VALUES
(
#{bomid}
,#{planProductName}
,#{planProductQuantity}
,#{deadline}
,#{remarks}
)
</insert>

















댓글 ( 4)
댓글 남기기