資源簡介
來自廣東工業大學
教學管理系統 數據庫課程設計 SQL-Server
源代碼工程與報告 非常完整
…………………………
一、課程設計題目
完成一個實際系統的數據庫應用系統的設計全過程。
二、課程設計內容
應包括：需求分析、數據庫設計、數據庫建立、數據輸入、應用系統的設計和開發、用戶界面的設計和實現等。
…………
（四）選題參考
1、教學管理系統
1）信息需求：
(1) 學生信息：學號、姓名、性別、出生日期、入學成績、所在系號。
(2) 教職工信息：職工號、姓名、性別、出身年月、所在系號、職稱、專業及教學方向。
(3) 系的基本信息：系號、系名稱、系的簡介。
(4) 課程信息：課程號、課程名稱、任課教師號、學時、學分、上課時間、上課地點、考試時間。
(5) 成績信息：學號、課程號、平時成績、考試成績、總評成績。
2）處理需求：
(1) 學生基本信息管理
…………
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;
namespace?CS.TeachingSystem
{
????class?Administrator?:?User
????{
????????//?Attributes?Definition
????????//?Methods?Definition
????????///?
????????///?Administrator‘s?constructor
????????///?
????????///?
????????///?
????????public?Administrator（String?UserName）?:?base（UserName?UserType.Administrator）
????????{
????????}
#region?Tooooo?Much?CopyCopyCopy........
????????///?
????????///?Select?operation?for?Administrator
????????///?Permissible?operations（QueryType）:?All?type?of?selete
????????///?
????????///?Transact-SQL?statement
????????///?Select?query?type
????????///?Teaching?system?database
????????///?Selected?DataTable
????????public?override?DataTable?Select（String?QueryString?QueryType?QT?TSDatabase?TSDB）
????????{
????????????SqlConnection?con?=?null;
????????????DataTable?DT?=?new?DataTable（）;
????????????this.ErrorMessage?=?““;
????????????//?If?it‘s?offline
????????????if?（!TSDB.IsConnected）
????????????{
????????????????//?If?fail?to?connect
????????????????if?（!TSDB.Connect（））
????????????????{
????????????????????this.ErrorMessage?+=?TSDB.ErrorMessage;
????????????????????return?null;
????????????????}
????????????}
????????????try
????????????{
????????????????con?=?TSDB.Connection;
????????????????//?If?connection?is?closed?open?first
????????????????if?（con.State?==?ConnectionState.Closed）
????????????????{
????????????????????con.Open（）;
????????????????}
????????????????//?Different?query?type
????????????????switch?（QT）
????????????????{
????????????????????case?QueryType.StudentSelect:
????????????????????case?QueryType.CourseSelect:
????????????????????case?QueryType.TeacherSelect:
????????????????????case?QueryType.ScoreSelect:
????????????????????case?QueryType.DeptSelect:
????????????????????case?QueryType.UserSelect:
????????????????????????{
????????????????????????????SqlDataAdapter?SDA?=?new?SqlDataAdapter（）;
????????????????????????????SqlCommand?SC?=?new?SqlCommand（QueryString?con）;
????????????????????????????SC.CommandType?=?CommandType.Text;
????????????????????????????SDA.SelectCommand?=?SC;
????????????????????????????int?num?=?SDA.Fill（DT）;
????????????????????????????num++;
????????????????????????}
????????????????????????break;
????????????????????default:
????????????????????????{
????????????????????????????this.ErrorMessage?=?this.ErrorMessage?+?“\nPermission?Deny:?“?+?QT.ToString（）;
????????????????????????????DT?=?null;
????????????????????????}
????????????????????????break;
????????????????}
????????????}
????????????catch?（System.Exception?ex）
????????????{
????????????????t ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????131584??2011-07-07?23:54??TeachingSystem\Application\CS.TeachingSystem.exe
?????文件????????282??2011-06-30?22:33??TeachingSystem\Application\CS.TeachingSystem.exe.config
?????文件??????23552??2011-07-06?17:41??TeachingSystem\Application\DataGridViewAutoFilter.dll
?????目錄??????????0??2011-07-09?12:08??TeachingSystem\Application
?????文件??????11378??2011-07-02?12:33??TeachingSystem\CodeProject\CS.TeachingSystem\Administrator.cs
?????文件????????282??2011-06-30?22:33??TeachingSystem\CodeProject\CS.TeachingSystem\App.config
?????文件?????131584??2011-07-07?23:54??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Debug\CS.TeachingSystem.exe
?????文件????????282??2011-06-30?22:33??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Debug\CS.TeachingSystem.exe.config
?????文件?????206336??2011-07-07?23:54??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Debug\CS.TeachingSystem.pdb
?????文件??????11600??2011-07-09?11:54??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Debug\CS.TeachingSystem.vshost.exe
?????文件????????282??2011-06-30?22:33??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Debug\CS.TeachingSystem.vshost.exe.config
?????文件????????490??2010-03-17?22:39??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Debug\CS.TeachingSystem.vshost.exe.manifest
?????文件??????23552??2011-07-06?17:41??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Debug\DataGridViewAutoFilter.dll
?????目錄??????????0??2011-07-09?12:06??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Debug
?????文件?????124928??2011-07-08?00:01??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Release\CS.TeachingSystem.exe
?????文件????????282??2011-06-30?22:33??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Release\CS.TeachingSystem.exe.config
?????文件?????183808??2011-07-08?00:01??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Release\CS.TeachingSystem.pdb
?????文件??????11600??2011-07-09?12:05??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Release\CS.TeachingSystem.vshost.exe
?????文件????????282??2011-06-30?22:33??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Release\CS.TeachingSystem.vshost.exe.config
?????文件????????490??2010-03-17?22:39??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Release\CS.TeachingSystem.vshost.exe.manifest
?????文件??????23552??2011-07-06?17:41??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Release\DataGridViewAutoFilter.dll
?????目錄??????????0??2011-07-09?12:06??TeachingSystem\CodeProject\CS.TeachingSystem\bin\Release
?????目錄??????????0??2011-07-09?12:06??TeachingSystem\CodeProject\CS.TeachingSystem\bin
?????文件???????7458??2011-07-07?11:59??TeachingSystem\CodeProject\CS.TeachingSystem\CS.TeachingSystem.csproj
?????文件???????4495??2011-07-02?19:51??TeachingSystem\CodeProject\CS.TeachingSystem\Info.cs
?????文件???????6775??2011-07-02?12:32??TeachingSystem\CodeProject\CS.TeachingSystem\Login.cs
?????文件???????9578??2011-07-01?15:09??TeachingSystem\CodeProject\CS.TeachingSystem\Login.Designer.cs
?????文件???????7796??2011-07-01?15:09??TeachingSystem\CodeProject\CS.TeachingSystem\Login.resx
?????文件???????2124??2011-07-09?11:54??TeachingSystem\CodeProject\CS.TeachingSystem\obj\x86\Debug\CS.TeachingSystem.csproj.FileListAbsolute.txt
?????文件?????131584??2011-07-07?23:54??TeachingSystem\CodeProject\CS.TeachingSystem\obj\x86\Debug\CS.TeachingSystem.exe
............此處省略129個文件信息
評論
共有 條評論
川公網安備 51152502000135號