Spring学习小记5—SSM—数据库连接池

数据库连接池

@author:MackyHuang

DBCP

• 导包 dbcp和mysql的jar包

  mysql-connector-java-5.1.44-bin.jar
  commons-dbcp

• 配置文件中创建dbcp连接池的bean

   <bean id="dataSource"class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
          <property name="driverClassName" value="#{config.driver}"></property>
          <property name="url" value="#{config.url}"></property>
          <property name="username" value="#{config.username}"></property>
          <property name="password" value="#{config.password}"></property>
    </bean>
  

• 编写配置文件properties然后用util:property导入

   <util:properties id="config" location="classpath:db.properties"></util:properties>
  

• 通过spring表达式在bean中配置驱动和url等

   value="#{config.password}"
  

• 在方法中启动容器创建dbcp的对象

      ApplicationContext applicationContext = new ClassPathXmlApplicationContext("springmvc.xml");
      DataSource dataSource = applicationContext.getBean("dataSource", DataSource.class);