更多内容请浏览本人博客
平常使用mybatis时并没有考虑内存问题,但今天遇到一件事情是一次需要查询的数据量很大,直接导致系统oom,所以对需要大量查询的sql做了如下修改...
直接上代码
@Autowired
private SqlSessionTemplate sqlSessionTemplate;
@Test
public void test() {
MerchantOrderPushExample merchantOrderPushExample = new MerchantOrderPushExample();
MerchantOrderPushExample.Criteria criteria = merchantOrderPushExample.createCriteria();
criteria.andIdIsNotNull();
merchantOrderPushExample.setOrderByClause(" id desc");
HashMap param = new HashMap<>();
param.put("oredCriteria", merchantOrderPushExample.getOredCriteria());
param.put("orderByClause", merchantOrderPushExample.getOrderByClause());
// param.put("limit",20); 测试分页的使用
sqlSessionTemplate.select("com.xws.business.mapper.MerchantOrderPushMapper.selectByExample", param, resultCont