學(xué)生信息管理系統(tǒng)JSP

1、大連工業(yè)大學(xué)課程設(shè)計(jì)（論文）任務(wù)書(shū)專(zhuān) 業(yè)電子商務(wù)班 級(jí)電商122題 目學(xué)生管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)子 題高校學(xué)生信息管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)指導(dǎo)教師1答疑教師1設(shè)計(jì)時(shí)間2014年12 月 15 日至 2014年 12 月 28 日 共 二 周設(shè)計(jì)要求設(shè)計(jì)（論文）的任務(wù)和基本要求，包括設(shè)計(jì)任務(wù)、查閱文獻(xiàn)、方案設(shè)計(jì)、說(shuō)明書(shū)（計(jì)算、圖紙、撰寫(xiě)內(nèi)容及規(guī)范等）、工作量等內(nèi)容。一、課程設(shè)計(jì)要求根據(jù)所選的題目，每組同學(xué)合作完成××管理系統(tǒng)數(shù)據(jù)庫(kù)的要求書(shū)寫(xiě)詳細(xì)的設(shè)計(jì)說(shuō)明書(shū)，嚴(yán)禁相互抄襲。具體要求如下：1、需求分析。調(diào)查清楚用戶(hù)的信息需求、處理需求、安全性和完整性需求，以書(shū)面形式表示出來(lái)。2、根據(jù)需

2、求分析的結(jié)果，設(shè)計(jì)××管理系統(tǒng)的E-R模型。3、將所設(shè)計(jì)的E-R模型轉(zhuǎn)換成相應(yīng)的關(guān)系數(shù)據(jù)庫(kù)模型。4、利用關(guān)系模型的規(guī)范化理論，分析設(shè)計(jì)出的關(guān)系數(shù)據(jù)庫(kù)模型，檢查是否存在著存儲(chǔ)異常等問(wèn)題，如果有的話，請(qǐng)用模式分解的方法消除之。5、數(shù)據(jù)庫(kù)實(shí)現(xiàn)。6、數(shù)據(jù)庫(kù)運(yùn)行與維護(hù)。7、可自行選擇前臺(tái)開(kāi)發(fā)工具，設(shè)計(jì)××管理系統(tǒng)的用戶(hù)訪問(wèn)界面，可實(shí)現(xiàn)用戶(hù)的權(quán)限控制、查詢(xún)、更新功能。8、設(shè)計(jì)完成后，必須提交設(shè)計(jì)說(shuō)明書(shū)。二、課程設(shè)計(jì)內(nèi)容要求學(xué)生根據(jù)課題的內(nèi)容完成方案論證、總體設(shè)計(jì)、技術(shù)標(biāo)準(zhǔn)和規(guī)范的使用、程序的編寫(xiě)、調(diào)試等方面，以期得到綜合性訓(xùn)練。根據(jù)所給課題，完成由指導(dǎo)教師具體布置的

3、課程設(shè)計(jì)任務(wù)。每組由組長(zhǎng)負(fù)責(zé)分工，小組成員共同完成設(shè)計(jì)內(nèi)容，并按課程設(shè)計(jì)要求寫(xiě)出課程設(shè)計(jì)說(shuō)明書(shū)。三、設(shè)計(jì)完成后，必須提交設(shè)計(jì)說(shuō)明書(shū)。四、備選題目1、高校學(xué)生信息管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)2、高等學(xué)校教師信息管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)3、高校圖書(shū)管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)4、高校學(xué)生宿舍管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)5、企業(yè)員工培訓(xùn)管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)6、企業(yè)員工薪酬管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)7、企業(yè)員工考勤管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)8、企業(yè)員工績(jī)效管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)9、超市銷(xiāo)售管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)10、酒店管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)11、公司庫(kù)存管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)12、小區(qū)物業(yè)管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)13、醫(yī)院住院管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)14

