Advertisement
Guest User

Untitled

a guest
Oct 11th, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. Connection conn = null;
  2. Statement stmt = null;
  3. ResultSet rs = null;
  4. try {
  5. DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
  6. conn = DriverManager.getConnection("jdbc:mysql://localhost/studydb?useSSL=false&serverTimezone=UTC", "study", "study");
  7. stmt = conn.createStatement();
  8. rs = stmt.executeQuery("select BookID, Title, Author, Publisher, ISBN from books order by BookID asc;");
  9. while (rs.next())
  10. {
  11. System.out.println(
  12. rs.getInt("BookID")+","+
  13. rs.getString("Title")+","+
  14. rs.getString("Author")+","+
  15. rs.getString("Publisher")+","+
  16. rs.getString("ISBN")
  17. );
  18. }
  19. }
  20. catch (Exception e) {
  21. e.printStackTrace();
  22. }
  23. finally {
  24. try { if (null!=conn) conn.close(); } catch (Exception e) {};
  25. try { if (null!=stmt) stmt.close(); } catch (Exception e) {};
  26. try { if (null!=rs) rs.close(); } catch (Exception e) {};
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement