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();

[1130 byte] By [roger5089a] at [2007-11-27 10:24:18]
# 1

INSERT INTO accountcheck VALUES( accountcheck_sequence.nextval, 'name' , 'afirstname' , 'roger@mail.com' , '1qaz2wsxedc' , '2007-10-10');

String in = "insert into subitems values(accountcheck_sequence.nextval,?,?,?,?,?)";

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();

tolmanka at 2007-7-28 17:27:05 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...