购物网站设计-Web实验报告

江.冢大fJ I A N G S U U N I V E R S I T 丫购物网站设计报告班级：学生姓名：学号：完成时间：2014年11月18日用户名密码电话邮箱submit 购物网站设计报告一：设计要求1. 购物车包含注册页面、登录页面、购物页面、购物车四个页面。

2. 在购物页面中，将页面信息与数据库绑定，直接将数据库中的内容显示到网页上。

另外，对“名称”设计超链接，点击进入商品的详细信息介绍页面。

3. 网站美观大方二.实现效果1. 登录页面用户名，zhangxinji密?玉irT登录注珊2. 注册页面返回登录页面3. 购物页面维续购物结算商品4. 购物车三.主要代码1. 登录页面与数据库连接protected void Butt on 2_Click(object sen der. Eve ntArgs e){stri ng conn str = @"Data Source=XIAOZHENZHEN-PC;l nitial Catalog=logi n;ln tegrated Security=True";Strin gBuilder sb = new Stri ngBuilder();sb.Appe nd("select cou nt (");sb.Append("'");sb.Appe nd( TextBox1.Text);sb.Appe nd("') from useri nfo where password=");sb.Appe nd( TextBox2.Text);using (SqlC onn ecti on conn = new SqlC onn ecti on(conn str)){SqlComma nd cmd = conn .CreateComma nd(); ma ndText = sb.ToStri ng(); conn. Ope n();int num = (int)cmd.ExecuteScalar();if (num > 0){ Response.Redirect("shop.aspx");}else{Response.Write("账号密码错误 ");}}}2. 注册页面与数据库连接protected void Button1_Click(object sender, EventArgs e){string connstr = @"Data Source=XIAOZHENZHEN-PC;Initial Catalog=login;IntegratedSecurity=True";StringBuilder sb = new StringBuilder();sb.Append("insert intouserinfo(username,password,shenfen,name,sex,birthday,telephone)values(");sb.Append("'");sb.Append(TextBox1.Text);sb.Append("'"); sb.Append(",");sb.Append("'");sb.Append(TextBox2.Text);sb.Append("'");sb.Append(",");Response.Write(sb.ToString());using (SqlConnection conn = new SqlConnection(connstr)){conn.Open();SqlCommand cmd = conn.CreateCommand();mandText = sb.ToString();int num =(int) cmd.ExecuteNonQuery();int count =(int)cmd.ExecuteNonQuery();if (count > 0){ Response.Redirect("Default.aspx"); }else{Response.Redirect("fault.aspx");}conn.Close();}}3. 购物车页面<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"DataSourceID="SqlDataSource1" Height="162px"Width="644px" BackColor="LightGoldenrodYellow" BorderColor="Tan"BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None" style="text-align: center" onselectedindexchanged="GridView1_SelectedIndexChanged">序列“ /> HeaderText="名介绍”/> 序列")%>' />名称")%>' /> 介绍”)%>' /> 价格")%>' /> vAlter nati ngRowStyle BackColor="PaleGolde nrod" /> vColum ns><asp:BoundField DataField=" 序列 "HeaderText="序列"SortExpression="<asp:HyperLi nkField DataNavigateUrlFields="序列" DataNavigateUrlFormatStri ng="detail.aspx?id={0}" DataTextField=" 称"/><asp:BoundField DataField="介绍 HeaderText="介绍SortExpression="<asp:lmageField DataAlternateTextField="图片"DatalmageUrlField=" HeaderText=" 图片"> </asp:ImageField><asp:BoundField DataField=" 价格"HeaderText="价格"SortExpression="价格"/> <asp:Comma ndField ShowDeleteButt on="True" /><asp:TemplateField HeaderText="购 o 买 6" ShowHeader="False"><ItemTemplate> <asp:Li nkButton ID="L in kButt on1" run at="server" CausesValidatio n="false"CommandName="" Text="加入购物车"CommandArgument='<%#Eval("序列")%>' OnClick="LinkButton1_Click"></asp:L in kButt on></ltemTemplatex/asp:TemplateFieldx/Colu mns></asp:GridView><asp:SqlDataSource ID="SqlDataSource1" run at="server"ConnectionString="<%$ ConnectionStrings:loginConnectionString %>" SelectComma nd="SELECT * FROM [shoppi ng]"x/asp:SqlDataSource>4. 详细信息<asp:FormView ID="FormView1" run at="server" DataSourceID="SqlDataSource1"><EditItemTemplate>序列：<asp:TextBox ID="序列 TextBox" runat="server" Text='<%# Bind("<br />名称：<asp:TextBox ID="名称 TextBox" runat="server" Text='<%# Bind("<br />介绍：<asp:TextBox ID="介绍 TextBox" runat="server" Text='<%# Bind("<br />价格:<asp:TextBox ID="价格 TextBox" runat="server" Text='<%# Bind("<br /><asp:Li nkButt on ID="UpdateButt on" run at="server" CausesValidatio n="True"Comma ndName="Update" Text="更新"/>&n bsp;<asp:L in kButt on ID="UpdateCa ncelButt on" run at="server" CausesValidatio n="False" Comma ndName="Ca ncel" Text="取消"/></EditItemTemplate><In sertItemTemplate>序列：序&列 TextBox" run at="server" Text='<%# Bi nd("<asp:TextBox ID=" <br />序列")%>' /><asp:TextBox ID=" 名称：名？称?TextBox" run at="server" Text='<%# Bin名称")%>' /> <br /><asp:TextBox ID=" <br />介绍介绍 TextBox" runat="server" Text='<%# Bind("介绍”)%>' /> <asp:TextBox ID=" <br />价格:价格 TextBox" runat="server" Text='<%# Bind("价格")%>' /> <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True"Comma ndName="l nsert" Text="插入"/>&n bsp;<asp:L in kButt on ID="I nsertCa ncelButton" run at="server"CausesValidati on="False" Comma ndName="Ca ncel" Text="取消"/></InsertItemTemplate> <ItemTemplate><asp:Label ID=" <asp:Label ID=" <asp:Label ID=" 序列：序&列 Label" run at="server" Text='<%# Bin d("名称：名称 Label" runat="server" Text='<%# Bind("介绍介绍 Label" runat="server" Text='<%# Bind(" 价格:价格 Label" runat="server" Text='<%# Bind("序列”)％>' /><br /> 名称")%>'/><br /> 介绍)%>' /><br /> 价格")%>' /><br /><asp:Label ID="</ItemTemplate> v/asp:FormView><asp:SqlDataSource ID="SqlDataSource1" run at="server"Co nn ectio nStri ng="<%$ Conn ectio nStrin gs:logi nConn ectio nStri ng %>" |SelectCommand="SELECT * FROM [detail] WHERE ([ 序列]=@ 序列 2)"><SelectParameters><asp:QueryStringParameter Name="序列 2" QueryStringField="id" Type="Int32" /></SelectParameters>v/asp:SqlDataSource>5. 购物车页面public partial class shopcar : System.Web.Ul.Page {protected void Page_Load(object sen der, Eve ntArgs e) {if (HsPostBack) {if (Convert.Tolnt32(Request.QueryString["序&列 ”])==1){Sessi on ["Iist1"] = "<tr><td> 水？杯？<td>";Session["check1"] = " Y辍？0.0<td>";Sessio n["cou nt1"] = Co nvert.Tol nt32(Sessio n["cou nt1"]) + 1;}}}int r = Con vert.ToI nt32(Sessio n["accou nt"]);stri ng[] strArray = new str in g[Sessi on .Cou nt];Sessi on .CopyTo(strArray, 0);Resp on se.Write("<table border=1px alig n=cen ter>");Resp on se.Write("<capti on alig n=left > 购物车 </capti on>");Respo nse.Write("<tr><td> 名称 <td>单价 <td>数量");foreach (str ing str in strArray){Resp on se.Write(Sessi on[ str]);}Respo nse.Write("</table>");}四、实验小结：五、收获和提高方向：通过这次网页设计，让我对网页基本布局和设计方法有了深刻的了解，了解了网页中的各种属性以及css+div这种设计方法的优势，让我能够通过更加快捷，方便，准确的方法来建立以及修改网页。