如何在jsp中将最后插入的id获取到jdbc

尝试这样的事情：

String query = "BEGIN " +    "  INSERT INTO Recipients( CustomerID, Name, Street, City, ZipCode, PhoneNumber" +     "   ,EmailAddress, ContactPersonName, ContactPersonSurname" +    "   ,ContactPersonPhoneNumber, ContactPersonEmailAddress) " +    "    VALUES(?,?,?,?,?,?,?,?,?,?,?) RETURNING id into ?; " +    "END;";CallableStatement cs = conn.prepareCall(query);cs.setString(1,transportTypeID);cs.setString(2,customerID);cs.setInt(3,recipientID);...cs.registerOutParameter(12, java.sql.Types.INTEGER);cs.execute();int id = cs.getInt(12);

然后将结果ID用于下一个插入。或者您也可以将其全部放入proc中。