Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package joinexam.db;
- import java.sql.Connection;
- import java.sql.DriverManager;
- public class DBManager {
- private DBManager() { // 외부에서는 생성자를 호출할 수 없다.
- }
- private static DBManager instance = new DBManager(); // 자기 자신을 객체로 생성한다 (싱글톤)
- public static DBManager getInstance() {
- return instance;
- }
- public Connection getConnection() throws Exception {
- Connection myConn = null;
- String myDriver = "oracle.jdbc.driver.OracleDriver";
- String myURL = "jdbc:oracle:thin:@localhost:1521:orcl";
- String myID = "HR"; // 정확한 ID를 입력
- String myPass = "1234"; // 정확한 비번을 입력
- try {
- Class.forName(myDriver);
- // System.out.println("오라클 드라이버 로딩 완료");
- } catch (Exception e) {
- e.printStackTrace();
- // System.out.println("오라클 드라이버 로딩 실패");
- }
- try {
- myConn = DriverManager.getConnection(myURL, myID, myPass);
- // System.out.println("커넥션 연결 완료");
- } catch (Exception e) {
- e.printStackTrace();
- // System.out.println("커넥션 연결 실패");
- }
- return myConn;
- }
- }
Add Comment
Please, Sign In to add comment