`
流浪鱼
  • 浏览: 1636198 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

update 元素例子

 
阅读更多

更新元素的例子

	    <update id="updateCreditExtension" parameterClass="map">
	    		UPDATE TEST_CUST_CREDITEXTENSION
				   SET PROTOCOL_CODE      = #PROTOCOL_CODE#,
				       CREDIT_TYPE        = #CREDIT_TYPE#,
				       CREDIT_DATE        = TO_DATE(#CREDIT_DATE#,'YYYY-MM-DD'),
				       CUST_ID            = #CUST_ID#,
				       PRE_MONEY          = #PRE_MONEY#,
				       PRE_MONEY_TYPE     = #PRE_MONEY_TYPE#,
				       CURRENT_MONEY      = #CURRENT_MONEY#,
				       CURRENT_MONEY_TYPE = #CURRENT_MONEY_TYPE#,
				       CREDIT_BALANCE     = #CREDIT_BALANCE#,
				       CREDIT_DATE_START  = TO_DATE(#CREDIT_DATE_START#,'YYYY-MM-DD'),
				       CREDIT_DATE_END    = TO_DATE(#CREDIT_DATE_END#,'YYYY-MM-DD'),
               <isNotEmpty property="RATE">RATE = #RATE#,</isNotEmpty>
				       IS_DIF_TYPE        = #IS_DIF_TYPE#,
				       IS_LOOP_CREDIT     = #IS_LOOP_CREDIT#,
				       IS_ASSURE          = #IS_ASSURE#,
				       CREDIT_REMARK      = #CREDIT_REMARK#,
				       MODIFY_DATE        = SYSDATE,
				       CUST_FLAG		  = #CUST_FLAG#,
				   	   CUST_DIF			  = #CUST_DIF#,
				       MODIFICATOR        = #CREATEID#
				 WHERE CUCES_ID = #CUCES_ID#
				   AND IS_DELETE = 0
	    </update>

 

 

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics