[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