jdbcTemplate插入MYSQL时怎么返回主键ID

Question

@OverridepublicIntegeradd(Boardboard){Stringsql="INSERTINTOtz_board(title,description)VALUES(?,?)";jdbcTemplate.update(sql,board.getTitle(),board.getDescription());IntegerboardId=jdbcTemplate.returnboardId;}不知道我这样写对不对IntegerboardId=jdbcTemplate.

Answer 1

KeyHolderkeyHolder=newGeneratedKeyHolder();
jdbcTemplate.update(newPreparedStatementCreator(){
@Override
publicPreparedStatementcreatePreparedStatement(Connectionconn)throwsSQLException{
PreparedStatementps=conn.prepareStatement(SQL_ADD,newString[]{});
ps=conn.prepareStatement(YOUR_SQL_SCRIPT,Statement.RETURN_GENERATED_KEYS);
ps.setString(1,"TEST");
ps.setInt(2,1);
//...
returnps;
}
},
keyHolder);
returnkeyHolder.getKey().intValue();
                            

Answer 2

Spring提供了一个接口
org.springframework.jdbc.support.KeyHolder
其中有方法
getKey()
方法描述
Retrievethefirstmapofkeys.Iftherearemultipleentriesinthelist(meaningthatmultiplerowshadkeysreturned),thenanInvalidDataAccessApiUsageExceptionisthrown.