java基本語句 java如何獲取剛插入記錄的自增長id號?
java如何獲取剛插入記錄的自增長id號?在mysql 中是這樣的:例如你剛進(jìn)行插入語句:String sql = "insert into table values(...)"objConn.exe
java如何獲取剛插入記錄的自增長id號?
在mysql 中是這樣的:例如你剛進(jìn)行插入語句:String sql = "insert into table values(...)"objConn.executeUpdate(sql)下面是取剛插入數(shù)據(jù)庫的ID號long ret_id=0ResultSet rs = objConn.executeQuery("select LAST_INSERT_ID()")if (rs.next())ret_id = rs.getLong(1)