web管理系统课程设计

湖北第二师范学院

《Web程序设计》

课程设计报告书

班级：12级计算机应用技术（1）班学号：

姓名：

指导老师：王海军

成绩：

设计时间：2014 年 6 月12 日

简单的Web应用系统设计、开发一.登录页面：

登录页面的设计与代码：

主要以不同的角色进去就会跳进不同的页面就会有不同的权限

源代码：

后台代码：

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 login1 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

Label7.Text = "当前时间是：" + DateTime.Now.ToString() ;

}

protected void Button1_Click(object sender, EventArgs e)

{

if (rbtstudent.Checked == false && rbtteacher.Checked == false)

{

Response.Write("");

}

else

{

if ( rbtstudent.Checked == true)

{

SqlConnection con = new SqlConnection("server=.;database=school;integrated security=SSPI");

con.Open();

SqlCommand cmd = new SqlCommand();

cmd.Connection = con;

https://www.360docs.net/doc/252175088.html,mandText = "select * from student where stdid='" + username.Text + "'and stdmm='" + userpwd.Text + "'";

//https://www.360docs.net/doc/252175088.html,mandText = "select * from achievement where stdid='" + username.Text + "'";

SqlDataReader dr = cmd.ExecuteReader();

if (dr.Read())

{

Session["stdid"] = dr[0];

Session["stdmm"] = dr["stdmm"];

Session["stdxb"]=dr["stdxb"];

Session["stdsfz"] = dr["stdsfz"];

Session["stdrxsj"] = dr["stdrxsj"];

Session["stdbj"] = dr["stdbj"];

Session["stddz"] = dr["stddz"];

Session["stddh"] = dr["stddh"];

Session["stdxm"] = dr["stdxm"];

username.Text= Session["stdid"].ToString();

userpwd.Text= Session["stdmm"].ToString();

Label4.Text = "登陆成功";

username.Text = "";//userID为textbox1

username.Enabled = false;

userpwd.Text = "";//userPWD为textbox2

userpwd.Enabled = false;

dr.Close();

Response.Redirect("students/学生主页.aspx");

// Response.Write("");

}

else

{

Response.Write("");

// Label4.Text = "用户名或密码不正当确，请重新输入";

con.Close();

}

}

if (rbtteacher.Checked==true)

{

SqlConnection con = new SqlConnection("server=.;database=school;integrated security=SSPI");

con.Open();

SqlCommand cmd = new SqlCommand();

cmd.Connection = con;

https://www.360docs.net/doc/252175088.html,mandText = "select * from teachers where thId='" + username.Text + "'and thmm='" + userpwd.Text + "'";

SqlDataReader dr = cmd.ExecuteReader();

if (dr.Read())

{

Session["thId"]=dr[0];

Session["thMm"] = dr["thMm"];

Session["thXm"] = dr["thXm"];

Session["thXb"]=dr["thXb"];

Session["thSfzh"]=dr["thSfzh"];

Session["thJsnl"]=dr["thJsnl"];

Session["thSzyx"]=dr["thSzyx"];

userpwd.Text = Session["thMm"].ToString();

username.Text = Session["thId"].ToString();

Label4.Text = "登陆成功";

username.Text = "";//userID为textbox1

username.Enabled = false;

userpwd.Text = "";//userPWD为textbox2

userpwd.Enabled = false;

dr.Close();

Response.Redirect("teachers/教师主页.aspx");

// Response.Write("");

}

else

{

Response.Write("");

// Label4.Text = "用户名或密码不正当确，请重新输入";

con.Close();

}

}

}

}

protected void Button2_Click(object sender, EventArgs e)

{

username.Text = "";

userpwd.Text = "";

Response.Redirect("login.aspx");

}

protected void rbtstudent_CheckedChanged(object sender, EventArgs e)

{

}}

二.教师主页的设计与代码：

后台代码：主要是用Response.Redirect("")语句实现跳转到各个页面;还有用session传值显示当前登录者“欢迎xx老师”。

（1）.学生信息管理（教师角色）：

主要用的是GridView控件实现学生信息查看与编辑，首先把GridViewde 的属性Visible=False把GridView控件隐藏，当点击“学生信息管理”的按钮的时候就能看到学生的信息与管理。

（2）.添加新生信息（教师角色）：

源代码：

后台代码：

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;

using System.Data.Sql;

using System.Data.SqlTypes;

public partial class techers_gradeinput : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (Session["thMm"] == null || Session["thMm"].ToString().Length == 0) Response.Redirect("~/login.aspx");

}

//添加新学生

protected void Button3_Click(object sender, EventArgs e)

{

}

protected void Button2_Click(object sender, EventArgs e)

{

Response.Redirect("teachmain.aspx");

}

protected void Button4_Click(object sender, EventArgs e)

{

Response.Redirect("gradeinput.aspx");

}

protected void FormView1_PageIndexChanging(object sender, FormViewPageEventArgs e) {

}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)

{

}

protected void LinkButton1_Click(object sender, EventArgs e)

{

}

