WEB 数据库实验报告
实验(训)报告
学号:
姓名
班级:
实验时间:2012-12-28
实验地点:A4059
指导老师:
实验名称
模块开发
实验目的
掌握根据需求来开发模块
一、实验题目
1、设计一个投诉与建议模块,有管理员,教师,学生三种不同的角色。学生
和老师都可以投诉,投诉的时候要包括投诉对象,接收人,还可以选择保密
不保密,保密就是只有自己能看到,不保密所有的人都能看到。如果管理员
和教师接收到信息可以进行回复,管理员可以查看已处理和未处理的投诉信
息。还可以删除一些过时的信息。教师可以查询学生给自己的问题并进行回
复。老师和学生可以看已回复和未回复的信息
二、实验内容及结果(请将相应题目代码和结果截图写在相应题目下方)
1、登录代码:
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using DataSet1TableAdapters;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
DataSet1TableAdapters.userTableAdapter a = new
userTableAdapter();
DataSet1.userDataTable b = a.GetData(TextBox1.Text);
DataSet1.userDataTable c = a.GetDataBy(TextBox1.Text,
TextBox2.Text);
if (b.Count > 0)
{
if (c.Count > 0)
{
Session["userid"] = TextBox1.Text;
//string x = c[0].role;
if (c[0].Role == "1")
Response.Redirect("Ordinary.aspx");
else if (c[0].Role == "2")
Response.Redirect("teacher.aspx");
else if (c[0].Role == "3")
Response.Redirect("admin.aspx");
else
}
else
Label1.Text = "未知用户角色!";
Label1.Text = "密码错误!";
Label1.Text = "用户名不存在!";
}
else
}
}
2、学生代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Ordinary : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
3、教师代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class teacher : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
4、管理员代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class teacher : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
5、投诉代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using DataSet1TableAdapters;
public partial class Complaints : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if ((string)(Session["userid"]) == null)
Response.Redirect("Default.aspx");
Label1.Text = (string)(Session["userid"]);
pd_rl2();
}
public void pd_rl2()
{
if (RadioButtonList2.SelectedItem.Value == "2")
{
DataSet1TableAdapters.teacherTableAdapter a=new
teacherTableAdapter();
DataSet1.teacherDataTable b = a.GetData();
DropDownList1.Items.Clear();
for (int i = 0; i < b.Count; i++)
DropDownList1.Items.Add(new ListItem(b[i].name +
"(" + b[i].userid + ")", b[i].userid));
}
else
{
DataSet1TableAdapters.AdminTableAdapter a = new
AdminTableAdapter();
DataSet1.AdminDataTable b= a.GetData();
DropDownList1.Items.Clear();
for (int i = 0; i < b.Count; i++)
DropDownList1.Items.Add(new ListItem(b[i].name +
"(" + b[i].userid + ")", b[i].userid));
}
}
protected void Button1_Click(object sender, EventArgs e)
{
DataSet1TableAdapters.ComplaintsTableAdapter a = new
ComplaintsTableAdapter();
a.Insert(TextBox1.Text, DropDownList1.SelectedItem.Value,
RadioButtonList1.SelectedItem.Value, DateTime.Now,
Request.Form["S1"], null, DateTime.Now, "0",
(string)(Session["userid"]), TextBox2.Text);
Response.Write("投诉成功");
//Button1.Text = Request.Form["S1"];
}
protected void RadioButtonList2_SelectedIndexChanged(object
sender, EventArgs e)
{
pd_rl2();
}
protected void DropDownList2_SelectedIndexChanged(object
sender, EventArgs e)
{
DropDownList3.Visible =false;
DropDownList4.Visible = false;
TextBox1.Visible = false;
string x = DropDownList2.SelectedValue;
if (x == "2") DropDownList3.Visible = true;
else if (x == "3") DropDownList4.Visible = true;
else if (x == "4") TextBox1.Visible = true;
}
protected void DropDownList3_SelectedIndexChanged(object
sender, EventArgs e)
{
TextBox1.Text = DropDownList3.SelectedItem.Text;
}
protected void DropDownList4_SelectedIndexChanged(object
sender, EventArgs e)
{
}
}
TextBox1.Text = DropDownList4.SelectedItem.Text;
6、回复代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using DataSet1TableAdapters;
public partial class 回复 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string a=Request.QueryString["look"];
if (a == "2")
Button1.Visible = true;
else if (a == "1") {
FormView1.ChangeMode(FormViewMode.ReadOnly);
}
//Response.Write(Request.QueryString["Complaintsid"]);
}
protected void Button1_Click(object sender, EventArgs e)
{
string x=Request.QueryString["Complaintsid"];
byte y=byte.Parse(x);
DataSet1TableAdapters.ComplaintsTableAdapter a = new
ComplaintsTableAdapter();
a.UpdateQuery("2", DateTime.Now, y);
Response.Write("已拒绝回复");
}
}
结果截图:
三、实验总结