今天想把ResultSet 转换成 List 这样用起来会比较方便,决定写过公共的方法来调用一下:
public static List resultSetToList(ResultSet rs) throws java.sql.SQLException {
if (rs == null)
return Collections.EMPTY_LIST;
ResultSetMetaData md = rs.getMetaData(); //得到结果集(rs)的结构信息,比如字段数、字段名等
int columnCount = md.getColumnCount(); //返回此 ResultSet 对象中的列数
List list = new ArrayList();
Map rowData = new HashMap();
while (rs.next()) {
rowData = new HashMap(columnCount);
for (int i = 1; i <= columnCount; i++) {
rowData.put(md.getColumnName(i), rs.getObject(i));
}
list.add(rowData);
// System.out.println("list : " + list.toString());
}
return list;
}
使用的时候就会很方便了,呵呵!
public List ShowCount(int page01,int pageamount){
String sql = "select * from t_user limit "+page01+","+pageamount;
Map paramMap = new HashMap();
try{
ResultSet rs = DBConnection.getConnection().createStatement().executeQuery(sql);
return resultSetToList(rs);
}catch(Exception e){
e.printStackTrace();
return null;
}
}