存储过程代码如下
CREATE OR REPLACE TRIGGER delete_stud
BEFORE DELETE ON stuInfo
FOR EACH ROW
DECLAREBEGIN
insert into stuInfo_bak values(stuInfobak_seq.nextval,:old.stuName,:old.password,:old.stuClass,:old.actor,:old.computer);
delete from stuScore where stuScore.stuId =:old.id ;
delete from stuAnswer where stuAnswer.stuId =:old.id ;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE( '出现异常:'||sqlErrm );END delete_stud;表:stuInfo
CREATE TABLE stuInfo (
id int PRIMARY KEY ,
stuName varchar2 (50) NOT NULL , --姓名
password varchar2 (10) NOT NULL , --密码
stuClass varchar2 (10) NULL , --班级
actor varchar2 (10) NOT NULL, --脚色
computer varchar2 (50) DEFAULT '0' NOT NULL --IP地址
);
CREATE SEQUENCE stuInfoID_seq start with 1 increment by 1;
CREATE OR REPLACE TRIGGER delete_stud
BEFORE DELETE ON stuInfo
FOR EACH ROW
DECLAREBEGIN
insert into stuInfo_bak values(stuInfobak_seq.nextval,:old.stuName,:old.password,:old.stuClass,:old.actor,:old.computer);
delete from stuScore where stuScore.stuId =:old.id ;
delete from stuAnswer where stuAnswer.stuId =:old.id ;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE( '出现异常:'||sqlErrm );END delete_stud;表:stuInfo
CREATE TABLE stuInfo (
id int PRIMARY KEY ,
stuName varchar2 (50) NOT NULL , --姓名
password varchar2 (10) NOT NULL , --密码
stuClass varchar2 (10) NULL , --班级
actor varchar2 (10) NOT NULL, --脚色
computer varchar2 (50) DEFAULT '0' NOT NULL --IP地址
);
CREATE SEQUENCE stuInfoID_seq start with 1 increment by 1;
输入java调用存储过程。查看结果即可
输入java调用存储过程。查看结果即可