Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DefaultTableMode1 mode1=(DefaultTableMode1)
- jTable1.getModel();
- try
- {
- Class.forName("java.sql.DriverManager");
- Connection con=(Connection)
- DriverManager.getConnection
- ("jdbc:mysql://localhost:3306/euphoria","root","Maryann_2000");
- Statement stmt=(Statement) con.createStatement();
- String query="select * from items";
- ResultSet rs=stmt.executeQuery(query);
- while(rs.next())
- {
- String item_name=rs.getString("item_name");
- String category=rs.getString("category");
- String price=rs.getString("price");
- String quantity=rs.getString("quantity");
- String size=rs.getString("size");
- String payment_type=rs.getString("payment_type");
- mode1.addRow (new Object[]
- {item_name,category,price,quantity,size,payment_type});
- }
- }
- catch(Exception e)
- {
- JOptionPane.showMessageDialog(this , e.getMessage());
- }
Add Comment
Please, Sign In to add comment