【正文】
mmyInfo 主鍵 : 姓名 name 列名 ( 中文 ) 列名 ( 英文 ) 數(shù)據(jù)類型 寬度 是否為空 序號(hào) id int 4 No 班級(jí) depart char 20 Yes 姓名 name varchar 20 No 性別 gender char 2 No 單位 ( 組織 ) anize varchar 20 Yes 出生日期 bthday smalltime 4 Yes 民族 nation char 5 Yes 籍貫 ntvpl varchar 20 Yes 學(xué)歷 enducation varchar 6 Yes 入黨時(shí)間 initiate smalltime 4 Yes 轉(zhuǎn)正時(shí)間 worktime smalltime 4 Yes 職務(wù) duty char 20 Yes 備注 remark varchar 50 Yes 表 6 發(fā)展學(xué)生基本信息表 預(yù)備學(xué)生基本信息表 PreCommyInfo 主鍵 : 姓名 name 列名 ( 中文 ) 列名 ( 英文 ) 數(shù)據(jù)類型 寬度 是 否為空 序號(hào) id int 4 No 班級(jí) depart char 20 Yes 姓名 name varchar 20 No 性別 gender char 2 No 出生日期 bthday smalltime 4 Yes 民族 nation char 5 Yes 籍貫 ntvpl varchar 20 Yes 學(xué)歷 enducation varchar 6 Yes 申請(qǐng)時(shí)間 apltime smalltime 4 Yes 入黨時(shí)間 initiate smalltime 4 Yes 備注 remark varchar 50 Yes 表 7 預(yù)備學(xué)生基本信息表 黨課安排表 Arrange 主鍵:課次 order 列名(中文) 列名(英文) 數(shù)據(jù)類型 寬度 是否為空 序號(hào) id int 4 No 課次 order char 20 No 時(shí)間 date smalldatetime 4 Yes 主題 subject varchar 20 Yes 內(nèi)容 content varchar 50 Yes 表 8 黨課安排表 管理員基本信息表 Admin 主鍵 : 姓名 name 列名 ( 中文 ) 列名 ( 英文 ) 數(shù)據(jù)類型 寬度 是否為空 姓名 name char 20 No 密碼 password char 20 No 表 9 管理員基本信息表 用戶基本信息表 UserInfo 主鍵 : 姓名 name 列名 ( 中文 ) 列名 ( 英文 ) 數(shù)據(jù)類型 寬度 是否為空 序號(hào) id int 4 No 班級(jí) depart char 20 Yes 姓名 username varchar 20 No 性別 gender char 2 No 出生日期 bthday smalltime 4 Yes 民族 nation char 5 Yes 籍貫 ntvpl varchar 20 Yes 學(xué)歷 enducation varchar 6 Yes 密碼 password varchar 20 NO 政治面貌 political char 10 Yes 備注 remark varchar 50 Yes 表 10 用戶基本信息表 另外 , 本數(shù)據(jù)庫(kù)中的表并未定義外鍵 , 數(shù)據(jù)的一致性保持通過(guò)程序來(lái)完成。 ASP是一個(gè)已編譯的、基于 ASP的環(huán)境,可以用任何與 ASP兼容的語(yǔ)言包括 Visual Basic。隨著 Inter的滲透,數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)開(kāi)發(fā)及實(shí)施的方法發(fā)生了重大的變化,從 Client/Server體系的二層結(jié)構(gòu)擴(kuò)展到了由 Web瀏覽器、應(yīng)用服務(wù)器、數(shù)據(jù)庫(kù)服務(wù)器組成的 Browser/Server體系的三層結(jié)構(gòu)。 開(kāi)發(fā)動(dòng)態(tài) Web數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng),主要使用到 ASP框架技術(shù)中的 ADOASP組件和 ASP技術(shù)。利用 SqlDataAdapter對(duì)象的 Fill方法可將數(shù)據(jù)庫(kù)中的數(shù)據(jù)讀到DataSet中。例: 執(zhí)行查詢 SQL的語(yǔ)句 ,返回一個(gè)數(shù)據(jù)表: public static DataTable executeQuery(string QueryString) { DataTable MyDataTable=new DataTable()。 } 執(zhí)行非查詢 語(yǔ)句 , 對(duì)數(shù)據(jù)庫(kù)進(jìn)行操作 : public static void executeNonQuery(string cmdText) { try { MysqlConnection .Open()。 DataGrid含有幾個(gè)屬性可以提高其可用性。若 DataGrid的AutoGenerateColumns屬性被設(shè)置為假,會(huì)阻止控件自動(dòng)生成列,而讓用戶負(fù)責(zé)定義將要在表中表示的列。指定列集合使用戶可以控制每列的類型。設(shè)置的若干項(xiàng)目樣式,如 headerStyle和 Alternating 、 ItemStyle。 DataGrid處理命令事件,該事件是通過(guò)包含在其項(xiàng)目中的按鈕觸發(fā)的。它識(shí)別標(biāo)準(zhǔn)命 “Delete”,并通過(guò)觸發(fā)此事件來(lái)將此更改通知用戶的代碼。 DataGrid的第二個(gè)缺陷是它的性能。其功能基本符合用戶需求,實(shí)現(xiàn)了基本信息的添加、刪除、更新、瀏覽,黨費(fèi)收繳管理,日常事務(wù)的提醒,以及信息發(fā)布等幾個(gè)方面的功能。程序的功能方面也還是很欠缺的。還要感 謝四年來(lái)傳授給我知識(shí),教給我人生哲理的敬愛(ài)的老師們,謝謝你們讓我擁有了一段值得思考、回味的大學(xué)生活。 Napoleon was at St. Helena。s head into the fountain of the FlowerMarket. They had begun to feel anxious at the Naval Department, on account of the lac k of news from that fatal frigate, The Medusa, w hich was destined to cover Chaumareix with infamy and Gericault with l Selves was going to Egypt to bee SolimanPasha. The palace of Thermes, in the Rue de La Harpe, served as a shop for a the platform of the octagonal tower of the Hotel de Cluny, the little shed of boards, w hich had served as an observatory to Messier, the naval astronomer under Louis XVI., was still to be Duchesse de Duras read to three or four friends her unpublished Ourika, in her boudoir furnished by X. in sky blue satin. The N39。 otherwise the monarchical principle would have received a the Council of Ministers the question was agitated whether vigtes representing slackrope performances, which adorned Franconi39。Mahoney, and De Chappedelaine were preparing the sketch, to some extent with Monsieur39。 M. de Salaberry was not satisfied. The edian Picard, who belonged to the Academy, which the edian Moliere had not been able to do, had The Two Philiberts played at the Odeon, upon whose pediment the removal of the letters still allowed THEATRE OF THE EMPRESS to be plainly read. People took part for or against Cug de Montarlot. Fabvier was factious。s instruments spread out before him, cleaning his teeth, which were charming, while he dictated The Monarchy according to the Charter to M. Pile, his secretary. Criticism, assuming an authoritative tone, preferred Lafon to Talma. M. de Feletez signed himself A.。 Descartes plained of it in his exile. Now David, having, in a Belgian publication, shown some displeasure at not receiving letters which had been written to him, it struc k the royalist journals as amusing。Albe and MalekAdel were masterpieces。 Odry did not yet exist. Madame Saqui had succeeded to were still Prussians in France. M. Delalot was a had just asserted itself by cutting off the hand, then the head, of Pleignier, of Carbonneau, and of Prince de Talleyrand, grand chamberlain, and the Abbe Louis, appointed minister of finance, laughed as they looked at each other, with the laugh of the two augurs。s pew of SaintGermaindesPres, in his costume of a peer of France, with his red ribbon and his long nose and the majesty of profile peculiar to a man who has performed a brilliant action. The brilliant action performed by M. Lynch was this: being mayor of Bordeaux, on the 12th of March, 1814, he had surrendered the city a little too promptly to M. the Duke d39。 參考文獻(xiàn) 2 發(fā)展學(xué)生工作手冊(cè) . 北京:黨建讀物出版社, 2020年 . 3 薩師煊 ,王珊 . 數(shù)據(jù)庫(kù)系統(tǒng)概論 . 北京:高等教育出版社, 1991年 . 4 閃四清 . 數(shù)據(jù)庫(kù)系統(tǒng)原理與應(yīng)用 . 北京:清華大學(xué)出版社, 2020年 . 5 陳英學(xué) . ASP深入編程 . 北京 :北京希望電子出版社, 2020年 . 6 明月創(chuàng)作室著 . ASP編程精彩百例 . 北京 :人民郵電出版社, 2020年 . 7 劉福太等譯 . ASP高級(jí)編程 . 北京:機(jī)械工業(yè)出版社, 2020年 . 8 張海藩 . 軟件工程 . 北京:人民郵電出版社, 2020年 . 9 劉楊等編著 .突破 C編程實(shí)例五十講 . 北京:中國(guó)水利水電出版社, 2020年 . 10 ASP完全入門(mén) . 11 黃梯云 . 管理信息系統(tǒng) . 北京:高等教育出版社, 2020年 . 12 Alex Homer and Dave Sussman. Inside ASP Web Matrix. Published by Wrox Press Ltd, 1999. 13 Mesbah Ahmed and Chris Garrett and Jeremy Faircloth Chris Payne . ASP Web Developer’s Guide. Pu blished by Syngre Publishing, Inc, 2020. 14 Karil Watson. marco bellinaso. Beginning C. 北