Database JDBC connection writing method

xiaoxiao2021-03-06  19

Mysql (http://www.mysql.com) mm.mysql-2.0.2-bin.jar

Class.Forname ("org.gjt.mm.mysql.driver");

CN = DriverManager.getConnection ("JDBC: MySQL: // MyDbComputernameorip: 3306 / MyDatabaseName", SUSR, SPWD);

2. PostgreSQL (http://www.de.postgreSql.org) pgjdbc2.jar

Class.Forname ("Org.PostgreSql.driver);

CN = DriverManager.getConnection ("JDBC: PostgreSQL: // MyDbComputernameorip / MyDatabaseName", SUSR, SPWD);

3. Oracle (http://www.racle.com/ip/deploy/database/oracle9i/) CLASSES12.ZIP

Class.Forname ("Oracle.jdbc.driver.OracleDriver");

CN = DriverManager.getConnection ("JDBC: Oracle: Thin: @MydbComputernameorip: 1521: Orcl", SUSR, SPWD);

4. Sybase (http://jtds.sourceforge.net) jconn2.jar

Class.Forname ("com.sybase.jdbc2.jdbc.sybdriver);

CN = DriverManager.getConnection ("JDBC: Sybase: TDS: MYDBComputernameorip: 2638", SUSR, SPWD);

// (Default-username / password: "dba" / "sql")

5. Microsoft SQLServer (http://jtds.sourceforge.net)

Class.Forname ("Net.SourceForge.jtds.jdbc.driver");

CN = DriverManager.getConnection ("JDBC: JTDS: SQLServer: // MYDBComputernameorip: 1433 / Master", SUSR, SPWD);

6. Microsoft SQLServer (http://www.microsoft.com)

Class.Forname ("com.microsoft.jdbc.sqlser.sqlserverdriver);

CN = DriverManager.getConnection ("JDBC: Microsoft: SQL Server: // mydbComputernameorip: 1433; DatabaseName = Master", SUSR, SPWD);

7. ODBC

Class.Forname ("Sun.jdbc.odbc.jdbcodbcdriver");

Connection CN = DriverManager.getConnection ("JDBC: ODBC:" SDSN, SUSR, SPWD;

8.db2

Class.Forname ("com.ibm.db2.jdbc.net.db2driver");

String URL = "JDBC: DB2: //192.9.200.108: 6789 / Sample" CN = DriverManager.getConnection (URL, SUSR, SPWD);

转载请注明原文地址:https://www.9cbs.com/read-39926.html

New Post(0)