오라클 + 이클립스(java) 연동

- 환경: Eclipse

 

[ConnectionMain]

package org.joonzis.ex2;

import java.sql.Connection;
import java.sql.SQLException;

public class ConnectionMain {
	public static void main(String[] args) {
		
		Connection conn = null;
		
		try {
			conn = DBConnection.getConnection();
			System.out.println("DB 연결 성공");
			conn.close();
		} catch (ClassNotFoundException e) {
			System.out.println("jdbc 드라이버 오류");
		} catch (SQLException e) {
			System.out.println("DB 연결 오류");
		}
	}
}

 

[DBConnection]

package org.joonzis.ex2;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBConnection {
	public static Connection getConnection() throws ClassNotFoundException, SQLException {
		
		Class.forName("oracle.jdbc.driver.OracleDriver");		// 외우자
		
		String user = "scott";
		String password = "tiger";
		String url = "jdbc:oracle:thin:@localhost:1521:xe";		// 외우자
		
		Connection conn = DriverManager.getConnection(url, user, password);
		
		return conn;
	}
}