主要是org.apache.ibatis.executor.BatchExecutor这个类,此类继承BaseExecutor(基本增删改查,缓存,懒加载处理)
BatchExecutor这个类有四个属性
//批处理更新最大返回结果
public static final int BATCH_UPDATE_RETURN_VALUE = Integer.MIN_VALUE + 1002;
//存放声明(命令)对象集合
private final List<Statement> statementList = new ArrayList<Statement>();
// 批处理结果集合
private final List<BatchResult> batchResultList = new ArrayList<BatchResult>();
//当前sql语句
private String currentSql;
一个带参数构造函数,传入配置信息和事务对象
public BatchExecutor(Configuration configuration, Transaction transaction) {
super(configuration, transaction);
}
重写了三个方法, 1.更新方法 2.查询方法 3.刷新方法
我们来看批量更新doUpdate
public int doUpdate(MappedStatement ms, Object parameterObject)
throws SQLException {
Configuration configuration = ms.getConfiguration();
StatementHandler handler = configuration.newStatementHandler(this, ms, parameterObject, RowBounds.DEFAULT, null);
BoundSql boundSql = handler.getBoundSql();
String sql = boundSql.getSql();
Statement stmt;
if (currentSql != null && sql.hashCode() == currentSql.hashCode() && sql.length() == currentSql.length()) {
int last = statementList.size() - 1;
stmt = statementList.get(last);
} else {
Connection connection = transaction.getConnection();
stmt = handler.prepare(connection);
currentSql = sql;
statementList.add(stmt);
batchResultList.add(new BatchResult(ms, sql, parameterObject));
}
handler.parameterize(stmt);
handler.batch(stmt);
return BATCH_UPDATE_RETURN_VALUE;
}
最重要一句话就是handler.batch(stmt),实际上就是stmt.addBatch();
举个小例子来说明:
//记录1
stmt.setInt(1, 1);
stmt.setString(2, "Cujo");
stmt.addBatch();
//记录2
stmt.setInt(1, 2);
stmt.setString(2, "Fred");
stmt.addBatch();
//记录3
stmt.setInt(1, 3);
stmt.setString(2, "Mark");
stmt.addBatch();
//批量执行上面3条语句
int [] counts = statement.executeBatch();
//Commit it
connection.commit();
如果项目中要用到批量更新如何使用?
下面的映射文件,假设namespace="com.dao.Stuent"
<insert id="insertbatch" parameterType="java.util.List">
<selectKey keyProperty="fetchTime" order="BEFORE"
resultType="java.lang.String">
SELECT CURRENT_TIMESTAMP()
</selectKey>
insert into kangaiduoyaodian ( depart1, depart2, product_name,
generic_name, img, product_specification, unit,
approval_certificate, manufacturer, marketPrice, vipPrice,
website, fetch_time, productdesc ) values
<foreach collection="list" item="item" index="index"
separator=",">
( #{item.depart1}, #{item.depart2}, #{item.productName},
#{item.genericName}, #{item.img},
#{item.productSpecification}, #{item.unit},
#{item.approvalCertificate}, #{item.manufacturer},
#{item.marketprice}, #{item.vipprice}, #{item.website},
#{fetchTime}, #{item.productdesc} )
</foreach>
</insert>
调用: SqlSession session = factory.openSession(ExecutorType.BATCH); //关键是这句