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

Question

@Override
publicIntegeradd(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(){@OverridepublicPreparedStatementcreatePreparedStatement(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.