JAVA JDBC DB연결 (중요도3)

* 필히 암기할 것

*일반 사용자 접속  관리자 접속은 다른 방법이 있음.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

package com.util;   import java.sql.Connection; import java.sql.DriverManager; // 암기해야함 // 일반접속   //singleton pattern public class DBConn {     private static Connection conn = null;       // 생성자가 private이므로 외부에서는 객체 생성 불가     private DBConn() {       }       // Connection 객체 리턴     public static Connection getConnection() {         // jdbc:oracle:thin:@오라클서버아이피:포트:SID         String url = "jdbc:oracle:thin:@127.0.0.1:1521:XE";         String user = "blue";         String pwd = "java$!";           try {             // OracleDriver 로딩             Class.forName("oracle.jdbc.driver.OracleDriver");             // 오라클 접속             conn = DriverManager.getConnection(url, user, pwd);         } catch (Exception e) {             System.out.println(e.toString());         }           return conn;     }       // 연결해제 close     public static void close() {         if (conn != null) {             try {                 if (conn.isClosed()) // Connection 객체가 열려있으면                     conn.close();             } catch (Exception e) {             }         }         conn = null;     } }