# mybatis-batch

**Repository Path**: xiwa/mybatis-batch

## Basic Information

- **Project Name**: mybatis-batch
- **Description**: mybatis batch operate extension for spring
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 3
- **Forks**: 0
- **Created**: 2017-07-11
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# mybatis-batch
mybatis batch operate extension for spring

github:[https://github.com/xiwasong/mybatis-batch](https://github.com/xiwasong/mybatis-batch)  
oschina:[http://git.oschina.net/xiwa/mybatis-batch](http://git.oschina.net/xiwa/mybatis-batch)  

# use guide
##### 1.set BatchSessionFactoryBuilder
```
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setSqlSessionFactoryBuilder(new BatchSessionFactoryBuilder());
```
##### 2.add mapping statement
```
<insert id="insertCountries" parameterType="java.util.List">
        insert into country (countryname, countrycode)
        values
        <foreach collection="list" item="item" index="index" separator=",">
            (#{item.name,jdbcType=VARCHAR},#{item.code,jdbcType=VARCHAR} )
        </foreach>
</insert>
```
##### 3.use SqlSessionTemplate 
```
@Autowired
private SqlSessionTemplate template;  

List<Country> countries=new ArrayList<Country>();
for(int i=0;i<count;i++){
  countries.add(new Country("name"+i,"code"+i));
}
BatchParameterInfo batchParameterInfo=new BatchParameterInfo(countries);
template.insert("batch.insertCountries",batchParameterInfo) ;
```