留言板系統(tǒng)的設(shè)計與實現(xiàn)

經(jīng)典word整理文檔，僅參考，雙擊此處可刪除頁眉頁腳。本資料屬于網(wǎng)絡(luò)整理，如有侵權(quán)，請聯(lián)系刪除，謝謝！目錄一、設(shè)計目的1二、需求分析1三、模塊分析及設(shè)計2四、數(shù)據(jù)庫設(shè)計24.1系統(tǒng)概念結(jié)構(gòu)設(shè)計24.1.1數(shù)據(jù)字典24.1.2系統(tǒng)E-R圖34.1.3系統(tǒng)流程圖44.2邏輯結(jié)構(gòu)設(shè)計5五、制作過程及要點65.1類庫建立65.2驗證碼65.3留言內(nèi)容界面75.4留言頁面75.5登錄界面95.6注冊頁面125.7修改密碼界面135.8管理員界面14設(shè)計總結(jié)15附錄15和1三、模塊分析及設(shè)計登陸留言登陸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