通过java,insert数据时返回键值。
结论
- 不仅可以返回主键,还可以返回具体某列的值。
- 只能作用于简单的insert的语句,insert select、merge语句不支持(只测试过ojdbc-14.jar)
- 不支持batch批处理
实例
package database;
//import 略
public class ConnectionTest {
private static String dbDriver = "oracle.jdbc.driver.OracleDriver";
private static String dbURL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static String dbUser = "testuser";
private static String dbPwd = "testuser";
private static Connection con;
private static Statement sm = null;
private static PreparedStatement ps = null;
private static ResultSet rs = null;
private String insertSqlStr = "insert into testtable values(testseq.nextVal, " +
"testseq.nextVal + 100, testseq.nextVal + 1000)";
@BeforeClass
public