Different database JDBC description

xiaoxiao2021-04-11  1.6K+

1. 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 (new addition)

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

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

9.Microsoft SQL Server Series (6.5, 7.x and 2000) And Sybase 10

JDBC Name: JTDS

URL: http://jtds.sourceforge.net/

Version: 0.5.1

Download URL: http://sourceforge.net/project/showfiles.php?group_id=33291

grammar:

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

Connection Con = DriverManager.getConnection ("JDBC: JTDS: SQLSERVER: // Host: Port / Database", "User", "Password");

oral

Connection Con = DriverManager.getConnection ("JDBC: JTDS: Sybase: // Host: Port / Database", "User", "Password");

10.PostgreSQL

JDBC Name: PostgreSQL JDBC

URL: http://jdbc.postgresql.org/

Version: 7.3.3 Build 110

Download URL: http://jdbc.postgreSQL.org/download.html

grammar:

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

Connection Con = DriverManager.getConnection ("JDBC: PostgreSQL: // Host: Port / Database", "User", "Password");

11. IBM AS400 host in JDBC syntax

Client Access Express with a V4R4 or above

Can be in C: / Program Files / IBM / Client Access / JT400 / LIB

Find the Driver file JT400.zip and change the extension to become JT400.jar

grammar:

Java.sql.driverManager.registerDriver (new com.ibm.as400.access.as400jdbcdriver ());

Class.Forname ("com.ibm.as400.access.as400jdbcconnection);

Con = DriverManager.getConnection ("JDBC: AS400: // IP", "User", "Password");

12.INFORMIX

Class.Forname ("com.informix.jdbc.ifxdriver). NewInstance ();

String URL =

"JDBC: Informix-SQLI: //123.45.67.89: 1533 / TESTDB: InformixServer = MyServer;

User = testuser; password = TestPassword ";

LIB: jdbcdrv.zip Class.Forname ("com.sybase.jdbc.sybdriver) URL =" JDBC: Sybase: TDS: 127.0.0.1: 2638 / asademo ";

SybConnection Connection = (SybConnection) DriverManager.getConnection (URL, "DBA", "SQL");

13.SAP DB

Class.Forname ("com.sap.dbtech.jdbc.driversapdb");

Java.sql.connection connection = java.sql.driverManager.getConnection ("JDBC: SAPDB: //" Host "/" Database_name, user_name, password)

14.interbase

String Url = "JDBC: Interbase: // localhost / e: /testbed/database/employee.gdb";

Class.Forname ("Interbase.IterClient.driver);

// driver d = new interbase.interclient.driver (); / * This will Want the line Above * /

Connection conn = drivermanager.getConnection (URL, "Sysdba", "MasterKey");

15. HSQLDB

URL: http://hsqldb.sourceforge.net/

Driver: org.hsqldb.jdbcdriver

There are 4 types of connection, respectively:

CON-STR: JDBC: HSQLDB.

Con-Str: JDBC: HSQLDB: / Path / TO / THE / DB / DIR

Con-str (http): jdbc: hsqldb: http: // dbsrv

Con-Str (HSQL): JDBC: HSQLDB: HSQL: // DBSRV

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

New Post(0)