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>