【正文】 I Visual_Basic SQL 學(xué)生信息管理系統(tǒng) 畢業(yè)設(shè)計(jì) 摘 要 本系統(tǒng)后臺(tái)數(shù)據(jù)庫(kù)采用 SQL Server 2020 建立，前端應(yīng)用程序采用 Visual Basic 開(kāi)發(fā)。 在 Visual Basic 中對(duì) Microsoft Active Data Object 部件的引用，并通過(guò)文件 DSN 的方式對(duì)數(shù)據(jù)庫(kù)進(jìn)行訪問(wèn)和操作。 此學(xué)生信息管理系統(tǒng)針對(duì)四川傳媒學(xué)院的具體情況進(jìn)行設(shè)計(jì)， 管理員登錄后能對(duì)班級(jí)信息、課程信息、學(xué)生基本信息、學(xué)生獎(jiǎng)懲信息進(jìn)行管理，包括對(duì)信息的添加、刪除和 更改，同時(shí)管理員能對(duì)訪問(wèn)者的權(quán)限進(jìn)行管理。教師用戶(hù)能對(duì)自己所擔(dān)任課程進(jìn)行課表查詢(xún)、成績(jī)管理。學(xué)生用戶(hù)登錄后能對(duì)自己的基本信息進(jìn)行確認(rèn)、查詢(xún)成績(jī)以及申請(qǐng)獎(jiǎng)學(xué)金。 本系統(tǒng)經(jīng)過(guò)多臺(tái)計(jì)算機(jī)測(cè)試，運(yùn)行正常，相對(duì)穩(wěn)定。且系統(tǒng)初具規(guī)模，基本能勝任四川傳媒學(xué)院的學(xué)生綜合信息管理。 關(guān)鍵詞： 學(xué)生管理系統(tǒng) 信息管理系統(tǒng) 管理系統(tǒng) 學(xué)生信息管理 II Abstracts This system use SQL Server 2020 to build the backstage database, and use Visual Basic to development the application program. In the Visual Basic, we select the Microsoft Active Data Object then we can opera the Database through file DSN. This student information system build for Sichuan Media College based on her detail, Administrators could management the class information, class information, students information after they signed in, and they also have right to build, delete or change information, what’s more, Administrators can management the right that who use this information system. Teachers can management their classes score, and they have right to know their course arrangement. Students can confirmation themselves information after they signed in, and they can check their course score. Applying for a scholarship in this system is a good choice too. The Sichuan media college students39。 information management system has tested on many PCs, they work quietly, safety and fast. And this system is a large system, could work for Sichuan Media College. Keywords: Students management system MIS Management system Students information management III 目 錄 1 前言 ......................................................................................................................... 1 2 開(kāi)發(fā)工具介紹 .......................................................................................................... 2 SQL Server 2020 簡(jiǎn)介 ........................................................................................ 2 Visual Basic 簡(jiǎn)介 ......................................................................................... 3 ADO 組件的主要對(duì)象及其功能 ........................................................................ 5 本系統(tǒng) Visual Basic 訪問(wèn)數(shù)據(jù)庫(kù)方法 ........................................................... 5 3 系統(tǒng)分析與設(shè)計(jì) ....................................................................................................... 7 系統(tǒng)功能分析 .................................................................................................... 7 系統(tǒng)結(jié)構(gòu)圖 ....................................................................................................... 7 系統(tǒng) E— R 圖 .................................................................................................... 8 數(shù)據(jù)庫(kù)設(shè)計(jì) ....................................................................................................... 8 4 系統(tǒng)具體實(shí)現(xiàn) ........................................................................................................ 11 模塊設(shè)計(jì) ......................................................................................................... 11 登錄窗體設(shè)計(jì) .................................................................................................. 12 系統(tǒng)主界面的設(shè)計(jì) .......................................................................................... 15 班級(jí)信息管理設(shè)計(jì) .......................................................................................... 18 學(xué)生基本信息維護(hù) .......................................................................................... 20 課程信息維護(hù) .................................................................................................. 22 教務(wù)信息模塊設(shè)計(jì) .......................................................................................... 23 獎(jiǎng)懲信息模塊設(shè)計(jì) .......................................................................................... 26 學(xué)費(fèi)信息模塊設(shè)計(jì) .......................................................................................... 28 管理員信息模塊設(shè)計(jì) ................................................................................... 30 5 結(jié)論 ....................................................................................................................... 33 致 謝 ........................................................................................................................... 34 參考文獻(xiàn) ....................................................................................................................... 35 1 1 前言 學(xué)生 信息 管理系統(tǒng)是一個(gè)教育單位不可缺少的部分 ,它的內(nèi)容對(duì)于學(xué)校的決策者和管理者來(lái)說(shuō)都至關(guān)重要。 長(zhǎng)期 以來(lái)人們使用傳統(tǒng) 紙質(zhì)檔案 的方式管理 學(xué)生信息 ，這種管理方式存在著許多缺點(diǎn) ， 如 ： 效率低、保密性差 ，而且長(zhǎng)時(shí)間會(huì) 產(chǎn)生大量的文件和數(shù)據(jù) ， 這對(duì)于查找、更新和維護(hù)都帶來(lái)了 不便 。 隨著科學(xué)技術(shù)的不斷提高 ， 計(jì)算機(jī)科學(xué)日漸成熟 ，逐漸應(yīng)用到各個(gè)領(lǐng)域 。作為計(jì)算機(jī)應(yīng)用的一部分 ， 使用計(jì)算機(jī)對(duì)學(xué)生信息進(jìn)行管理 ，