Spring配置dbcp连接数据库注意事项

r囧r小猫 2022-02-28 04:26 263阅读 0赞

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xmlns:aop="http://www.springframework.org/schema/aop"
    	xmlns:context="http://www.springframework.org/schema/context"
    	xmlns:tx="http://www.springframework.org/schema/tx"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans 
    						http://www.springframework.org/schema/beans/spring-beans.xsd
    						http://www.springframework.org/schema/context 
    						http://www.springframework.org/schema/context/spring-context-4.3.xsd
    						http://www.springframework.org/schema/aop 
    						http://www.springframework.org/schema/aop/spring-aop-4.3.xsd" default-lazy-init="true">
    	
    		
    	
    	
    
    	
    	<context:component-scan base-package="com.fehead.spring.jdbc"></context:component-scan>
    
    	
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    		<property name="username" value="xiaoaxiao"></property>
    		<property name="password" value="8023hyx1999hyx"></property>
    		<property name="url" value="jdbc:mysql://localhost:3306/spring1"></property>
    		<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
    	</bean>
    	
    	
    	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
    		<property name="dataSource" ref="dataSource"></property>
    	</bean>
    	
    	
    	
    </beans>

最重要的一段是：  
  
设置bean的时候，每一个property的name必须设置正确（和下面的一模一样）  
username  
password  
url  
driverClassName