Spring整合JDBC

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"
        xmlns:tx="http://www.springframework.org/schema/tx"
        xsi:schemaLocation="http://www.springframework.org/schema/beans 
                http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
                http://www.springframework.org/schema/context 
                http://www.springframework.org/schema/context/spring-context-2.5.xsd
                http://www.springframework.org/schema/tx
                http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
                http://www.springframework.org/schema/aop
                http://www.springframework.org/schema/aop/spring-aop-2.5.xsd">
    
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
        <property name="driverClass" value="oracle.jdbc.driver.OracleDriver"/>
        <property name="jdbcUrl" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
        <property name="user" value="scott"/>
        <property name="password" value="tiger"/>
    </bean>
    
    <bean id="deptDao" class="com.jdbc.DeptDAOJdbcImpl">
        <property name="dataSource" ref="dataSource"/>
    </bean>
 </beans>

Dept.java :

public class Dept {
	
	private int deptno;
	private String dname;
	private String loc;
	
	public int getDeptno() {
		return deptno;
	}
	public void setDeptno(int deptno) {
		this.deptno = deptno;
	}
	public String getDname() {
		return dname;
	}
	public void setDname(String dname) {
		this.dname = dname;
	}
	public String getLoc() {
		return loc;
	}
	public void setLoc(String loc) {
		this.loc = loc;
	}
	
}

DeptDAO.java :

public interface DeptDAO {
	public void save(Dept dept);
	public void delete(int deptno);
	public void update(Dept dept);
	public Dept findById(int deptno);
	public List<Dept> findAll();
}

DeptMapper.java :

public class DeptMapper implements RowMapper {

	@Override
	public Object mapRow(ResultSet rs, int arg1) throws SQLException {
		Dept dept=new Dept();
		int deptno=rs.getInt("deptno");
		String dname=rs.getString("dname");
		String loc=rs.getString("loc");
		dept.setDeptno(deptno);
		dept.setDname(dname);
		dept.setLoc(loc);
		return dept;
	}

}

DeptDAOJdbcImpl.java :

public class DeptDAOJdbcImpl extends JdbcDaoSupport implements DeptDAO {

	@Override
	public void delete(int deptno) {
		String sql="delete from dept where deptno=?";
		this.getJdbcTemplate().update(sql,new Object[]{deptno});
	}

	@SuppressWarnings("unchecked")
	@Override
	public List<Dept> findAll() {
		String sql="select * from dept";
		List<Dept> depts=this.getJdbcTemplate().query(sql,new DeptMapper());
		return depts;
	}

	@Override
	public Dept findById(int deptno) {
		String sql="select * from dept where deptno=?";
		Dept dept=(Dept) this.getJdbcTemplate().queryForObject(sql,new Object[]{deptno},new DeptMapper());
		return dept;
	}

	@Override
	public void save(Dept dept) {
		String sql="insert into dept(deptno,dname,loc) values(?,?,?)";
		Object[] params=new Object[]{dept.getDeptno(),dept.getDname(),dept.getLoc()};
		this.getJdbcTemplate().update(sql,params);
	}

	@Override
	public void update(Dept dept) {
		String sql="update dept set dname=?,loc=? where deptno=?";
		Object[] params=new Object[]{dept.getDname(),dept.getLoc(),dept.getDeptno()};
		this.getJdbcTemplate().update(sql,params);
	}

}

Test.java :

public class Test {

	public static void main(String[] args) {
		ApplicationContext ctx=new ClassPathXmlApplicationContext("bean.xml");
		DeptDAO dao=(DeptDAO) ctx.getBean("deptDao");
		List<Dept> depts=dao.findAll();
		for(Dept dept:depts){
			System.out.println(dept.getDeptno()+" "+dept.getDname()+" "+dept.getLoc());
		}
	}

}