| |
import java.sql.*;
public class DbConnectionTest
{
public static void main(String [] args){
String db_driver="oracle.jdbc.driver.OracleDriver";
String db_url="jdbc:oracle:thin:@127.0.0.1:1521:ioio";
String db_user="username";
String db_password="1111";
Connection dbcon = null;
try{
Class.forName(db_driver);
}catch(ClassNotFoundException e){
System.out.println("JDBC 드라이버를 찾을 수 없습니다." + e);
}
try{
dbcon = DriverManager.getConnection(db_url,db_user,db_password);
System.out.println("연결성공");
}catch(Exception e){
System.out.println("DB에 연결할 수 없습니다.");
}finally{
try{
if(dbcon != null) dbcon.close();
}catch(Exception e){}
}
}
}
|