<!-- tomcat jdbc -->

<dependency>

　　<groupId>org.apache.tomcat</groupId>

　　<artifactId>tomcat-jdbc</artifactId>

　　<version>7.0.59</version>

</dependency>

<!-- oracle ojdbc -->

<dependency>

　　<groupId>oracle</groupId>

　　<artifactId>ojdbc6</artifactId>

　　<version>11.2.0.3</version>

</dependency>

#Oracle

oracle.driverClassName=oracle.jdbc.OracleDriver

oracle.url=jdbc:oracle:thin:@192.168.2.164:1521:xe

oracle.username=xxx

oracle.password=xxx

oracle.maxActive=50

oracle.initialSize=1

oracle.defaultAutoCommit=true

<!-- 加载配置文件 -->

<context:property-placeholder location="classpath:jdbc.properties" />

<bean id="oracleDataSource" class="org.apache.tomcat.jdbc.pool.DataSource" destroy-method="close">

　　<property name="driverClassName" value="${oracle.driverClassName}" />

　　<property name="url" value="${oracle.url}" />

　　<property name="username" value="${oracle.username}" />

　　<property name="password" value="${oracle.password}" />

　　<property name="maxActive" value="${oracle.maxActive}" />

　　<property name="initialSize" value="${oracle.initialSize}" />

　　<property name="defaultAutoCommit" value="${oracle.defaultAutoCommit}" />

</bean>