下列语句从数据库中得到结果集rs,其中有IP和磁盘大小两个信息。现在要对“磁盘大小”进行排序,并根据磁盘大小(从大到小)获得相应IP地址,请问如何实现 :
DBManager dbop = new DBManager();
String mySQL = "select * from Storage_Node_Info;";
ResultSet rs = dbop.myquery(mySQL);
//int max_desk_size = rs.getInt("Disk_Available_MB");
//String IP = rs.getString("IP");
DBManager dbop = new DBManager();
String mySQL = "select * from Storage_Node_Info;";
ResultSet rs = dbop.myquery(mySQL);
//int max_desk_size = rs.getInt("Disk_Available_MB");
//String IP = rs.getString("IP");
String mySQL = "select * from Storage_Node_Info order by Disk_Available_MB";
ResultSet rs = dbop.myquery(mySQL);ArrayList list = new ArrayList();
while(rs.next()){
list.add(rs.getString("IP"));
}