sringMVC链接oracle和mysql的字符串

1、链接mysql

pos.driverClassName=com.mysql.jdbc.Driver
pos.url=jdbc:mysql://192.168.40.136:3306/envirmonitor?useUnicode\=true&characterEncoding\=utf-8
pos.username=root
pos.password=password
pos.validationQuery=select 1
pos.testOnBorrow=true
pos.timeBetweenEvictionRunsMillis=7200000
pos.numTestsPerEvictionRun=20

2、链接oracle

pos.driverClassName=oracle.jdbc.driver.OracleDriver
pos.url=jdbc:oracle:thin:@192.168.40.131:1521:orcl
pos.username=taihu
pos.password=password

3、修改相应的application.xml

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${pos.driverClassName}" />
<property name="url" value="${pos.url}" />
<property name="username" value="${pos.username}" />
<property name="password" value="${pos.password}" />
<!-- <property name="validationQuery" value="${pos.validationQuery}" /> -->
<!-- <property name="testOnBorrow" value="${pos.testOnBorrow}" /> -->
<!-- <property name="timeBetweenEvictionRunsMillis" value="${pos.timeBetweenEvictionRunsMillis}" /> -->
<!-- <property name="numTestsPerEvictionRun" value="${pos.numTestsPerEvictionRun}" /> -->
</bean>

如果是链接mysql，取消注释