ibatis批量处理 存储过程.docxVIP

/*?*在项目中，遇到这样的一个问题，当某一模块需要插入，更新一批大的数据量时，?*此处大的含义是：更新到的数据记录比较多?*用ibatis实现一条一条的插入，更新，如此循环下去。速度很慢?*分析：?*?这些操作有个共同点：?*?PreparedStatement对象和已映射的语句完全一致（简单点说：就是操作不断重复）?*?由于事物是交给spring管理了，所以每做一次操作都会起一个事物，久而久之导致?*?性能问题。?*??*?batch批处理就适合那些查询，插入，更新，删除等大量重复的操作?*?*?存储过程也比较适合这样的场合，但要求很多??*?批处理?是把?所有sql语句??放入一块内存中，然后一次性全部写到服务器，这个节省了客*?服端到服务器的访问时间?*/??--?Create?table??create?or?replace?table?DEMO??(????UUID??????NUMBER,????UUSER?????VARCHAR2(50),????UPASSWORD?VARCHAR2(50)??)????--Insert?a?million?records?with?the?DEMO?procedure??create?or?replace?procedure?demo_p(total?in?integer)?AS??uuid?number?:=1;??uuser?varchar2(50)?:=?user;??upassword?varchar2(50)?:=password;??begin??loop??????insert?into?demo(uuid,uuser,upassword)?values(uuid,uuser||uuid,upassword||uuid);????uuid?:=?uuid?+?1;????exit?when?uuid?=?total;??end?loop;??end;????---Clear?table?then?call?procedure?to?insert?a?million?records???truncate?table?demo;??call?demo_p(1000);??select?*?from?demo;????--Java实现??--1--ibatis普通实现插入一百条条数据--????--2--ibatis批量插入一百万条数据--????--3--ibatis调用存储过程插入一百万条数据--??1--构建环境 添加 classes12.jar ibatis-26.jar 2--写好ibatis基本配置文件,公共资源文件 SqlMapCperties Java代码 ?#?DB?Config???driver=oracle.jdbc.driver.OracleDriver??url=jdbc:oracle:thin:@localhost:1521:orcl??username=scott??password=tiger??SqlMapConfig.xml Java代码 ??xml?version=1.0?encoding=UTF-8???!DOCTYPE?sqlMapConfig??PUBLIC?-//iBATIS.com//DTD?SQL?Map?Config?2.0//EN??/dtd/sql-map-config-2.dtd??!--?Always?ensure?to?use?the?correct?XML?header?as?above!?--??sqlMapConfig??????properties??resource?=?com/oyp/sqlmap/SqlMapCperties?/????????????settings??cacheModelsEnabled=true?enhancementEnabled=true??????????lazyLoadingEnabled=true?maxRequests=32?maxSessions=10??????????maxTransactions=5?useStatementNamespaces=false?/????????????transactionManager?type?=?JDBC??????????dataSource?type??=?SIMPLE??????????????property?name=JDBC.Driver?value=${driver}?/??????????????property?name=JDBC.ConnectionURL?value=${url}?/??????????????property?name=JDBC.Username?value=${userna