4、、醫(yī)院門(mén)診管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)15、汽車(chē)銷(xiāo)售管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)16、藥房銷(xiāo)售管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)17、房地產(chǎn)銷(xiāo)售管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)18、機(jī)票預(yù)訂管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)19、旅行社管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)20、駕駛員培訓(xùn)學(xué)校管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)指導(dǎo)教師簽字： 系（教研室）主任簽字： 2014年12 月 15 日課程設(shè)計(jì)分工全組：數(shù)據(jù)庫(kù)概念結(jié)構(gòu)設(shè)計(jì)全組：數(shù)據(jù)庫(kù)邏輯結(jié)構(gòu)設(shè)計(jì) 全組：數(shù)據(jù)庫(kù)物理結(jié)構(gòu)設(shè)計(jì)部分趙負(fù)責(zé)數(shù)據(jù)庫(kù)實(shí)現(xiàn)部分孫負(fù)責(zé)數(shù)據(jù)庫(kù)設(shè)計(jì)部分趙負(fù)責(zé)數(shù)據(jù)庫(kù)設(shè)計(jì)部分劉負(fù)責(zé)數(shù)據(jù)庫(kù)設(shè)計(jì)部分李負(fù)責(zé)報(bào)告書(shū)寫(xiě)和答辯 劉負(fù)責(zé)數(shù)據(jù)庫(kù)實(shí)現(xiàn)部分 目錄第一章 需求分析5第二章 數(shù)據(jù)庫(kù)概念結(jié)構(gòu)設(shè)計(jì)6第三章 數(shù)據(jù)庫(kù)邏輯結(jié)構(gòu)設(shè)計(jì)1

5、1第四章 數(shù)據(jù)庫(kù)物理結(jié)構(gòu)設(shè)計(jì)12第五章 數(shù)據(jù)庫(kù)運(yùn)行及維護(hù)13第六章 學(xué)生信息管理系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)30鏈接Oracle的頁(yè)面30首頁(yè)代碼31檢驗(yàn)登陸密碼是否正確進(jìn)行跳轉(zhuǎn)33學(xué)生登陸成功頁(yè)面35教師登陸成功頁(yè)面36管理員登陸成功頁(yè)面38學(xué)生登陸成功后看課表39學(xué)生登陸成功后看成績(jī)41管理員登陸對(duì)學(xué)生進(jìn)行操作43管理員查詢(xún)學(xué)生46管理員登陸對(duì)學(xué)生進(jìn)行添加操作46學(xué)生添加成功48添加成功后顯示在表里增加一行50管理員登陸對(duì)學(xué)生進(jìn)行更新操作50更新成功后顯示在表里改變一行54管理員登陸對(duì)學(xué)生進(jìn)行刪除操作54管理員課程頁(yè)面57管理員教師頁(yè)面60第七章 課程設(shè)計(jì)總結(jié)64第一章 需求分析 信息需求：學(xué)生信息管理

6、系統(tǒng)，可用于學(xué)校等機(jī)構(gòu)的學(xué)生信息管理，查詢(xún)，更新與維護(hù)，使用方便，易用性強(qiáng)。 處理需求：該系統(tǒng)實(shí)現(xiàn)的大致功能：用戶(hù)登陸。提供了學(xué)生信息的查詢(xún)，相關(guān)科目的成績(jī)查詢(xún)等功能。教師管理。提供了對(duì)學(xué)生成績(jī)的錄入，修改，刪除。管理員?？梢孕薷?，刪除，查詢(xún)所有信息。 安全性：數(shù)據(jù)庫(kù)的安全性是指保護(hù)數(shù)據(jù)庫(kù)以防止不合法的使用所造成的數(shù)據(jù)泄露,更改,或者破壞。安全性問(wèn)題不是數(shù)據(jù)庫(kù)系統(tǒng)所獨(dú)有的,所有計(jì)算機(jī)系統(tǒng)都有這個(gè)問(wèn)題,只是在數(shù)據(jù)庫(kù)系統(tǒng)中大量數(shù)據(jù)集中存放,而且為許多最終用戶(hù)直接共享,從而使安全問(wèn)題更為突出,系統(tǒng)安全保護(hù)措施是否有效是數(shù)據(jù)庫(kù)系統(tǒng)的主要指標(biāo)之一。 完整性需求： 數(shù)據(jù)庫(kù)中關(guān)系模型完整性約束：實(shí)體完整性、

