用prepareStatement（sql，Statement.RETURN_GENERATED_KEYS）方式在获取主键时出错，oracle数据库

Question

[color=darkred][/color][color=darkred][/color][img]http://dl.iteye.com/upload/attachment/0073/8634/396fc643-5c67-331a-9a21-9738be9c8ede.jpg[/img]
package com.call;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.DateFormat;

import com.util.JdbcUtils;
public class ReturnPremaryKey {

public static void main(String[] args) {
    Connection con=null;
    PreparedStatement ps=null;
    ResultSet  rs=null;
    String sql="insert into mini values(?,?,?)";
    int primaryKey=0;
    try {
        con=JdbcUtils.getConnection();
        //申明在执行的时候还会返回主键
        ps=con.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
        ps.setInt(1, 21);
        ps.setString(2, "hui");
        ps.setDate(3,
                new Date(DateFormat.getDateInstance().parse("2010-3-21")
                        .getTime()));
        ps.execute();
        rs=ps.getGeneratedKeys();
        if(rs.next()){
                     //这里取主键时出错
            primaryKey=rs.getInt(1);
            System.out.println(primaryKey);

        }
    } catch (Exception e) {
        throw new RuntimeException(e.getMessage());
    }finally{
        JdbcUtils.close(con, ps, rs);
    }

}

}

表结构如上，数据库为oracle

Answer 1

1、oracle不支持RETURN_GENERATED_KEYS，比如mysql支持
2、请使用sequence，即在插入之前通过sequence获取主键