use Oracle SEQUENCE funtion hwo to define in PreparedStatement?
Dear all
i have one question with Oracle SEQUENCE function to insert data into jsp page which i use PreparedStatement this object.
the way when i create one SEQUENCEcalled and the problem is that i donot know how to declare pno = accountcheck_sequence.nextval in to
PreparedStatement this function
drop SEQUENCE accountcheck_sequence
CREATE SEQUENCE accountcheck_sequence
START WITH 1 INCREMENT BY 1
--INSERT INTO accountcheck VALUES( accountcheck_sequence.nextval,'name' ,'afirstname' ,'roger@mail.com' ,'1qaz2wsxedc' ,'2007-10-10');
String in ="insert into subitems values(?,?,?,?,?)";
PreparedStatement ps = conn.prepareStatement(in);
pno = accountcheck_sequence?
ps.setInt(1,pno);
ps.setString(2,itemno);
ps.setString(3,subname);
ps.setString(4,"miss");
ps.setString(5,"miss");
ps.excute();

