Spring总结（四）--spring整合jdbc

Spring整合jdbc

(一)Spring本身提供了很多模板整合Dao层

并且spring中提供了一个可以操作数据库的对象.对象封装了jdbc技术.

package cn.spring.jdbcTest;

import java.beans.PropertyVetoException;

import org.junit.Test;
import org.springframework.jdbc.core.JdbcTemplate;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class Demo {

	@Test
	public void test() throws PropertyVetoException{
		//准备连接池
		ComboPooledDataSource datasource=new ComboPooledDataSource();
		datasource.setDriverClass("com.mysql.jdbc.Driver");
		datasource.setJdbcUrl("jdbc:mysql:///spring");
		datasource.setUser("root");
		datasource.setPassword("root");
		//创建jdbc模板对象
		JdbcTemplate jt=new JdbcTemplate();
		jt.setDataSource(datasource);
		//书写sql并执行
		String sql="insert into t_user value(null,'xiaobai')";
		jt.update(sql);
	}
}

（二）准备工作--导包

主要有Spring的4个核心包+2个公共包/log4j+spring-test /spring-aop/junit4类库+c3p0连接池/JDBC驱动+spring-jdbc
/spring-tx事务

Dao：

package cn.spring.dao;

import java.util.List;

import cn.spring.bean.User;

public interface UserDao {

	void save(User user);
	void delete(Integer id);
	void update(User user);
	User getById(Integer id);
	int getTotalCount();
	List<User> getAll();
}

package cn.spring.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

import cn.spring.bean.User;
//使用jdbc模板实现增删改查
public class UserDaoImpl extends JdbcDaoSupport implements UserDao {
	//插入数据
	@Override
	public void save(User user) {		
		String sql="insert into t_user values(null,?)";
		super.getJdbcTemplate().update(sql,user.getName());
	}
	//删除数据
	@Override
	public void delete(Integer id) {

		String sql="delete from t_user where id=?";
		super.getJdbcTemplate().update(sql, id);
	}
//修改数据
	@Override
	public void update(User user) {
		String sql="update t_user set name=? where id=?";
		super.getJdbcTemplate().update(sql, user.getName(),user.getId());
	}
//通过id获得单个数据
	@Override
	public User getById(Integer id) {
		String sql="select * from t_user where id=?";
		return super.getJdbcTemplate().queryForObject(sql, new RowMapper<User>(){
			@Override
			public User mapRow(ResultSet rs, int arg1) throws SQLException {
				User user=new User();
				user.setId(rs.getInt("id"));
				user.setName(rs.getString("name"));
				return user;
			}},id);
	}
//获取所有数据的数量
	@Override
	public int getTotalCount() {
		String sql="select count(*) from t_user";
		Integer count = super.getJdbcTemplate().queryForObject(sql, Integer.class);
		return count;
	}
//获取所有数据对象
	@Override
	public List<User> getAll() {
		String sql="select * from t_user";
		List<User> list = super.getJdbcTemplate().query(sql, new RowMapper<User>(){

			@Override
			public User mapRow(ResultSet rs, int arg1) throws SQLException {
				User u=new User();
				u.setId(rs.getInt("id"));
				u.setName(rs.getString("name"));
				return u;
			}});
		return list;
	}
}

Spring配置：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd ">
<context:property-placeholder location="classpath:db.properties"/>
 <!-- 配置连接池 -->
 <bean name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
   <property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
   <property name="driverClass" value="${jdbc.driverClass}"></property>
   <property name="user" value="${jdbc.user}"></property>
   <property name="password" value="${jdbc.password}"></property>
 </bean>
 <!-- 将jdbcTemplate放到Spring 中 -->
 <bean name="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
    <property name="dataSource" ref="dataSource"></property>
 </bean>
 <bean name="userDao" class="cn.spring.dao.UserDaoImpl">
   <property name="dataSource" ref="dataSource"></property>
 </bean>
 
</beans>

db.properties

jdbc.jdbcUrl=jdbc:mysql:///spring
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.user=root
jdbc.password=root

测试Demo：

package cn.spring.dao;

import java.util.List;

import javax.annotation.Resource;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import cn.spring.bean.User;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class Demo {

	@Resource(name="userDao")
	private UserDaoImpl ui;
	@Test
	public void test(){
		User user=new User();
		user.setName("hahaha");
		ui.save(user);
	}
	@Test
	public void test1(){
		List<User> user=ui.getAll();
		System.out.println(user);
	}
}