Database connection driver class and JDBC URL Daquan

1. MySQL:

DriverClass:com.mysql.jdbc.Driver
Org.gjt.mm.mysql.Driver

Jdbcurl:jdbc:mysql://192.168.0.1:3306/yourdbname

2. Oracle:

(Thin mode)

DriverClass:oracle.jdbc.driver.OracleDriver

Jdbcurl:jdbc:oracle:thin:@192.168.0.1:1521:yourdbname

3. SQL Server:

DriverClass:com.microsoft.sqlserver.jdbc.SQLServerDriver (version 2005 and later)

Com.microsoft.jdbc.sqlserver.SQLServerDriver (version 2000)

Jdbcurl:jdbc:sqlserver://192.168.0.1:1433;databasename=yourdbname

4. Sybase:

DriverClass:com.sybase.jdbc3.jdbc.SybDriver
Com.sysbase.jdbc.SybDriver

Jdbcurl:jdbc:sybase:tds:127.0.0.1:5007/mydb

5, DB2:

1) Db2java.zip

DriverClass:COM.ibm.db2.jdbc.net.DB2Driver

jdbcurl:jdbc:db2://127.0.0.1:5000/dbname

2) Db2jcc.jar

DriverClass:com.ibm.db2.jcc.DB2Driver

jdbcurl:jdbc:db2://127.0.0.1:5000/dbname
3) driverClass:com.ibm.db2.jdbc.app.DB2Driverjdbcurl:jdbc:db2://127.0.0.1:5000/yourdbname

6. Informix:

DriverClass:com.informix.jdbc.IfxDriver

Jdbcurl:jdbc:informix-sqli://127.0.0.1:1533/yourdbname:informixserver=myserver;user=test;password=test123

7. PostgreSQL:

DriverClass:org.postgresql.Driver

Jdbcurl:jdbc:postgresql://127.0.0.1:5432/yourdbname

8. Access:

DriverClass:sun.jdbc.odbc.JdbcOdbcDriver

JdbcUrl:jdbc:odbc:dataSourceName

9, Memcached:

Driverclass:

Jdbcurl:

10. MongoDB:

Driverclass:

Jdbcurl:

11. Redis:

Driverclass:

Jdbcurl:

12, SQLite:

Driverclass:

Jdbcurl:

Driverclass:

Jdbcurl:

Database connection driver class and JDBC URL Daquan