Spring jdbcのサポート

public class User {
	private int id;
	private String name;

//setter & getter
}

package com.xll.jdbc.dao;

import java.util.List;

import com.xll.jdbc.bean.User;

public interface UserDao {
	void save(User user);
	void delete(User user);
	User get(int id);
	List<User> getUsers();
}

package com.xll.jdbc.daoImpl;

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

import javax.sql.DataSource;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.transaction.annotation.Transactional;

import com.xll.jdbc.bean.User;
import com.xll.jdbc.dao.UserDao;

@Transactional
public class UserDaoImpl implements UserDao{
	private JdbcTemplate jdbcTemplate;
	
	public void setDatasouce(DataSource datasource) {
		jdbcTemplate = new JdbcTemplate( datasource);
	}
	public void delete(User user) {
		this.jdbcTemplate.update("delete from user where id=?", new Object[]{user.getId()});
		System.out.println("    ！");
	}
	public User get(int id) {
		User user = (User)this.jdbcTemplate.queryForObject("select * from user where id=?", new Object[]{id},
				new UserMapper());
		return user;
	}
	@SuppressWarnings("unchecked")
	public List<User> getUsers() {
		return this.jdbcTemplate.query("select * from user", new UserMapper());
	}

	public void save(User user) {
		this.jdbcTemplate.update("insert into user(id,name) values(?,?)",
				new Object[]{user.getId(),user.getName()});
		System.out.println("    ！");
	}
	private static final class UserMapper implements RowMapper {
	   
		public Object mapRow(java.sql.ResultSet rs, int rowNum)
				throws SQLException {
			  User user = new User();
		      user.setId(rs.getInt("id"));
		      user.setName(rs.getString("name"));
		        return user;
		}
	}
}	

<?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: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/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
			http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
		
		
		
	<bean id="Datasource"
		class="org.apache.commons.dbcp.BasicDataSource">
			<property name="driverClassName" value="com.mysql.jdbc.Driver" />
			<property name="url" value="jdbc:mysql://localhost:3306/mydb" />
			<property name="username" value="root" />
			<property name="password" value="123" />
			<property name="initialSize" value="2" />
			<property name="maxActive" value="100" />
			<property name="maxIdle" value="2" />
			<property name="minIdle" value="1" />
	</bean>
		<bean id="txManager"	class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
			<property name="dataSource" ref="Datasource" />
		</bean>
		
	<tx:annotation-driven transaction-manager="txManager" />
		
	<bean id="userDaoImp" class="com.xll.jdbc.daoImpl.UserDaoImpl">
	<property name="datasouce" ref="Datasource" />
	</bean>
</beans>		

public void testGetAll(){
		ApplicationContext ctx = new FileSystemXmlApplicationContext("src/applicationContext.xml");
		UserDao ud = (UserDao)ctx.getBean("userDaoImp");
		List list = ud.getUsers();
		
		Iterator iter = list.iterator();
		while(iter.hasNext()){
			User user = (User)iter.next();
			System.out.println(user);
		}
	}
	

name=xiaoliang,id=7
name=xiao,id=9

UserDao ud = (UserDao)ctx.getBean("userDaoImp");  

<aop:config proxy-target-class="true"></aop:config>

UserDaoImpl ud = (UserDaoImpl)ctx.getBean("userDaoImp");

public void save(User user) {
		this.jdbcTemplate.update("insert into user(id,name) values(?,?)",
				new Object[]{user.getId(),user.getName()});
		int i = 10/0;
		System.out.println("    ！");
	}