spring中三种数据库连接配置

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans default-autowire="autodetect">
	<bean id="a" class="example.TestAjax">
		<property name="jdbcTemplate" ref="jdbcTemplate" />
	</bean>
	<!-- DriverManagerDataSource建立连接是只要有连接就新建一个connection,没有连接池的作用。 -->
	<bean id="dataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://localhost:3306/mysql" />
		<property name="username" value="root" />
		<property name="password" value="111111" />
	</bean>
	<!-- dbcp使用了连接池技术 -->
	<bean id="dataSource" class="org.apache.tomcat.dbcp.dbcp.BasicDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://localhost:3306/mysql" />
		<property name="username" value="root" />
		<property name="password" value="111111" />
	</bean>
	<!-- jndi -->
	<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName" value="java:comp/env/jdbc/mysql" />
	</bean>
	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="dataSource" />
	</bean>
</beans>

web.xml

<resource-ref>
	<description>DataBase Connection</description>
	<res-ref-name>jdbc/mysql</res-ref-name>
	<res-type>javax.sql.DataSource</res-type>
	<res-auth>Container</res-auth>
	<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>

context.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context>
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
	<Resource
	    auth="Application"
	    name="jdbc/mysql"
	    type="javax.sql.DataSource"
	    factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
	    driverClassName="com.mysql.jdbc.Driver"
	    url="jdbc:mysql://localhost:3306/mysql"
	    username="root"
	    password="111111"
	/>
</Context>

使用jndi的要在web.xml，context.xml作修改，另外两种不用。