电子商务应用开发技术课程设计论文

《电子商务应用开发技术课程设计》论文1042803109 王静娴一、系统初步规划该系统主要是以ASP编程技术为核心实现网上购物的功能，本系统是在管理信息系统的理论和方法指导下、数据库技术支持下完成的。

目的是实现用户注册、登录、商品浏览、商品购买、付款等流程。

内容包括：用户的登录与注册、Table的制作、超链接的制作、大规模商品列表的制作、数据库的制作等。

建立的目标是实现用户在线多次购买不同种类的商品。

二、系统设计背景1.背景伴随着Internet的蓬勃发展，网上购物作为电子商务的一种形式正以其高效，低成本的优势，逐步成为新兴的经营模式和理念，人们已经不再满足网站信息浏览和发布的用途，而是渴望着能够享受网络所带来的更多的便利。

网络购物正适应了当今社会快节奏的生活，使顾客足不出户便能方便快捷轻松地选购自己喜欢的商品2.目的开发此网站，目的是全面掌握所学的控件、超链接及各种代码知识，全面了解电子商务的开发过程，界面追求简洁，功能力求完美。

3.必要性因为电子商务的范围波及人们的生活、工作、学习及消费等广泛领域，其服务和管理也涉及政府、工商、金融及用户等诸多方面。

Internet逐渐在渗透到每个人的生活中，而各种业务在网络上的相继展开也在不断推动电子商务这一新兴领域的昌盛和繁荣。

这一趋势必然需要构建完善的系统支持电子商务的发展。

三、系统流程图四、功能设计以及清单五．数据库设计E-R图T_catT_product六．成果展示(1)登录页面(1)注册页面主要代码using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication3{public partial class_Default : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){}protected void LinkButton1_Click(object sender, EventArgs e){Panel1.Visible = false;Panel2.Visible = true;}protected void Button2_Click(object sender, EventArgs e){SqlConnection conn = new SqlConnection();conn.ConnectionString = @"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;IntegratedSecurity=True;User Instance=True";conn.Open();SqlCommand cmd = new SqlCommand();cmd.Connection = conn;mandText = "Select *From T_users Where username='" + TextBox3.Text + "'";if (cmd.ExecuteScalar() != null){Label2.Text = "该用户已被使用!";}else{mandText = "Insert Into T_users(username,password) Values ('" + TextBox3.Text + "','" + TextBox4.Text + "')";cmd.ExecuteNonQuery();Session["username"] = TextBox3.Text;ArrayList cart = new ArrayList();Session["cart"] = cart;Response.Redirect("2.aspx");}conn.Dispose();cmd.Dispose();}protected void Button1_Click(object sender, EventArgs e){SqlConnection conn = new SqlConnection();conn.ConnectionString = @"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;IntegratedSecurity=True;User Instance=True";conn.Open();SqlCommand cmd = new SqlCommand();cmd.Connection = conn;mandText = "Select * From T_users Where username='" + TextBox1.Text + "' AND password='" + TextBox2.Text + "' ";cmd.ExecuteNonQuery();if (cmd.ExecuteScalar() != null){Session["username"] = TextBox1.Text;ArrayList cart = new ArrayList();Session["cart"] = cart;Response.Redirect("2.aspx");}else{Response.Write("登录失败!");}conn.Dispose(); cmd.Dispose();}}}(3)首页(4)商品种类页面主要代码using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication3{public partial class_41 : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){SqlConnection conn = new SqlConnection();conn.ConnectionString = @"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;IntegratedSecurity=True;User Instance=True";conn.Open();SqlCommand cmd = conn.CreateCommand();mandText = "select * from T_cat";SqlDataReader dr = cmd.ExecuteReader();Response.Write("<table border='1' Height='250px' Width='500px'><tr><td>商品种类名称</td><td>商品种类描述</td></tr>");while (dr.Read()){Response.Write("<tr>");Response.Write("<td><a href='4.aspx?catid=" + dr[0] + "'>" + dr[1] +"</a></td><td>" + dr[2] + "</td>");Response.Write("</tr>");}Response.Write("</table>");conn.Dispose();cmd.Dispose();dr.Dispose();}}}（5）以生日礼物为例，点击进入生日礼物页面主要代码using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication3{public partial class_1 : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){SqlConnection conn = new SqlConnection();conn.ConnectionString = @"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;IntegratedSecurity=True;User Instance=True";conn.Open();SqlCommand cmd = conn.CreateCommand();mandText = "select * from T_product where catid='" +Request.QueryString["catid"] + "'";SqlDataReader dr = cmd.ExecuteReader();Response.Write("<table border='1'>");while (dr.Read()){Response.Write("<tr>");for (int i = 0; i < dr.FieldCount - 1; i++){Response.Write("<td>" + dr[i] + "</td>");}Response.Write("<td><a href='5.aspx?id=" + dr[0] + "'><img src='" + dr["pic"] + "' width='100'><\a></td>");Response.Write("</tr>");}Response.Write("</table>");conn.Dispose();cmd.Dispose();dr.Dispose();}}}（6）查看牛奋斗玩偶公仔的详细信息（7）输入购买量，确认购买using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication3{public partial class_9 : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){SqlConnection conn = new SqlConnection();conn.ConnectionString = @"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;IntegratedSecurity=True;User Instance=True";conn.Open();SqlCommand cmd = conn.CreateCommand();mandText = "select * from T_product where id='"+ Request.QueryString["id"] + "'";SqlDataReader dr = cmd.ExecuteReader();while(dr.Read()){Response.Write("商品名称："+dr[1]+"<br/>");Response.Write("商品价格：" + dr[4] + "<br/>");Response.Write("商品详细介绍：" + dr[3] + "<br/>");Response.Write("<img src='" + dr["pic"] + "'>");}conn.Dispose();cmd.Dispose();dr.Dispose();}protected void LinkButton1_Click(object sender, EventArgs e){Response.Redirect("3.aspx");}protected void LinkButton2_Click(object sender, EventArgs e){Response.Redirect("2.aspx");}protected void Button1_Click(object sender, EventArgs e){SqlConnection conn = new SqlConnection();conn.ConnectionString = @"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;IntegratedSecurity=True;User Instance=True";conn.Open();SqlCommand cmd = conn.CreateCommand();mandText = "select * from T_product where id='" + Request.QueryString["id"] + "'";SqlDataReader dr = cmd.ExecuteReader();dr.Read();ArrayList arr1 = (ArrayList)Session["cart"];if(arr1!=null){arr1.Add(new Class1(Convert.ToInt32(dr["id"]),Convert.ToInt32(TextBox1.Text)));Response.Write("购买成功！<a href='6.aspx'>查看购物车</a>");Session["cart"] = arr1;}else{Response.Write("<a href='1.aspx'>请先登录再购买</a>");}conn.Dispose();cmd.Dispose();dr.Dispose();}}}（8）查看购物车，确认付款主要代码using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication3{public partial class_10 : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){int total = 0;SqlConnection conn = new SqlConnection();conn.ConnectionString = @"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True";conn.Open();SqlCommand cmd = conn.CreateCommand();Response.Write("您的购物车中有以下商品：");ArrayList arr1 = (ArrayList)Session["cart"];Response.Write("<table border='1' Height='250px' Width='500px'><tr><td>商品名称</td><td>商品价格</td><td>商品数量</td></tr>");foreach (Class1 p in arr1){Response.Write("<tr>");mandText = "select * from T_product where id='" + p.id+"'";SqlDataReader dr = cmd.ExecuteReader();dr.Read();total = total + Convert.ToInt32(dr["price"]) * p.amount;Response.Write("<td><a href='5.aspx?id=" + dr[0] + "'>" + dr[1] +"</a></td><td>" + dr["price"] + "</td><td>" + p.amount + "</td>");Response.Write("</tr>");dr.Dispose();}Response.Write("<tr><td colspan=4 align=center>总计：" + total + "元</td></tr>"); Response.Write("</table>");conn.Dispose();cmd.Dispose();}protected void Button1_Click(object sender, EventArgs e){Response.Redirect("15.aspx");}}}（9）确认运输及付款方式（10）购买成功（11）会员中心主要代码using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;namespace WebApplication3{public partial class_7 : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e){if (Session["username"] != null){SqlConnection conn = new SqlConnection();conn.ConnectionString = @"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;IntegratedSecurity=True;User Instance=True";conn.Open();SqlCommand cmd = conn.CreateCommand();mandText = "select * from T_users where username ='" +Session["username"] + "'";SqlDataReader dr = cmd.ExecuteReader();dr.Read();Panel1.Visible = false;Label2.Text = "尊敬的"+ "<font color='red'>"+ Session["username"] + "</font>" + "，欢迎您！";Label3.Text = Convert.ToString(Session["username"]);}else{Panel2.Visible = false;Label1.Text = "您还未登录，请返回登录！";}}protected void Button1_Click(object sender, EventArgs e){Response.Redirect("1.aspx");}protected void Button2_Click(object sender, EventArgs e){Response.Redirect("6.aspx");}protected void Button3_Click(object sender, EventArgs e){Response.Redirect("2.aspx");}}}七．课程设计总结根据这次的电子商务课程设计，充分理解了电子商务得开发过程，对于电子商务得活动过程已经有了更深一步的了解。