JAVA 저장전 중복체크 처리
============serviceimpl===============
int dupRegCnt = (Integer)le022DAO.selectByPk("LE022DAO.chkRegDupl", vo);
if(dupRegCnt > 0){
throw new BizException(.........);
}
=============xml=====================
<select id="LE022DAO.chkRegDupl" parameterClass="le022VO" resultClass="int">
/* [LE022DAO.chkRegDupl] ............. */
SELECT COUNT(*) CNT
FROM LE_TRN_VND_DT
WHERE NAT_CD = #natCd#
AND VHC_NO = #vhcNo#
AND VND_CD = #vndCd#
AND VHC_SZE = #vhcSze#
WITH UR
</select>
int dupRegCnt = (Integer)le022DAO.selectByPk("LE022DAO.chkRegDupl", vo);
if(dupRegCnt > 0){
throw new BizException(.........);
}
=============xml=====================
<select id="LE022DAO.chkRegDupl" parameterClass="le022VO" resultClass="int">
/* [LE022DAO.chkRegDupl] ............. */
SELECT COUNT(*) CNT
FROM LE_TRN_VND_DT
WHERE NAT_CD = #natCd#
AND VHC_NO = #vhcNo#
AND VND_CD = #vndCd#
AND VHC_SZE = #vhcSze#
WITH UR
</select>
댓글
댓글 쓰기