JDBC 접속시 파라미터 값 설정

jdbc.driverClassName.oracle=oracle.jdbc.OracleDriver

jdbc.url.oracle=jdbc:oracle:thin:@IP:PORT(1521):SID명

jdbc.username.oracle=userid

jdbc.password.oracle=userps

jdbc.driverClassName.hsqldb=org.hsqldb.jdbcDriver

jdbc.url.hsqldb=jdbc:hsqldb:C:/dev/tools/db(생성시 위치)

jdbc.username.hsqldb=userid

jdbc.password.hsqldb=userps

jdbc.driverClassName.mssql=com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc.url.mssql=jdbc:sqlserver://IP:PORT(1433);databaseName=DB명;

jdbc.username.mssql=userid

jdbc.password.mssql=userps

 Connection conn = null; //Connection 변수 생성
PreparedStatement psmt = null; //PreparedStatement 변수 생성

//1. DB접속 드라이브 설정
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException cnf){
System.out.println("DB접속 드라이버가없습니다. : "+cnf);
}

//2. DB연결 - Connection(IP, PORT, SID, ID, PWD)
try{
conn = DriverManager.getConnection("dbc:oracle:thin:@192.168.100.123:1123:IPIdfV","ipdfev","pwd");
}catch(Exception e){
System.out.println("DB접속이 안됩니다."+e);
}