ibatis sqlMap基本写法

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">

<sqlMap namespace="SettleAccountsDao">

    <typeAlias alias="SettleAccounts" type="com.jala.finance.entity.SettleAccounts" />
    
	<resultMap id="SettleAccounts-Rusult" class="SettleAccounts">
	<result property="k3code" column="k3code" jdbcType="VARCHAR2" />
		<result property="vid" column="vid" jdbcType="NUMBER" nullValue="0" />
		<result property="settleAccountsId" column="settle_accounts_id" jdbcType="NUMBER" nullValue="0" />
		<result property="orderSourceTypeId" column="order_source_type_id" jdbcType="NUMBER" nullValue="0" />
		<result property="orderSourceTypeName" column="order_source_type_name" jdbcType="VARCHAR2" />
		<result property="settleAccountsDrpId" column="settle_accounts_drp_id" jdbcType="VARCHAR2" />
		<result property="settleAccountsType" column="settle_accounts_type" jdbcType="VARCHAR2" />
		<result property="dealerName" column="dealer_name" jdbcType="VARCHAR2" />
		<result property="ccUserId" column="cc_user_id" jdbcType="NUMBER" nullValue="0" />
		<result property="lastCcUserId" column="last_cc_user_id" jdbcType="NUMBER" nullValue="0" />
		<result property="createTime" column="create_time" jdbcType="VARCHAR2" />
		<result property="lastTime" column="last_time" jdbcType="VARCHAR2" />
	</resultMap>

	<select id="SettleAccounts-SelectByKey" resultMap="SettleAccounts-Rusult">
	<![CDATA[
		select 
		k3code,
		settle_accounts_id,
		order_source_type_id,
		order_source_type_name,
		settle_accounts_drp_id,
		settle_accounts_type,
		dealer_name,
		cc_user_id,
		last_cc_user_id,
		create_time,
		last_time,
		vid
		from CRM_SETTLE_ACCOUNTS 
		where settleAccountsId = #value#
	]]>
	</select>
	
	<select id="SettleAccounts-SelectByObject" resultMap="SettleAccounts-Rusult">
		select 
		k3code,
		settle_accounts_id,
		order_source_type_id,
		order_source_type_name,
		settle_accounts_drp_id,
		settle_accounts_type,
		dealer_name,
		cc_user_id,
		last_cc_user_id,
		create_time,
		last_time,
		vid
		from CRM_SETTLE_ACCOUNTS 
		<dynamic prepend="WHERE">
			<isNotNull prepend="and" property="k3code">
		k3code = #k3code#
			</isNotNull>
			<isNotEqual prepend="and" property="vid" compareValue="0">
		vid = #vid#
			</isNotEqual>
			<isNotEqual prepend="and" property="settleAccountsId" compareValue="0">
		settle_accounts_id = #settleAccountsId#
			</isNotEqual>
			<isNotEqual prepend="and" property="orderSourceTypeId" compareValue="0">
		order_source_type_id = #orderSourceTypeId#
			</isNotEqual>
			<isNotNull prepend="and" property="orderSourceTypeName">
		order_source_type_name = #orderSourceTypeName#
			</isNotNull>
			<isNotNull prepend="and" property="settleAccountsDrpId">
		settle_accounts_drp_id = #settleAccountsDrpId#
			</isNotNull>
			<isNotNull prepend="and" property="settleAccountsType">
		settle_accounts_type = #settleAccountsType#
			</isNotNull>
			<isNotNull prepend="and" property="dealerName">
		dealer_name = #dealerName#
			</isNotNull>
			<isNotEqual prepend="and" property="ccUserId" compareValue="0">
		cc_user_id = #ccUserId#
			</isNotEqual>
			<isNotEqual prepend="and" property="lastCcUserId" compareValue="0">
		last_cc_user_id = #lastCcUserId#
			</isNotEqual>
			<isNotNull prepend="and" property="createTime">
		create_time = #createTime#
			</isNotNull>
			<isNotNull prepend="and" property="lastTime">
		last_time = #lastTime#
			</isNotNull>
		</dynamic>
	</select>

	<!-- mapped statement for IbatisWpTingDAO.insert -->
	<insert id="SettleAccounts-Insert" parameterClass="SettleAccounts">
    <![CDATA[
	INSERT INTO CRM_SETTLE_ACCOUNTS(
		k3code,	
		settle_accounts_id,	
		order_source_type_id,	
		order_source_type_name,	
		settle_accounts_drp_id,	
		settle_accounts_type,	
		dealer_name,	
		cc_user_id,	
		last_cc_user_id,	
		create_time,	
		last_time,	
		vid
	)VALUES(	
		#k3code#,
		#settleAccountsId#,
		#orderSourceTypeId#,
		#orderSourceTypeName#,
		#settleAccountsDrpId#,
		#settleAccountsType#,
		#dealerName#,
		#ccUserId#,
		#lastCcUserId#,
		#createTime#,
		#lastTime#,
		1
		)
    ]]>
	</insert>
	
	<delete id="SettleAccounts-DeleteByKey">
	<![CDATA[
		delete from CRM_SETTLE_ACCOUNTS 
		where settleAccountsId = #value#
	]]>
	</delete>
	
	<delete id="SettleAccounts-DeleteByObject" parameterClass="SettleAccounts">
	<![CDATA[
		delete from CRM_SETTLE_ACCOUNTS 
		where settleAccountsId = #settleAccountsId#
	]]>
	</delete>
	
	<update id="SettleAccounts-Update" parameterClass="SettleAccounts">
	<![CDATA[
	    update CRM_SETTLE_ACCOUNTS
	    set	    
		k3code = #k3code#,	
		order_source_type_id = #orderSourceTypeId#,	
		order_source_type_name = #orderSourceTypeName#,	
		settle_accounts_drp_id = #settleAccountsDrpId#,	
		settle_accounts_type = #settleAccountsType#,	
		dealer_name = #dealerName#,	
		cc_user_id = #ccUserId#,	
		last_cc_user_id = #lastCcUserId#,	
		create_time = #createTime#,	
		last_time = #lastTime#,	
		vid = vid + 1
		where settleAccountsId = #settleAccountsId#
		and vid = #vid#
	]]>
	</update>
	
</sqlMap>

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值