Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void showData(JTable table, DefaultTableModel model, String qry) throws SQLException{
- Connection c = null;
- Statement stmt = null;
- c = DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgres","postgres","199591");
- stmt = c.createStatement();
- ResultSet rs = stmt.executeQuery(qry);
- print(table, rs);
- rs.close();
- stmt.close();
- c.close();
- }
- public void print(JTable table, ResultSet rs) throws SQLException{
- Vector<Object> columnNames = new Vector<Object>();
- Vector<Object> data = new Vector<Object>();
- ResultSetMetaData md = rs.getMetaData();
- int columns = md.getColumnCount();
- for (int i = 1; i <= columns; i++) {
- columnNames.addElement( md.getColumnName(i) );
- }
- // Get row data
- while (rs.next())
- {
- Vector<Object> row = new Vector<Object>(columns);
- for (int i = 1; i <= columns; i++){
- row.addElement( rs.getObject(i) );
- }
- data.addElement( row );
- }
- DefaultTableModel model = new DefaultTableModel(data, columnNames)
- {
- @Override
- public Class getColumnClass(int column)
- {
- for (int row = 0; row < getRowCount(); row++)
- {
- Object o = getValueAt(row, column);
- if (o != null)
- {
- return o.getClass();
- }
- }
- return Object.class;
- }
- };
- table.setModel(model);
- DefaultTableCellRenderer centerRenderer = new DefaultTableCellRenderer();
- centerRenderer.setHorizontalAlignment( JLabel.CENTER );
- table.setDefaultRenderer(String.class, centerRenderer);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement