</pre><pre name="code" class="java">jdbcTemplate 实现插入一条数据后吗,返回id
</pre><pre name="code" class="java"> KeyHolder key = new GeneratedKeyHolder();
PreparedStatementCreator psc = new PreparedStatementCreator() {
@Override
public PreparedStatement createPreparedStatement(Connection con)
throws SQLException {
PreparedStatement ps = con.prepareStatement(addSql,PreparedStatement.RETURN_GENERATED_KEYS);
ps.setString(1, obj.getType());
ps.setString(2, obj.getUser_id());
ps.setDouble(3, obj.getCf_amt());
ps.setString(4, obj.getCreate_tm());
ps.setString(5, obj.getYbid());
ps.setString(6,obj.getPbchannel());
return ps;
}
};
getJdbcTemplate().update(psc,key);
int cf_id = key.getKey().intValue();
obj.setCf_id(cf_id);