CREATE user zengym
identified by zengym
default tablespace users
temporary tablespace temp
quota 10m on users;
grant create session,resource to zengym;
CREATE TABLE zengym.class_Cour
(class_NO number Primary Key,
course_Name varchar2(50)
)
TABLESPACE USERS;
Insert Into zengym.class_Cour Values(0156,'外语');
Insert Into zengym.class_Cour Values(10156,'C语言');
Insert Into zengym.class_Cour Values(20156,'VB');
Insert Into zengym.class_Cour Values(30156,'计算机英语');
Insert Into zengym.class_Cour Values(0246,'VB');
Insert Into zengym.class_Cour Values(10246,'邓小平理论');
Insert Into zengym.class_Cour Values(20246,'C语言');
Insert Into zengym.class_Cour Values(30246,'计算机英语');
Insert Into zengym.class_Cour Values(0122,'外语');
Insert Into zengym.class_Cour Values(10122,'电路');
Insert Into zengym.class_Cour Values(20122,'C语言');
Insert Into zengym.class_Cour Values(0238,'C语言');
Insert Into zengym.class_Cour Values(10238,'电路');
Insert Into zengym.class_Cour Values(20238,'VB');
Insert Into zengym.class_Cour Values(30238,'邓小平理论');
CREATE TABLE zengym.class_Form
(class_No number Primary Key,
class_Name varchar2(50),
class_Teacher varchar2(50),
class_Remarks varchar2(50)
)
TABLESPACE USERS;
Insert Into zengym.class_Form Values(0156,'计算机','钟莉云','计算机科学与技术');
Insert Into zengym.class_Form Values(0246,'计算机','丛立香','计算机科学与技术');
Insert Into zengym.class_Form Values(0122,'物理学','李鹏','应用物理学');
Insert Into zengym.class_Form Values(0238,'经济','刘洪','经济学');
CREATE TABLE zengym.course_Form
(course_Name Varchar2(50) Primary Key,
course_Rem Varchar2(50)
)
TABLESPACE USERS;
insert into zengym.course_Form values('外语','英语');
insert into zengym.course_Form values('电路','计算机基础');
insert into zengym.course_Form values('C语言','计算机编程语言');
insert into zengym.course_Form values('VB','计算机编程基础');
CREATE TABLE zengym.prize_Form
(prize_name varchar2(50) Primary Key,
prize_Rem Varchar2(50)
)
TABLESPACE USERS;
Insert Into zengym.prize_Form Values('校级优秀学生','');
Insert Into zengym.prize_Form Values('国家级优秀学生','');
Insert Into zengym.prize_Form Values('记过处分','');
CREATE TABLE zengym.prize_Stud
(prize_NO number Primary Key,
prize_Stu number,
prize_Dat date,
prize_Nam Varchar2(50)
)
TABLESPACE USERS;
Insert Into zengym.prize_Stud Values(100001,0156001,to_date('2010-10-01','yyyy-mm-dd'),'校级优秀学生');
Insert Into zengym.prize_Stud Values(100002,0122001,to_date('2010-10-01','yyyy-mm-dd'),'校级优秀学生');
Insert Into zengym.prize_Stud Values(100003,0156002,to_date('2010-10-01','yyyy-mm-dd'),'国家级优秀学生');
Insert Into zengym.prize_Stud Values(100004,0238004,to_date('2010-05-01','yyyy-mm-dd'),'记过处分');
Insert Into zengym.prize_Stud Values(100005,0238002,to_date('2010-03-01','yyyy-mm-dd'),'校级优秀学生');
Insert Into zengym.prize_Stud Values(100006,0122003,to_date('2010-10-01','yyyy-mm-dd'),'国家级优秀学生');
Insert Into zengym.prize_Stud Values(100007,0122002,to_date('2010-05-01','yyyy-mm-dd'),'记过处分');
CREATE TABLE zengym.score_Form
(score_NO number Primary Key,
score_per Varchar2(50),
score_Cla number,
score_Stu number,
score_Cou Varchar2(50),
score_Sco Varchar2(50)
)
TABLESPACE USERS;
Insert Into zengym.score_Form Values(200001,'2002A',0238,0238002,'电路','65.00');
Insert Into zengym.score_Form Values(200002,'2002B',0122,0122002,'电路','59.00');
Insert Into zengym.score_Form Values(200003,'2002A',0122,0122002,'C语言','98.00');
Insert Into zengym.score_Form Values(200004,'2002A',0238,0238001,'电路','86.00');
Insert Into zengym.score_Form Values(200005,'2002B',0156,0156002,'外语','68.00');
Insert Into zengym.score_Form Values(200006,'2002A',0122,0122003,'电路','98.00');
Insert Into zengym.score_Form Values(200007,'2002B',0246,0246003,'邓小平理论','68.00');
Insert Into zengym.score_Form Values(200008,'2002B',0156,0156001,'C语言','80.00');
Insert Into zengym.score_Form Values(200009,'2002B',0156,0156001,'外语','90.00');
Insert Into zengym.score_Form Values(200010,'2002B',0156,0156001,'VB','70.00');
Insert Into zengym.score_Form Values(200011,'2002B',0156,0156001,'计算机英语','60.00');
Insert Into zengym.score_Form Values(200012,'2002A',0156,0156002,'外语','90.00');
Insert Into zengym.score_Form Values(200013,'2002A',0156,0156002,'C语言','80.00');
Insert Into zengym.score_Form Values(200014,'2002A',0156,0156002,'计算机英语','59.00');
Insert Into zengym.score_Form Values(200015,'2002A',0156,0156003,'外语','78.00');
Insert Into zengym.score_Form Values(200016,'2002A',0156,0156003,'C语言','88.00');
Insert Into zengym.score_Form Values(200017,'2002A','0156','0156003','VB','75.00');
Insert Into zengym.score_Form Values(200018,'2002A','0156','0156003','计算机英语','98.00');
Insert Into zengym.score_Form Values(200019,'2002A','0156','0156004','外语','79.50');
Insert Into zengym.score_Form Values(200020,'2002A','0156','0156004','VB','69.00');
Insert Into zengym.score_Form Values(200021,'2002A','0156','0156005','C语言','99.00');
Insert Into zengym.score_Form Values(200022,'2002A','0156','0156005','计算机英语','97.00');
Insert Into zengym.score_Form Values(200023,'2002A','0122','0122002','电路','97.00');
Insert Into zengym.score_Form Values(200024,'2002B','0156','0156005','C语言','87.00');
CREATE TABLE zengym.student_Form
(student_NO number Primary Key,
student_Name Varchar2(50),
student_Sex Varchar2(5),
student_Bir Date,
student_Cla number,
student_Tel Varchar2(50),
student_Esd Date,
student_Add Varchar2(50),
student_Rem Varchar2(50)
)
TABLESPACE USERS;
Insert Into zengym.student_Form Values(0156001,'白龙','男',to_date('1989-05-26','yyyy-mm-dd'),0156,'1500000001',to_date('2010-09-01','yyyy-mm-dd'),'辽宁沈阳市','');
Insert Into zengym.student_Form Values(0156002,'杨涛','男',to_date('1988-03-06','yyyy-mm-dd'),0156,'1500000002',to_date('2010-09-01','yyyy-mm-dd'),'江西宜春市','');
Insert Into zengym.student_Form Values(0156003,'向建华','男',to_date('1988-07-16','yyyy-mm-dd'),0156,'1500000003',to_date('2010-09-01','yyyy-mm-dd'),'湖南怀化市','');
Insert Into zengym.student_Form Values(0156004,'邝著盛','男',to_date('1989-10-06','yyyy-mm-dd'),0156,'1500000004',to_date('2010-09-01','yyyy-mm-dd'),'江西赣州市','');
Insert Into zengym.student_Form Values(0156005,'赵亮','男',to_date('1991-05-28','yyyy-mm-dd'),0156,'1500000005',to_date('2010-09-01','yyyy-mm-dd'),'黑龙江齐齐哈尔市','');
Insert Into zengym.student_Form Values(0246001,'代思','女',to_date('1986-11-18','yyyy-mm-dd'),0246,'1500000006',to_date('2008-09-01','yyyy-mm-dd'),'北京','');
Insert Into zengym.student_Form Values(0246002,'王彤','女',to_date('1987-01-05','yyyy-mm-dd'),0246,'1500000007',to_date('2008-09-01','yyyy-mm-dd'),'上海','');
Insert Into zengym.student_Form Values(0246003,'曾龙','男',to_date('1988-12-08','yyyy-mm-dd'),0246,'1500000008',to_date('2008-09-01','yyyy-mm-dd'),'江西抚州','');
Insert Into zengym.student_Form Values(0246004,'奋斗','女',to_date('1985-06-14','yyyy-mm-dd'),0246,'1500000009',to_date('2008-09-01','yyyy-mm-dd'),'天津','');
Insert Into zengym.student_Form Values(0122001,'曾永明','男',to_date('1991-08-08','yyyy-mm-dd'),0122,'1500000010',to_date('2008-09-01','yyyy-mm-dd'),'江西赣州','');
Insert Into zengym.student_Form Values(0122002,'李真','男',to_date('1981-10-25','yyyy-mm-dd'),0122,'15000000011',to_date('2007-09-01','yyyy-mm-dd'),'江西赣州','');
Insert Into zengym.student_Form Values(0122003,'地球','男',to_date('1986-09-11','yyyy-mm-dd'),0122,'1500000012',to_date('2007-09-01','yyyy-mm-dd'),'江西上饶','');
Insert Into zengym.student_Form Values(0122004,'可可','女',to_date('1991-01-06','yyyy-mm-dd'),0122,'1500000013',to_date('2007-09-01','yyyy-mm-dd'),'福建厦门','');
Insert Into zengym.student_Form Values(0238001,'李丽','女',to_date('1990-08-21','yyyy-mm-dd'),0238,'1500000014',to_date('2009-09-01','yyyy-mm-dd'),'重庆','');
Insert Into zengym.stud
VB+oracle编写的学生信息管理系统（文档+代码）
5星 · 超过95%的资源 需积分: 9 190 浏览量
2011-06-01
22:18:49
上传
评论 7
收藏 1.76MB RAR 举报 
Oracle学生信息管理系统.rar （36个子文件） 
Oracle学生信息管理系统 
zengyongming.dmp 10KB 脚本 080703022.sql 8KB 可执行文件 源码 源码 ICO notesg.ico 6KB Thumbs.db 4KB NOTEPA~5.ICO 2KB
学生管理系统.exe 584KB Command.ocx 144KB Data frmprpi.frm 14KB frmcusi.frm 21KB 工程1.PDM 5KB frmMain.frx 6KB 工程1.vbp 1KB MSSCCPRJ.SCC 190B frmscoi.frm 45KB Module1.bas 2KB frmsumi.frx 2KB Command.oca 28KB frmprpi.frx 2KB
JDSJ278.jpg 229KB frmcusi.frx 2KB frmstsi.frx 2KB 080703022.sql 8KB 工程1.vbw 545B dColor.frx 254KB dColor.frm 2KB frmcoui.frx 2KB frmMain.frm 3KB frmLogin.frm 7KB frmscoi.frx 2KB frmcoui.frm 15KB frmclai.frx 2KB frmclai.frm 24KB frmsumi.frm 13KB frmstsi.frm 32KB frmLogin.frx 17KB
080703022曾永明.doc 1.3MB资源评论
ZJJ1965735362011-12-09系统运行不了啊 只能看代码 自己重新运行cmd···而且工程在我电脑里也打不开哦 需要自己改很多东西·
zmde2012-11-29嗯，系统实现不了，但是还是学到东西了
sxl58107562011-12-25系统确实运行不了，但是代码还不错，很有参考价值。其实有代码就可以了。非常感谢能够分享到资源。- chitu143092013-07-03一般，没怎么看
aishenlan2011-12-22系统运行不了啊 只能看代码 自己重新运行cmd···而且工程在我电脑里也打不开哦 需要自己改很多东西·
