<?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">
<!-- 加上default属性 -->
<!--
导入资源文件
<context:property-placeholder location="classpath:db.properties"/>
-->
<!-- 配置自动扫描的包 -->
<context:component-scan base-package="com.fehead.spring.jdbc"></context:component-scan>
<!-- 构造dbcp连接池 -->
<!--
<font color=#FF0000>
设置bean的时候,每一个property必须设置正确
username
password
url
driverClassName
</font>
-->
<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>
<!-- 配置Spring的JdbcTemplate -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!--
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.simple.SimpleJdbcTemplate">
<constructor-arg ref="dataSource"/>
</bean>
-->
</beans>
最重要的一段是:
设置bean的时候,每一个property的name必须设置正确(和下面的一模一样)
username
password
url
driverClassName