7、參照完整性、和用戶(hù)定義完整性。其實(shí)實(shí)體完整性和參照完整性是關(guān)系模型中必須滿(mǎn)足的完整性條件。因此用戶(hù)在使用數(shù)據(jù)庫(kù)必須遵守完整性規(guī)則：實(shí)體完整性規(guī)則、參照完整性規(guī)則、用戶(hù)定義完整性規(guī)則。在關(guān)系模型中以主碼作為唯一標(biāo)識(shí)，因此主碼不能為空?？偟膩?lái)說(shuō)數(shù)據(jù)庫(kù)完整性是指數(shù)據(jù)的正確性和相容性。例如本系統(tǒng)中學(xué)生學(xué)號(hào)必須唯一;性別只能是男或女等.數(shù)據(jù)庫(kù)是否具備完整性關(guān)系到數(shù)據(jù)庫(kù)系統(tǒng)能否真實(shí)地反映現(xiàn)實(shí)世界,因此維護(hù)數(shù)據(jù)庫(kù)的完整性是非常重要的。第二章 數(shù)據(jù)庫(kù)概念結(jié)構(gòu)設(shè)計(jì)課程實(shí)體集及其屬性： 課學(xué)分 課學(xué)時(shí)授課院系課程課程名課程號(hào)電話登錄密碼 教師教師實(shí)體集及其屬性： 專(zhuān)業(yè)號(hào) 職稱(chēng)姓名教師號(hào)性別姓名性別學(xué)號(hào) 學(xué)生學(xué)生實(shí)

8、體集及其屬性班級(jí)號(hào)出生時(shí)間登錄密碼職稱(chēng)nm電話nm學(xué)院實(shí)體集及其屬性學(xué)院號(hào)學(xué)院學(xué)院名專(zhuān)業(yè)實(shí)體集及其屬性專(zhuān)業(yè)號(hào)專(zhuān)業(yè)學(xué)院號(hào)專(zhuān)業(yè)名班級(jí)實(shí)體集及其屬性人數(shù)班級(jí)號(hào)班級(jí)專(zhuān)業(yè)號(hào)班級(jí)名講授聯(lián)系的屬性課程號(hào)教師號(hào)職稱(chēng)課程名講授課程課學(xué)時(shí)電話教師1 1教室號(hào)號(hào)課學(xué)分登錄密碼上課實(shí)體集及其屬性學(xué)號(hào)教師號(hào)姓名職稱(chēng)學(xué)生上課 n性別電話教師1出生時(shí)間登錄密碼課程號(hào)m考試聯(lián)系的屬性p郵政編碼E-mail課程號(hào)學(xué)號(hào)姓名課程名學(xué)生課程考試n1學(xué)分性別年齡周學(xué)時(shí) 成績(jī)?nèi)值腅-R模型：數(shù)據(jù)元素一覽表4-2編號(hào)數(shù)據(jù)元素名稱(chēng)別名類(lèi)型長(zhǎng)度DE001學(xué)號(hào)id字符型10DE002姓名s_name字符型10DE003性別s_sex字符型2D

9、E004出生時(shí)間s_birthdaydatetime型8DE005學(xué)生密碼s_password字符型10DE006課程號(hào)cou_id字符型20DE007課程名cou_name字符型20DE008授課院系cou_dept字符型10DE009課學(xué)時(shí)cou_hourint型4DE010課學(xué)分cou_scorefloat型8DE011教師號(hào)t_id字符型10DE012教師名t_name字符型10DE013性別t_sex字符型2DE014職稱(chēng)duty字符型10表4-2 數(shù)據(jù)元素一覽表 續(xù)表編號(hào)數(shù)據(jù)元素名稱(chēng)別名類(lèi)型長(zhǎng)度DE015電話tel字符型20DE017教師密碼t_password字符型10DE018

10、學(xué)院號(hào)d_id字符型2DE019學(xué)院名d_name字符型10DE020專(zhuān)業(yè)號(hào)m_id字符型4DE021專(zhuān)業(yè)名m_name字符型10DE022班級(jí)號(hào)c_id字符型6DE023班級(jí)名c_name字符型10DE024人數(shù)c_numberint型3DE026教室號(hào)r_id字符型10DE027成績(jī)score字符型10學(xué)生信息管理涉及的實(shí)體有：(1)學(xué)生student 它的屬性有：學(xué)號(hào)、姓名、性別、出生時(shí)間、登錄密碼，班級(jí)號(hào)。(2)課程course 它的屬性有：課程號(hào)、課程名、授課院系、課學(xué)時(shí)、課學(xué)分。(3)教師teacher 它的屬性有：教師號(hào)、姓名、性別、職稱(chēng)、電話、登錄密碼，專(zhuān)業(yè)號(hào)(4)學(xué)院dept

