67,516
社区成员
发帖
与我相关
我的任务
分享
String sql = "select * from tablename";
rs = stmt.executeQuery(sql);
ArrayList list = new ArrayList();
while(rs.next) {
list.add(rs.getXXX());
}
int count = list.size();
return list;
String sql = "select * from tablename";
rs = stmt.executeQuery(sql);
ArrayList list = new ArrayList();
while(rs.next) {
list.add(rs.getXXX());
}
int count = list.size();
return list;
String sql = "select count(id) from tablename";
rs = stmt.executeQuery(sql);
int count = rs.getInt(1);
//分页,每页20条,第5页
sql = "select top 20 * from tablename where id in (select top 100 id from tablename)";
rs = stmt.executeQuery(sql);
while(rs.next) {
//执行后续操作
}