jdbc

[subutuo]

package org.zerock.web;

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

import org.junit.Test;

public class OracleConnectionTest { private static final String DRIVER = "oracle.jdbc.driver.OracleDriver"; private static final String URL="jdbc:oracle:thin:@localhost:1522:orcl"; private static final String USER = "scott"; private static final String PW = "tiger";

@Test
public void testConnection() throws Exception{
    Class.forName(DRIVER);
    try(Connection conn = DriverManager.getConnection(URL, USER, PW)){
        System.out.println(conn);
    }catch(Exception e){
        e.printStackTrace();
    }       
}

}

[subutuo]

ojdbc는 maven에서 받는거보다 Java Build Path에서 외부 jar파일을 불러오는 식으로 사용하는게 더 쉬움