使用Spring的JdbcTemplate进行CRUD

package com.mo;

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;

/**
 * 使用SpringJBDC的模板进行CRUD
 * 
 * @author 文龙
 * @version 2018-3-7 下午9:10:22
 */
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:spring.xml")
public class Demo {
	
	@Resource(name="jdbcTemplate")
	private JdbcTemplate jdbcTemplate;
	
	@Test
	public void update() {
		//update可以完成增删改
		jdbcTemplate.update("insert into t_account (name,money) values (?,?)","手机",10000);
		jdbcTemplate.update("delete from t_account where id = ?",2);
		jdbcTemplate.update("update t_account set name= ? where id = ?","电话",1);
	}
	
	@Test
	public void select() {
		//查询使用的是query()方法.RowMapper是将查询到的结果与java类进行对应起来
		
		//查询当个对象
		Account account = jdbcTemplate.queryForObject("select * from t_account where id = ?", new AccountMapper(), 1);
		System.out.println(account); //Account [id=1, name=电话, money=1000]
		
		//查询多个对象
		List<Account> list = jdbcTemplate.query("select * from t_account where 1=?", new AccountMapper(),1);
		System.out.println(list);
		
		//查询记录数
		Integer count = jdbcTemplate.queryForObject("select count(*) from t_account", Integer.class);
		System.out.println(count);
	}
}


class AccountMapper implements RowMapper<Account> {

	//自己手动封装数据，一行一行封装
	public Account mapRow(ResultSet rs, int arg1) throws SQLException {
		Account account = new Account();
		account.setId(rs.getInt("id"));
		account.setName(rs.getString("name"));
		account.setMoney(rs.getInt("money"));
		return account;
	}
	
}

package com.mo;

/**
 * @author 文龙
 * @version 2018-3-7 下午9:35:41
 */
public class Account {
	private int id;
	private String name;
	private int money;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getMoney() {
		return money;
	}
	public void setMoney(int money) {
		this.money = money;
	}
	@Override
	public String toString() {
		return "Account [id=" + id + ", name=" + name + ", money=" + money
				+ "]";
	}
	
	
}

<?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">  
    
    <!-- 配置连接池 spring只带的连接池 -->
    <!-- <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/springjdbc"></property>
		<property name="username" value="root"></property>
		<property name="password" value="root"></property>
    </bean> -->
    <!-- 配置DBCP连接池 -->
    <!-- <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/springjdbc"></property>
    	<property name="username" value="root"></property>
    	<property name="password" value="root"></property>
    </bean> -->
    
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    	<property name="driverClass" value="com.mysql.jdbc.Driver"></property>
    	<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/springjdbc"></property>
    	<property name="user" value="root"></property>
		<property name="password" value="root"></property>    		
    </bean>
    <!-- 配置Spring提供的JDBC模板 -->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="dataSource"></property>    	
    </bean>
    
</beans>