62,612
社区成员
发帖
与我相关
我的任务
分享
String sql = "select * from ttt order by a,b,c";
// String sql = "select * from weather";
ResultSet rs = BaseDao.execQuery(sql);
String a = null;
String b = null;
String c = null;
boolean isLoop = true;
do {
if(rs.next()){
a = rs.getString("a");
b = rs.getString("b");
c = rs.getString("c");
}else{
isLoop = false;
rs.close();
}
} while (isLoop);
}
String a,b,c;
String oldA, oldB, oldC;
if (rs.next()) {
if (flag) {
oldA = rs.getString("a");
oldB = rs.getString("b");
oldC = rs.getString("c");
flag = false;
} else {
a = rs.getString("a");
b = rs.getString("b");
c = rs.getString("c");
if (oldA.equals(a) && oldB.equals(b)) {
if ("@@".equals(c)) {
oldA = a;
oldB = b;
oldC = c;
}
} else {
System.out.println(oldA + "\t"+oldB+"\t"+oldC);
oldA = a;
oldB = b;
oldC = c;
}
}
}
System.out.println(a + "\t"+b+"\t"+c);