Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "";
String user = "";
String password = "";
Connection conn = DriverManager.getConnection(url, user, password);
String sql = "insert into student(STUNO,STUNAME,fenshu) values(sys_guid(),'test',85.0) returning stuno into ?";
OraclePreparedStatement pstmt = (OraclePreparedStatement) conn.prepareStatement(sql);
pstmt.registerReturnParameter(1, OracleTypes.VARCHAR,32);
int count = pstmt.executeUpdate();
if(count>0){
ResultSet rs = pstmt.getReturnResultSet();
while(rs.next()){
System.out.println(rs.getString(1));//get return uuid
}
}
}
转载于:https://my.oschina.net/lvzjane/blog/191193