jdbc를 이용한 db별 접속방법

1. Oracle
 
Class.forName ("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:DBNAME", "user", "password");
 
 

2. Sybase

Class.forName ("com.sybase.jdbc2.jdbc.SybDriver"); 
Connection con = DriverManager.getConnection ("jdbc:sybase:Tds:localhost:5001/DBNAME", "user", "password");
 
* JDBC드라이버 : jTDS2.jar
  
 

3. MS-SQL
 
Class.forName ("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=DBNAME", "user", "password");
 
* JDBC드라이버 : msbase.jar, mssqlserver.jar, msutil.jar
 

 
4. DB2
 
Class.forName("COM.ibm.db2.jdbc.net.DB2Driver"); // Type 3 (v9.x 이상부터 지원안함)
Class.forName("com.ibm.db2.jcc.DB2Driver"); // Type 4
 Connection conn = DriverManager.getConnection("jdbc:db2://localhost:50000/DBNAME", "user", "password");
 
* JDBC드라이버 : db2jcc.jar, db2jcc_javax.jar, db2jcc_license_cu.jar
 
 
 
5. UniSQL
 
Class.forName("unisql.jdbc.driver.UniSQLDriver");
Connection conn = DriverManager.getConnection("jdbc:unisql:localhost:43300:DBNAME:::", "user", "password");

6. MySQL
 
Class.forName("com.mysql.jdbc.Driver"); 
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/DBNAME", "user", "password");

* JDBC드라이버 : mysql-connector-java-5.1.6-bin.jar

 
출처 : http://blog.naver.com/blubeard/80059531151