首頁(yè) 猿問(wèn) jdbcTemplate插入MYS...

jdbcTemplate插入MYSQL時(shí)怎么返回主鍵ID

JavaScript

森林海 2019-04-13 08:45:49

@OverridepublicIntegeradd(Boardboard){Stringsql="INSERTINTOtz_board(title,description)VALUES(?,?)";jdbcTemplate.update(sql,board.getTitle(),board.getDescription());IntegerboardId=jdbcTemplate.returnboardId;}不知道我這樣寫(xiě)對(duì)不對(duì)IntegerboardId=jdbcTemplate.

查看完整描述

2 回答

守候你守候我

TA貢獻(xiàn)1802條經(jīng)驗(yàn) 獲得超10個(gè)贊

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();

反對(duì) 回復(fù) 2019-04-13

慕村225694

TA貢獻(xiàn)1880條經(jīng)驗(yàn) 獲得超4個(gè)贊

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