1 Spring的JDBC Template
1.1 jar要求
- 基础的spring开发包
- spring-core.jar
- spring-beans.jar
- spring-context.jar
- spring-expression.jar
- commons-logging.jar
- log4j.jar
- spring-jdbc.jar
- spring-tx.jar
- mysql-connection.jar
- spring-aop.jar
- spring-test.jar,方便测试
- c3p0.jar,如果需要使用c3p0连接池功能
1.2 数据库和表准备
create database jdbc_template;
use jdbc_template;
create table account(
id int primary key auto_increment,
name varchar(20),
money double
);
1.3 不使用spring配置测试适用jdbc template
public class JDBCTemplateTest01
{
@Test
public void test() throws SQLException
{
DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl("jdbc:mysql:///jdbc_template");
dataSource.setUsername("root");
dataSource.setPassword("123456");
JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
jdbcTemplate.update("insert into account (name,money) values(?,?)", "张三", 1000d);
}
}
1.4 使用spring配置jdbcTemplate
1.4.1 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: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">
<!-- 配置数据源 -->
<bean id="dataSource" class