JDBC , DB , try-with-resources (Java 1.7이상) 자원해제

 

https://blog.naver.com/pgram16/221821654060

try-with-resource : 자원 해제하기

 

https://blog.naver.com/nature128/221430455866

try-with-resources (Java 1.7이상)

 

---

 

               try {

                      Class.forName(driver);

               } catch (ClassNotFoundException e2) {

                      e2.printStackTrace();

               }

               try(  

                      Connection con = DriverManager.getConnection(url, user, pw);

                      Statement stmt = con.createStatement();

                      ResultSet rs = stmt.executeQuery("SELECT * FROM board");

                      PreparedStatement pstmt = con.prepareStatement(preQuery);

                  ) //try() 안에 넣기

               {

                     

                      System.out.println("연결 성공");

                      while(rs.next()) {

                              String id = rs.getString("id");

                              String title = rs.getString("title");

                              String writer = rs.getString("writer");

                              String contents = rs.getString("contents");

                              LocalDateTime regdate = rs.getTimestamp("regdate").toLocalDateTime();

                             

                              System.out.printf("%s | %s | %s | %s | %s \n", id,title,writer,contents,regdate.toString());

                              System.out.println("-------------------------------------");

                      }

                      System.out.println("Insert using PreparedStatement");

                     

                      pstmt.setString(1, "have a nice day");

                      pstmt.setString(2, "yoon");

                      pstmt.setString(3, "Good luck");                                 

                      pstmt.setTimestamp(4, Timestamp.valueOf(LocalDateTime.now()));

                      pstmt.setString(5, "0");

                      pstmt.executeUpdate();

               } catch (SQLException e) {

                      System.out.println("[SQL Error : " + e.getMessage() + "]");

               }