oracle插入自增长id,Oracle id自增长插入

private Connection conn = null;

private PreparedStatement ps = null;

private ResultSet rs = null;

/**

* 添加方法

*/

public void insert(NoteMms record) {

// 主键编号

int insertkey = 0;

// 查询序列

String sequence = "select S_TBL_NOTEMMS.nextval from dual";

// 插入语句

String sql = "insert into TBL_NOTEMMS (ID, SENDPHONE, RECEIVEPHONE, CREATETIME) values (?,?,?,?)";

try {         conn = Conn.getConn();                ps = conn.prepareStatement(sequence);         rs = ps.executeQuery();         rs.next();         insertkey = rs.getInt(1);             ps = conn.prepareStatement(sql);         ps.setInt(1, insertkey);         ps.setString(2, record.getSendphone());         ps.setString(3, record.getReceivephone());         ps.setDate(4, new java.sql.Date(record.getCreatetime().getTime()));         ps.executeUpdate();        } catch (SQLException e) {         e.printStackTrace();       } finally {           try {             rs.close();             ps.close();             conn.close();           } catch (SQLException e) {             e.printStackTrace();           }       }     }