欢迎访问悦橙教程(wld5.com),关注java教程。悦橙教程  java问答|  每日更新
页面导航 : > > 文章正文

各种数据库的jdbc连接串写法,jdbc串写法,提供了比较全的数据库连接

来源: javaer 分享于  点击 32256 次 点评:80

各种数据库的jdbc连接串写法,jdbc串写法,提供了比较全的数据库连接


提供了比较全的数据库连接代码!!!!!!!!!

数据库连接

<!-- 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>    <!-- Oracle     jdbc: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>    -->    <!-- 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>    -->    <!-- 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>     -->    <!-- H2     <entry key="jdbc.url">jdbc:h2:tcp://localhost/~/test</entry>    <entry key="jdbc.driver">org.h2.Driver</entry>    -->

[Java]代码

<!-- 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>    <!-- Oracle     jdbc: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>    -->    <!-- 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>    -->    <!-- 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>     -->    <!-- H2     <entry key="jdbc.url">jdbc:h2:tcp://localhost/~/test</entry>    <entry key="jdbc.driver">org.h2.Driver</entry>    -->
相关栏目:

用户点评