JDBC : 오라클 접속 실습

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

//jdbc : 기본 접속 실습

 

public class jdbcEx01 {

        public static void main(String[] args) {

              

               Connection conn = null;

               try {

                       //대소문자 구별 주의!!

                       Class.forName("oracle.jdbc.driver.OracleDriver");

                       conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");

                      

                       if(conn != null){

                              System.out.println("데이터베이스 접속성공");

                       } else{

                              System.out.println("데이터베이스 접속 실패");

                       }

                      

               } catch (ClassNotFoundException e) {

                       // TODO Auto-generated catch block

                       e.printStackTrace();

               } catch (SQLException e) {

                       // TODO Auto-generated catch block

                       e.printStackTrace();

               } finally{

                       if(conn != null) try{ conn.close();} catch(SQLException e){};

               }

 

        }

}