【正文】
以進(jìn)入系統(tǒng)。 用戶管理頁(yè)面效果圖批量添加新用戶則默認(rèn)將用戶的姓名等于ID,自動(dòng)生成學(xué)生用戶信息,信息的修改則由學(xué)生用戶登陸系統(tǒng)后自行操作。 系統(tǒng)操作日志頁(yè)面效果圖 獎(jiǎng)勵(lì)與處罰管理獎(jiǎng)勵(lì)與處分管理模塊包括獎(jiǎng)勵(lì)類型、獎(jiǎng)勵(lì)管理、處罰類型、處罰管理。 綜合測(cè)評(píng)管理數(shù)據(jù)流圖添加了3個(gè)SQL存儲(chǔ)過(guò)程1) Reward_Self用于計(jì)算用戶某學(xué)年某測(cè)評(píng)的獎(jiǎng)勵(lì)得分。 + Year + 39。Summ39。, 39。 From MSS_Reward Left join MSS_Reward_Type on = Where = Reward_Year And = Reward_Eval_Type Group By User_ID Order by Summ Desc GO 3) Punish_Self用于計(jì)算用戶某學(xué)年的扣分。 + Year + 39。Summ39。[9]德育獎(jiǎng)勵(lì)分=原始獎(jiǎng)勵(lì)分247。滿分100分,由基本分、獎(jiǎng)勵(lì)分和扣分部分構(gòu)成,其中基本分占85%,獎(jiǎng)勵(lì)分占15%。[9]兩個(gè)存儲(chǔ)過(guò)程Intel_SelfMark、Intel_MaxMark計(jì)算本人學(xué)年平均學(xué)分績(jī)點(diǎn)、班級(jí)學(xué)年最高平均學(xué)分績(jī)點(diǎn)。 添加新智育測(cè)評(píng)效果 綜合測(cè)評(píng)綜合素質(zhì)測(cè)評(píng)成績(jī)的計(jì)算方法:綜合素質(zhì)測(cè)評(píng)總分=德育測(cè)評(píng)得分20%+智育測(cè)評(píng)得分60%+文體測(cè)評(píng)得分10%+能力測(cè)評(píng)得分10%。將數(shù)據(jù)庫(kù)技術(shù)應(yīng)用到B/S體系結(jié)構(gòu)中.實(shí)現(xiàn)以前單機(jī)及C/S結(jié)構(gòu)不能達(dá)到的功能和性能,提高軟件的可重用性和可維護(hù)性。參考文獻(xiàn)[1] 李康滿,[J].電腦知識(shí)與技術(shù),2006(1):19107。[5] 馬曉虎,基于B/S結(jié)構(gòu)的通用學(xué)生管理系統(tǒng)的開發(fā)[J].電腦知識(shí)與技術(shù),2006(1):2275。[9] [M].,[10] Nidal Yousef Abu and Implementation an OnLine Computer Store Shopping System Using .NET and Web Services Technologies[D]中南大學(xué),2004.[11] Oboile and Implementation of an Online Digital Library System[D]中南大學(xué),2004.[12] Sales and Management System: Design and Implementation with and MultiTier Architecture[D]中南大學(xué),2004.The Student Mangement System Base on ——User Management, Safety Management Module,Reward and Punishment Management Module,Comprehensive Assessment Management ModuleAbstract: Using and SQL Server 2000 database technology ,people can manage the classes with student management system,which have the function of assisting instructors and counselors class to carry on class management. Class instructors can be conveyed through a systematic understanding of the various classes of information and can conduct prehensive evaluation。 Comprehensive Assessment 。 Students can inquire to the relevant state and information of their function of the user management, safety management, reward and punishment management and Comprehensive Assessment Man