Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void FillTable(JTable table, String Query)
- {
- try
- {
- DoConnect();
- stmt = con.createStatement();
- rs = stmt.executeQuery(Query);
- String host = "jdbc:derby://localhost:1527/Moviedata";
- String uName = "user1";
- String uPass= "1234";
- con = DriverManager.getConnection( host, uName, uPass );
- //To remove previously added rows
- while(Taulukko.getRowCount() > 0)
- {
- ((DefaultTableModel) Taulukko.getModel()).removeRow(0);
- }
- int columns = rs.getMetaData().getColumnCount();
- while(rs.next())
- {
- Object[] row = new Object[columns];
- for (int i = 1; i <= columns; i++)
- {
- row[i - 1] = rs.getObject(i);
- }
- ((DefaultTableModel) Taulukko.getModel()).insertRow(rs.getRow()-1,row);
- }
- rs.close();
- stmt.close();
- con.close();
- }
- catch(SQLException err) {
- JOptionPane.showMessageDialog(this, err.getMessage());
- {
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement