Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Connection conn = null;
- Statement stmt = null;
- ResultSet rs = null;
- try {
- DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
- conn = DriverManager.getConnection("jdbc:mysql://localhost/studydb?useSSL=false&serverTimezone=UTC", "study", "study");
- stmt = conn.createStatement();
- rs = stmt.executeQuery("select BookID, Title, Author, Publisher, ISBN from books order by BookID asc;");
- while (rs.next())
- {
- System.out.println(
- rs.getInt("BookID")+","+
- rs.getString("Title")+","+
- rs.getString("Author")+","+
- rs.getString("Publisher")+","+
- rs.getString("ISBN")
- );
- }
- }
- catch (Exception e) {
- e.printStackTrace();
- }
- finally {
- try { if (null!=conn) conn.close(); } catch (Exception e) {};
- try { if (null!=stmt) stmt.close(); } catch (Exception e) {};
- try { if (null!=rs) rs.close(); } catch (Exception e) {};
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement