1.使用技术
实际上就相当于jdbc的批量插入,就是编译一次sql,然后每次传递参数即可。实际上还是使用插入单条的sql
2.实例
ibatis实现
public void insertBatch(final List<Person> list)
{
getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
executor.startBatch();
for (Person p:list)
{
executor.insert("person.insertPerson", p);
}
return executor.executeBatch();
}
});
}
sql:
<insert id="insertPerson" parameterClass="Person">
insert into person(name,age)
values(#name#,#age#)
</insert>