连接各种数据库的URL和DRIVER代码,Java代码库,德仔网

代码语言

代码分类

【Java】连接各种数据库的URL和DRIVER

作者:遥远的救世主 / 发布于2012/5/14/ 428

连接各种数据库的URL和DRIVER

<div><!-- Mysql -->
<entry key="jdbc.url">jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=UTF-8</entry>
<entry key="jdbc.driver">com.mysql.jdbc.Driver</entry></div>
<div><!-- Oraclejdbc:oracle:oci:@tnsname_devdb
<entry key="jdbc.url">jdbc:oracle:thin:@192.168.0.177:1521:[sid]</entry>
<entry key="jdbc.driver">oracle.jdbc.driver.OracleDriver</entry>
-->

<!-- SQLServer2000 
<entry key="jdbc.url">jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=[database]</entry>
<entry key="jdbc.driver">com.microsoft.jdbc.sqlserver.SQLServerDriver</entry>
-->

<!-- SQLServer2005 
<entry key="jdbc.url">jdbc:sqlserver://192.168.0.98:1433;DatabaseName=[database]</entry>
<entry key="jdbc.driver">com.microsoft.sqlserver.jdbc.SQLServerDriver</entry>
--></div>
<div><!-- JTDs for SQLServer 
<entry key="jdbc.url">jdbc:jtds:sqlserver://192.168.0.102:1433/[database];tds=8.0;lastupdatecount=true</entry>
<entry key="jdbc.driver">net.sourceforge.jtds.jdbc.Driver</entry>
--></div>
<div><!-- PostgreSql
<entry key="jdbc.url">jdbc:postgresql://localhost/[database]</entry>
<entry key="jdbc.driver">org.postgresql.Driver</entry>
 -->

<!-- Sybase
<entry key="jdbc.url">jdbc:sybase:Tds:localhost:5007/[database]</entry>
<entry key="jdbc.driver">com.sybase.jdbc.SybDriver</entry>
 -->

<!-- DB2 
<entry key="jdbc.url">jdbc:db2://localhost:5000/[database]</entry>
<entry key="jdbc.driver">com.ibm.db2.jdbc.app.DB2Driver</entry>
-->

<!-- HsqlDB 
<entry key="jdbc.url">jdbc:hsqldb:mem:generatorDB</entry>
<entry key="jdbc.driver">org.hsqldb.jdbcDriver</entry>
-->

<!-- Derby 
<entry key="jdbc.url">jdbc:derby://localhost/databaseName</entry>
<entry key="jdbc.driver">org.apache.derby.jdbc.ClientDriver</entry>
--></div>
<div><!-- H2 
<entry key="jdbc.url">jdbc:h2:tcp://localhost/~/test</entry>
<entry key="jdbc.driver">org.h2.Driver</entry>
-->
</div>

试试其它关键字

　连接各种数据库　

同语言下

可能有用的

遥远的救世主贡献的其它代码(1)

.连接各种数据库的URL和DRIVER