CUBRID AUTO_INCREMENT 컬럼 MySQL LAST_INSERT_ID() 대체 방법

Create table test_t(a int auto_increment, b char(10), c char(10) );

//MySQL
Insert into test_t(b,c) value(‘b’,’c’);

Select LAST_INSERT_ID(); //자동 증가된 a 컬럼의 값을 가져온다.

è

//CUBRID
preparedStatement =

connection. prepareStatement(“insert into test_t(b,c) value(‘b’,’c’)”, Statement.RETURN_GENERATED_KEYS);

preparedStatement.execute();

resultSet = preparedStatement.getGeneratedKeys();

if (rs.next()) {

java.math.BigDecimal bdDocNo = rs.getBigDecimal(1);

   docNo = bdDocNo.intValue();

}