java访问oracle与mysql的url

oracle:

maven

 <dependency>
        <groupId>oracle</groupId>
        <artifactId>ojdbc6</artifactId>
        <version>12.1.0.1</version>
        </dependency>

url

driver=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@192.168.2.234:1521:ORA11G
username=
password=
#定义初始连接数
initialSize=0
#定义最大连接数
maxActive=20
#定义最大空闲
maxIdle=20
#定义最小空闲
minIdle=1
#定义最长等待时间
maxWait=60000

mysql:

maven

  <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.30</version>
        </dependency>

url

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://192.168.2.39:3306/demo
username=
password=
#定义初始连接数
initialSize=0
#定义最大连接数
maxActive=20
#定义最大空闲
maxIdle=20
#定义最小空闲
minIdle=1
#定义最长等待时间
maxWait=60000

 sqlserver

jdbc.driverClass = com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url = jdbc\:sqlserver\://127.0.0.1\:1433;DatabaseName=Bill
jdbc.user = sa
jdbc.password =

 各种数据库

<!-- H2
    <entry key="jdbc.url">jdbc:h2:tcp://localhost/test</entry>
    <entry key="jdbc.driver">org.h2.Driver</entry>
    -->
     <!--Mysql-->
    <entry key="jdbc_url">jdbc:mysql://192.168.2.39:3306/demo?useUnicode=true&amp;characterEncoding=UTF-8</entry>
    <entry key="jdbc_driver">com.mysql.jdbc.Driver</entry>


    <!-- Oracle
    <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://192.168.1.161:5432/logistics?characterEncoding=UTF-8</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>    
    -->

 oracle集群访问方式

url=jdbc:oracle:thin:@192.168.2.234:1521/ORA11G

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL =TCP)(HOST=ipadd)(PORT=port))(ADDRESS=(PROTOCOL=TCP)(HOST=ipadd)(PORT=port))(FAILOVER=on)(LOAD_BALANCE=on)(CONNECT_DATA=(SERVICE_NAME=ORADB)))