阿飞Javaer,转载请注明原创出处,谢谢!
单表查询之结果合并
接下来以执行SELECT o.* FROM t_order o where o.user_id=10 order by o.order_id desc limit 2,3
分析下面这段Java代码是如何对结果进行合并的:
result = new ShardingResultSet(resultSets, new MergeEngine(resultSets, (SelectStatement) routeResult.getSqlStatement()).merge());
MergeEngine.merge()方法的源码如下:
public ResultSetMerger merge() throws SQLException {
selectStatement.setIndexForItems(columnLabelIndexMap);
return decorate(build());
}
build()方法源码如下:
private ResultSetMerger build() throws SQLException {
// 说明:GroupBy***ResultSetMerger在第六篇文章单独讲解,所以此次分析的SQL条件中没有group by
if (!selectStatement.getGroupByItems().isEmpty() || !selectStatement.getAggregationSelectItems().isEmpty()) {
if (selectStatement.isSameGroupByAndOrderByItems()) {
return new GroupByStreamResultSetMerger(columnLabelIndexMap, resultSets, selectStatement);
} else {
return new GroupByMemoryResultSetMerger(columnLabelIndexMap, resultSets, selectStatement);
}
}
// 如果select语句中有order by字段,那么需要OrderByStreamResultSetMerger对结果处理
if (!selectStatement.getOrderByItems().isEmpty()) {
return new OrderByStreamResultSetMerger(resultSets, selectStatement.getOrderByItems());
}
return new IteratorStreamResultSetMerger(resultSets);
}
根据这段代码可知,其作用是根据sql语句选择多个不同的ResultSetMerger对结果进行合并处理,ResultSetMerger实现有这几种:GroupByStreamResultSetMerger,GroupByMemoryResultSetMerger,OrderByStreamResultSetMerger,IteratorStreamResultSetMerger