1，用Oracle 的returning 语句。

PreparedStatement  sta = conn.prepareStatement("INSERT INTO 得到自增列的下一个会插入的id iis7站长之家 VALUES (TESTSEQ.NEXTVAL,SYSDATE)returning id into ? ");

  sta.execute();
  ResultSet rset = sta.getResultSet();
  while(rset.next())
    {
      int id = rset.getInt(1);

    }

如果是既有传入值,又有返回值的话,应该:

sta = conn.prepareStatement("INSERT INTO LOGGING VALUES

(TESTSEQ.NEXTVAL,? )returning id into ?; ; ");

sta = conn.(sqlText);
sta .setString(1, srqID);

sta .registerOutParameter(2, Types.NUMERIC);
sta .execute();

return sta .getLong(2);

或者用oracle的 OraclePreparedStatement

            String sql = "insert into test values(1,?) returning  id into ?";
            OraclePreparedStatement pstt = (OraclePreparedStatement) conn.prepareStatement(sql);

            pstt.setString(1, "xxx");
            pstt.registerReturnParameter(2, OracleTypes.INTEGER);

            pstt.executeUpdate();

            ResultSet rset = pstt.getReturnResultSet(); // rest is not null
           
            while (rset.next()) {
                int id = rset.getInt(1);
                system.out.println("insert returnning: " + id);
            }

2,用JDBC的getGeneratedKeys，返回的是Oracle 的rowid. 

PreparedStatement  sta = conn.prepareStatement("INSERT INTO TESTTABLE VALUES (TESTSEQ.NEXTVAL,'aaaa')",Statement.RETURN_GENERATED_KEYS);

  sta.execute();
  
  System.out.println(sta.getGeneratedKeys());
  ResultSet rest = sta.getGeneratedKeys();
  rest.next();
  //oracle rowid
  System.out.println(rest.getString(1));

您可能感兴趣的文章: