CellTemplateConfigDao.java 1.48 KB
Newer Older
1
package pwc.taxtech.atms.dao;
eddie.woo's avatar
eddie.woo committed
2

eddie.woo's avatar
eddie.woo committed
3 4 5
import org.apache.ibatis.session.ExecutorType;
import org.apache.ibatis.session.SqlSession;
import org.mybatis.spring.SqlSessionTemplate;
eddie.woo's avatar
eddie.woo committed
6 7
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
8 9
import pwc.taxtech.atms.entity.CellTemplateConfig;
import pwc.taxtech.atms.entity.CellTemplateConfigExample;
eddie.woo's avatar
eddie.woo committed
10

eddie.woo's avatar
eddie.woo committed
11
import javax.annotation.Resource;
eddie.woo's avatar
eddie.woo committed
12 13 14 15 16 17
import java.util.List;

@Service
public class CellTemplateConfigDao {
    @Autowired
    private CellTemplateConfigMapper mapper;
eddie.woo's avatar
eddie.woo committed
18 19
    @Resource(name = "sqlSessionTemplate")
    private SqlSessionTemplate sqlSessionTemplate;
eddie.woo's avatar
eddie.woo committed
20

21
    public List<CellTemplateConfig> getByTemplateId(Long id) {
eddie.woo's avatar
eddie.woo committed
22 23
        CellTemplateConfigExample example = new CellTemplateConfigExample();
        CellTemplateConfigExample.Criteria criteria = example.createCriteria();
24
        criteria.andReportTemplateIdEqualTo(id);
eddie.woo's avatar
eddie.woo committed
25 26 27
        return mapper.selectByExample(example);
    }

eddie.woo's avatar
eddie.woo committed
28 29 30 31 32 33 34 35 36 37
    public void batchInsert(List<CellTemplateConfig> list) {
        long start = System.currentTimeMillis();
        SqlSession sqlSession = sqlSessionTemplate.getSqlSessionFactory().openSession(ExecutorType.BATCH);
        for (CellTemplateConfig cellTemplate : list) {
            mapper.insertSelective(cellTemplate);
        }
        sqlSession.commit();
        long end = System.currentTimeMillis();
        System.out.println("---------------batch insert: count:" + list.size() + "  time: " + (start - end) + "---------------");
    }
eddie.woo's avatar
eddie.woo committed
38 39

}