JavaWeb课程设计

Web系统开发技术课程设计题目：图书征集反馈系统系别：信息工程学院专业（含班级）：XXXXXX学号：XXXXXX姓名：XXX指导教师：XXX 职称讲师填表日期：2013 年 1 月 6 日一、选题的依据及意义：反馈是传播活动的重要环节。

通过反馈，受众表达自己对传者及讯息的意见；传者借以检验传播效果是否理想，传播目的是否达到，并了解受众的信息需求，改进、优化自己的传播行为。

信息传播系统在传者受者的互动中不断地趋于合理。

图书出版传播的读者反馈对出版者具有十分重要的价值和意义，它可以显化目标市场，凸显读者需求，矫正编辑视角，改进编辑业务，提高出版质量，实现最佳出版传播效果。

当前的出版社面临的各种问题和挑战，如选题重复、退货频繁、库存积压，以及其他媒体和国外出版企业带来的激烈竞争，使构建图书读者反馈机制，从而科学高效的利用读者反馈信息，了解市场动态，明晰读者需求，消减出版传播隔阂与障碍，提高出版活动的市场预见性，缩小出版提供和读者需求之间的差距，成为出版业进一步发展的必然要求。

出版者市场意识、读者意识的觉醒，读者反馈意识的增强，各种通讯技术的发展带来空前便利的反馈渠道，使图书读者反馈机制的构建具备了现实可能性。

二、本课程设计内容要求实现图书征集反馈系统，主要实现读者注册账号，管理员对读者进行操作，读者填写反馈表等操作。

该系统可划分为两个角色：1．管理员角色；管理员角色主要涉及一下操作：1）对用户管理：主要对用户信息进行添加、删除、修改等。

2）系统设置2．用户角色；用户角色主要涉及以下操作：1）注册账号2）登录系统3）填写图书反馈表三、研究目标任何商品要想占领市场，必须满足消费者的需求，获得消费者的认可。

网络书店上的读者评论，图书里附带的读者调查表，出版社网站上的留言板等等，这些让读者说话、与编辑者沟通的渠道和行为总是深受读者的青睐。

本系统力争成为最低成本、最短的期限完成让读者最为青睐的交流平台；系统具有良好的扩展性能和便捷的维护性能。

Web系统开发技术课程设计实现方案一、需求分析1.需求调查1）管理员：管理可以对用户进行操作，如添加、修改、删除等。

2）用户：用户可以注册完账号后登录系统填写图书反馈表。

