Spring使用JdbcTemplate、JdbcDaoSupport和返回表自增主键值

Spring使用JdbcTemplate、JdbcDaoSupport和返回表自增主键值  

2013-04-13 08:50:48|  分类： 默认分类|举报|字号 订阅

1、使用模版类JdbcTemaplate。

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
	<property name="dataSource" ref="dataSource"></property>
</bean>

<bean id="daoBase" abstract="true">
	<property name="jdbcTemplate" ref="jdbcTemplate"></property>
</bean>

<bean id="studentDao" parent="daoBase" class="com.daoImpl.StudentDaoImpl"></bean> 

<bean id="studentService" class="com.serviceImpl.StudentServiceImpl">
	<property name="studentDao" ref="studentDao"></property>
</bean>

2、通过模版类对应的支持类来使用JdbcTemaplate。

public class BaseDao extends JdbcDaoSupport{
	//公共方法
}

public class TeacherDaoImpl extends BaseDao implements TeacherDao{

	@Override
	public Student seacherStu(int id) {
		String sql="select * from student where id=?";
		final Student student=new Student();
		this.getJdbcTemplate().query(sql, new Object[]{id}, new RowCallbackHandler() {
			@Override
			public void processRow(ResultSet res) throws SQLException {
				student.setName(res.getString("name"));
				student.setSex(res.getString("sex"));
				student.setSay(res.getString("say"));
			}
		});
		return student;
	}
}

配置文件：

<bean id="teacherDao" class="com.daoImpl.TeacherDaoImpl">
	<property name="dataSource" ref="dataSource"></property>
</bean>
<bean id="teacherService" class="com.serviceImpl.TeacherServiceImpl">
	<property name="teacherDao" ref="teacherDao"></property>
</bean>

3、返回数据库表自增主键值

通过一下方法绑定主键值：

int executeUpdate(String sql,int autoGenerateKeys)

PreparedStatement prepareStatement(String sql,int autoGenerateKeys)

：：将 autoGenerateKeys设置为Statement.RETURN_GENERATED_KEYS绑定主键值到Statement或者 PreparedStatement ;设置为 Statement.NO_GENERATED_KEYS则不绑定。

Spring提供了int update(PreparedStatementCreator psc,KeyHolder generateKeyHolderr) 方法来返回新增记录对应的主键值。

public void addStudent(final Student student){
	final String sql="insert into t_student(name,sex) values(?,?)";
	//创建一个主键持有者
	KeyHolder key=new GeneratedKeyHolder();
	this.getJdbcTemplate().update(new PreparedStatementCreator(){
		public PreparedStatement createPreparedStatement(Conection con) throws SQLException{
			PreparedStatement preState=con.prepareStatement(sql);
			preState.setString(1,student.getName());
			preState.setString(2,student.getSex());
					return preState;
		}
	},key);
	//从主键持有者中获得主键值
	student.setKey(key.getKey().intValue);
}