IBATIS2.0映射文件oracle/mysql版实现示例,功能全面且丰富
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了IBATIS2.0映射文件oracle/mysql版实现示例,功能全面且丰富,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含9484字,纯文字阅读大概需要14分钟。
内容图文
![IBATIS2.0映射文件oracle/mysql版实现示例,功能全面且丰富](/upload/InfoBanner/zyjiaocheng/566/cf0e5470f93542d6a6da1ea86055256b.jpg)
IBATIS2.0映射文件oracle/mysql版实现示例,功能全面且丰富,开发参考可以提高一定效率,还不错。呵呵。 实现的功能 1.保存物资项目。 2.保存物资变更记录集合。 3.查询处理返回内容字段。 iBATIS Oracle MySQL ?xml version="1.0" encoding="UTF-8" standalon
IBATIS2.0映射文件 oracle/mysql 版实现示例,功能全面且丰富,开发参考可以提高一定效率,还不错。呵呵。实现的功能
1.保存物资项目。
2.保存物资变更记录集合。
3.查询处理返回内容字段。 iBATIS Oracle MySQL
HUGS_ID, HUGS_NAME, HUGS_BRAND, HUGS_VERSION, HUGS_PRODUCT_DATE, HUGS_ASSET_CODE, HUGS_PRICE, HUGS_DEPT_ID, HUGS_DEPT_NAME, HUGS_USER_ID, HUGS_USER_NAME, HUGS_USE_RESON, HUGS_USE_STATUS, HUGS_DESCR, HUGS_STATUS, HUGS_CREATOR, HUGS_CREATE_TIME, HUGS_UPDATE, HUGS_UPDATE_TIME,HUGS_COMPANY AND HUGS_ASSET_CODE LIKE '%$HUGS_ASSET_CODE$%' AND HUGS_NAME LIKE '%$HUGS_NAME$%' AND HUGS_DEPT_NAME LIKE '%$HUGS_DEPT_NAME$%' AND HUGS_USER_NAME LIKE '%$HUGS_USER_NAME$%' AND HUGS_USE_RESON LIKE '%$HUGS_USE_RESON$%' AND HUGS_COMPANY = #HUGS_COMPANY# SELECT HU_GOODS_SQ.NEXTVAL AS VALUE FROM DUAL INSERT INTO HU_GOODS ( HUGS_ID, HUGS_NAME, HUGS_BRAND, HUGS_VERSION, HUGS_PRODUCT_DATE, HUGS_ASSET_CODE, HUGS_PRICE, HUGS_DEPT_ID, HUGS_DEPT_NAME, HUGS_USER_ID, HUGS_USER_NAME, HUGS_USE_RESON, HUGS_USE_STATUS, HUGS_DESCR, HUGS_STATUS, HUGS_CREATOR, HUGS_CREATE_TIME, HUGS_UPDATE, HUGS_UPDATE_TIME, HUGS_COMPANY ) VALUES ( #HUGS_ID#, #HUGS_NAME#, #HUGS_BRAND#, #HUGS_VERSION#,#HUGS_PRODUCT_DATE#,#HUGS_ASSET_CODE#,#HUGS_PRICE#,#HUGS_DEPT_ID#,#HUGS_DEPT_NAME#,#HUGS_USER_ID#,#HUGS_USER_NAME#,#HUGS_USE_RESON#,#HUGS_USE_STATUS#,#HUGS_DESCR#,#HUGS_STATUS#,#HUGS_CREATOR#,SYSDATE, #HUGS_UPDATE#, SYSDATE, #HUGS_COMPANY# )UPDATE HU_GOODS SET HUGS_NAME=#HUGS_NAME#, HUGS_BRAND=#HUGS_BRAND#, HUGS_VERSION=#HUGS_VERSION#,HUGS_PRODUCT_DATE=#HUGS_PRODUCT_DATE#,HUGS_PRICE=#HUGS_PRICE#,HUGS_DEPT_ID=#HUGS_DEPT_ID#,HUGS_DEPT_NAME=#HUGS_DEPT_NAME#,HUGS_USER_ID=#HUGS_USER_ID#,HUGS_USER_NAME=#HUGS_USER_NAME#,HUGS_USE_RESON=#HUGS_USE_RESON#,HUGS_USE_STATUS=#HUGS_USE_STATUS#,HUGS_DESCR=#HUGS_DESCR#,HUGS_STATUS=#HUGS_STATUS#,HUGS_CREATOR=#HUGS_CREATOR#,HUGS_UPDATE_TIME=SYSDATE where HUGS_ASSET_CODE=#HUGS_ASSET_CODE# HUGI_ID, HUGI_GOODS_ID, HUGI_DEPT_ID, HUGI_DEPT_NAME, HUGI_USER_ID, HUGI_USER_NAME, HUGI_USE_RESON, HUGI_USE_STATUS, HUGI_DESCR, HUGI_STATUS, HUGI_CREATOR, HUGI_CREATE_TIME, HUGI_UPDATE, HUGI_UPDATE_TIME AND HUGI_GOODS_ID = #HUGI_GOODS_ID# AND HUGI_DEPT_NAME LIKE '%$HUGI_DEPT_NAME$%' AND HUGI_USER_NAME LIKE '%$HUGI_USER_NAME$%' AND HUGI_USE_RESON LIKE '%$HUGI_USE_RESON$%' SELECT HU_GOODS_ITEM_SQ.NEXTVAL AS VALUE FROM DUAL INSERT INTO HU_GOODS_ITEM (HUGI_ID,HUGI_GOODS_ID, HUGI_DEPT_ID, HUGI_DEPT_NAME, HUGI_USER_ID, HUGI_USER_NAME, HUGI_USE_RESON, HUGI_USE_STATUS, HUGI_DESCR, HUGI_STATUS, HUGI_CREATOR, HUGI_CREATE_TIME, HUGI_UPDATE, HUGI_UPDATE_TIME) VALUES (#HUGI_ID#,#HUGI_GOODS_ID#, #HUGI_DEPT_ID#, #HUGI_DEPT_NAME#, #HUGI_USER_ID#, #HUGI_USER_NAME#, #HUGI_USE_RESON#, #HUGI_USE_STATUS#, #HUGI_DESCR#, #HUGI_STATUS#, #HUGI_CREATOR#, SYSDATE, #HUGI_UPDATE#, SYSDATE)DELETE FROM HU_GOODS_ITEM WHERE HUGI_ID =#HUGI_ID#
HUGS_ID, HUGS_NAME, HUGS_BRAND, HUGS_VERSION, HUGS_PRODUCT_DATE, HUGS_ASSET_CODE, HUGS_PRICE, HUGS_DEPT_ID, HUGS_DEPT_NAME, HUGS_USER_ID, HUGS_USER_NAME, HUGS_USE_RESON, HUGS_USE_STATUS, HUGS_DESCR, HUGS_STATUS, HUGS_CREATOR, HUGS_CREATE_TIME, HUGS_UPDATE, HUGS_UPDATE_TIME,HUGS_COMPANY AND HUGS_ASSET_CODE LIKE '%$HUGS_ASSET_CODE$%' AND HUGS_NAME LIKE '%$HUGS_NAME$%' AND HUGS_DEPT_NAME LIKE '%$HUGS_DEPT_NAME$%' AND HUGS_USER_NAME LIKE '%$HUGS_USER_NAME$%' AND HUGS_USE_RESON LIKE '%$HUGS_USE_RESON$%' AND HUGS_COMPANY = #HUGS_COMPANY# SELECT HU_GOODS_SQ.NEXTVAL AS VALUE FROM DUAL INSERT INTO HU_GOODS ( HUGS_ID, HUGS_NAME, HUGS_BRAND, HUGS_VERSION, HUGS_PRODUCT_DATE, HUGS_ASSET_CODE, HUGS_PRICE, HUGS_DEPT_ID, HUGS_DEPT_NAME, HUGS_USER_ID, HUGS_USER_NAME, HUGS_USE_RESON, HUGS_USE_STATUS, HUGS_DESCR, HUGS_STATUS, HUGS_CREATOR, HUGS_CREATE_TIME, HUGS_UPDATE, HUGS_UPDATE_TIME, HUGS_COMPANY ) VALUES ( #HUGS_ID#, #HUGS_NAME#, #HUGS_BRAND#, #HUGS_VERSION#,#HUGS_PRODUCT_DATE#,#HUGS_ASSET_CODE#,#HUGS_PRICE#,#HUGS_DEPT_ID#,#HUGS_DEPT_NAME#,#HUGS_USER_ID#,#HUGS_USER_NAME#,#HUGS_USE_RESON#,#HUGS_USE_STATUS#,#HUGS_DESCR#,#HUGS_STATUS#,#HUGS_CREATOR#,SYSDATE, #HUGS_UPDATE#, SYSDATE, #HUGS_COMPANY# )UPDATE HU_GOODS SET HUGS_NAME=#HUGS_NAME#, HUGS_BRAND=#HUGS_BRAND#, HUGS_VERSION=#HUGS_VERSION#,HUGS_PRODUCT_DATE=#HUGS_PRODUCT_DATE#,HUGS_PRICE=#HUGS_PRICE#,HUGS_DEPT_ID=#HUGS_DEPT_ID#,HUGS_DEPT_NAME=#HUGS_DEPT_NAME#,HUGS_USER_ID=#HUGS_USER_ID#,HUGS_USER_NAME=#HUGS_USER_NAME#,HUGS_USE_RESON=#HUGS_USE_RESON#,HUGS_USE_STATUS=#HUGS_USE_STATUS#,HUGS_DESCR=#HUGS_DESCR#,HUGS_STATUS=#HUGS_STATUS#,HUGS_CREATOR=#HUGS_CREATOR#,HUGS_UPDATE_TIME=SYSDATE where HUGS_ASSET_CODE=#HUGS_ASSET_CODE# HUGI_ID, HUGI_GOODS_ID, HUGI_DEPT_ID, HUGI_DEPT_NAME, HUGI_USER_ID, HUGI_USER_NAME, HUGI_USE_RESON, HUGI_USE_STATUS, HUGI_DESCR, HUGI_STATUS, HUGI_CREATOR, HUGI_CREATE_TIME, HUGI_UPDATE, HUGI_UPDATE_TIME AND HUGI_GOODS_ID = #HUGI_GOODS_ID# AND HUGI_DEPT_NAME LIKE '%$HUGI_DEPT_NAME$%' AND HUGI_USER_NAME LIKE '%$HUGI_USER_NAME$%' AND HUGI_USE_RESON LIKE '%$HUGI_USE_RESON$%' SELECT HU_GOODS_ITEM_SQ.NEXTVAL AS VALUE FROM DUAL INSERT INTO HU_GOODS_ITEM (HUGI_ID,HUGI_GOODS_ID, HUGI_DEPT_ID, HUGI_DEPT_NAME, HUGI_USER_ID, HUGI_USER_NAME, HUGI_USE_RESON, HUGI_USE_STATUS, HUGI_DESCR, HUGI_STATUS, HUGI_CREATOR, HUGI_CREATE_TIME, HUGI_UPDATE, HUGI_UPDATE_TIME) VALUES (#HUGI_ID#,#HUGI_GOODS_ID#, #HUGI_DEPT_ID#, #HUGI_DEPT_NAME#, #HUGI_USER_ID#, #HUGI_USER_NAME#, #HUGI_USE_RESON#, #HUGI_USE_STATUS#, #HUGI_DESCR#, #HUGI_STATUS#, #HUGI_CREATOR#, SYSDATE, #HUGI_UPDATE#, SYSDATE)DELETE FROM HU_GOODS_ITEM WHERE HUGI_ID =#HUGI_ID#
内容总结
以上是互联网集市为您收集整理的IBATIS2.0映射文件oracle/mysql版实现示例,功能全面且丰富全部内容,希望文章能够帮你解决IBATIS2.0映射文件oracle/mysql版实现示例,功能全面且丰富所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。