Advertisement
Guest User

Untitled

a guest
Feb 13th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. String dbURL = "jdbc:mysql://localhost:3306/Project1";
  2. String username = "root";
  3. String password = "";
  4. Connection dbCon = null;
  5. Statement stmt = null;
  6. ResultSet rs = null;
  7. try {
  8. Class.forName("com.mysql.jdbc.Driver");
  9. dbCon = DriverManager.getConnection(dbURL, username, password);
  10. stmt = dbCon.prepareStatement("SELECT itemname,priceperplate from rest WHERE ItemNo=4");
  11. rs = stmt.executeQuery("SELECT itemname,priceperplate from rest WHERE ItemNo=4");
  12. while (rs.next()) {
  13. String itemname = rs.getString("ItemName");
  14. String price = rs.getString("priceperplate");
  15. System.out.println(price);
  16. System.out.println(itemname);
  17. }
  18.  
  19. } catch (Exception e) {
  20. System.out.print("Exception");}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement