创建表.sql

通过JDBC连接数据库

CREATE table S --创建数据表S
(
sno char(6) default 'J0400' not null constraint sno_PK primary key,
sname char(8) not null,
birthday datetime default '1980-01-01',
sdepartment varchar(20),
tel char(8) not null,
constraint sno_CK check (sno like '[A-Z][0-9][0-9][0-9][0-9]'),
constraint tel_CK check (tel like '[0-9][0-9]-[0-9][0-9][0-9][0-9]')
)
CREATE table C --创建数据表C
(
cno char(3)default 'C00' not null,
cname varchar(20) not null,
teacher char(8) null,
pcno char(3) null,
constraint pcno_FK foreign key (pcno)references C(cno),
constraint cno_CK check (cno like 'C[0-9][0-9]'),
constraint cno_PK primary key (cno) 
)
CREATE table SC --创建数据表SC
(
sno char(6),
cno char (3),
grade smallint null,
constraint scno_PK primary key (sno,cno),
constraint cno_FK foreign key (cno)references C(cno),
constraint sno_FK foreign key (sno)references S(sno),
constraint grade_CK check ((grade is null) or (grade between 0 and 100))
)