留言板系统的设计与实现

经典word整理文档，仅参考，双击此处可删除页眉页脚。本资料属于网络整理，如有侵权，请联系删除，谢谢！目录一、设计目的1二、需求分析1三、模块分析及设计2四、数据库设计24.1系统概念结构设计24.1.1数据字典24.1.2系统E-R图34.1.3系统流程图44.2逻辑结构设计5五、制作过程及要点65.1类库建立65.2验证码65.3留言内容界面75.4留言页面75.5登录界面95.6注册页面125.7修改密码界面135.8管理员界面14设计总结15附录15和1三、模块分析及设计登陆留言登陆4.1.1231n4.1.34是否5publicclassdb{publicdb(){}publicstaticSqlConnectionCreateConnection(){SqlConnectioncon=newSqlConnection(@"server=(Local);database=message;Integrated);returncon;}}protectedvoidPage_Load(objectsender,EventArgse){thisthis.GenCode(4));Session[]=this.GenCode(4);}privatestringGenCode(intnum){[]source={,"1",,,,,,,"8",,,"A","B","C","D","E",,"G",,,,,"L",,"N","O","P",,"R",,"T","U","V","W","X",,"Z"};stringcode=;Randomrd=new();for(inti=0;i<num;i++){code+=source[rd.Next(0,source.Length)];}returncode;}privatevoidstringcode){BitmapmyPalette=newBitmap(60,20);Graphicsgh=Graphics.FromImage(myPalette);Rectanglerc=newRectangle(0,0,60,20);gh.FillRectangle(newSolidBrush(.Blue),rc);6gh.DrawString(code,newFont(宋体,16),newSolidBrush(.White),rc);gh.Dispose();myPalette.Dispose();}protectedvoidButton3_Click(objectsender,EventArgse){7protectedvoidPage_Load(objectsender,EventArgse){try{this.Label1.Text=].ToString();SqlConnectioncon=db.CreateConnection();con.Open();stringstrsql="selectcount(*)from;SqlCommandcmd=newSqlCommand(strsql,con);SqlDataReaderrd=cmd.ExecuteReader();while(rd.Read()){this.Label2.Text=rd[0].ToString();}rd.Close();con.Close();}{8}{SqlConnectioncon=db.CreateConnection();con.Open();stringstrsql="insertintomessagesvalues('"+Label1.Text+"','"+TextBox2.Text++TextBox3.Textcon.Close();"<script>alert('留言成功！')</script>");Response.Redirect("messageout.aspx");}protectedvoidButton2_Click(objectsender,EventArgse){9protectedvoidPage_Load(objectsender,EventArgse){this.ImageButton1.ImageUrl="image.aspx";}protectedvoidButton1_Click(objectsender,EventArgse){if(this.TextBox1.Text==){Label1.Text=用户名不能为空！<br>";}if(this.TextBox2.Text==){Label1.Text+="密码不能为空！<br>";}if(this.TextBox3.Text==){Label1.Text+="请输入验证码！<br>";}else{SqlConnectioncon=db.CreateConnection();con.Open();if(RadioButtonList1.SelectedItem.Value.ToString().Trim()==用户){stringstrsql="selectUpassfromloginwhereUname='"+this.TextBox1.Text+"'andUpass='"+this.TextBox2.Text+;SqlCommandcmd=newSqlCommand(strsql,con);DataSetds=newDataSet();SqlDataReaderdr=cmd.ExecuteReader();try{if(dr.Read()){stringaa=this.TextBox3.Text.ToString();if(aa==Convert])){Session[]=this.TextBox1.Text.ToString();Response.Redirect("messageout.aspx");10}else{Label1.Text=验证码错误，注意大小写！;}}else{Label1.Text=用户名或者密码错误！;}}catch{Label1.Text=输入的用户名不存在！;}con.Close();}elseif(RadioButtonList1.SelectedItem.Value.ToString().Trim()==管理员){stringstrsql1="selectUpassfrommanagementwhereUname='"+this.TextBox1.Text+"'andUpass='"+this.TextBox2.Text+;SqlCommandcmd=newSqlCommand(strsql1,con);DataSetds=newDataSet();SqlDataReaderdr=cmd.ExecuteReader();try{if(dr.HasRows){stringaa=this.TextBox3.Text.ToString();if(aa==Convert])){Session[]=this.TextBox1.Text.ToString();Response.Redirect("management.aspx");}else{Label1.Text=验证码错误，注意大小写！;}}else{Label1.Text=用户名或者密码错误！;}}11Label1.Text=输入的用户名不存在！;}protectedvoidButton1_Click(objectsender,EventArgse){try{SqlConnectioncon=db.CreateConnection();con.Open();SqlCommandcmd=con.CreateCommand();=(cmd.ExecuteNonQuery();"<script>alert('注册用户成功！')</script>");}}}protectedvoidButton1_Click1(objectsender,EventArgse){SqlConnectioncon=db.CreateConnection();SqlCommandcmd=con.CreateCommand();con.Open();cmd.CommandText=strsql1;DataSetds=newDataSet();SqlDataReaderdr1=cmd.ExecuteReader();{TextBox1.Text+);cmd2.CommandText=strsql;cmd2.E