![\"Java\"](\"http:\/\/oprsteny.cz\/wp-content\/uploads\/eclipse.png\")
If you want to display a JTable that displays data from a DataBase ResultSet you can do it manually using JTable that displays data converted from database table ResultSet into Object [ ][ ].
\nAnother approach is to build the JTable model dynamically using the ResultSet meta data. In this article you can see an example of how this can be achieved.
\nThe main idea is hidden in this method which dynamically generates a model from given ResultSet<\/p>\n
private DefaultTableModel buildTableModel(ResultSet rs)\r\n throws SQLException {\r\n\r\n ResultSetMetaData metaData = rs.getMetaData();\r\n\r\n \/\/ names of columns\r\n Vector<String> columnNames = new Vector<String>();\r\n int columnCount = metaData.getColumnCount();\r\n for (int column = 1; column <= columnCount; column++) {\r\n columnNames.add(metaData.getColumnName(column));\r\n }\r\n\r\n \/\/ data of the table\r\n Vector<Vector<Object>> data = new Vector<Vector<Object>>();\r\n while (rs.next()) {\r\n Vector<Object> vector = new Vector<Object>();\r\n for (int columnIndex = 1; columnIndex <= columnCount; columnIndex++) {\r\n vector.add(rs.getObject(columnIndex));\r\n }\r\n data.add(vector);\r\n }\r\n\r\n return new DefaultTableModel(data, columnNames);\r\n}<\/pre>\nThe usage in the application might then be like in the following code<\/p>\n
public class Main extends JFrame {\r\n\r\n private static final long serialVersionUID = 1L;\r\n\r\n public static void main(String[] args) {\r\n Connection con = null;\r\n Statement st = null;\r\n ResultSet rs = null;\r\n\r\n String url = \"jdbc:mysql:\/\/example.com:3306\/eshop\";\r\n String user = \"john_doe\";\r\n String password = \"P@ssw0rd\";\r\n\r\n try {\r\n con = DriverManager.getConnection(url, user, password);\r\n st = con.createStatement();\r\n rs = st.executeQuery(\"select * from product_info\");\r\n\r\n Main window = new Main();\r\n window.setPreferredSize(new Dimension(800, 600));\r\n window.setMinimumSize(new Dimension(400, 230));\r\n window.setTitle(\"Database binding demo\");\r\n window.setBounds(100, 100, 697, 524);\r\n window.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);\r\n\r\n \/\/ It creates and displays the table\r\n JTable table = new JTable(window.buildTableModel(rs));\r\n window.getContentPane().add(new JScrollPane(table));\r\n\r\n window.setVisible(true);\r\n\r\n } catch (SQLException ex) {\r\n Logger lgr = Logger.getLogger(Version.class.getName());\r\n lgr.log(Level.SEVERE, ex.getMessage(), ex);\r\n } finally {\r\n try {\r\n if (rs != null) {\r\n rs.close();\r\n }\r\n\r\n if (st != null) {\r\n st.close();\r\n }\r\n\r\n if (con != null) {\r\n con.close();\r\n }\r\n } catch (SQLException ex) {\r\n Logger lgr = Logger.getLogger(Version.class.getName());\r\n lgr.log(Level.WARNING, ex.getMessage(), ex);\r\n }\r\n }\r\n }\r\n}<\/pre>\n","protected":false},"excerpt":{"rendered":"If you want to display a JTable that displays data from a DataBase ResultSet you can do it manually using JTable that displays data converted from database table ResultSet into Object [ ][ ]. Another approach is to build the … Continue reading