protected void Button3_Click1(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("server=.;database=school;integrated security=SSPI");

//con.Open();

string strsql = "select count(*) from [student] where stdid='" + TextBox10.Text.Trim() + "'";

SqlCommand com = new SqlCommand(strsql, con);

con.Open();

int num = (int)com.ExecuteScalar();

if (num > 0)

{

Response.Write("");

}

else

{

string userid = TextBox10.Text.Trim();

string password = TextBox11.Text.Trim();

string name = TextBox13.Text.Trim();

string sex = DropDownList1.Text.Trim();

string shenfen = TextBox2.Text.Trim();

string ruxuesj = TextBox3.Text.Trim();

string classes = TextBox4.Text.Trim();

string zhuzhi = TextBox5.Text.Trim();

string dianhua = TextBox6.Text.Trim();

string strinsert = "insert into student(stdid,stdmm,stdxm,stdxb,stdsfz,stdrxsj,stdbj,stddz,stddh) values('"+userid +"','"+password + "','"+name+"','"+sex+"','"+shenfen+"','"+ruxuesj +"','"+classes+"','"+zhuzhi+"','"+dianhua +"')";

com = new SqlCommand(strinsert, con);

com.ExecuteNonQuery(); //插入数据

Label2.Text = "添加成功！";

//Response.Write("");

// con.Close();

//Response.Write("");

//查询userid

con.Close();??//关闭连接??

Response.Write("");

//Response.Redirect("~/.aspx");

}

}

protected void Button1_Click(object sender, EventArgs e)

{

Response.Redirect("教师主页.aspx");

}

}

（3）.教师信息管理：

主要是教师个人信息的查看与密码的修改。

后台代码：

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 techers_tpsdmodify : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (Session["thMm"] == null || Session["thMm"].ToString().Length == 0) Response.Redirect("~/login.aspx");

}

protected void Button1_Click(object sender, EventArgs e)

{

if (Page.IsValid)

{

SqlConnection cn = new SqlConnection("server=.;database=school;integrated security=SSPI");

if (this.TextBox1.Text == Session["thMm"].ToString())

{

if (this.TextBox2.Text == this.TextBox3.Text)

{

SqlCommand cmd = new SqlCommand("update teachers set thMm='" + this.TextBox2.Text + "' where thMm='" + Session["thMm"].ToString() + "'", cn);

cn.Open();

cmd.ExecuteNonQuery();

cn.Close();

Response.Write("");

// Response.Redirect("~/login1.aspx");

}

else

{

Response.Write("");

this.TextBox2.Text = "";

this.TextBox3.Text = "";

}

}

else

{

Response.Write("");

this.TextBox1.Text = "";

this.TextBox2.Text = "";

this.TextBox3.Text = "";

}

}

}

/* if (spassword.Trim() != TextBox1.Text)

{

Label8.Text = "对不起，您输入的密码有误！";

return;

}*/

protected void Button2_Click(object sender, EventArgs e) {

//TextBox1.Text = "";

//TextBox2.Text = "";

//TextBox3.Text = "";

Response.Redirect("教师主页.aspx");

}

protected void Button3_Click(object sender, EventArgs e)

{

Response.Redirect("~/login.aspx");

}

}

6.教师个人密码的修改：

后台代码：

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 techers_tpsdmodify : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (Session["thMm"] == null || Session["thMm"].ToString().Length == 0) Response.Redirect("~/login.aspx");

}

protected void Button1_Click(object sender, EventArgs e)

{

if (Page.IsValid)

{

SqlConnection cn = new SqlConnection("server=.;database=school;integrated security=SSPI");

if (this.TextBox1.Text == Session["thMm"].ToString())

{

if (this.TextBox2.Text == this.TextBox3.Text)

{

SqlCommand cmd = new SqlCommand("update teachers set thMm='" + this.TextBox2.Text + "' where thMm='" + Session["thMm"].ToString() + "'", cn);

cn.Open();

cmd.ExecuteNonQuery();

cn.Close();

Response.Write("");

// Response.Redirect("~/login1.aspx");

}

else

{

Response.Write("");

this.TextBox2.Text = "";

this.TextBox3.Text = "";

}

}

else

{

Response.Write("");

this.TextBox1.Text = "";

this.TextBox2.Text = "";

this.TextBox3.Text = "";

}

}

}

/* if (spassword.Trim() != TextBox1.Text)

{

Label8.Text = "对不起，您输入的密码有误！";

return;

}*/

protected void Button2_Click(object sender, EventArgs e)

{

//TextBox1.Text = "";

//TextBox2.Text = "";

//TextBox3.Text = "";

Response.Redirect("教师主页.aspx");

}

protected void Button3_Click(object sender, EventArgs e)

{

Response.Redirect("~/login.aspx");

}

}

7.插入学生的成绩（教师角色）：

代码的实现：主要用DetailsView控件新建功能,插入学生的成绩.

二．学生角色：

主要有查看个人的成绩与管理个人信息。

学生主页：

学生个人信息：

成绩的查询：

个人信息与个人成绩查询：主要是通过session传值的功能显示当前用户的相关的信息！！！

结束语：

设计实验我选做的是学生信息管理系统，实现最基本的查询、添加、删除、更新功能。实验结果的界面图如代码中的界面图所示，只是在执行时要输入相应的信息以满足“查看”、“添加”、“删除”、“更新”最基本的要求。我我刚开始的时候怎么都动不了手，然后有查了好多的资料，根本就不能用照打出来就出现了好多的错误的：最后没有办法了就想了一下把一个大概的框架做出来然后再一步完善，

一个功能一个功能的去修改代码与查看资料；最后把系统做出来之后，大多书的代码都知道了它的用处与功能。。。。。。。。。

主要的参考质料：

《https://www.360docs.net/doc/252175088.html, 4.0 Web 程序设计》刘艳丽张恒

《ASP。NET+SQL Server动态网站的开发》杨鲲鹏孟凡琦

。。。。。。。。