使用多线程同时查询案例

该项目使用多线程实现分页查询，分为两步，第一步查询list，第二步查询数量进行分页计算。

• 条数返回值类

@Data
public class ThreadCountPage {

    private Integer sumCount;
}

 

多线程实现Callable接口工具类

public class ThreadQuery<T> implements Callable<List> {


    private List list;//查出来的数据
    private String sql;//执行的sql
    private  Map<String,Object> args;//查询条件
    private String dataSource;//指定的数据源
    private CommonDao commonDao;//查询工具类
    private Class<T> clazz;//返回的范型Class

    public ThreadQuery(String sql, Map<String, Object> args, String dataSource, CommonDao commonDao, Class<T> clazz) {
        this.sql = sql;
        this.args = args;
        this.dataSource = dataSource;
        this.commonDao = commonDao;
        this.clazz = clazz;
    }


    @Override
    public List call() throws Exception {
            System.err.println(dataSource+" start "+System.currentTimeMillis() );
            list= commonDao.query(sql,args,clazz,dataSource);
            System.err.println(dataSource+" end "+System.currentTimeMillis() );
            return list;
    }
}

• 使用工具类查询

  public <T> PageModel<T> queryPage(String sql, Map<String, Object> queryMap, BasePageModel pageModel, Class<T> clazz, String dataSourceType) {
  
      PageModel<T> tPageModel = new PageModel<>();
      //封装查询条件
      tPageModel.setCurrentPage(pageModel.getCurrentPage());
      tPageModel.setSize(pageModel.getSize());
      //将sql格式化 可省略
      String upperSql = sql.toUpperCase();
      Map<String, Object> tempMap = new HashMap<String, Object>();
      for (Map.Entry<String, Object> entry : queryMap.entrySet()) {
  	    String key = entry.getKey().toUpperCase();
  		tempMap.put(key, entry.getValue());
  	}
      if (null != pageModel) {
          //1.分页查询数据
  	//因为有group by子句时会造成结果不准确 所以改用下面的外层分页方式
  	String pageSql = "SELECT *   FROM ( SELECT PAGE_TABLE.*, ROWNUM RN FROM (" + upperSql + ") PAGE_TABLE ) WHERE RN BETWEEN 'START_NUM' AND 'END_NUM'";
  	String startNum = String.valueOf(((pageModel.getCurrentPage() - 1) * pageModel.getSize()) + 1);
  	String endNum = String.valueOf(pageModel.getCurrentPage() * pageModel.getSize());
  	tempMap.put("START_NUM", startNum);
  	tempMap.put("END_NUM", endNum);
  
  
          //2. 总条数
  	String countSql = "SELECT COUNT(0) as sumCount FROM (" + upperSql + ")";
  
  //重点部分 使用线程池查询
      ExecutorService executor = Executors.newFixedThreadPool(2);
  	ThreadQuery threadQuery1 = new ThreadQuery(pageSql, tempMap, dataSourceType, this,clazz);
  	ThreadQuery threadQuery2 = new ThreadQuery(countSql, tempMap, dataSourceType, this, ThreadCountPage.class);
  
  	FutureTask<List> task1 = new FutureTask<List>(threadQuery1);
  	FutureTask<List> task2 = new FutureTask<List>(threadQuery2);
  	List<FutureTask<List>> tasks = new ArrayList<>();
  	tasks.add(task1);
  	tasks.add(task2);
  
  	for (FutureTask<List> task : tasks) {
  		new Thread(task).start();
  	}
  
  	try {
  		List<T> list = new ArrayList<>();
  		list.addAll(task1.get());
  		tPageModel.setList(list);
  		ThreadCountPage cPage = (ThreadCountPage)task2.get().get(0);
  		int count = cPage.getSumCount();
  
  		int pages = 1;//总页数
  		if (count % pageModel.getSize() == 0) { // 计算总页数,总记录数和每页显示的数
  			pages = count / pageModel.getSize(); // 对总页数赋值
  		} else {
  			pages = count / pageModel.getSize() + 1; // 对总页数赋值
  		}
  		//对总条数数赋值  总页数自动计算 不需要赋值
  		tPageModel.setSumCount(count);
  
  	} catch (Exception e) {
  		e.printStackTrace();
  		tPageModel.setList(null);
  		tPageModel.setSumCount(0);
  	}
  	executor.shutdown();//关闭线程池
  
  
      }
  
  return tPageModel;
  }