-
大小: 32.16MB文件類型: .rar金幣: 1下載: 0 次發(fā)布日期: 2023-08-04
- 語(yǔ)言: 數(shù)據(jù)庫(kù)
- 標(biāo)簽: 數(shù)據(jù)庫(kù)??SQL??源代碼??報(bào)告??
資源簡(jiǎn)介
來(lái)自廣東工業(yè)大學(xué)
教學(xué)管理系統(tǒng) 數(shù)據(jù)庫(kù)課程設(shè)計(jì) SQL-Server
源代碼工程與報(bào)告 非常完整
…………………………
一、課程設(shè)計(jì)題目
完成一個(gè)實(shí)際系統(tǒng)的數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)的設(shè)計(jì)全過程。
二、課程設(shè)計(jì)內(nèi)容
應(yīng)包括：需求分析、數(shù)據(jù)庫(kù)設(shè)計(jì)、數(shù)據(jù)庫(kù)建立、數(shù)據(jù)輸入、應(yīng)用系統(tǒng)的設(shè)計(jì)和開發(fā)、用戶界面的設(shè)計(jì)和實(shí)現(xiàn)等。
…………
（四）選題參考
1、教學(xué)管理系統(tǒng)
1）信息需求：
(1) 學(xué)生信息：學(xué)號(hào)、姓名、性別、出生日期、入學(xué)成績(jī)、所在系號(hào)。
(2) 教職工信息：職工號(hào)、姓名、性別、出身年月、所在系號(hào)、職稱、專業(yè)及教學(xué)方向。
(3) 系的基本信息：系號(hào)、系名稱、系的簡(jiǎn)介。
(4) 課程信息：課程號(hào)、課程名稱、任課教師號(hào)、學(xué)時(shí)、學(xué)分、上課時(shí)間、上課地點(diǎn)、考試時(shí)間。
(5) 成績(jī)信息：學(xué)號(hào)、課程號(hào)、平時(shí)成績(jī)、考試成績(jī)、總評(píng)成績(jī)。
2）處理需求：
(1) 學(xué)生基本信息管理
…………
代碼片段和文件信息
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 ?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件?????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個(gè)文件信息
評(píng)論
共有 條評(píng)論
川公網(wǎng)安備 51152502000135號(hào)