spring获取数据源

最新推荐文章于 2024-07-08 16:53:33 发布

不放的小二郎

最新推荐文章于 2024-07-08 16:53:33 发布

阅读量3.6k

点赞数

分类专栏： java 文章标签： spring

本文链接：https://blog.csdn.net/baidu_28283893/article/details/55101490

版权

java 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

spring.xml

<bean id="dataSourcetelcrm" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://10.10.10.77/telcrm" />
        <property name="username" value="root" />
        <property name="password" value="pass123" />
        <property name="testWhileIdle"><value>true</value></property>
        <property name="testOnBorrow"><value>false</value></property>
        <property name="testOnReturn"><value>false</value></property>
        <property name="validationQuery"><value>select 1</value>  </property>
        <property name="timeBetweenEvictionRunsMillis"><value>28800000</value></property>
        <property name="numTestsPerEvictionRun"><value>10</value></property>
        <property name="maxActive"><value>10</value></property>
    </bean>

java code

ApplicationContext applicationContext = new ClassPathXmlApplicationContext("applicationContext.xml");
DataSource dataSource=applicationContext.getBean("dataSourcetelcrm",DataSource.class);        
Connection connection=dataSource.getConnection();