jdbc연결

jdbc 접속 driver 명이랑 url명 적는 규칙들은 매번 까먹게되서.. 책이나 예전에 썼던 소스나..아니면 인터넷 검색을 통해 찾아서 적게된다....
매번 검색하는것도 귀찮고.. 이참에 하나 적어놔야지.. 싶어서 종류별로 검색해서 올린다. 전부 퍼온것



☞ thin 방식

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

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

☞ oci 방식

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

Connection conn = DriverManager.getConnection ("jdbc:oracle:oci8:@ORA73", "scott", "tiger");

DB2 Jdbc 연결

☞ DB2 UDB APP Driver Test

Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();

Connection conn = DriverManager.getConnection("jdbc:db2:dbname", "user", "password");

☞ DB2 UDB Net Driver Test

Class.forName("COM.ibm.db2.jdbc.net.DB2Driver").newInstance();

Connection conn = DriverManager.getConnection("jdbc:db2://localhost:6789/dbname", "user", "password");

DATABASE
ORACLE DRIVER : oracle.jdbc.driver.OracleDriver
             URL : jdbc:oracle:thin:@hostname:port:SID

MSSQL DRIVER : com.microsoft.jdbc.sqlserver.SQLServerDriver
            URL : jdbc:Microsoft:sqlserver://localhost:1433;databasename=DB명

MYSQL DRIVER : org.gjt.mm.mysql.Driver
           URL :  jdbc:mysql://localhost:3306/DB명

//mysql 연결 테스트
  import java.sql.*;
public class DriverTest {
 public static void main(String[] args){
  String driver="com.mysql.jdbc.Driver";
  String user="root";
  String pass="pass";
  String dbURL="jdbc:mysql://localhost:3306/test";
  Connection connection;
  try{
   Class.forName(driver);
   System.out.println("driver");
   connection=DriverManager.getConnection(dbURL,user,pass);
   System.out.println("Driver found");
   }
   catch(ClassNotFoundException cne){
   System.out.println("JDBC driver not found");
   }
   catch(SQLException se){
   System.out.println("SQL error");
  }
 }
}