[JDBC] DBManager, DBProperties

DBManager

---

[DBManager.java]

  public class DBManager {
      /**
       * 로드
       **/
      static {
          try {
              Class.forName(DBProperties.DRIVER_NAME);
          } catch(ClassNotFoundException e) {
              e.printStackTrace();
          }
      }

       /**
       * 연결
       **/
      public static Connection getConnection() throws SQLException {
          return DriverManager.getConnection(DBProperties.URL, DBProperties.USER_ID, DBProperties.USER_PASS);
      }

      /**
       * 닫기(DML 전용)
       **/
      public static void releaseConnection(Connection con, Statement st) {
          try {
              if(st != null) st.close();
              if(con != null) con.close();
          } catch (SQLException e) {
              e.printStackTrace();
          }    
      }
    /**
       * 닫기(select 전용)
       **/
      public static void releaseConnection(Connection con, Statement st, ResultSet rs) {
          try {
              if(rs != null) rs.close();
          } catch (SQLException e) {
              e.printStackTrace();
          }
          releaseConnection(con, st);
      }
  }

DBProperties

---

[DBProperties.java]

  /**
   * DB의 설정정보들을 상수로 관리
   * */
  public interface DBProperties {
      public static final String DRIVER_NAME = "oracle.jdbc.driver.OracleDriver";
      String URL="jdbc:oracle:thin:@localhost:1521:XE";
      String USER_ID="c##scott";
      String USER_PASS="tiger";
  }