java结果集比较_java – 比较jdbc中的结果集

此代码检查两个结果集的所有列,并且行数必须相等.

int col = 1;

while (rs1.next() && rs2.next()) {

final Object res1 = rs1.getObject(col);

final Object res2 = rs2.getObject(col);

// Check values

if (!res1.equals(res2)) {

throw new RuntimeException(String.format("%s and %s aren't equal at common position %d",

res1, res2, col));

}

// rs1 and rs2 must reach last row in the same iteration

if ((rs1.isLast() != rs2.isLast())) {

throw new RuntimeException("The two ResultSets contains different number of columns!");

}

col++;

}