Advertisement
Guest User

Untitled

a guest
May 4th, 2016
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1.  
  2. public void FillTable(JTable table, String Query)
  3.  
  4. {
  5. try
  6. {
  7. DoConnect();
  8. stmt = con.createStatement();
  9. rs = stmt.executeQuery(Query);
  10.  
  11. String host = "jdbc:derby://localhost:1527/Moviedata";
  12. String uName = "user1";
  13. String uPass= "1234";
  14. con = DriverManager.getConnection( host, uName, uPass );
  15.  
  16. //To remove previously added rows
  17. while(Taulukko.getRowCount() > 0)
  18. {
  19. ((DefaultTableModel) Taulukko.getModel()).removeRow(0);
  20. }
  21. int columns = rs.getMetaData().getColumnCount();
  22. while(rs.next())
  23. {
  24. Object[] row = new Object[columns];
  25. for (int i = 1; i <= columns; i++)
  26. {
  27. row[i - 1] = rs.getObject(i);
  28. }
  29. ((DefaultTableModel) Taulukko.getModel()).insertRow(rs.getRow()-1,row);
  30. }
  31.  
  32. rs.close();
  33. stmt.close();
  34. con.close();
  35. }
  36. catch(SQLException err) {
  37. JOptionPane.showMessageDialog(this, err.getMessage());
  38. {
  39. }
  40. }
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement