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{@Overridepublic 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() {@Overridepublic 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);
}