spring+ibatis 批处理

谁借莪１个温暖的怀抱￠ 2022-07-16 14:48 202阅读 0赞

引用：[http://ftmxqq-gmail-com.javaeye.com/category/105128?show\_full=true][http_ftmxqq-gmail-com.javaeye.com_category_105128_show_full_true]

public void batchInsert(final ConcurrentHashMap<String, SpiderUrl> urls) \{  
getSqlMapClientTemplate().execute(new SqlMapClientCallback() \{  
  
@Override  
public Object doInSqlMapClient(SqlMapExecutor sqlmapexecutor)  
throws SQLException \{  
// TODO Auto-generated method stub  
sqlmapexecutor.startBatch();  
int i = 0;  
Set<String> keys = urls.keySet();  
for (String url : keys) \{  
SpiderUrl spiderUrl = urls.get(url);  
// System.out.println("insert:" + spiderUrl);  
sqlmapexecutor.insert("url.insert", spiderUrl);  
i++;  
if (i == 2000) \{  
sqlmapexecutor.executeBatch();  
i = 0;  
  
\}  
\}  
sqlmapexecutor.executeBatch();  
return null;  
\}  
  
\});  
\}  
最重要一点：  
**datasource配置中增加一行：<property name="defaultAutoCommit" value="false"/>**  
但是这样处理，所有的其它非批处理操作均不能插入数据。所以改用下面的方式  
public void batchInsert(final ConcurrentHashMap<String, SpiderUrl> urls) \{  
SqlMapClient client = getSqlMapClient();  
Connection con=null;  
boolean autoCommit=false;  
try \{  
con = client.getDataSource().getConnection();  
autoCommit=con.getAutoCommit();  
con.setAutoCommit(false);  
client.setUserConnection(con);  
client.startBatch();  
int i = 0;  
Set<String> keys = urls.keySet();  
for (String url : keys) \{  
SpiderUrl spiderUrl = urls.get(url);  
// System.out.println("insert:" + spiderUrl);  
client.insert("url.insert", spiderUrl);  
i++;  
if (i == 2000) \{  
client.executeBatch();  
i = 0;  
  
\}  
\}  
client.executeBatch();  
\} catch (SQLException e) \{  
// TODO Auto-generated catch block  
e.printStackTrace();  
\} finally \{  
try \{  
con.setAutoCommit(autoCommit);  
\} catch (SQLException e) \{  
// TODO Auto-generated catch block  
e.printStackTrace();  
\}  
\}  
\}  
**datasource配置中增加一行：<property name="defaultAutoCommit" value="true"/>**

[http_ftmxqq-gmail-com.javaeye.com_category_105128_show_full_true]: http://ftmxqq-gmail-com.javaeye.com/category/105128?show_full=true