Advertisement
Guest User

Untitled

a guest
Mar 30th, 2016
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.00 KB | None | 0 0
  1. public void showData(JTable table, DefaultTableModel model, String qry) throws SQLException{
  2. Connection c = null;
  3. Statement stmt = null;
  4.  
  5. c = DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgres","postgres","199591");
  6. stmt = c.createStatement();
  7.  
  8.  
  9. ResultSet rs = stmt.executeQuery(qry);
  10. print(table, rs);
  11.  
  12. rs.close();
  13. stmt.close();
  14. c.close();
  15. }
  16.  
  17.  
  18.  
  19.  
  20.  
  21. public void print(JTable table, ResultSet rs) throws SQLException{
  22.  
  23. Vector<Object> columnNames = new Vector<Object>();
  24. Vector<Object> data = new Vector<Object>();
  25. ResultSetMetaData md = rs.getMetaData();
  26. int columns = md.getColumnCount();
  27.  
  28.  
  29. for (int i = 1; i <= columns; i++) {
  30. columnNames.addElement( md.getColumnName(i) );
  31. }
  32.  
  33. // Get row data
  34.  
  35. while (rs.next())
  36. {
  37. Vector<Object> row = new Vector<Object>(columns);
  38.  
  39. for (int i = 1; i <= columns; i++){
  40. row.addElement( rs.getObject(i) );
  41. }
  42.  
  43. data.addElement( row );
  44. }
  45.  
  46. DefaultTableModel model = new DefaultTableModel(data, columnNames)
  47. {
  48. @Override
  49. public Class getColumnClass(int column)
  50. {
  51. for (int row = 0; row < getRowCount(); row++)
  52. {
  53. Object o = getValueAt(row, column);
  54.  
  55. if (o != null)
  56. {
  57. return o.getClass();
  58. }
  59. }
  60.  
  61. return Object.class;
  62. }
  63. };
  64.  
  65. table.setModel(model);
  66.  
  67. DefaultTableCellRenderer centerRenderer = new DefaultTableCellRenderer();
  68. centerRenderer.setHorizontalAlignment( JLabel.CENTER );
  69. table.setDefaultRenderer(String.class, centerRenderer);
  70.  
  71.  
  72. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement