Spring DataSource 数据源

来源：互联网发布：绿毒越狱软件编辑：程序博客网时间：2024/05/22 08:58

看如下的配置：

<bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">    <!-- results in a setDriverClassName(String) call -->  <property name="driverClassName">    <value>com.mysql.jdbc.Driver</value>  </property>  <property name="url">    <value>jdbc:mysql://localhost:3306/mydb</value>  </property>  <property name="username">    <value>root</value>  </property>  <property name="password">    <value>masterkaoli</value>  </property></bean>

或者：

<bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">    <!-- results in a setDriverClassName(String) call -->  <property name="driverClassName" value="com.mysql.jdbc.Driver"/>  <property name="url" value="jdbc:mysql://localhost:3306/mydb"/>  <property name="username" value="root"/>  <property name="password" value="masterkaoli"/></bean>

当然也可以通过占位符方式，如下所示：

<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">    <property name="locations">        <value>classpath:com/foo/jdbc.properties</value>    </property></bean><bean id="dataSource" destroy-method="close"      class="org.apache.commons.dbcp.BasicDataSource">    <property name="driverClassName" value="${jdbc.driverClassName}"/>    <property name="url" value="${jdbc.url}"/>    <property name="username" value="${jdbc.username}"/>    <property name="password" value="${jdbc.password}"/></bean>

jdbc.properties对应的内容如下：

jdbc.driverClassName=org.hsqldb.jdbcDriverjdbc.url=jdbc:hsqldb:hsql://production:9002jdbc.username=sajdbc.password=root

1 0