Spring的JDBCTemplate和HIbernate、Mybatis一样,也是web开发中持久层的一个框架。
使用JDBCTemplate对象需要传入一个datasource连接池对象,Spring、DBCP、C3P0都可以提供这个连接池对象
配置文件bean
<?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:aop="http://www.springframework.org/schema/aop" 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.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 引入属性文件jdbc.properties -->
<context:property-placeholder location="classpath:jdbc.properties"/>
<!-- 配置Spring内置连接池的bean -->
<!-- <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/jdbctemplate"></property>
<property name="username" value="root"></property> <property name="password"
value="root"></property> </bean> -->
<!-- 配置DBCP连接池的bean -->
<!-- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url"
value="jdbc:mysql://localhost:3306/jdbctemplate"></property>
<property name="username" value="root"></property>
<property name="password" value="root"></property>
</bean> -->
<!-- 配置C3P0连接池的bean -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driverClass}"></property>
<property name="jdbcUrl" value="${jdbc.url}"></property>
<property name="user" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean>
<!-- 配置JdbcTemplate的bean -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
</beans>
配置C3P0时使用的jdbc.properties文件
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/jdbctemplate
jdbc.username=root
jdbc.password=root
测试代码
package com.jdbctemplate.demo;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import javax.annotation.Resource;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class JdbcTemplateDemo3 implements RowMapper<Account> {
@Resource(name="jdbcTemplate")
private JdbcTemplate jdbcTemplate;
@Test
//增删改操作都可以用update方法
public void update(){
jdbcTemplate.update("insert into account values(null,?,?)","六六",2000d);
}
@Test
//查询操作
public void query(){
String name = jdbcTemplate.queryForObject("select name from account where id = ?", String.class, 1);
System.out.println(name);
}
@Test
//查询一个对象
public void getAccount(){
Account ac = jdbcTemplate.queryForObject("select * from account where id = ?",new MyRowMapper() , 1);
System.out.println(ac);
}
@Test
//查询一个list集合
public void getList(){
List<Account> list = jdbcTemplate.query("select * from account", this);
for(Account ac:list){
System.out.println(ac);
}
}
@Override
public Account mapRow(ResultSet rs, int arg1) throws SQLException {
Account ac = new Account();
ac.setId(rs.getInt("id"));
ac.setName(rs.getString("name"));
ac.setMoney(rs.getDouble("money"));
return ac;
}
}
class MyRowMapper implements RowMapper<Account>{
public Account mapRow(ResultSet rs, int arg1) throws SQLException {
Account ac = new Account();
ac.setId(rs.getInt("id"));
ac.setName(rs.getString("name"));
ac.setMoney(rs.getDouble("money"));
return ac;
}
}