NET程序設(shè)計(jì)實(shí)驗(yàn)報(bào)告

.NET程序設(shè)計(jì)實(shí)驗(yàn)報(bào)告班級(jí):IT1002學(xué)號(hào)：1111610205姓名：唐春林成績(jī)：一.實(shí)驗(yàn)名稱：宿舍管理系統(tǒng)二.實(shí)驗(yàn)?zāi)康模?.通過(guò)對(duì)《ASP.NETWeb應(yīng)用程序設(shè)計(jì)教程》的學(xué)習(xí)，運(yùn)用所學(xué)知識(shí)基于VisualStudio.NET集成開(kāi)發(fā)環(huán)境設(shè)計(jì)一個(gè)簡(jiǎn)單的網(wǎng)站，實(shí)現(xiàn)一定的功能。2.熟練掌握.NET開(kāi)發(fā)環(huán)境的常用控件，體驗(yàn)其可視化的開(kāi)發(fā)模式，從而大大提高開(kāi)發(fā)效率。3.靈活掌握類、控件、數(shù)據(jù)庫(kù)等的建立與使用，從而使網(wǎng)站的功能更強(qiáng)大。4.通過(guò)對(duì)錯(cuò)誤過(guò)程的分析與調(diào)試，提高自己處理問(wèn)題的能力，加深對(duì)知識(shí)的理解與掌握。三．設(shè)計(jì)過(guò)程和算法描述：程序功能概述。1.用戶界面設(shè)計(jì)（1）登陸頁(yè)面（denglu.aspx）控件類型控件屬性Lable控件ID="Label3"Text="用戶名："Font-Bold="True"Font-Size="X-Large"ForeColor="Black"ID="Label2"Text="密碼:"Font-Bold="True"Font-Size="X-Large"ForeColor="Black"TextBox控件ID="un1"Height="30px"Width="138px"ID="pw1"TextMode="Password"Width="138px"Height="30px"style="margin-left:0px"Button控件ID="Button1"OnClick="Click1"Text="登錄"BackColor="GRAY"Font-Bold="True"Font-Size="XX-Large"HyperLink控件ID="HyperLink1"NavigateUrl="~/zhuce.aspx">沒(méi)有帳號(hào)？注冊(cè)?。?）注冊(cè)頁(yè)面（zhuce.aspx）控件類型控件屬性TextBox控件ID="TextBox1"ID="TextBox2"Button控件ID="Button1"onclick="Button1_Click"Text="提交"BackColor="#CCCCFF"Font-Bold="True"Font-Size="X-Large"HyperLink控件ID="HyperLink1"NavigateUrl="~/index.aspx"Font-Size="X-Large"Font-Bold="True"ForeColor="Black"（3）查詢頁(yè)面（Default3.aspx,Default4.aspx,Default5.aspx,Default6.aspx）控件類型控件屬性HyperLink控件ID="HyperLink2"Font-Bold="True"Font-Size="XX-Large"NavigateUrl="~/Default5.aspx"ID="HyperLink3"NavigateUrl="~/Default6.aspx"ID="HyperLink4"Font-Bold="True"Font-Size="XX-Large"NavigateUrl="~/Default4.aspx"ID="HyperLink5"NavigateUrl="~/Default3.aspx"DropDownList控件ID="DropDownList1"AutoPostBack="True"DataSourceID="SqlDataSource1"DataTextField="樓號(hào)"DataValueField="樓號(hào)"ID="DropDownList2"AutoPostBack="True"DataSourceID="SqlDataSource1"DataTextField="房號(hào)"DataValueField="房號(hào)"ID="DropDownList1"AutoPostBack="True"DataSourceID="SqlDataSource1"DataTextField="樓層"DataValueField="樓層"ID="DropDownList1"AutoPostBack="True"DataSourceID="SqlDataSource1"DataTextField="班級(jí)"DataValueField="班級(jí)"SqlDataSource控件ID="SqlDataSource1"runat="server"ConnectionString="<%$ConnectionStrings:DormitoryInfoConnectionString1%>"SelectCommand="SELECT"DISTINCT[班級(jí)]FROM[sushexinxi]"ID="SqlDataSource1"runat="server"ConnectionString="<%$ConnectionStrings:DormitoryInfoConnectionString1%>"SelectCommand="SELECT"DISTINCT[樓層]]FROM[sushexinxi]ID="SqlDataSource1"runat="server"ConnectionString="<%$ConnectionStrings:DormitoryInfoConnectionStringfanghao%>"SelectCommand="SELECTDISTINCT[房號(hào)]FROM[sushexinxi]ID="SqlDataSource1"runat="server"ConnectionString="<%$ConnectionStrings:DormitoryInfoConnectionString1%>"SelectCommand="SELECTDISTINCT[樓號(hào)]FROM[sushexinxi]GridView控件GridViewID="GridView1"AutoGenerateColumns="False"DataSourceID="SqlDataSource4"ForeColor="Black"（4）首頁(yè)（index.aspx）控件類型控件屬性LinkButton控件ID="LinkButton1"runat="server"PostBackUrl="~/denglu.aspx"ForeColor="Red"Font-Bold="True"Font-Italic="False"Font-Size="XX-Large"Font-Names="黑體">登錄<asp:LinkButtonID="LinkButton2"runat="server"PostBackUrl="~/zhuce.aspx"ForeColor="#FF0006"Font-Bold="True"Font-Size="XX-Large"Font-Names="黑體">注冊(cè)2.算法設(shè)計(jì)(1)數(shù)據(jù)庫(kù)(DormitoryInfo.mdf)*表1>sushexinxi的定義列名姓名房號(hào)樓層樓號(hào)班級(jí)班長(zhǎng)室長(zhǎng)數(shù)據(jù)類型Varchar(50)Varchar(50)Varchar(50)Varchar(50)Varchar(50)Varchar(50)Varchar(50)2>UserIfo_的定義列名usernamepasswardquanxian數(shù)據(jù)類型varchar(20)varchar(20)varchar(10)*存儲(chǔ)過(guò)程1>sushexinxicmd1.Parameters.AddWithValue("@user_name",Session["userName"]);cmd1.Parameters.Add("@ID",SqlDbType.VarChar,50);cmd1.Parameters.Add("@班級(jí)",SqlDbType.VarChar,50);cmd1.Parameters.Add("@姓名",SqlDbType.VarChar,50);cmd1.Parameters.Add("@房號(hào)",SqlDbType.VarChar,50);cmd1.Parameters.Add("@班長(zhǎng)",SqlDbType.VarChar,50);cmd1.Parameters.Add("@室長(zhǎng)",SqlDbType.VarChar,50);2>sushexinxiALTERPROCEDUREdbo.deleteclass(@IDint) /*(@parameter1int=5,@parameter2datatypeOUTPUT)*/ RETURN(2)單擊事件1>登錄protectedvoidClick1(objectsender,EventArgse){if(TextBox1.Text!=""&&TextBox2.Text!=""){stringName=TextBox1.Text;stringPw=TextBox2.Text;Stringconstr=WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;stringselectStr="Select*fromUser_wherename='"+Name+"'";using(SqlConnectioncon=newSqlConnection(constr)){SqlCommandcmd=newSqlCommand(selectStr,con);con.Open();SqlDataReadersdr=cmd.ExecuteReader();//執(zhí)行查詢if(sdr.Read())//如果該用戶存在{if(sdr.GetString(1)==Pw)//密碼正確{Session["userName"]=Name;Response.Redirect("Default3.aspx");con.Close();}}elseResponse.Write("<script>alert('用戶名或密碼錯(cuò)誤')</script>");}}elseResponse.Write("<script>alert('請(qǐng)輸入用戶名和密碼')</script>");}2>注冊(cè)*類提供基礎(chǔ)。usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.HtmlControls;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Xml.Linq;usingSystem.Data.SqlClient;///<summary>///UserCommon的摘要說(shuō)明///</summary>publicclassUserCommon{publicboolresUser(Stringuname,Stringupass){Stringconstring=@"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory.mdf;IntegratedSecurity=True;UserInstance=True";SqlConnectioncon=newSqlConnection(constring);con.Open();SqlCommandsc=newSqlCommand("INSERTINTO[User_]([name],[passward])VALUES('"+uname+"','"+upass+"'')",con);intcount=sc.ExecuteNonQuery();if(count>0){returntrue;}else{returnfalse;}}}*實(shí)現(xiàn)類protectedvoidButton1_Click(objectsender,EventArgse){UserCommonuc=newUserCommon();Stringuname=this.TextBox1.Text;Stringupass=this.TextBox2.Text;Stringuemail=this.TextBox3.Text;if(uc.resUser(uname,upass,uemail)){Response.Redirect("index.aspx");}}說(shuō)明：通過(guò)編寫(xiě)類，在單擊事件中形成類實(shí)例來(lái)講注冊(cè)的用戶信息存到數(shù)據(jù)庫(kù)User_表中，為用戶登錄提供基礎(chǔ)。3>查詢protectedvoidButton1_Click(objectsender,EventArgse){stringconstr1=@"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\BookshopInfo.mdf;IntegratedSecurity=True;UserInstance=True";SqlConnectioncon1=newSqlConnection(constr1);SqlConnectioncon2=newSqlConnection(constr1);try{con1.Open();SqlCommandcmd1=newSqlCommand();cmd1.CommandType=CommandType.StoredProcedure;cmd1.Connection=con1;cmd1.CommandText="buybook";cmd1.Parameters.AddWithValue("@user_name",Session["userName"]);cmd1.Parameters.Add("@ID",SqlDbType.VarChar,50);cmd1.Parameters.Add("@班級(jí)",SqlDbType.VarChar,50);cmd1.Parameters.Add("@姓名",SqlDbType.VarChar,50);cmd1.Parameters.Add("@房號(hào)",SqlDbType.VarChar,50);cmd1.Parameters.Add("@室長(zhǎng)",SqlDbType.VarChar,50);for(intj=0;j<=GridView1.Rows.Count-1;j++){CheckBoxcbox1=(CheckBox)GridView1.Rows[j].FindControl("select");if(cbox1.Checked==true){