2.数据字典二、实现方案注册界面：其实现代码为：public partial class zhuce_zhuce : System.Web.UI.Page {protected void Page_Load(object sender, EventArgs e){}protected void Button1_Click(object sender, EventArgs e){//建立连接SqlConnection conn = new SqlConnection();conn.ConnectionString =ConfigurationManager.ConnectionStrings["authConnStr"].ConnectionString;//创建连接数据库对象//建立命令SqlCommand cmd = new SqlCommand();cmd.Connection = conn;mandText = "insert into user_info123(username,password,email,age,post) values(@username,@password,@email,@age,@post)";//往存储过程传递参数SqlParameter param_1 = new SqlParameter("@username", this.TextBox1.Text);SqlParameter param_2 = new SqlParameter("@password",this.TextBox2.Text);SqlParameter param_3 = new SqlParameter("@email",this.TextBox4.Text);SqlParameter param_4 = new SqlParameter("@age",Convert.ToInt32(this.TextBox5.Text));SqlParameter param_5 = new SqlParameter("@post",Convert.ToInt32(this.TextBox6.Text));cmd.Parameters.Add(param_1);cmd.Parameters.Add(param_2);cmd.Parameters.Add(param_3);cmd.Parameters.Add(param_4);cmd.Parameters.Add(param_5);conn.Open();//打开连接//执行命令int val = cmd.ExecuteNonQuery();if (val > 0){this.lblmsg.Text = "注册成功！" + "<a href='Login.aspx'>登录</a>";}else{this.lblmsg.Text = "用户注册失败！请重新检查注册信息";}}protected void Button2_Click(object sender, EventArgs e){this.TextBox1.Text = "";this.TextBox2.Text = "";this.TextBox3.Text = "";this.TextBox4.Text = "";this.TextBox5.Text = "";this.TextBox6.Text = "";}}管理员登录界面：其实现代码为：public partial class Login : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){}public Boolean findAdmin(string username, string password){SqlConnection conn = new SqlConnection();conn.ConnectionString =ConfigurationManager.ConnectionStrings["authConnStr"].ConnectionString;//创建连接数据库对象conn.Open();SqlCommand cmd = new SqlCommand("select count(*) as a from admin_info where username='" + username + "' and password='" + password + "'", conn);int count = Convert.ToInt32(cmd.ExecuteScalar());if (count > 0){Session["username"] = username;return true;}else{Response.Write("<script>alert('用户名或者密码错误，请重新输入！');history.back()</script>");return false;}}public Boolean findusers(string username, string password){SqlConnection conn = new SqlConnection();conn.ConnectionString =ConfigurationManager.ConnectionStrings["authConnStr"].ConnectionString;//创建连接数据库对象conn.Open();SqlCommand cmd = new SqlCommand("select count(*) as a from user_info123 where username='" + username + "' and password='" + password + "'", conn);int count = Convert.ToInt32(cmd.ExecuteScalar());if (count > 0){Session["username"] = username;return true;}else{Response.Write("<script>alert('用户名或者密码错误，请重新输入！');history.back()</script>");return false;}}protected void Button1_Click1(object sender, EventArgs e){//建立连接string username = ername.Text;string password = this.pwd.Text;string roleName = this.Role.SelectedValue;if (roleName == "admin"){if (Roles.IsUserInRole("许建清", "admin")){if (findAdmin(username, password)){FormsAuthentication.RedirectFromLoginPage(roleName, false);Response.Redirect("~/Edit/admin.aspx");}else{Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "clientScript","<script language=javascript>alert('用户名或密码不正确，请重新输入！');</script>");ername.Text = "";this.pwd.Text = "";}}else{Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "clientScript","<script language=javascript>alert('你选择的角色不正确！');</script>");ername.Text = "";this.pwd.Text = "";}}if (roleName == "users"){if (Roles.IsUserInRole("李四", "users")){if (findusers(username, password)){FormsAuthentication.RedirectFromLoginPage(roleName, false);Response.Redirect("~/Feedback/Feedback.aspx");}else{Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "clientScript","<script language=javascript>alert('用户名或密码不正确，请重新输入！');</script>");ername.Text = "";this.pwd.Text = "";}}else{Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "clientScript","<script language=javascript>alert('你选择的角色不正确！');</script>");ername.Text = "";this.pwd.Text = "";}}}protected void CreateRoles(){Roles.CreateRole("管理员");Roles.CreateRole("用户");}protected void Authorize(){Roles.AddUserToRole("许建清", "admin");Roles.AddUserToRole("李四", "users");}protected void Button2_Click(object sender, EventArgs e){}}管理员操作界面：其实现代码为：public partial class admin_welcome : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){DataBindToGridView();}}public void DataBindToGridView(){SqlConnection conn = new SqlConnection();conn.ConnectionString =ConfigurationManager.ConnectionStrings["authConnStr"].ConnectionString;//创建连接数据库对象//建立命令SqlCommand cmd = new SqlCommand();mandText = "select * from user_info123";cmd.Connection = conn;SqlDataAdapter sda = new SqlDataAdapter();sda.SelectCommand = cmd;DataSet ds = new DataSet();sda.Fill(ds, "user_info123");this.GridView1.DataSource = ds.Tables[0];this.GridView1.DataBind();}protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) {this.GridView1.PageIndex = e.NewPageIndex;DataBindToGridView();}protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e){this.GridView1.EditIndex = e.NewEditIndex;DataBindToGridView();}protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e){int userId = Convert.ToInt16(this.GridView1.DataKeys[e.RowIndex].Value);TextBox txtUserName =this.GridView1.Rows[e.RowIndex].Cells[1].FindControl("TextBox3") as TextBox;TextBox txtUserPassword =this.GridView1.Rows[e.RowIndex].Cells[2].FindControl("TextBox4") as TextBox;TextBox txtUserEmail =this.GridView1.Rows[e.RowIndex].Cells[3].FindControl("TextBox5") as TextBox;TextBox txtUserAge =this.GridView1.Rows[e.RowIndex].Cells[4].FindControl("TextBox6") as TextBox;TextBox txtUserPost =this.GridView1.Rows[e.RowIndex].Cells[5].FindControl("TextBox7") as TextBox;string UserName = txtUserName.Text;string UserPassword = txtUserPassword.Text;string UserEmail = txtUserEmail.Text;string UserAge = txtUserAge.Text;string UserPost = txtUserPost.Text;string update_username_sql = "update user_info123 setusername=@UserName,password=@UserPassword,email=@UserEmail, age=@UserAge, post=@UserPost where userId=@userId";SqlConnection conn = new SqlConnection();conn.ConnectionString =ConfigurationManager.ConnectionStrings["authConnStr"].ConnectionString;//创建连接数据库对象SqlCommand cmd = new SqlCommand();cmd.Connection = conn;mandText = update_username_sql;cmd.Parameters.Add(new SqlParameter("@UserName", UserName));cmd.Parameters.Add(new SqlParameter("@UserPassword", UserPassword));cmd.Parameters.Add(new SqlParameter("@UserEmail", UserEmail));cmd.Parameters.Add(new SqlParameter("@UserAge", UserAge));cmd.Parameters.Add(new SqlParameter("@UserPost", UserPost));cmd.Parameters.Add(new SqlParameter("@userId", userId));conn.Open();cmd.ExecuteNonQuery();this.GridView1.EditIndex = -1;DataBindToGridView();}protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e){int userId = Convert.ToInt16(this.GridView1.DataKeys[e.RowIndex].Value);string update_username_sql = "delete from user_info123 where userId=@userId";SqlConnection conn = new SqlConnection();conn.ConnectionString =ConfigurationManager.ConnectionStrings["authConnStr"].ConnectionString;//创建连接数据库对象SqlCommand cmd = new SqlCommand();cmd.Connection = conn;mandText = update_username_sql;cmd.Parameters.Add(new SqlParameter("@userId", userId));conn.Open();cmd.ExecuteNonQuery();object o = this.GridView1.DataKeys[e.RowIndex].Value;this.DataBindToGridView();GridView1.DataBind();}protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e){this.GridView1.EditIndex = -1;DataBindToGridView();}protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e){int i = 0;for (i = 0; i <= GridView1.Rows.Count; i++){if (e.Row.RowType == DataControlRowType.DataRow){e.Row.Attributes.Add("onmouseover","c=this.style.backgroundColor;this.style.backgroundColor='#00A9FF'");e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");}}}}编辑界面：用户登录界面：用户操作界面：其实现代码为：<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Feedback.aspx.cs"Inherits="Feedback" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN""/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head runat="server"><link href="~/css/Feedback.css" type="text/css" rel="StyleSheet" /><title>图书反馈信息征集</title></head><body><h3 style="text-align:center">图书反馈信息征集</h3><form id="form1" runat="server"><table border="1" cellpadding="2" cellpadding="0" width="577"align="center" style="font-size:12px;line-height:25px;"><tr><td bgcolor="#f7fdf3" height="36" width="10" align="center">书名</td><td height="36"><asp:TextBox ID="TextBox1" runat="server" Width="163px"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="书名不能为空！"ControlToValidate="TextBox1"></asp:RequiredFieldValidator></td></tr><tr><td bgcolor="#f7fdf3" width="10" align="center">购书<br />时间</td><td><asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="TextBox2" ErrorMessage="购书时间不能为空！"></asp:RequiredFieldValidator></td></tr><tr><td bgcolor="#f7fdf3" rowspan="2" width"10%" align="center">本<br />书<br />反<br />馈</td><td height="50">图书质量：<asp:RadioButtonList ID="RadioButtonList1" runat="server" RepeatDirection="Horizontal"><asp:ListItem>很好</asp:ListItem><asp:ListItem>好</asp:ListItem><asp:ListItem>一般</asp:ListItem><asp:ListItem>差</asp:ListItem></asp:RadioButtonList><asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="RadioButtonList1" ErrorMessage="必须选择图书质量！"></asp:RequiredFieldValidator></td></tr><tr><td height="73">吸引您购买书本的原因：（可多选）<asp:CheckBoxList ID="CheckBoxList1" runat="server" RepeatColumns="3"><asp:ListItem>出版社品牌</asp:ListItem><asp:ListItem>内容提要前言目录等</asp:ListItem><asp:ListItem>他人推荐</asp:ListItem><asp:ListItem>版式设计</asp:ListItem><asp:ListItem>作者或出版社的名声</asp:ListItem><asp:ListItem>封面设计</asp:ListItem><asp:ListItem>价格实惠</asp:ListItem></asp:CheckBoxList></td></tr><tr><td bgcolor="#f7fdf3" height="117" width="10%" align="center">购<br />书<br />信<br/>息</td><td height="117">1、了解本书的途径：<br /><asp:ListBox ID="ListBox1" runat="server" Height="90px"Width="195px" SelectionMode="Multiple"><asp:ListItem>朋友推荐</asp:ListItem><asp:ListItem>书店挑选</asp:ListItem><asp:ListItem>网上查询</asp:ListItem><asp:ListItem>店员推荐</asp:ListItem><asp:ListItem>媒体广告</asp:ListItem></asp:ListBox><asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="ListBox1" ErrorMessage="必须选择了解书本的途径！"></asp:RequiredFieldValidator><br />2、购书渠道：<asp:TextBox ID="TextBox3" runat="server"Width="248px"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="TextBox3" ErrorMessage="购书途径不能为空！"></asp:RequiredFieldValidator><br />3、能接受的图书价格：<asp:TextBox ID="TextBox4" runat="server"Width="80px"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="TextBox4" ErrorMessage="能接受的图书价格不能为空！"></asp:RequiredFieldValidator><asp:CompareValidator ID="CompareValidator1" runat="server"ControlToValidate="TextBox4" ErrorMessage="必须是数值型！"Type="Double"></asp:CompareValidator></td></tr><tr><td bgcolor="#f7fdf3" height="40" width="10%" align="center">图书<br />服务</td><td height="40">您对本书的发行售后服务评价是：<br /><asp:DropDownList ID="DropDownList1" runat="server"><asp:ListItem>非常满意</asp:ListItem><asp:ListItem>满意</asp:ListItem><asp:ListItem>一般</asp:ListItem><asp:ListItem>不满意</asp:ListItem></asp:DropDownList></td></tr><tr><td bgcolor="#f7fdf3" height="75" width="10%" align="center">宝<br />贵<br />意<br />见</td><td height="75"><asp:TextBox ID="TextBox5" runat="server" Height="70px"TextMode="MultiLine" Width="405"></asp:TextBox></td></tr><tr><td bgcolor="#f7fdf3" height="104" width="10%" align="center">读<br />者<br />信<br />息</td><td height="104">姓名：<asp:TextBox ID="TextBox6" runat="server" Width="104px"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="TextBox6" ErrorMessage="姓名不能为空！"></asp:RequiredFieldValidator><br />年龄：<asp:TextBox ID="TextBox7" runat="server" Width="33px"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" ControlToValidate="TextBox7" ErrorMessage="年龄不能为空！"></asp:RequiredFieldValidator><asp:RangeValidator ID="RangeValidator1" runat="server"ControlToValidate="TextBox7" ErrorMessage="年龄要在1和120之间" MaximumValue="120"MinimumValue="1" Type="Integer"></asp:RangeValidator><br />电话：<asp:TextBox ID="TextBox8" runat="server"></asp:TextBox><asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" ControlToValidate="TextBox8" ErrorMessage="电话不能为空！"></asp:RequiredFieldValidator><%-- <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"ControlToValidate="TextBox8" ErrorMessage="电话号码格式不正确！"ValidationExpression="(\(\d{3}\)|\d{3}-)?\d{8}"></asp:RegularExpressionValidator>--%><br />邮编：<asp:TextBox ID="TextBox9" runat="server" Width="77px"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator10" runat="server"ControlToValidate="TextBox9" ErrorMessage="邮编不能为空！"></asp:RequiredFieldValidator><asp:RegularExpressionValidator ID="RegularExpressionValidator2"runat="server"ControlToValidate="TextBox9" ErrorMessage="邮编号码格式不正确！"ValidationExpression="\d{6}"></asp:RegularExpressionValidator><br />邮件地址：<asp:TextBox ID="TextBox10" runat="server" Width="215px"></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator11" runat="server"ControlToValidate="TextBox10" ErrorMessage="邮件地址不能为空！"></asp:RequiredFieldValidator><asp:RegularExpressionValidator ID="RegularExpressionValidator3"runat="server"ControlToValidate="TextBox10" ErrorMessage="邮件地址格式不正确！"ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator></td></tr></table><center><br /><asp:Button ID="Button1" runat="server" Text="提交" onclick="Button1_Click1"/></center></form></body></html>提交显示界面：其实现代码为：public partial class show : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){Label1.Text = (PreviousPage.FindControl("TextBox1") as TextBox).Text.ToString(); Label2.Text = (PreviousPage.FindControl("TextBox2") as TextBox).Text.ToString(); Label3.Text = (PreviousPage.FindControl("RadioButtonList1") as RadioButtonList).Text.ToString();Label4.Text = (PreviousPage.FindControl("CheckBoxList1") asCheckBoxList).Text.ToString();Label5.Text = (PreviousPage.FindControl("ListBox1") as ListBox).Text.ToString();Label6.Text = (PreviousPage.FindControl("TextBox3") as TextBox).Text.ToString(); Label7.Text = (PreviousPage.FindControl("TextBox4") as TextBox).Text.ToString(); Label8.Text = (PreviousPage.FindControl("DropDownList1") asDropDownList).Text.ToString();Label9.Text = (PreviousPage.FindControl("TextBox5") as TextBox).Text.ToString(); Label10.Text = (PreviousPage.FindControl("TextBox6") as TextBox).Text.ToString(); Label11.Text = (PreviousPage.FindControl("TextBox7") as TextBox).Text.ToString(); Label12.Text = (PreviousPage.FindControl("TextBox8") as TextBox).Text.ToString(); Label13.Text = (PreviousPage.FindControl("TextBox9") as TextBox).Text.ToString(); Label14.Text = (PreviousPage.FindControl("TextBox10") asTextBox).Text.ToString();}}Web系统开发技术课程设计小结本次课程设计涵盖了这一学期以来所学的大部分内容。