11、 它的屬性有：學(xué)院號(hào)、學(xué)院名。(5)專(zhuān)業(yè)major 它的屬性有：專(zhuān)業(yè)號(hào)、專(zhuān)業(yè)名，學(xué)院號(hào)。(6)班級(jí)sclass 它的屬性有：班級(jí)號(hào)、班級(jí)名、人數(shù)，專(zhuān)業(yè)號(hào)。聯(lián)系：（1）講授instruct：教師號(hào)、課程號(hào)、教室號(hào)（2）上課teach：教師號(hào)、課程號(hào)、學(xué)號(hào)（3）考試exam：課程號(hào)、學(xué)生號(hào)、成績(jī)(4)一個(gè)學(xué)生可以選擇多個(gè)課程，而一個(gè)課程又可以被多個(gè)學(xué)生所選擇。(5)一個(gè)學(xué)生類(lèi)別里包含一個(gè)或多個(gè)學(xué)生，一個(gè)學(xué)生必然屬于某個(gè)特定學(xué)生類(lèi)別。(6)一個(gè)課程類(lèi)別里包含一門(mén)或多門(mén)課程，一門(mén)課程必然屬于某個(gè)特定課程類(lèi)別。第三章 數(shù)據(jù)庫(kù)邏輯結(jié)構(gòu)設(shè)計(jì)學(xué)生（學(xué)號(hào)，姓名，性別，出生時(shí)間，登錄密碼，班級(jí)號(hào)）教師（教師號(hào)，姓

12、名，性別，職稱(chēng)，電話，登錄密碼，專(zhuān)業(yè)號(hào)）課程（課程號(hào)、課程名、授課院系、課學(xué)時(shí)、課學(xué)分）學(xué)院（學(xué)院號(hào)、學(xué)院名）專(zhuān)業(yè)（專(zhuān)業(yè)號(hào)、專(zhuān)業(yè)名，學(xué)院號(hào)）班級(jí)（班級(jí)號(hào)、班級(jí)名、人數(shù)，專(zhuān)業(yè)號(hào)）講授（教師號(hào)、課程號(hào)、教室號(hào)）上課（教師號(hào)、課程號(hào)、學(xué)號(hào)）考試（課程號(hào)、學(xué)生號(hào)、成績(jī)）講授（教師號(hào)、課程號(hào)、教室號(hào)）屬于第一范式上課（教師號(hào)、課程號(hào)、學(xué)號(hào)）屬于第一范式考試（課程號(hào)、學(xué)生號(hào)、成績(jī)）屬于第一范式第4章 數(shù)據(jù)庫(kù)物理結(jié)構(gòu)設(shè)計(jì)1、 確定記錄的存儲(chǔ)格式 Jsp格式2、 選擇文件的存儲(chǔ)結(jié)構(gòu) 散列結(jié)構(gòu)3、存儲(chǔ)路徑D:myeclipseWorkspacesMyEclipse 10kcsj第5章 數(shù)據(jù)庫(kù)運(yùn)行及維護(hù)1、建立數(shù)

