java 关系型数据库常用链接

<!--oracle-->
<property name="driverClass" value="oracle.jdbc.driver.OracleDriver"/>
<property name="jdbcUrl" value="jdbc:oracle:thin:@171.100.96.xx:1521:ORCL"/>
<property name="user" value="jdptest"/>
<property name="password" value="jdptest"/>
注意写法有两种
//监听sid服务，表示sid为orcl
database.url=jdbc:oracle:thin:@171.100.96.xx:1521:orcl
//监听服务名，表示服务名为orcl
database.url=jdbc:oracle:thin:@171.100.96.xx:1521/orcl 

<!--sqlserver-->
<property name="driverClass" value="net.sourceforge.jtds.jdbc.Driver"/>
<property name="jdbcUrl" value="jdbc:jtds:sqlserver://192.168.0.25:1433/ths_meng_show3;instance=sql2008r2;tds=8.0;lastupdatecount=true"/>
<property name="user" value="user"/>
<property name="password" value="thssl"/>
 
<!--db2 -->
<property name="driverClass" value="com.ibm.db2.jcc.DB2Driver"/>
<property name="jdbcUrl" value="jdbc:db2://192.168.0.45:50003/JDP_OU"/>
<property name="user" value="douser"/>
<property name="password" value="password"/>

<!--mysql-->
<property name="driverClass" value="com.mysql.jdbc.Driver"/>
<property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:3306/xinzhou?useUnicode=true&amp;characterEncoding=utf8&amp;serverTimezone=GMT"/>
<property name="user" value="xinzhou"/>
<property name="password" value="1qaz@WSX"/>