資源簡介
通過該系統(tǒng)，學(xué)校不同角色的用戶可以通過網(wǎng)路完成選課系統(tǒng)功能：管理員通過該系統(tǒng)實現(xiàn)對學(xué)生、教師、課程的添加和維護和學(xué)生成績的維護；教師通過該系統(tǒng)實現(xiàn)查看課程選修情況和錄入學(xué)生成績；學(xué)生通過該系統(tǒng)實現(xiàn)選課、退課等功能；還有公有模塊：修改密碼功能。
\MyElectCourse \DB \MyElectCourse.sql 網(wǎng)上選課系統(tǒng)數(shù)據(jù)數(shù)據(jù)庫創(chuàng)建腳本
\MyElectCourse \DB \MyElectCourse.bak 網(wǎng)上選課系統(tǒng)數(shù)據(jù)數(shù)據(jù)庫備份
\MyElectCourse \Images\ 網(wǎng)上選課系統(tǒng)圖片文件夾
\MyElectCourse \Controls\left.ascx 網(wǎng)上選課系統(tǒng)用戶控件
\MyElectCourse \Login.aspx 登錄頁面
\MyElectCourse \Main.aspx 管理員主頁面
\MyElectCourse \adminStudentAdd.aspx 添加學(xué)生頁面
\MyElectCourse \adminStudentDetails.aspx 學(xué)生維護頁面
\MyElectCourse \adminCourse.aspx 添加課程頁面
\MyElectCourse \adminCourseDetails.aspx 課程維護頁面
\MyElectCourse \adminTeacherAdd.aspx 添加教師頁面
\MyElectCourse \adminTeacherDetails.aspx 教師維護頁面
\MyElectCourse \adminStudentScore.aspx 成績維護頁面
\MyElectCourse \studentElect.aspx 學(xué)生選課頁面
\MyElectCourse \courseDetail.aspx 課程詳細信息頁面
\MyElectCourse \teacherQueryElect.aspx 教師查詢選課情況頁面
\MyElectCourse \teacherSubmitScore.aspx 教師提交成績頁面
\MyElectCourse \ModifyPwd.aspx 修改密碼頁面
代碼片段和文件信息
using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Data.SqlClient;
public?partial?class?adminCourse?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（!this.IsPostBack）
????????{
????????????ddlBind（）;
????????????CourceDetailsShow（）;
????????}
????}
????private?void?ddlBind（）
????{
????????string?connStr?=?ConfigurationManager.ConnectionStrings[“ConnectionString“].ConnectionString;???//取出連接字符串
????????string?SqlStr?=?“SELECT?teaIDteaName?from?Teacher“;
????????DataSet?ds?=?new?DataSet（）;
????????SqlConnection?conn?=?new?SqlConnection（connStr）;????//創(chuàng)建連接對象
????????if?（conn.State.ToString（）?==?“Closed“）??????????????//如果連接關(guān)閉打開
????????????conn.Open（）;
????????SqlDataAdapter?da?=?new?SqlDataAdapter（SqlStr?conn）;
????????da.Fill（ds）;????????????????????????????????????????//從數(shù)據(jù)庫中取數(shù)據(jù)放到DataSet數(shù)據(jù)集中
????????if?（conn.State.ToString（）?==?“Open“）
????????????conn.Close（）;
????????ddlTeacherName.DataSource?=?ds.Tables[0].DefaultView;
????????ddlTeacherName.DataTextField?=?“teaName“;?????????????//下拉列表框每項顯示教師姓名
????????ddlTeacherName.DataValueField?=?“teaID“;??????????????//下拉列表框每項的值為教師編號
????????ddlTeacherName.DataBind（）;????????
????}
????private?void?CourceDetailsShow（）
????{
????????string?connStr?=?ConfigurationManager.ConnectionStrings[“ConnectionString“].ConnectionString;???//取出連接字符串
????????string?SqlStr?=?“SELECT?Cource.*Teacher.teaName?from?CourceTeacher?where?Cource.teaID=Teacher.teaID?and?Cource.courceID=‘“?+?Request[“courceID“].ToString（）?+?“‘?and?Cource.teaID=‘“?+?Request[“teaID“].ToString（）?+?“‘“;
????????SqlConnection?conn?=?new?SqlConnection（connStr）;????//創(chuàng)建連接對象
????????try
????????{
????????????if?（conn.State.ToString（）?==?“Closed“）??????????//連接如果關(guān)閉，打開
????????????????conn.Open（）;
????????????SqlCommand?cmd?=?new?SqlCommand（SqlStr?conn）;
????????????SqlDataReader?sdr?=?cmd.ExecuteReader（）;
????????????if?（sdr.Read（））
????????????{
????????????????courceName.Text?=?sdr[“courceName“].ToString（）;
????????????????txtName.Text?=?sdr[“courceName“].ToString（）;
????????????????ddlTeacherName.SelectedItem.Text?=?sdr[“teaName“].ToString（）;
????????????????txtTime.Text?=?sdr[“courceTime“].ToString（）;
????????????????txtAddress.Text?=?sdr[“courceAddress“].ToString（）;
????????????????txtDetails.Text?=?sdr[“courceInfo“].ToString（）;
????????????}
????????????else
????????????{
????????????????Response.Write（“數(shù)據(jù)庫錯誤，沒查詢到該門課程！“）;
????????????????Response.End（）;
????????????}
????????}
????????catch?（Exception?ex）????????????????????????????????//異常處理
????????{
????????????Response.Write（“數(shù)據(jù)庫錯誤，錯誤原因：“?+?ex.Message）;
????????????Response.End（）;
????????}
????????finally
????????{
????????????if?（conn.State.To ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????2330??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminCourse.aspx
?????文件???????4908??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminCourse.aspx.cs
?????文件???????9713??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminCourseDetails.aspx
?????文件???????8518??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminCourseDetails.aspx.cs
?????文件???????3516??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminStudentAdd.aspx
?????文件???????2607??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminStudentAdd.aspx.cs
?????文件???????4824??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminStudentDetails.aspx
?????文件???????7840??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminStudentDetails.aspx.cs
?????文件???????3574??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminStudentScore.aspx
?????文件???????8329??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminStudentScore.aspx.cs
?????文件???????2227??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminTeacherAdd.aspx
?????文件???????2420??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminTeacherAdd.aspx.cs
?????文件???????3328??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminTeacherDetails.aspx
?????文件???????5711??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\adminTeacherDetails.aspx.cs
?????文件???10485760??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\App_Data\ASPNETDB.MDF
?????文件?????516096??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\App_Data\aspnetdb_log.ldf
?????文件???????2224??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\Controls\left.ascx
?????文件????????534??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\Controls\left.ascx.cs
?????文件???????1977??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\courseDetail.aspx
?????文件???????2461??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\courseDetail.aspx.cs
?????文件???????9502??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\DB\ElectClass.sql
?????文件???????1265??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\Images\ADD.GIF
?????文件???????1056??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\Images\Close.GIF
?????文件????????505??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\Images\CONFIRM.GIF
?????文件???????1584??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\Images\FangKuai.gif
?????文件???????1073??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\Images\Login.GIF
?????文件????????322??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\Images\mm.gif
?????文件????????922??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\Images\movetool1.gif
?????文件????????171??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\Images\movetoolright1.gif
?????文件????????988??2007-03-05?17:25??網(wǎng)上選課系統(tǒng)\MyElectCourse\Images\name.gif
............此處省略30個文件信息
評論
共有 條評論
川公網(wǎng)安備 51152502000135號