jdbctemplate 批量插入 返回自增id importorg.springframework.dao.DataAccessException;importorg.springframework.jdbc.core.*;importorg.springframework.jdbc.support.JdbcUtils;importorg.springframework.jdbc.support.KeyHolder;importjava.sql.*;importjava.util.List;publicclassCustomerJdbcTemplateextendsJdbcTemplate {pu...
String sql="insert into buy_bean(id,bid,pid,s,datetime,mark,count)" +"values(null,?,?,?,?,?,?)";this.getJdbcTemplate().batchUpdate(sql,newBatchPreparedStatementSetter() { @OverridepublicintgetBatchSize() {returntempBpplist.size(); } @Overridepublicvoid setValues(PreparedStatement ps,inti)...
ps.setInt(++i,b.getType()); return ps; } }, keyHolder); return keyHolder.getKey().intValue(); } 2.批量插入数据 public void addBuyBean(List<BuyBean> list) { final List<BuyBean> tempBpplist = list; String sql="insert into buy_bean(id,bid,pid,s,datetime,mark,count)" + " value...
* @param params 参数 * @return 主键 */ public Long insertAndGetKey(final String sql, final SmsBean smsbean) { KeyHolder keyHolder = new GeneratedKeyHolder(); jdbcTemplate.update(new PreparedStatementCreator() { public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {...
(dataSource); } public Long insertAndReturnId(String name, String email) { String sql = "INSERT INTO users (name, email) VALUES (:name, :email)"; // 使用MapSqlParameterSource来设置参数 MapSqlParameterSource parameters = new MapSqlParameterSource() .addValue("name", name) .addValue("email...
@Override public Integer add(Board board) { String sql = "INSERT INTO tz_board(title, description) VALUES(?,?)"; jdbcTemplate.update(sql, board.getTitle(), board.getDescription()); Integer boardId = jdbcTemplate. return boardId; } 不知道我这样写对不对 Integer boardId = jdbcTemplate.java...
这个属于比较常见的需求了,我希望获取插入数据的主键id,用于后续的业务使用; 这时就需要用KeyHolder 代码语言:javascript 代码运行次数:0 运行 AI代码解释 /** * 新增数据,并返回主键id * * @return */ private int insertAndReturnId() { String sql = "INSERT INTO `money` (`name`, `money`, `is_dele...
keyHolder);returnkeyHolder.getKey().intValue(); }publicintaddBean(final Bean b){ final String strSql ="insert into buy(id,c,s,remark,line,cdatetime," +"c_id,a_id,count,type) values(null,?,?,?,?,?,?,?,?,?)"; KeyHolder keyHolder =newGeneratedKeyHolder();this.getJdbcTemplate()....
Spring的JdbcTemplate插入操作返回主键ID的方法: /** * * * 增加并且获取主键 * @param sql sql语句 * @param params 参数 * @return 主键 */ public Long insertAndGetKey(final String sql, final Student student ) { KeyHolder keyHolder = new GeneratedKeyHolder(); jdbcTemplate.update...
(e);}returnps;}},keyHolder);//orderRequestMoney.setDealLinkID(keyHolder.getKey().intValue());}finalstaticStringSQL_addOrderRequestMoney="insert into Order_RequestMoney(CompanyID,CreateTime,EmailState,ExprieTime) values(?,GETDATE(),?,DATEADD(HOUR, 2, GETDATE()));select @@IDENTITY as ...