public int saveRegInfo(String salutation, String name, String mobile,
String email, String address, String offer, String tncAgree)
throws SQLException {
int orderId=-1;
try {
getConnection();
int i = 0;
String sql="INSERT INTO GROUPBUYING(id,CRTE_DATE,SALUTATION,CUST_NAME,CONTACT_NO,EMAIL,ADDRESS,SERVER_TYPE,IS_ACCEPT) "
+ "VALUES (SEQ_GROUPBUYING_ID.nextval, SYSDATE, ?,gen_encr(?), gen_encr(?), gen_encr(?),gen_encr(?), ?,?)";
stmt = conn.prepareStatement(sql,new String[]{"id"});
stmt.setString(++i, salutation);
stmt.setString(++i, name);
stmt.setString(++i, mobile);
stmt.setString(++i, email);
stmt.setString(++i, address);
stmt.setString(++i, offer);
stmt.setString(++i, tncAgree);
int excuteResult=stmt.executeUpdate() ;
if (excuteResult> 0) {
ResultSet generatedKeys = stmt.getGeneratedKeys();
// if resultset has data, get the primary key value
// of last inserted record
if (null != generatedKeys && generatedKeys.next()) {
// voila! we got id which was generated from sequence
orderId = generatedKeys.getInt(1);
}
} else {
throw new SQLException("Insert info to table GROUPBUYING failed! Error="+excuteResult);
}
} catch (SQLException e) {
throw e;
} finally {
if (rs != null)
rs.close();
if (stmt != null)
stmt.close();
if (conn != null)
conn.close();
}
return orderId;
}