ibatis insert 语句与update语句
来源:互联网 发布:unity代码如何优化 编辑:程序博客网 时间:2024/06/06 19:56
update QPC_TRANSINTERINTERESTRATE
<dynamic prepend="set">
<isNotNull prepend="," property="transOffice">
TRANSOFFICE = #transOffice#
</isNotNull>
<isNotNull prepend="," property="currencyId">
CURRENCYID = #currencyId#
</isNotNull>
<isNotNull prepend="," property="rateName">
RATE_NAME = #rateName#
</isNotNull>
<isNotNull prepend="," property="subDate">
SUB_DATE = #subDate#
</isNotNull>
<isNotNull prepend="," property="rateResource">
RATE_RESOURCE = #rateResource#
</isNotNull>
<isNotNull prepend="," property="rateSevendays">
RATE_SEVENDAYS = #rateSevendays#
</isNotNull>
<isNotNull prepend="," property="rateFourteendays">
RATE_FOURTEENDAYS = #rateFourteendays#
</isNotNull>
<isNotNull prepend="," property="rateOneMonth">
RATE_ONEMONTH = #rateOneMonth#
</isNotNull>
<isNotNull prepend="," property="rateThreeMonth">
RATE_THREEMONTH = #rateThreeMonth#
</isNotNull>
<isNotNull prepend="," property="rateSixMonth">
RATE_SIXMONTH = #rateSixMonth#
</isNotNull>
<isNotNull prepend="," property="rateNineMonth">
RATE_NINEMONTH = #rateNineMonth#
</isNotNull>
<isNotNull prepend="," property="rateOneYear">
RATE_ONEYEAR = #rateOneYear#
</isNotNull>
<isNotNull prepend="," property="modifyTime">
MODIFYTIME = #modifyTime#
</isNotNull>
</dynamic>
where ID = #id#
</update>
<insert id="insert" parameterClass="com.iss.finance.price.inter.entity.inter.PriceInter">
<selectKey resultClass="Long" type="pre" keyProperty="id">
SELECT HIBERNATE_SEQUENCE.NEXTVAL AS VALUE FROM DUAL
</selectKey>
insert into QPC_TRANSINTERINTERESTRATE
<dynamic prepend="(">
<isNotNull prepend="," property="id">
ID
</isNotNull>
<isNotNull prepend="," property="transOffice">
TRANSOFFICE
</isNotNull>
<isNotNull prepend="," property="currencyId">
CURRENCYID
</isNotNull>
<isNotNull prepend="," property="rateName">
RATE_NAME
</isNotNull>
<isNotNull prepend="," property="subDate">
SUB_DATE
</isNotNull>
<isNotNull prepend="," property="rateResource">
RATE_RESOURCE
</isNotNull>
<isNotNull prepend="," property="rateSevendays">
RATE_SEVENDAYS
</isNotNull>
<isNotNull prepend="," property="rateFourteendays">
RATE_FOURTEENDAYS
</isNotNull>
<isNotNull prepend="," property="rateOneMonth">
RATE_ONEMONTH
</isNotNull>
<isNotNull prepend="," property="rateThreeMonth">
RATE_THREEMONTH
</isNotNull>
<isNotNull prepend="," property="rateSixMonth">
RATE_SIXMONTH
</isNotNull>
<isNotNull prepend="," property="rateNineMonth">
RATE_NINEMONTH
</isNotNull>
<isNotNull prepend="," property="rateOneYear">
RATE_ONEYEAR
</isNotNull>
<isNotNull prepend="," property="inputTime">
INPUTTIME
</isNotNull>
)
</dynamic>
values
<dynamic prepend="(">
<isNotNull prepend="," property="id">
#id#
</isNotNull>
<isNotNull prepend="," property="transOffice">
#transOffice#
</isNotNull>
<isNotNull prepend="," property="currencyId">
#currencyId#
</isNotNull>
<isNotNull prepend="," property="rateName">
#rateName#
</isNotNull>
<isNotNull prepend="," property="subDate">
#subDate#
</isNotNull>
<isNotNull prepend="," property="rateResource">
#rateResource#
</isNotNull>
<isNotNull prepend="," property="rateSevendays">
#rateSevendays#
</isNotNull>
<isNotNull prepend="," property="rateFourteendays">
#rateFourteendays#
</isNotNull>
<isNotNull prepend="," property="rateOneMonth">
#rateOneMonth#
</isNotNull>
<isNotNull prepend="," property="rateThreeMonth">
#rateThreeMonth#
</isNotNull>
<isNotNull prepend="," property="rateSixMonth">
#rateSixMonth#
</isNotNull>
<isNotNull prepend="," property="rateNineMonth">
#rateNineMonth#
</isNotNull>
<isNotNull prepend="," property="rateOneYear">
#rateOneYear#
</isNotNull>
<isNotNull prepend="," property="inputTime">
#inputTime#
</isNotNull>
)
</dynamic>
</insert>
- ibatis insert 语句与update语句
- mysql insert update语句
- MySQL insert update语句
- ibatis 嵌套insert select语句
- MYSQL INSERT UPDATE DELETE 语句
- DML语句(delete,insert,update)
- insert 复合语句和 update 复合语句
- (Insert)插入语句,(Update)修改语句,(delete)删除语句
- Ibatis insert语句中 思想 keyProperty
- select,delete,update,insert语句使用方法
- 如何跨服务器进行insert update语句
- SQL语句复习:insert,update,delete,select
- hibernate自定义的(insert,update,delete)语句
- T-SQL Recipes------Insert, Update, Delete语句
- SQL语句复习:insert,update,delete,select
- oracle中合并insert、update语句
- mysql数据库insert、delete、update语句总结
- 根据POJO 产生 UPDATE 和 INSERT 语句
- java设计模式,模板方法模式
- DM9000网卡
- 打签名包错误汇总
- 科大讯飞的语音听写
- [LeetCode]--258. Add Digits
- ibatis insert 语句与update语句
- 冒泡排序
- mybaties 错误
- Shell中的重定向
- OpenGL—渲染管线
- activiti5.20简单介绍(四) -- helloworld
- mysql 查询以及修改表、数据库的编码方式(以及整个数据库的编码方式)
- 使用Dom4j解析XML
- androd studio 依赖引用的方法以及常见的问题