Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void init_table(JTable X)
- {
- try
- {
- Class.forName(JDBC_DRIVER);
- con= DriverManager.getConnection("jdbc:mysql://localhost:3306/store",DB_USER, DB_PASS);
- query="SELECT * from Stalk";
- stmt = con.createStatement();
- rs = stmt.executeQuery(query);
- DefaultTableModel model= new DefaultTableModel();
- ResultSetMetaData meta = rs.getMetaData();
- int Columncount = meta.getColumnCount();
- for(int columnindex=1; columnindex<=Columncount; columnindex++)
- {
- model.addColumn(meta.getColumnLabel(columnindex));
- }
- Object[] row= new Object[Columncount];
- while(rs.next())
- {
- int i=0;
- for(i=0;i<Columncount;i++)
- {
- row[i]=rs.getObject(i+1);
- }
- model.addRow(row);
- }
- X.setModel(model);
- }
- catch(Exception e)
- {
- e.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement