简单的JdbcTemplate程序，先看bean.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"
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">
<!-- 配置JdbcTemplate -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</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/demo"></property>
<property name="username" value="root"></property>
<property name="password" value="1234"></property>
</bean>
</beans>
执行类：
public class JdbcTemplateDemo1 {
public static void main(String[] args) {
//1、获取容器
ApplicationContext ac = new ClassPathXmlApplicationContext("bean.xml");
//2、跟id获取bean对象
JdbcTemplate jt = (JdbcTemplate) ac.getBean("jdbcTemplate");
//3、执行操作
jt.execute("insert into account(name,money) values('ddd', 1234)");
//保存
jt.update("insert into account(name, money) values (?,?)", "fff", 3456);
//更新
jt.update("update account set money = ? where id = ?", 3567, 3);
//删除
jt.update("delete from account where id = ?", 5);
//查询所有
// List<Account> accounts = jt.query("select * from account where money > ?",
// new BeanPropertyRowMapper<Account>(Account.class), 10000);
// for(Account account : accounts) {
// account.toString();
// }
//查询一个
// List<Account> accounts = jt.query("select * from account where money = ?",
// new BeanPropertyRowMapper<Account>(Account.class), 10000);
//查询返回一行一列：聚合函数的使用
Integer count = jt.queryForObject("select count(*) from account where money > ? ", Integer.class, 1000)
}
}