SpringJdbcTemplate(整合数据源)

1.1 常见数据源

在使用JdbcTemplate的时候&＃xff0c;需要设置一个数据源对象&＃xff0c;才能完成数据库操作

#常见的数据源&＃xff1a;
内置数据源&＃xff1a;org.springframework.jdbc.datasource.DriverManagerDataSourcec3p0数据源&＃xff1a;com.mchange.v2.c3p0.ComboPooledDataSourcedbcp数据源&＃xff1a;org.apache.commons.dbcp.BasicDataSourcedruid数据源&＃xff1a;com.alibaba.druid.pool.DruidDataSource


1.2 内置数据源


<beans xmlns&＃61;"http://www.springframework.org/schema/beans"xmlns:xsi&＃61;"http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation&＃61;"http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsd"><bean id&＃61;"jdbcTemplate" class&＃61;"org.springframework.jdbc.core.JdbcTemplate"><property name&＃61;"dataSource" ref&＃61;"dataSource">property>bean><bean id&＃61;"dataSource" class&＃61;"org.springframework.jdbc.datasource.DriverManagerDataSource"><property name&＃61;"driverClassName" value&＃61;"com.mysql.jdbc.Driver">property><property name&＃61;"url" value&＃61;"jdbc:mysql://127.0.0.1:3306/1_spring">property><property name&＃61;"username" value&＃61;"root">property><property name&＃61;"password" value&＃61;"admin">property>bean>beans>


1.3 整合c3p0

1.3.1 项目结构​

1.3.2 配置pom.xml


<c3p0.version>0.9.5c3p0.version>
<dependency><groupId>com.mchangegroupId><artifactId>c3p0artifactId><version>${c3p0.version}version>
dependency>


1.3.3 配置bean.xml


<beans xmlns&＃61;"http://www.springframework.org/schema/beans"xmlns:xsi&＃61;"http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation&＃61;"http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsd"><bean id&＃61;"jdbcTemplate" class&＃61;"org.springframework.jdbc.core.JdbcTemplate"><property name&＃61;"dataSource" ref&＃61;"dataSource">property>bean><bean id&＃61;"dataSource" class&＃61;"com.mchange.v2.c3p0.ComboPooledDataSource"><property name&＃61;"driverClass" value&＃61;"com.mysql.jdbc.Driver">property><property name&＃61;"jdbcUrl" value&＃61;"jdbc:mysql://127.0.0.1:3306/spring">property><property name&＃61;"user" value&＃61;"root">property><property name&＃61;"password" value&＃61;"root">property>bean>
beans>


1.3.4 执行结果

1.4 整合druid数据源

1.4.1 项目结构

​

1.4.2 配置pom.xml


<druid.version>1.0.29druid.version>
<dependency><groupId>com.alibabagroupId><artifactId>druidartifactId><version>${druid.version}version>
dependency>


1.4.3 配置bean.xml


<beans xmlns&＃61;"http://www.springframework.org/schema/beans"xmlns:xsi&＃61;"http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation&＃61;"http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsd"><bean id&＃61;"jdbcTemplate" class&＃61;"org.springframework.jdbc.core.JdbcTemplate"><property name&＃61;"dataSource" ref&＃61;"dataSource">property>bean><bean id&＃61;"dataSource" class&＃61;"com.alibaba.druid.pool.DruidDataSource"><property name&＃61;"driverClassName" value&＃61;"com.mysql.jdbc.Driver">property><property name&＃61;"url" value&＃61;"jdbc:mysql://127.0.0.1:3306/spring">property><property name&＃61;"username" value&＃61;"root">property><property name&＃61;"password" value&＃61;"root">property>bean>
beans>


1.4.4 执行结果