Database ----- Common Database Connection Methods, ----- database connection

Database ----- Common Database Connection Methods, ----- database connection

Oracle

Driver oracle. jdbc. driver. OracleDriver

URL jdbc: oracle: thin: @ loaclhost: 1521: orcl // orcl indicates the database SID.

MySQL

Driver com. mysql. jdbc. Driver

URL jdbc: mysql: // localhost: 3306/db_name // db_name indicates the database name.

Microsoft SQL Server 2.0 Driver (the one with Three jar files); you can also use jTDS to connect to the SQLServer database.

Driver com. microsoft. jdbc. sqlserver. SQLServerDriver

URL jdbc: microsoft: sqlserver: // localhost: 1433; DatabaseName = db_name // db_name indicates the Database Name

Microsoft SQL Server 3.0 Driver (one jar)

Driver com. microsoft. sqlserver. jdbc. SQLServerDriver ";

URL jdbc: microsoft: sqlserver: // localhost: 1433; DatabaseName = db_name // db_name indicates the Database Name

Sysbase

Driver com. sybase. jdbc. SybDriver

URL jdbc: Sysbase: // localhost: 5007/db_name // db_name indicates the data name.

PostgreSQL

Driver org. postgresql. Driver ";

URL jdbc: postgresql: // localhost/db_name // db_name indicates the data name

DB2

Driver com. ibm. db2.jdbc. app. DB2.Driver // connect to a Provider instance with a DB2 Client

// Driver com.ibm.db2.jdbc.net. DB2.Driver // connect a Provider instance that does not have a DB2 Client

URL jdbc: db2: // localhost: 5000/db_name // db_name indicates the database name.

Informix

Driver com. informix. jdbc. IfxDriver

URL jdbc: Informix-sqli: // localhost: 1533/db_name: INFORMIXSER = myserver // db_name indicates the data name

JDBC-ODBC

Driver sun. jdbc. odbc. JdbcOdbcDriver