1、数据库插入,返回记录的id
final String sql = "insert into attribute (name) values(?)";
getJdbcTemplate().update(new PreparedStatementCreator() {@Override
public PreparedStatement createPreparedStatement(
java.sql.Connection con) throws SQLException {
PreparedStatement ps = con.prepareStatement(sql,
Statement.RETURN_GENERATED_KEYS);
ps.setString(1, goodsAttribute.getName());
return ps;
}
}, keyHolder);
return keyHolder.getKey().intValue();