13、據(jù)庫(kù)結(jié)構(gòu)，試運(yùn)行，裝入實(shí)際數(shù)據(jù)庫(kù)并建立實(shí)際數(shù)據(jù)庫(kù)。create table course(cou_id char(20),cou_name varchar(30) not null,cou_dept varchar(20) not null,cou_hour number(4) not null,cou_score float(8) not null,constraint pk_course primary key(cou_id);create table dept(d_id char(10),d_name varchar(20) not null,constraint pk_dept pri

14、mary key(d_id);create table major(m_id char(10),m_name varchar(30) not null,d_id char(10),constraint pk_major primary key(m_id),constraint fk_did foreign key(d_id) references dept(d_id) on delete cascade);create table teacher(t_id char(10),t_name varchar(20) constraint nn_t_name not null,t_sex varch

15、ar(4) constraint nn_t_sex not null,duty varchar(10) not null,tel varchar(20),t_password varchar(10) not null,m_id char(10),constraint pk_teacher primary key(t_id),constraint chk_t_sex check(t_sex in('男','女'),constraint fk_mid foreign key(m_id) references major(m_id) on delete cascade

16、);create table sclass(c_id char(10),c_name varchar(30) not null,c_number number(3) not null,m_id char(10),constraint pk_sclass primary key(c_id),constraint fk_majorid foreign key(m_id) references major(m_id) on delete cascade);create table student(id char(10),s_name varchar(20) constraint nn_s_name

17、not null,s_sex varchar(4) constraint nn_s_sex not null,s_birthday varchar(10) not null,s_password varchar(10) not null,c_id char(10) not null, constraint pk_student primary key(id),constraint fk_cid foreign key(c_id) references sclass(c_id) on delete cascade);create table instruct(t_id char(10),cou_

18、id char(10),r_id varchar(10) not null,constraint pk_instruct primary key(cou_id),constraint fk_itid foreign key(t_id) references teacher(t_id) on delete cascade,constraint fk_icid foreign key(cou_id) references course(cou_id) on delete cascade);create table exam(cou_id char(10),id char(10),score cha

19、r(10),constraint pk_exem primary key(cou_id, id),constraint fk_ecid foreign key(cou_id) references course(cou_id) on delete cascade,constraint fk_esid foreign key(id) references student(id) on delete cascade);create table teach(t_id char(10),id char(10),cou_id char(10),constraint pk_teach primary ke

20、y(t_id, id,cou_id),constraint fk_ttid foreign key(t_id) references teacher(t_id) on delete cascade,constraint fk_tsid foreign key(id) references student(id) on delete cascade,constraint fk_tcid foreign key(cou_id) references course(cou_id) on delete cascade);create table usern(u_id char (10),u_passw

21、ord varchar(10),constraint pk_usern primary key(u_id);insert into dept values('7','管理學(xué)院');insert into dept values('8','機(jī)械學(xué)院');insert into dept values('9','服裝學(xué)院');insert into dept values('6','生物工程學(xué)院');insert into dept values('5',

22、'食品學(xué)院');insert into course values('1','高數(shù)','3','48','7');insert into course values('2','英語(yǔ)','3','48','7');insert into course values('3','英語(yǔ)聽(tīng)說(shuō)','2','48','7');insert into cou

23、rse values('4','毛澤東理論原理','3','48','9');insert into course values('5','概率學(xué)','2','48','7');insert into course values('6','統(tǒng)計(jì)學(xué)','2.5','48','7');insert into course values('7',&

24、#39;統(tǒng)籌學(xué)','3','48','7');insert into course values('8','運(yùn)籌學(xué)','3','48','7');insert into course values('9','機(jī)械原理學(xué)','3','48','8');insert into course values('10','環(huán)境與物理學(xué)','3'

25、,'48','8');insert into course values('11','形式與政治','3','48','6');insert into course values('12','JAVA','3','48','7');insert into course values('13','C語(yǔ)言','3','48','8'

26、;);insert into course values('14','會(huì)計(jì)','3','48','7');insert into course values('15','服飾藝術(shù)','3','48','9');insert into course values('16','動(dòng)物學(xué)','3','48','6');insert into course value

27、s('17','物理學(xué)','3','48','8');insert into course values('18','材料化學(xué)','3','48','5');insert into course values('19','包裝','3','48','5');insert into course values('20','食品衛(wèi)生學(xué)&#

28、39;,'3','48','5');insert into major values('708','電子商務(wù)','7');insert into major values('704','工商管理','7');insert into major values('503','工藝','5');insert into major values('506','工業(yè)工程','

29、5');insert into major values('901','服裝表演','9');insert into major values('902','高分子','9');insert into major values('602','紡織材料','6');insert into major values('604','紡織工藝','6');insert into major values(

30、'809','機(jī)械工程','8');insert into major values('805','動(dòng)力工程','8');insert into sclass values('12070801','電子商務(wù)121','5','708');insert into sclass values('12070802','電子商務(wù)122','5','708');insert into

31、 sclass values('12070401','工商管理121','5','704');insert into sclass values('12070402','工商管理122','5','704');insert into sclass values('12050301','工藝121','5','503');insert into sclass values('12050302'

32、;,'工藝122','5','503');insert into sclass values('12050601','工業(yè)工程121','5','506');insert into sclass values('12050602','工業(yè)工程122','5','506');insert into sclass values('12090101','服裝表演121','5',

33、'901');insert into sclass values('12090102','服裝表演122','5','901');insert into sclass values('12090201','高分子121','5','902');insert into sclass values('12090202','高分子122','5','902');insert into sclas

34、s values('12060201','紡織材料121','5','602');insert into sclass values('12060202','紡織材料122','5','602');insert into sclass values('12060401','紡織工藝121','5','604');insert into sclass values('12060402',&#

35、39;紡織工藝122','5','604');insert into sclass values('12080901','機(jī)械工程121','5','809');insert into sclass values('12080902','機(jī)械工程122','5','809');insert into sclass values('12080501','動(dòng)力工程121','5',&#

36、39;805');insert into sclass values('12080502','動(dòng)力工程122','5','805');insert into student values('1207080201','太史慈','男','1993.1.2','123','12070802');insert into student values('1207080202','夏侯淵','男&#

37、39;,'1994.2.4','123','12070802');insert into student values('1207080203','荀彧','男','1993.9.15','123','12070802');insert into student values('1207080204','花木蘭','女','1992.12.2','123','120

38、70802');insert into student values('1207080205','鐘立春','女','1993.2.2','123','12070802');insert into student values('1207080101','陸抗','男','1994,2,3','123','12070801');insert into student values('120

39、7080102','武則天','女','1995.2.6','123','12070801');insert into student values('1207080103','柳如是','女','1993.4,20','123','12070801');insert into student values('1207080104','趙云','男','19

40、92.4.12','123','12070801');insert into student values('1207080105','黃忠','男','1993.8.9','123','12070801');insert into student values('1207040201','姜維','男','1992.5.12','123','12070402');

41、insert into student values('1207040202','馬騰','男','1996.3.1','123','12070402');insert into student values('1207040203','夏侯?lèi)?#39;,'男','1992.9.13','123','12070402');insert into student values('1207040204'

42、;,'董小宛','女','1993.1.2','123','12070402');insert into student values('1207040205','司馬昭','男','1993,8.12','123','12070402');insert into student values('1207040101','秦良玉','女','1993.7.20

43、9;,'123','12070401');insert into student values('1207040102','蔡瑁','男','1994.5.26','123','12070401');insert into student values('1207040103','魯肅','男','1992.12.9','123','12070401');insert in

44、to student values('1207040104','張遼','男','1995.2.12','123','12070401');insert into student values('1207040105','公孫淵','男','1993.9.14','123','12070401');insert into student values('1208090201','陳

45、圓圓','女','1992.2.5','123','12080902');insert into student values('1208090202','何進(jìn)','男','1994.2.16','123','12080902');insert into student values('1208090203','黃道婆','女','1994.4.15','1

46、23','12080902');insert into student values('1208090204','曹操','男','1992.3.18','123','12080902');insert into student values('1208090205','司馬相如','男','1994.7.12','123','12080902');insert into stud

47、ent values('1208090101','潘金蓮','女','1995.12.1','123','12080901');insert into student values('1208090102','馬超','男','1992.2.3','123','12080901');insert into student values('1208090103','西施',&

48、#39;女','1992.3.2','123','12080901');insert into student values('1208090104','孫策','男','1993.2.20','123','12080901');insert into student values('1208090105','魏延','男','1993.4.23','123',&#

49、39;12080901');insert into student values('1208050201','劉封','男','1993.4.24','123','12080502');insert into student values('1208050202','孫權(quán)','男','1993.4.25','123','12080502');insert into student values(&

50、#39;1208050203','徐盛','男','1993.4.26','123','12080502');insert into student values('1208050204','郭嘉','男','1993.4.27','123','12080502');insert into student values('1208050205','趙宏','男',&

51、#39;1993.4.28','123','12080502');insert into student values('1208050101','祝英臺(tái)','女','1993.4.29','123','12080501');insert into student values('1208050102','李香君','女','1993.4.30','123','120805

52、01');insert into student values('1208050103','周瑜','男','1994.9.1','123','12080501');insert into student values('1208050104','徐昭佩','女','1994.9.2','123','12080501');insert into student values('120805

53、0105','趙飛燕','女','1994.9.3','123','12080501');insert into student values('1209010201','皇甫浩','男','1994.9.4','123','12090102');insert into student values('1209010202','上官婉兒','女','1994

54、.9.5','123','12090102');insert into student values('1209010203','班昭','女','1994.9.6','123','12090102');insert into student values('1209010204','張合','男','1994.9.7','123','12090102');inse

55、rt into student values('1209010205','丁原','男','1994.9.8','123','12090102');insert into student values('1209010101','馬謖','男','1994.9.9','123','12090101');insert into student values('1209010102','

56、;典韋','男','1994.9.10','123','12090101');insert into student values('1209010103','蘇小妹','女','1994.9.11','123','12090101');insert into student values('1209010104','梁紅玉','女','1994.9.12',

57、9;123','12090101');insert into student values('1209010105','卓文君','女','1994.9.13','123','12090101');insert into student values('1209020201','黃蓋','男','1994.9.14','123','12090202');insert into st

58、udent values('1209020202','龐統(tǒng)','男','1994.9.15','123','12090202');insert into student values('1209020203','張飛','男','1994.9.16','123','12090202');insert into student values('1209020204','穆桂英'

59、;,'女','1994.9.17','123','12090202');insert into student values('1209020205','董卓','男','1994.9.18','123','12090202');insert into student values('1209020101','妲己','女','1994.9.19','123'

60、;,'12090201');insert into student values('1209020102','劉禪','男','1994.9.20','123','12090201');insert into student values('1209020103','呂布','男','1993.3.13','123','12090201');insert into student valu

61、es('1209020104','法正','男','1993.3.14','123','12090201');insert into student values('1209020105','袁術(shù)','男','1993.3.15','123','12090201');insert into student values('1206020201','諸葛亮','男&#

62、39;,'1993.3.16','123','12060202');insert into student values('1206020202','魚(yú)玄機(jī)','女','1993.3.17','123','12060202');insert into student values('1206020203','薛濤','女','1993.3.18','123','12

63、060202');insert into student values('1206020204','徐庶','男','1993.3.19','123','12060202');insert into student values('1206020205','張亮','男','1993.3.20','123','12060202');insert into student values('1

64、206020101','貂蟬','女','1993.3.21','123','12060201');insert into student values('1206020102','呂蒙','男','1993.3.22','123','12060201');insert into student values('1206020103','許諸','男','1

65、993.3.23','123','12060201');insert into student values('1206020104','孫尚香','女','1993.3.24','123','12060201');insert into student values('1206020105','陸遜','男','1993.3.25','123','12060201'

66、;);insert into student values('1206040201','袁紹','男','1993.3.26','123','12060402');insert into student values('1206040202','張角','男','1993.3.27','123','12060402');insert into student values('1206040203&

67、#39;,'杜預(yù)','男','1994,8,13','123','12060402');insert into student values('1206040204','盧植','男','1994,8,14','123','12060402');insert into student values('1206040205','劉備','男','1994,8,15&#

68、39;,'123','12060402');insert into student values('1206040101','甘寧','男','1994,8,16','123','12060401');insert into student values('1206040102','關(guān)羽','男','1994,8,17','123','12060401');insert i

69、nto student values('1206040103','楊玉環(huán)','女','1994,8,18','123','12060401');insert into student values('1206040104','謝道韞','女','1994,8,19','123','12060401');insert into student values('1206040105','

70、;王昭君','女','1994,8,20','123','12060401');insert into student values('1205030201','賈詡','男','1994,8,21','123','12050302');insert into student values('1205030202','司馬懿','男','1992.11.1',

71、9;123','12050302');insert into student values('1205030203','蔡文姬','女','1992.11.2','123','12050302');insert into student values('1205030204','李清照','女','1992.11.3','123','12050302');insert into s

72、tudent values('1205030205','張繡','男','1992.11.4','123','12050302');insert into student values('1205030206','秋瑾','女','1992.11.5','123','12050302');insert into student values('1205030101','孔融'

73、;,'男','1992.11.6','123','12050302');insert into student values('1205030102','佘太君','女','1992.11.7','123','12050302');insert into student values('1205030103','鄧艾','男','1992.11.8','123

74、9;,'12050302');insert into student values('1205030104','龐德','男','1992.11.9','123','12050302');insert into student values('1205030105','劉彩春','女','1992.11.10','123','12050301');insert into student v

75、alues('1205060201','曹丕','男','1992.11.11','123','12050301');insert into student values('1205060202','程普','男','1992.11.12','123','12050301');insert into student values('1205060203','朱淑真',

76、9;女','1992.11.13','123','12050301');insert into student values('1205060204','虞姬','女','1992.11.14','123','12050301');insert into student values('1205060205','曹植','男','1992.11.15','123',

77、'12050602');insert into student values('1205060101','杜十娘','女','1992.11.16','123','12050602');insert into student values('1205060102','顧太青','女','1992.11.17','123','12050602');insert into student values('1205060103','黃月英','女','1992.11.18','123','1