raq 发表于 2013-1-13 18:50:15

各种数据库的JDBC链接

转自商智世界 
<div class="post-content"><div class="cnt">Microsoft SQL Server JDBC connection URL

<div class="entry">jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=northwindcom.microsoft.jdbc.sqlserver.SQLServerDrivermsbase.jar;mssqlserver.jar;msutil.jardownloadlMicrosoft SQL Server 2005 JDBC connection URL

jdbc:sqlserver://serverNameinstance:port[;user=value][;password=value][;property=value]com.microsoft.sqlserver.jdbc.SQLServerDriversqljdbc.jardownload SQL Server 2005 driverMicrosoft SQL Server (JTurbo) JDBC connection URL

jdbc:JTurbo://<HOST>:<PORT>/<DB>com.ashna.jturbo.driver.DriverMicrosoft SQL Server (Sprinta) JDBC connection URL

jdbc:inetdae7:<HOST>:<PORT>?database=<DB>com.inet.tds.TdsDrivedownload
Cloudscape JDBC connection URL

jdbc:cloudscape:MyDataBaseCOM.cloudscape.core.JDBCDriverCloudscape RMI JDBC connection URL

jdbc:rmi://hostname:portnumber/jdbc:cloudscape:MyDatabaseRmiJdbc.RJDriverHypersonic SQL (server) JDBC connection URL

jdbc:hsqldb:hsql://localhostorg.hsqldb.jdbcDriverhsqldb.jardownload (SourceForge)Hypersonic SQL (in-process) JDBC connection URL

jdbc:hsqldb:file:/opt/db/testdborg.hsqldb.jdbcDriverhsqldb.jarHypersonic SQL (in-memory) JDBC connection URL

jdbc:hsqldb:mem:anameorg.hsqldb.jdbcDriverhsqldb.jarH2 Database (embedded)

jdbc:h2:testH2 Database (Client Server)

jdbc:h2:tcp://localhost:9092/testH2 Database (Client Server, Clustered)

jdbc:h2:tcp://localhost:9092,backuphost.com:9092/testH2 Database (In Memory)

jdbc:h2:{ {.|mem:} | fileName | {tcp|ssl}:[//]server[:port][,server2[:port]]/name }[;key=value...]Informix JDBC connection URL

jdbc:informix-sqli://hostname:portnumber/MyDatabase:INFORMIXSERVER=MyServerNamecom.informix.jdbc.IfxDriverMySQL JDBC connection URL

jdbc:mysql:///testjdbc:mysql://[,failoverhost...][:port]/[?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]...com.mysql.jdbc.DriverOracle JDBC connection URL

jdbc:oracle:thin:@localhost:1521:MyDatabaseoracle.jdbc.driver.OracleDriverclasses12.zipPostgresSQL JDBC connection URL

jdbc:postgresql:template1org.postgresql.DriverDB2 JDBC connection URL

jdbc:db2:testcom.ibm.db2.jdbc.app.DB2DriverTimesTen in-memory database JDBC connection URL

jdbc:timesten:direct:testcom.timesten.jdbc.TimesTenDriverDB2/400 (native) JDBC connection URL

jdbc:db2://systemnamecom.ibm.db2.jdbc.app.DB2DriverDB2/400 (toolbox) JDBC connection URL

jdbc:as400://systemnamecom.ibm.as400.access.AS400JDBCDriverDerby JDBC connection URL

jdbc:derby:/test;create=trueorg.apache.derby.jdbc.EmbeddedDriverSybase JDBC connection URL

jdbc:sybase:Tds:localhost:2048/MyDatabasecom.sybase.jdbc2.jdbc.SybDriverjconn2.jardownloadMckoi SQL JDBC connection URL

jdbc:mckoi:local://C:/mckoi1.0.3/db.confcom.mckoi.JDBCDriverSAP DB JDBC connection URL

jdbc:sapdb://localhost/TSTcom.sap.dbtech.jdbc.DriverSapDBJSQL JDBC connection URL

jdbc:JSQLConnect://localhost/testcom.jnetdirect.jsql.JSQLDriverJTurbo JDBC connection URL

jdbc:JTurbo://localhost:1433/testcom.newatlanta.jturbo.driver.DriverjTDS JDBC connection URL

jdbc:jtds:sqlserver://localhost/testnet.sourceforge.jtds.jdbc.DriverInterbase (Java driver) JDBC connection URL

jdbc:firebirdsql:localhost/3050:/firebird/test.gdborg.firebirdsql.jdbc.FBDriverInterbase (Interclient driver) JDBC connection URL

jdbc:interbase://localhost:3060/C:/firebird/test.gdbinterbase.interclient.DriverPointBase JDBC connection URL

jdbc:pointbase:embedded:samplecom.pointbase.jdbc.jdbcUniversalDriverIngres JDBC connection URL

ca.edbc.jdbc.EdbcDriver
jdbc:edbc://localhost:II7/database
Mimer SQL JDBC connection URL

jdbc:mimer:multi1com.mimer.jdbc.Driver
页: [1]
查看完整版本: 各种数据库的JDBC链接