java驱动

最新推荐文章于 2023-11-21 08:58:57 发布

原创最新推荐文章于 2023-11-21 08:58:57 发布 · 553 阅读

0 ·

CC 4.0 BY-SA版权

本文汇总了多种数据库的JDBC连接字符串及对应的驱动程序名称，包括IBM DB2、Oracle、MySQL等，为开发者提供了一个全面的参考指南。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

IBM DB2
jdbc:db2: //<HOST>:<PORT>/<DB>
COM.ibm.db2.jdbc.app.DB2Driver

JDBC-ODBC Bridge
jdbc:odbc:<DB>
sun.jdbc.odbc.JdbcOdbcDriver

Microsoft SQL Server
jdbc:weblogic:mssqlserver4:<DB>@<HOST>:<PORT>
weblogic.jdbc.mssqlserver4.Driver

Oracle Thin
jdbc:oracle:thin:@<HOST>:<PORT>:<SID>
oracle.jdbc.driver.OracleDriver

PointBase Embedded Server
jdbc:pointbase: //embedded[:<PORT>]/<DB>
com.pointbase.jdbc.jdbcUniversalDriver

Cloudscape
jdbc:cloudscape:<DB>
COM.cloudscape.core.JDBCDriver

Cloudscape RMI
jdbc:rmi: //<HOST>:<PORT>/jdbc:cloudscape:<DB>
RmiJdbc.RJDriver

Firebird ( JCA/JDBC Driver )
jdbc:firebirdsql: [ //<HOST>[:<PORT>]/]<DB>
org.firebirdsql.jdbc.FBDriver

IDS Server
jdbc:ids: //<HOST>:<PORT>/conn?dsn='<ODBC_DSN_NAME>'
ids.sql.IDSDriver

Informix Dynamic Server
jdbc:informix-sqli: //<HOST>:<PORT>/<DB>:INFORMIXSERVER=<SERVER_NAME>
com.informix.jdbc.IfxDriver

InstantDB ( v3.13 and earlier )
jdbc:idb:<DB>
jdbc.idbDriver

InstantDB ( v3.14 and later )
jdbc:idb:<DB>
org.enhydra.instantdb.jdbc.idbDriver

Interbase ( InterClient Driver )
jdbc:interbase: //<HOST>/<DB>
interbase.interclient.Driver

Hypersonic SQL ( v1.2 and earlier )
jdbc:HypersonicSQL:<DB>
hSql.hDriver

Hypersonic SQL ( v1.3 and later )
jdbc:HypersonicSQL:<DB>
org.hsql.jdbcDriver

Microsoft SQL Server ( JTurbo Driver )
jdbc:JTurbo: //<HOST>:<PORT>/<DB>
com.ashna.jturbo.driver.Driver

Microsoft SQL Server ( Sprinta Driver )
jdbc:inetdae:<HOST>:<PORT>?database=<DB>
com.inet.tds.TdsDriver

Microsoft SQL Server 2000 ( Microsoft Driver )
jdbc:microsoft:sqlserver: //<HOST>:<PORT>[;DatabaseName=<DB>]
com.microsoft.jdbc.sqlserver.SQLServerDriver

MySQL ( MM.MySQL Driver )
jdbc:mysql: //<HOST>:<PORT>/<DB>
org.gjt.mm.mysql.Driver

Oracle OCI 8 i
jdbc:oracle:oci8:@<SID>
oracle.jdbc.driver.OracleDriver

Oracle OCI 9 i
jdbc:oracle:oci:@<SID>
oracle.jdbc.driver.OracleDriver

PostgreSQL ( v6.5 and earlier )
jdbc:postgresql: //<HOST>:<PORT>/<DB>
postgresql.Driver

PostgreSQL ( v7.0 and later )
jdbc:postgresql: //<HOST>:<PORT>/<DB>
org.postgresql.Driver

Sybase ( jConnect 4.2 and earlier )
jdbc:sybase:Tds:<HOST>:<PORT>
com.sybase.jdbc.SybDriver

Sybase ( jConnect 5.2 )
jdbc:sybase:Tds:<HOST>:<PORT>
com.sybase.jdbc2.jdbc.SybDriver

   //To test your driver once it's installed, try the following code:

   Class .forName ( "Driver name" ) ;
   Connection con = DriverManager.getConnenction ( "jdbcurl" , "username" , "password" )