测试环境搭建:
1.测试表:年级、班级、学生、临时表
1.测试表:年级、班级、学生、临时表
CREATE TABLE HTSAP.TESTSTU(
ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE),
CLASSNAME VARCHAR(15),
NAME VARCHAR(15),
AGE INTEGER,
SEX CHAR(4)
);
CREATE TABLE HTSAP.TESTCLASS(
ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE),
NAME VARCHAR(15),
GREADNAME VARCHAR(15)
);
CREATE TABLE HTSAP.TESTGREAD(
ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE),
NAME VARCHAR(15)
);
INSERT INTO HTSAP.TESTSTU(CLASSNAME,NAME,AGE,SEX)
VALUES('一班','XIAOMING1',15,'男'),('一班','XIAOMING2',15,'男'),('一班','XIAOMING3',15,'男'),
('二班','XIAOMING1',15,'男'),('二班','XIAOMING2',15,'男'),(&