mysql drivercs_Driver集合

Mysql(driverdownload: http://mysql.cs.pu.edu.tw/Downloads/Connector-J/mysql-connector-java-5.1.6.zip):

Class.forName("com.mysql.jdbc.Driver");

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/cmsjsp?user=root&password=");

Oracle(driverdownload: ):

Method1: JDBC Driver

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

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

Method2: JDBC-ODBC

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection conn = DriverManager.getConnection("jdbc:odbc:localhost", "scott", "tiger");

SQLServer:

Method1: JDBC Driver

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dbname", "scott", "tiger");

Method2: JDBC-ODBC

Class.forName("net.sourceforge.jtds.jdbc.Driver");

Connection conn = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/dbname", "scott", "tiger");