从ResultSet获取结果Map

public static void setDataSourceFromDB(HashMap<String,String> dataSource,ResultSet rst) throws Exception {
  ResultSetMetaData rsmd = rst.getMetaData();
  int numberOfColumns = rsmd.getColumnCount();
  String sKey = "";
  String sValue = "";
  if (dataSource != null) {
   for (int i = 1;i <= numberOfColumns ; i++) {
    sKey = (rsmd.getColumnName(i)).trim();
    String tString = rst.getString(i);
    if (tString == null) sValue = "";
    else {
     sValue = tString.trim();
     if (sValue == null) sValue = "";
    }
    dataSource.put(sKey,sValue);
   }
  }
  else {
   throw new Exception("dataSource object is null.");
  }
 }

 

 

欢迎关注公众号：“架构一线”，定期分享一些实战心得，互联网前沿技术等.