改成这样不行吗:
PreparedStatement prestmt=conn.prepareStatement("insert into bbs(a,b) values(seq2.nextval(),?)");
prestmt.setBytes(2,cardid.getBytes());
你可以在表上建一个触发器,这样就不用给这个字段(a)赋值了
PreparedStatement prestmt=conn.prepareStatement("insert into bbs(a,b) values(seq2.nextval(),?)");
prestmt.setBytes(2,cardid.getBytes());
你可以在表上建一个触发器,这样就不用给这个字段(a)赋值了
after update of scbz,csbz or delete on ryjbxx
for each row
begin
if deleting then
delete from ryxxzb
where rybh=:old.rybh;
delete from ryxxzb1
where rybh=:old.rybh;
delete from ryxxzb2
where rybh=:old.rybh;
end if;
if updating then
update ryxxzb
set scbz=:new.scbz,csbz=:new.csbz
where rybh=:new.rybh;
update ryxxzb1
set scbz=:new.scbz,csbz=:new.csbz
where rybh=:new.rybh;
update ryxxzb2
set scbz=:new.scbz,csbz=:new.csbz
where rybh=:new.rybh;
end if;
end;
/