Advertisement
Guest User

Untitled

a guest
Apr 21st, 2014
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.79 KB | None | 0 0
  1. public List resultSetToArrayList(ResultSet rs) throws SQLException{
  2. ResultSetMetaData md = rs.getMetaData();
  3. int columns = md.getColumnCount();
  4. ArrayList list = new ArrayList(50);
  5. while (rs.next()){
  6. HashMap row = new HashMap(columns);
  7. for(int i=1; i<=columns; ++i){
  8. row.put(md.getColumnName(i),rs.getObject(i));
  9. }
  10. list.add(row);
  11. }
  12.  
  13. return list;
  14. }
  15.  
  16. public List<Map<String, Object>> resultSetToArrayList(ResultSet rs) throws SQLException {
  17. final ResultSetMetaData md = rs.getMetaData();
  18. int columns = md.getColumnCount();
  19. final List<Map<String, Object>> list = new ArrayList<Map<String, Object>>(50);
  20. while (rs.next()) {
  21. final HashMap<String, Object> row = new HashMap<String, Object>(columns);
  22. for (int i = 1; i <= columns; ++i) {
  23. row.put(md.getColumnName(i), rs.getObject(i));
  24. }
  25. list.add(row);
  26. }
  27. return list;
  28. }
  29.  
  30. List<Map<String, Object>> list = yourObject.resultSetToArrayList(rs);
  31. for (Map<String, Object> map : list) {
  32. //you can call map.get("yourkey") here
  33. }
  34.  
  35. HashMap<String,Object> row = (HashMap<String,Object>) list.get(rowNum);
  36.  
  37. Set<String> columns = row.keySet();
  38.  
  39. Object value = row.get(columnName);
  40.  
  41. ArrayList list = new ArrayList(50);
  42. while (rs.next()){
  43. HashMap row = new HashMap(columns);
  44. row.put(rs.getObject(0),rs.getObject(1));
  45. list.add(row);
  46. }
  47.  
  48. HashMap<String,String> table = new HashMap<String,String>();
  49. while (rs.next()){
  50. table.put(rs.getString(0),rs.getString(1));
  51. }
  52.  
  53. String keyColumnName = "FROM";
  54. int keyColumnNum = -1; // to be found
  55. for (int i = 0; i < md.getColumnCount(); i++) {
  56. if (keyColumnName.equals.getColumnName(i)) {
  57. keyColumnNum = i;
  58. break;
  59. }
  60. }
  61. // if the column exists, keyColumnNum has the right value here
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement