馬達拉

http://www.aiuxian.com/article/p-1217429.html

  /**
   * 查询数据 返回的是一个ArrayList对象，对象中的每一个元素是一个HashMap对象
   * @param sql String 查询语句
   * @return ArrayList 结果集
   * @throws Exception
   */
  public ArrayList queryListAsHashMap(String sql) throws Exception {
    java.sql.ResultSet rs = this.executeSql(sql);
    ArrayList list = new ArrayList(20);
    ResultSetMetaData rsm = rs.getMetaData();
    int count = rsm.getColumnCount();
    while (rs.next()) {
      HashMap map = new HashMap();
      for (int i = 0; i < count; i++) {
        String columnName = rsm.getColumnName( (i + 1));
        int sqlType = rsm.getColumnType(i+1);
        Object sqlView = rs.getString(columnName);
        if (Types.CHAR == sqlType && null != sqlView) {
            map.put(columnName, sqlView.toString().trim());
        } else {
            map.put(columnName, sqlView);
        } 
      }
      list.add(map);
    }
    rs.close();
    return list;
  }