1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
| --创建表空间
create tablespace OralData
datafile 'D:\OralData.bdf'
size 3M
autoextend on;
--创建用户
create user gg
identified by abc;
--授权
grant connect to gg;
grant resource to gg;
--创建表Users
create table Users
(
UserID number not null primary key,
UserName varchar(50) not null,
UserPwd varchar(50) not null,
UserRole number(4) not null
);
select * from Users where UserName='张三' and UserPwd='admin'
--创建表Question
create table Question
(
QuestionID number(4) not null primary key,
CourseID number(4) not null references Course(CourseID),
Title varchar(200) not null,
OptionA varchar(40) not null,
OptionB varchar(40) not null,
OptionC varchar(40) not null,
OptionD varchar(40) not null,
Answer char(1) not null
);
--创建表Course
create table Course
(
CourseID number(4) not null primary key,
CourseName varchar(20) not null,
Semester varchar(10) not null
);
select CourseID,CourseName from Course where Semester='上学期';
--创建三个序列
create sequence Use_id
increment by 1
start with 1
nomaxvalue
nocycle;
create sequence Que_id
increment by 1
start with 1
nomaxvalue
nocycle;
create sequence Cou_id
increment by 1
start with 1
nomaxvalue
nocycle;
--插入数据
insert into Users values(Use_id.Nextval,'张三','admin',1);
insert into Users values(Use_id.Nextval,'李四','admin',1);
insert into Users values(Use_id.Nextval,'王五','admin',1);
insert into Users values(Use_id.Nextval,'赵六','admin',1);
insert into Users values(Use_id.Nextval,'管老师','admin',2);
insert into Course values(Cou_id.Nextval,'语文','上学期');
insert into Course values(Cou_id.Nextval,'数学','上学期');
insert into Course values(Cou_id.Nextval,'英语','下学期');
insert into Course values(Cou_id.Nextval,'物理','下学期');
insert into Question values(Que_id.Nextval,1,'理想，今年你几岁？','3','18','30','100','A');
insert into Question values(Que_id.Nextval,3,'1+1等于几，不能说是2哦?','0','1','2','22','C');
insert into Question values(Que_id.Nextval,3,'what why where when','what','why','where','when','B');
insert into Question values(Que_id.Nextval,4,'牛顿的重力加速度是多少？','0.98','9.8','98','980','B');
commit;
|