Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public List resultSetToArrayList(ResultSet rs) throws SQLException{
- ResultSetMetaData md = rs.getMetaData();
- int columns = md.getColumnCount();
- ArrayList list = new ArrayList(50);
- while (rs.next()){
- HashMap row = new HashMap(columns);
- for(int i=1; i<=columns; ++i){
- row.put(md.getColumnName(i),rs.getObject(i));
- }
- list.add(row);
- }
- return list;
- }
- public List<Map<String, Object>> resultSetToArrayList(ResultSet rs) throws SQLException {
- final ResultSetMetaData md = rs.getMetaData();
- int columns = md.getColumnCount();
- final List<Map<String, Object>> list = new ArrayList<Map<String, Object>>(50);
- while (rs.next()) {
- final HashMap<String, Object> row = new HashMap<String, Object>(columns);
- for (int i = 1; i <= columns; ++i) {
- row.put(md.getColumnName(i), rs.getObject(i));
- }
- list.add(row);
- }
- return list;
- }
- List<Map<String, Object>> list = yourObject.resultSetToArrayList(rs);
- for (Map<String, Object> map : list) {
- //you can call map.get("yourkey") here
- }
- HashMap<String,Object> row = (HashMap<String,Object>) list.get(rowNum);
- Set<String> columns = row.keySet();
- Object value = row.get(columnName);
- ArrayList list = new ArrayList(50);
- while (rs.next()){
- HashMap row = new HashMap(columns);
- row.put(rs.getObject(0),rs.getObject(1));
- list.add(row);
- }
- HashMap<String,String> table = new HashMap<String,String>();
- while (rs.next()){
- table.put(rs.getString(0),rs.getString(1));
- }
- String keyColumnName = "FROM";
- int keyColumnNum = -1; // to be found
- for (int i = 0; i < md.getColumnCount(); i++) {
- if (keyColumnName.equals.getColumnName(i)) {
- keyColumnNum = i;
- break;
- }
- }
- // if the column exists, keyColumnNum has the right value here
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement