Web大作业.docx

无锡太湖学院实验报告 学 院 物联网学院 课程名称 Web开发技术 期末大作业 实验名称： 小型网上商城 专业 计算机科学 班级 1404 姓名 学号 成绩 指导老师签字 实验时间 20 17年 6 月 日 1、 大作业目的1、 综合运用Web编程技术；2、 熟练掌握ASP.NET对数据库的操作（增、删、改、查）；3、 掌握Web服务器端编程（C#）；4、 掌握网页设计的方法2、 实验仪器设备（或软件平台）序号实验设备名称（或软件平台）1Window7操作系统2Microsoft Visual Studio 2010或以上3Microsoft SQL Server 2008或以上4Internet Explorer 8 或以上3、 开发过程（开发内容和源代码、实验步骤和结果等）1、功能一：商品浏览aspx页面文件内容：按照在Visual Studio中的文本样式原样给出(字体、颜色、缩进等)；只列最主要内容，母板页、CSS样式等辅助内容不要列出；尽量紧凑；以下同。% Page Language=C# AutoEventWireup=true CodeBehind=f3.aspx.cs Inherits=webTest06.f3 %!DOCTYPE htmlhtml xmlns=/1999/xhtmlhead runat=servermeta http-equiv=Content-Type content=text/html; charset=utf-8/ title/title/headbody form id=form1 runat=serverasp:SqlDataSource ID=SqlDataSource1 runat=server ConnectionString=Data Source=USER-20161219WD;Initial Catalog=tempdb;Integrated Security=True ProviderName=System.Data.SqlClient SelectCommand=SELECT * FROM store/asp:SqlDataSource asp:TextBox ID=TextBox1 runat=server Enabled=False Font-Size=Larger Height=30px OnTextChanged=TextBox1_TextChanged Width=193px登录状态/asp:TextBoxnbsp; asp:Label ID=Label16 runat=server Text=user_num/asp:Label asp:TextBox ID=TextBox2 runat=server/asp:TextBox br /br /nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; asp:Label ID=Label17 runat=server Text=user_pw/asp:Label asp:TextBox ID=TextBox3 runat=server Width=138px/asp:TextBoxbr /br /nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; asp:Button ID=Button6 runat=server OnClick=Button6_Click Text=login Width=68px /nbsp;nbsp;nbsp; asp:Button ID=Button7 runat=server OnClick=Button7_Click Text=register Width=64px / br /br / asp:Panel ID=Panel3 runat=server Height=435px Width=1497px asp:Image ID=Image2 runat=server Height=292px ImageUrl=/Resources/beef.jpg Width=357px / br / br / asp:Label ID=Label1 runat=server Font-Size=Larger Height=30px Text=PORK Width=277px/asp:Labelnbsp;nbsp; asp:Button ID=Button1 runat=server Height=27px Text=+ Width=41px / nbsp;br /br / asp:Label ID=Label2 runat=server Font-Size=Larger Height=30px Text=3.99 Width=277px/asp:Label br / br / asp:Label ID=Label3 runat=server Font-Size=Larger Height=30px Text=Remains:85 Width=277px/asp:Label/asp:Panel br / asp:Panel ID=Panel4 runat=server Height=435px Width=1497px asp:Image ID=Image3 runat=server Height=292px ImageUrl=/Resources/chicken.jpg Width=357px /br /br / asp:Label ID=Label4 runat=server Font-Size=Larger Height=30px Text=Duck Width=277px/asp:Label nbsp;nbsp;asp:Button ID=Button2 runat=server Height=27px Text=+ Width=41px / nbsp; br /br / asp:Label ID=Label5 runat=server Font-Size=Larger Height=30px Text=4.99 Width=277px/asp:Label br / br / asp:Label ID=Label6 runat=server Font-Size=Larger Height=30px Text=Remains:25 Width=277px/asp:Label/asp:Panel br / asp:Panel ID=Panel5 runat=server Height=435px Width=1497px asp:Image ID=Image4 runat=server Height=292px ImageUrl=/Resources/duck.jpg Width=357px / br /br / asp:Label ID=Label7 runat=server Font-Size=Larger Height=30px Text=Chicken Width=277px/asp:Label nbsp;nbsp;asp:Button ID=Button3 runat=server Height=27px Text=+ Width=41px / nbsp; br / br / asp:Label ID=Label8 runat=server Font-Size=Larger Height=30px Text=2.99 Width=277px/asp:Labelbr / br / asp:Label ID=Label9 runat=server Font-Size=Larger Height=30px Text=Remains:35 Width=277px/asp:Label /asp:Panel br / asp:Panel ID=Panel6 runat=server Height=435px Width=1497px asp:Image ID=Image5 runat=server Height=292px ImageUrl=/Resources/horsemeat.jpg Width=357px / br / br / asp:Label ID=Label10 runat=server Font-Size=Larger Height=30px Text=HorseMeat Width=277px/asp:Label nbsp;nbsp;asp:Button ID=Button4 runat=server Height=27px Text=+ Width=41px / nbsp; br /br / asp:Label ID=Label11 runat=server Font-Size=Larger Height=30px Text=12.69 Width=277px/asp:Label br / br / asp:Label ID=Label12 runat=server Font-Size=Larger Height=30px Text=Remains:22 Width=277px/asp:Label /asp:Panel br / asp:Panel ID=Panel7 runat=server Height=435px Width=1497px asp:Image ID=Image6 runat=server Height=292px ImageUrl=/Resources/donkeymeat.jpg Width=357px / br /br / asp:Label ID=Label13 runat=server Font-Size=Larger Height=30px Text=DonkeyMeat Width=277px/asp:Label nbsp;nbsp;asp:Button ID=Button5 runat=server Height=27px Text=+ Width=41px /nbsp; br /br / asp:Label ID=Label14 runat=server Font-Size=Larger Height=30px Text=7.99 Width=277px/asp:Labelbr /br / asp:Label ID=Label15 runat=server Font-Size=Larger Height=30px Text=Remains:12 Width=277px/asp:Label /asp:Panelbr /br /br /br /br / /form/body/htmlC#实现代码（.cs文件）：只列出最关键的代码，名称空间引用等辅助代码不要列出；尽量紧凑，减少空行；以下同。public partial class f3 : System.Web.UI.Page SqlConnection cnn = new SqlConnection(Data Source=USER-20161219WD;Initial Catalog=tempdb;Integrated Security=True); protected void Page_Load(object sender, EventArgs e) String num = ApplicationNum.ToString().Trim(); if (num.Equals() TextBox1.Text = 暂无用户登录; else TextBox1.Text = 欢迎 +num+ 号登录; protected void Button7_Click(object sender, EventArgs e) Response.Redirect(register.aspx,true); protected void Button6_Click(object sender, EventArgs e) String num, pw; num = TextBox2.Text.Trim(); pw = TextBox3.Text.Trim(); String check = select * from man where num= + num + and pw= + pw + ; cnn.Open(); SqlCommand onCheck = new SqlCommand(check,cnn); if (null != onCheck.ExecuteScalar() ApplicationNum = num; Response.Write(num + 号已登录); TextBox1.Text = 欢迎 + num + 号登录; TextBox2.Text = ; TextBox3.Text = ; cnn.Close(); else TextBox2.Text = ; TextBox3.Text = ; Response.Write(ID不存在或密码输入错误！); cnn.Close(); 程序运行屏幕截图：能说明功能实现的网页截图或/和SQL Server管理台截图用户表man：商品表store：2、功能二：用户登录aspx页面文件内容：要求同上asp:Label ID=Label16 runat=server Text=user_num/asp:Label asp:TextBox ID=TextBox2 runat=server/asp:TextBox br / br /nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; asp:Label ID=Label17 runat=server Text=user_pw/asp:Label asp:TextBox ID=TextBox3 runat=server Width=138px/asp:TextBox br / br /nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; asp:Button ID=Button6 runat=server OnClick=Button6_Click Text=login Width=68px /nbsp;nbsp;nbsp;C#实现代码（.cs文件）：要求同上protected void Button6_Click(object sender, EventArgs e) String num, pw; num = TextBox2.Text.Trim(); pw = TextBox3.Text.Trim(); String check = select