create table ap (ident varchar2(20),admin varchar2(20),pw varchar2(10));
create table stu_info (
sno varchar2(10) primary key not null,
sname varchar2(10) not null,
sex varchar2(6) ,
signtime varchar2(10) not null ,
department varchar2(20) not null ,
course varchar2(10) ,
tel varchar2(11) ,
address varchar2(20) ,
cno varchar2(10)
);
create table score_info (
cno varchar2(10),
sno varchar2(10),
sname varchar2(10) not null,
sub varchar2(12),
grade varchar2(3),
absent varchar2(6) not null
);
create table course(
sub varchar2(10),
stime varchar2(3),
sfen varchar2(3),
examtype varchar2(5)
);
alter table course add primary key(sub);
alter table score_info add foreign key (sub) references course (sub)
on delete cascade;
alter table score_info add foreign key (sno) references stu_info (sno)
on delete cascade;
java课程设计-基于Java swing带GUI界面的成绩(教务)管理系统（源码+数据库表+报告+uml）.zip （162个子文件） 
LoginFrame.java.bak 9KB FindDeltInfo.class 14KB Findstuinfo.class 13KB UpdateGrade.class 10KB Insertgrade.class 10KB CourseManager.class 9KB LoginFrame.class 8KB ScoreManager.class 8KB Spassword.class 6KB Spassword.class 6KB PersonalInfo$InforPanel.class 5KB StudentsImfo.class 5KB PersonalInfo.class 4KB TeacherFrame.class 4KB StudentsImfo$InforPanel$1.class 3KB StudentFrame.class 3KB Showtable.class 3KB Selectgrade.class 3KB Showallstu.class 3KB Selectallcourse.class 3KB Maxgrade.class 3KB FindDeltInfo$Show.class 3KB Findstuinfo$Show.class 3KB StudentsImfo$InforPanel.class 3KB UpdateGrade$2.class 3KB Spassword$1.class 3KB Spassword$1.class 3KB ConnectOracle.class 2KB LoadOracle.class 2KB LoadOracle.class 2KB ConnectOracle.class 2KB StudentFrame$1.class 1KB Findstuinfo$4.class 1KB StudentFrame$3.class 1KB PersonalInfo$InforPanel$1.class 914B StudentsImfo$InforPanel$2.class 896B StudentFrame$4.class 856B StudentFrame$2.class 853B TeacherFrame$5.class 850B Selectallcourse$2.class 794B TeacherFrame$2.class 785B Selectgrade$2.class 770B Showallstu$2.class 764B TeacherFrame$6.class 762B StudentFrame$5.class 762B FindDeltInfo$2.class 759B FindDeltInfo$1.class 759B FindDeltInfo$3.class 759B Showtable$2.class 758B UpdateGrade$4.class 752B Maxgrade$2.class 752B UpdateGrade$1.class 752B Insertgrade$3.class 752B Findstuinfo$3.class 752B Findstuinfo$1.class 752B UpdateGrade$3.class 752B Findstuinfo$2.class 752B Insertgrade$2.class 752B Insertgrade$1.class 752B TeacherFrame$3.class 749B TeacherFrame$4.class 749B TeacherFrame$1.class 748B Spassword$2.class 745B Spassword$2.class 745B CourseManager$1.class 744B CourseManager$2.class 744B LoginFrame$4.class 739B ScoreManager$1.class 737B ScoreManager$3.class 737B ScoreManager$2.class 737B ScoreManager$4.class 737B ScoreManager$6.class 737B ScoreManager$5.class 737B LoginFrame$1.class 733B LoginFrame$3.class 733B LoginFrame$2.class 733B Maxgrade$1.class 707B Selectgrade$1.class 706B Selectallcourse$1.class 701B Showallstu$1.class 671B Showtable$1.class 665B FindDeltInfo$4.class 546B Insertgrade$4.class 542B UpdateGrade$5.class 542B .classpath 301B
UML图.doc 1.19MB 实验报告.doc 536KB E-R图.doc 40KB 新建 Microsoft Word 文档.doc 11KB 新建 Microsoft Word 文档.doc 11KB FindDeltInfo.java 23KB FindDeltInfo.java 23KB Findstuinfo.java 22KB Findstuinfo.java 22KB UpdateGrade.java 14KB UpdateGrade.java 14KB Insertgrade.java 13KB Insertgrade.java 13KB CourseManager.java 11KB CourseManager.java 11KB共 162 条
- 1
- 2
资源评论
一吨酸菜鱼2024-10-20感谢资源主的分享，这个资源对我来说很有用，内容描述详尽，值得借鉴。
KkulliarThas2023-05-29资源不错，很实用，内容全面，介绍详细，很好用，谢谢分享。
m0_720503592022-06-22用户下载后在一定时间内未进行评价，系统默认好评。
