Guest User

Untitled

a guest
Nov 27th, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. DefaultTableMode1 mode1=(DefaultTableMode1)
  2. jTable1.getModel();
  3.  
  4. try
  5. {
  6. Class.forName("java.sql.DriverManager");
  7.  
  8. Connection con=(Connection)
  9.  
  10. DriverManager.getConnection
  11.  
  12. ("jdbc:mysql://localhost:3306/euphoria","root","Maryann_2000");
  13.  
  14. Statement stmt=(Statement) con.createStatement();
  15.  
  16. String query="select * from items";
  17.  
  18. ResultSet rs=stmt.executeQuery(query);
  19.  
  20. while(rs.next())
  21. {
  22. String item_name=rs.getString("item_name");
  23.  
  24. String category=rs.getString("category");
  25.  
  26. String price=rs.getString("price");
  27.  
  28. String quantity=rs.getString("quantity");
  29.  
  30. String size=rs.getString("size");
  31.  
  32. String payment_type=rs.getString("payment_type");
  33.  
  34. mode1.addRow (new Object[]
  35. {item_name,category,price,quantity,size,payment_type});
  36.  
  37. }
  38.  
  39. }
  40. catch(Exception e)
  41.  
  42. {
  43.  
  44. JOptionPane.showMessageDialog(this , e.getMessage());
  45.  
  46. }
Add Comment
Please, Sign In to add comment