这个项目本来是用MySQL的,我想改成Oracle,连接是连接上了,但是一使用insert就老报这个错误
public static void addA(String email, String pw, String name, String phone,
String IDNumber) throws SQLException, ClassNotFoundException {
String sql = "insert into admin(EMAIL,APW,ANAME,PHONE,IDNUMBER)" + "values(ADMIN_SEQ.nextval,?,?,?,?,?)";
//"insert into admin values(?,?,?,?,?)";
PreparedStatement ps = DataConnect.getCon().prepareStatement(sql);
ps.setString(1, email);
ps.setString(2, pw);
ps.setString(3, name);
ps.setString(4, phone);
ps.setString(5, IDNumber);
ps.executeUpdate();
DataConnect.getCon().commit();
}