Spring JdbcTemplate学习笔记(一) —— 环境搭建

JdbcTemplate模板与DbUtils工具类比较类似

1. 配置数据源
<!-- 配置数据源 --> <context:property-placeholder location=
"classpath:jdbc.properties" /> <bean id="dataSource" class=
"com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="user" value=
"${jdbc.user}"></property> <property name="password" value="${jdbc.password}"></
property> <property name="driverClass" value="${jdbc.driverClass}"></property> <
property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property> <!-- 配置其他属性(省略) -->
</bean>
2．配置jdbcTemplate
<!-- 配置 spring 的 JdbcTemplate --> <bean id="jdbcTemplate" class=
"org.springframework.jdbc.core.JdbcTemplate"> <property name="dataSource" ref=
"dataSource"></property> </bean>
3.开发时注入 jdbcTemplate 即可
4.主要依赖的jar
Spring容器相关jar
数据库驱动
连接池jar 如 c3p0
Spring-jdbc
<dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</
artifactId> <version>${spring.version}</version> </dependency> <dependency> <
groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <
version>${spring.version}</version> </dependency> <dependency> <groupId>
com.mchange</groupId> <artifactId>c3p0</artifactId> <version>0.9.5.2</version>
</dependency> <dependency> <groupId>mysql</groupId> <artifactId>
mysql-connector-java</artifactId> <version>${mysql.version}</version> </
dependency>
引入spring-jdbc依赖就自动一如了其依赖的依赖就是spring容器和一些核心依赖。
applicationContext.xml配置文件:
<?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: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/tx
http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.0.xsd"> <!--
配置自动扫描的包 --> <context:component-scan base-package="com.sssp"></
context:component-scan> <!-- 配置数据源 --> <context:property-placeholder location=
"classpath:jdbc.properties" /> <bean id="dataSource" class=
"com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="user" value=
"${jdbc.user}"></property> <property name="password" value="${jdbc.password}"></
property> <property name="driverClass" value="${jdbc.driverClass}"></property> <
property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property> <!-- 配置其他属性(省略) -->
</bean> <!-- 配置 spring 的 JdbcTemplate --> <bean id="jdbcTemplate" class=
"org.springframework.jdbc.core.JdbcTemplate"> <property name="dataSource" ref=
"dataSource"></property> </bean> </beans>
测试方法:
@Autowired private JdbcTemplate jdbcTemplate; @Test public void test1() throws
SQLException{ String sql ="select * from user where id = 1"; List list =
jdbcTemplate.queryForList(sql); }

• « 上一篇：程序员过关斩将--数据库快速迁移10亿级数据
• » 下一篇：deep learning中网络的层数和每层的节点数是如何确定的？