1、電子商務(wù)與安全課程設(shè)計一. 設(shè)計思想：隨著internet的發(fā)展和普及，電了商務(wù)在人們的生活中的角色越來越重要。以互聯(lián) 網(wǎng)為依托的電子商務(wù)，可以方便商家和消費者。木課程設(shè)計利用vs2010開發(fā)環(huán)境和 asp.net語言，設(shè)計實現(xiàn)了一個簡單的電子商務(wù)網(wǎng)站。asp.net的運行環(huán)境： win7+iis+vs2010。數(shù)據(jù)庫采用microsfot sql server 2008o可以實現(xiàn)簡單的在線購物 以及后臺管理功能。通過配置本地服務(wù)器，對以實現(xiàn)上線運營。二. 網(wǎng)站功能：一. 會員注冊功能。網(wǎng)購的第一步是注冊帳號。只有在注冊帳號之后才能選購商品，結(jié)帳。二. 登陸功能。注冊z后，網(wǎng)站為用戶在數(shù)據(jù)庫中

2、記錄信息，登陸z后就可以連接到數(shù)據(jù)庫, 從而可以將購物信息存儲到數(shù)據(jù)庫，同時可以使用會員信息查詢功能，查看會員的購物記錄, 消費金額等。三. 會員管理功能。會員登錄之后可以通過此功能修改個人信息。四. 商品信息杳詢。會員可以按商品所屬類別、所屬倉庫、商品名稱杏看商品的詳細(xì)信息。 同時町以選則購買商品，點擊購買商品后該商品口動加入到購物車中。五. 購物車功能。會員可以在購物車中查看已經(jīng)買到的商品，刪除不想購買的商品。點擊結(jié) 帳示可以完成購物。點擊清空購物車，可以刪除所有添加到購物車中的商殆。六. 購物信息查詢功能。會員可以輸入自己的id查看自己的購物記錄。七. 后臺管理功能。登陸管理員帳戶，可以

3、實現(xiàn)商品管理、會員管理、倉庫管理、訂單管理、 修改管理員帳八信息等功能。三.功能的具體實現(xiàn)l.defailt.aspx:網(wǎng)站的整體布局* 收藏本姑叭殳蚤主頁聯(lián)系我們幫助中心刀首頁會員管理購物車l.dqin服裝.衣 b2西服廠服裝i褲子:鞋!電器：卜電視機(jī)i i 空調(diào):冰箱卜家用商品毛巾“牙膏牙刷l.文具卜文具童i詡筆l圈珠筆所廉類別所僅倉庫商品名稱詳細(xì)信息|衣服服裝商務(wù)鬼裝詳細(xì)值息衣服服裝西服詳細(xì)信息鞋服裝ajl7 代詳細(xì)信息褲子服裝西褲詳細(xì)信息牙刷家用商品牛仔褲詳細(xì)信息電觀機(jī)電器創(chuàng)憐詳細(xì)信息電視機(jī)電器長埴詳細(xì)值患空調(diào)電器海8燒調(diào)詳細(xì)信息123«bo查詢條件：商品id 關(guān)健宇：查詢商

4、務(wù)胃裝:源碼：網(wǎng)站的梏體布局商務(wù)男裝西朋創(chuàng)17代牛仔褲后臺入口public partial class de1au11 : system. web. ui. pageprotected void page_load(object sender, eventargs e)(2.會員注冊功能：新會員注冊>會員登錄名檢測會員名性別男3密碼真實姓名密碼問題密碼提示笞案電話email地址所在城市北樂市3住址挪編頭像./image®片妊冊匚口mcmbcrmanagc/rcgpro. aspx 主要源碼：<asp:dropdownlist id二"ddlcity"

5、runal二"server" width二"134px" font-size=，9pt，><asp:listitem> 威海市 </asp:listltem>/所在城市設(shè)置<asp:textbox id="lxtaddress" run al 二"server" font-si ze=，9pt，x/asp:textbox>/地址<asp:textbox wtpostcode" run at 二"server" font-size=，9pt

6、，z></asp:textbox>郵編<asp:textbox td="txti on ey" run a t=" server" font-size=z，9pt，z en abl ed=>zfal sez，x/asp: textbox>會員充值public partial class membermanago_rcgpro : system. web. ui. pageprotected void btnagree_click(object sender, eventargs e)response. redirect

7、 (''register aspx");protected void btnrefuseclick(object sender, eventargs e)response. redirect c'goodslnfo. aspx，z);3 購物千功能:數(shù)據(jù)綁定數(shù)據(jù)綁走數(shù)據(jù)綁定刪除數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)綁定刪除數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)綁定刪除數(shù)擄綁走數(shù)據(jù)綁定數(shù)據(jù)綁定刪除數(shù)據(jù)綁定數(shù)據(jù)綁走數(shù)據(jù)綁定刪除數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)綁定刪除數(shù)據(jù)綁定數(shù)據(jù)綁定數(shù)據(jù)綁定刪除數(shù)擄綁走數(shù)擁綁定數(shù)據(jù)綁走刪除1 2l崔續(xù)購買臺計金額：labmoney主要源碼：<asp:linkbutton l

8、d="lbtncheck" runat=/serverz， font-undcrline="false" forecolor="black" oncl ick=，lbtncheck_cl ick"結(jié)d賬?</asp: li nkbutton>結(jié)帳功能<asp:linkbutton id="lbtnclcai*" run at 二"server" font-underl ine=z，falsc/z forccolor=/，blackz， onclick=/，lbtncl

9、ear click"清?空?購o物?車u </asp:linkbutton>清空購物乍public partial class membermanage_shopping : system.web.ulpagesqlopcratc sqlopcratc = new sqlopcratc();sqlconnection sqlconn = newprotected void pagc_load(objcct sender, eventargs c)if (session"mnamenj = null)response.write(”vscript>alert

10、('您還沒有登錄，請登錄后再使用該功 th!')；location='javascript:history.go(- l)'</script>”);if (jispostback)string sq 1 str = "select orderid,goodsname,goodstypename,goodsprice from tb_ordcrinfo where ordermembeu"' +convcrt.tostring(scssion"mnamc") + "* and ischeckou

11、t=* 否沖;gvorderlnfo.datakeynames = new stringh norderld" ; sqloperate.gvdatabind(gvorderlnfo, sqlstr);string sqlstrtprice = "select sum(goodsprice) as tprice from tbrderlnfo"+ " where ordcrmcmbcr=," + convcrt.tostring(scssion"mnamc") + and ischeckout='否”sqlconn.

12、open();sqldataadapter myda = new sqldataadapter(sqlstrtprice, sqlconn);dataset myds = new dataset();myda.fill(myds, "tb_orderinfo");datarowview mydrv = myds.tables"tb_orderinfo".defaultview0;labmoney.text = convert.tostring(mydrv.rowl"tprice'r);protected void lbtnchcck_c

13、lick(objcct sender, eventargs c)if (labmoney.text ="”)response. write("<script>alert(,您的購物車中沒有任何物品');</script>");elsestring sqlstr = "select membername,membermoney from tb_member wheremembername=,n + session”mname”.tostring() +；sqlconn.opcn();sqldataadapter myda =

14、 new sqldataadapter(sqlstr, sqlconn);dataset myds = new dataset();myda.fill(myds, ktb_memberm);datarowview mydrv = myds.tablesmtb_memberm.defaultviewoj;string mprice = convert.tostring(mydrv.rowmmembermoneynl);if (convcrt.toint32(mpricc) < convcrt.toint32(labmoncy.tcxt.trim()response.write(h<s

15、cript>alert(的余額不足,請重新充值后再購買!elsestring sqlstrshopl = hupdate tb_member set membermoney=nr+ (convert.toint32(mprice) - convert.toint32(labmoney.text) + where membername='" + session"mname".tostring() + sqloperate.datacom(sqlstrshop 1);string sqlstrshop2 = update tb_orderinfo set

16、 ischeckout是'where ordermember=,n + sessionumnamehl.tostring() +;sqlopcratc.datacom(sqlstrshop2);response.redirect(hsuccshop.aspxm);protected void lbtnclcar_click(objcct sender, evcntargs c)string sqlstr = mdelete from tb_orderinfo where ordermember=n,+ session,rmnamen.tostring() + ,m and ischec

17、kout=*否，; sqloperate.datacom(sqlstr);response.rcdircct(hshopping.aspxh);protected void gvorderinfo_pageindexchanging(object sender, gridviewpageeventargs e) gvorderlnfo.pagelndex = e.newpagelndex;gvordcrinfo.databind();protected void gvorderlnfo_rowdatabound(object sender, gridviewroweventargs e)if

18、(e.row.rowtype = datacontrolro wtype. dataro w)(linkbutton)(e.row.cells3.controls0).attributes.add("onclick", "return confirm。確定要刪除嗎?')“)；protected void gvordcrinfo_rowdclcting(objcct sender, gridvicwdclctcevcntargs c)string sqlstr = "delete from tb_orderinfo where orderld=,m

19、 + gvorderinfo.datakeyse.rowlndexj. value +sqloperate.datacom(sqlstr);response.redirect(ushopping.aspxh);4 購物信息查詢購物信息查詢請輸入會員id:適詢購物信息查詢請輸入會員id: 1皆印cjl商務(wù)男裝衣朋cj1商務(wù)男裝衣朋380是380是源碼：public partial class mcmbcrmanagc_ordcrinfo : system.wcb.ui.pagesqloperate sqloperate = new sqloperate();sqlconnection sqlco

20、nn = newsqlconnection(configurationmanager.appsettingsmconnectionstringmj); protected void page_load(object sender, eventargs e)if(!ispostback)protected void txtsel_click(object sender, eventargs e)if (sessionnmnameh = null)response.write(n<script>alertc還沒有登錄，請登錄后再使用，謝謝！ ,);location=javascript

21、:history.go(-1 )'</script>h);elsethis.gvbind();protected void gvshopinfo_pageindexchanging(object sender, gridviewpageeventargs e) gvshopi nfo.pagelndex = e.newpagelndex;this.gvbind();public void gvbind()string sqlstr = "select memberldmembername from tb_member where memberid=n, + txt

22、mid.text.trimo +;sqlconn.open();sqlcommand sqlcom = new sqlcommand(sqlstr,sqlconn);int count = convcrt.toint32(sqlcom.exccutcscalar();if (count > 0)sqldataadapter myda = new sqldataadapter(sqlstr, sqlconn);dataset myds = new dataset();myda.fill(myds, ntb_mcmbcrm);datarowview mydrv = myds.tablesht

23、b_memberm.defaultviewo;string sqlstrbind = ”select * from tb_orderinfo where ordermember=,h+ convert.tostring(mydrv.row,membernamehj) + ,n,;sqlcommand com = new sqlcommand(sqlstrbind,sqlconn);int countinfo = convcrt.toint32(com.exccutcscaiar();if (countinfo > 0)sqloperate.gvdatabind(gvshopinfo, s

24、qlstrbind);elsegvshopinfo. visible = false;response. write(” vscript>alen('沒有該會員購物信息')</script>u);elseresponse.write("<script>alert(,沒冇該用戶,請您重新輸入!,);location='javascript:history.go(-1 )'</script>");5.后臺管理功能:cj i 廠|、西褲 牛仔褲后臺入口用戶名:密碼：7944査詢條件：商品id二關(guān)査詢1商奔禺

25、裝衣服380是詳細(xì)信息2西服衣服460是詳細(xì)值患3事7代鞋1000是詳細(xì)信恿辭余6褲子333是詳細(xì)信息剛除7牛仔廉牙刷128是詳細(xì)fl息8er維電視機(jī)2900是詳細(xì)值息m9長虹電視機(jī)1400否詳細(xì)ftfll10海er$調(diào)主調(diào)1000是詳細(xì)值患會員管理源碼：1登錄:public partial class adminmanagc_login : system webui pageprotected void pago_load(object sender, evcntargs c)(if (!ispostback)random randobj = new random (); labcode.

26、text = randobj. next (1000, 10000). tostringo ;protected void imagebuttonl_click(object sender, imageclickeventargs e)sqlconnectionsqlconn=newsqlconncction(configurationvkinagcr. appsettingsconnectionstring，z);sqlconn. 0pcn();sqlcommand sqlcom = new sqlcominand (，zproadminlnfo", sqlconn); sqlco

27、m. conunandtypo = commandtypostorodprocoduro;sqlcom. parameters. add (adminnanie", sqldbtype. varchar, 20). value txt/dm in nam c. text trimo ;sqlcom. parameters. add (，adminpwdz，,sqldbtype. varchar,20). value =txtadminpwd text trimo ；sqldatareader road = sqlcomexccutorcador();if (txtadmincode.

28、 text. trimo = labcode. text. trimo)if (read. reado)/response. write(z，<scriptlanguage=javascript>windows open(' adminindex aspx，);/script");response redirect (，zadmininclex aspx");response. write("<script>alert c您輸入的用戶名或密碼錯誤，請重新輸入! );location二'javascript :history.

29、 go(t) ;</script>，z);response. write (/z<script>alert c驗證碼輸入有誤，請重新輸入 );location=，javascript:history. go(t) ；/script")；protected void imagebutton2_click(object sender, imagedickevontargs o)response write(，z<script>window closco ; location二'javascript :history. go(一 1)'

30、;</script>z，)v2.后臺管理：1.管理員添加或者刪除：查詢條件:id號0關(guān)鍵字:m號姓名瓷碼詳細(xì)信息除6 adimn 123詳細(xì)信息刪除public partial class adminmanagc_editadmin : system.wcb.ui.page sqlconnection sqlconn = newsqlconnection(configurationmanage rappsettingsconnectionstting); sqloperate sqloperate = new sqloperate();protected void pagc_loa

31、d(objcct sender, evcntargs c)if (jlspostback)txtaid.text = requestnadminidh.tostring(); string sqlstr = "select * from tb_admin where adminid=m+requestmadminidh.tostring()+;sqlconn.open();sql data adapter myda = new sqldataadapter(sqlstr,sqlconn);dataset myds = new dataset(); myda.fill(myds,&qu

32、ot;tb_admin");datarowview mydrv=myds.tablesntb_adminnj.defaultview0j; txtaname.text = convert.tostring(mydrv.rowmadminnamehl)； txtapwd.tcxt = convert.tostring(mydrv.rowhadminpwdn); sqlconn.close();1protected void btnadd_click(object sender, eventargs e)string sqltest = "select * from tb_ad

33、min where adminname=,m + txtaname.text + ,mu sqlconn.open();sqlcommand sqlcom = new sqlcommand(sqltest, sqlconn);sqldatareader read = sqlcom.executereader();rcad.rcad();if (read.hasrows)if (this.txtaname.text.trimo = read"adminname".tostring().trim()response.write(h<script language=java

34、script'>alert('該管理員已經(jīng)存在 ,);localtion=,editadniin.aspx'</script>");return;elsestring sqlstr = "insert into tb_admin(adminname,adminpwd)"+ ” values(”' + txtaname.text.trim() + ,h,n, + txtapwd.text.trim() + ” sqloperate.datacom(sqlstr);response. writeckscripoaler

35、tc 添加成功');location='adminmanage.aspx'</script>");protected void btnedit_click(object sender, eventargs e)string sqlstr = "update tb_admin set adminnamc=,"4-txtanamc.tcxt.trim() +"adminpwd=,"+txtapwd.text.trim()+u' whereadminld="'+request"a

36、dminld"j.tostring()+",h;sqlopcratc.datacom(sqlstr);response. write(u<script>alert(,修改成功,);location=,adminmanage.aspx,;</script>h);protected void btnback_click(object sender, eventargs e) response. redircct("adminmanageaspx”)；查詢2.商品管理：查詢條件:商品id商品名稱商品類別商品價格是否推薦詳細(xì)信息1商務(wù)男裝衣朋380

37、是詳細(xì)信息刪除2西服衣服460是詳細(xì)信息刪除3訓(xùn)代鞋1000是詳細(xì)信息刪除6西褲褲子333是詳細(xì)信息刪除7牛仔褲牙刷128是詳細(xì)信息刪除8倉曠維電視機(jī)2900是詳細(xì)信息刪除9長水虹電視機(jī)1400否詳細(xì)信息刪除10海&咗調(diào)空調(diào)1000是詳細(xì)信息刪除public partial class adminmanage_editgoods : system.web.ui.pagesqloperate sqloperate = new sqloperate();sqlconncction sqlconn = newsqlconnection(configurationmanage 匚 appset

38、tingscormectionstringj); protected void page_load(object sender, eventargs e)sqlconn.open();if (jispostback)string sqlstr = mselect * from tb_goodstypeh; sqloperate.ddldatabind(ddlgtype, sqlstr,mgoodstypenameh); string sqlstrshow = "select * from tb.goodsinfo where goodsid=,h+request,goodsid,&#

39、39;l.tostring()+;sqldataadaptcr myaptcr = new sqldataadaptcr(sqlstrshow,sqlconn); dataset mydset = new dataset(); myapter.fill(mydset/tb_goodsinfon);datarowvicw mydrvicw=mydsct.tablcsntb_goodsinfon.dcfaultvicw0; txtgname.text = convert.tostring(mydrview.rowmgoodsnamem); txtgprice.text = convert.tost

40、ring(mydrview.rowhgoodspricemj); txtgintroduce.text = convert.tostring(mydrview.rowngoodsintroducenj); imgphoto. imageurl = converttostring(mydrviewrowgoodsphoto0); string sqlstrimg = "select image from (bmagen; sqloperate.ddldatabind(ddlphoto>sqlstrimg/,imagem);string strgid;strgid = conver

41、t.tostring(mydrview.row"goodstypeid");string sqlstrbind 二"select * from tb_goodstype where goodstypeid=,h + strgid + ;sqldataadapter myda = new sqldataadapter(sqlstrbind, sqlconn);dataset myds = new dataset(); myda.fill(myds, "tb_goodstype");datarowview mydrv = myds.tablesmt

42、b_goodstypem.defaultview0; ddlgtypc.sclcctcdvaluc = convert.tostring(mydrv.row,goodstypename,1); sessiongid”二 strgid;if (convert.tostring(mydrview.rowmgoodsisnew").trim()= ”是”)cblsnew.checked = true; else cblsnew.checked = false;sqlconn.close();protected void btnadd_click(object sender, eventar

43、gs e)string sqltest = "select * from tbgoodsinfo where goodsname=,r + this.txtgname.text +sqlconn.opcn();sqlcommand sqlcom = new sqlcommand(sqltest, sqlconn);sqldatareader read = sqlco m. executereader();read.read();if (read.hasrows)if (this.txtgnamc.tcxt.trim() = read"goodsname".tost

44、ring().trim()response.write(n<script language=,javascript,>alert(,i 商 品 已經(jīng)存在 ,);localtion=,editgoods.aspx,</script>u);return;else read.closeo; goodsid();訐(cblsnew.checked = true)string sqlstr = insert into tb_goodsinfon+h(goodsname,goodsprice,goodstypeid,goodslsnew,goodsintroduce,goodsph

45、oto)m+ "valuesc" + txtgname.text.trim() + txtgprice.text.trim()+ ”+ sessiongidj.tostringo + 是+ txtgintroduce.text.trim()+ ddlphoto.sclcctcdvaluc +sqloperate.datacom(sqlstr);1elsestring sqlstr = "insert into tb_goodsinfon+h(goodsname,goodsprice,goodstypeid,goodslsnew,goodsintroduce,goo

46、dsphoto)m+ "valuesc" + txtgname.text.trim() + txtgprice.text.trim()+ scssionngidh.tostring() + 舄否+ txtgintroduce.text.trim()+ ddlphoto.sclcctcdvaluc +sqloperate.datacom(sqlstr);1protected void btnedit_click(objcct sender, evcntargs c)goodsid();訐(cblsnew.checked = true)string sqlstr = hupda

47、tc tb_goodsinfo set goodsnamc=nr+txtgnaitic.tcxt.trim() +",goodsprice="'4-txtgprice.text.trim()+',goodstypeid=,m 4-session',gid,.tostring()+'",goodsisnew=,是；goodslntroduce”+ txtgintroduce.text.trim() + ”',goodsphoto=”' + ddlphoto.selectedvalue+ n, where goodsid

48、="' + request,goodsid,.tostring() + ”' sqlopcratc.datacom(sqlstr);elsestring sqlstr = "update tb_goodsinfo set goodsname=u, + txtgname.text.trim()+ n,goodsprice=,h + txtgprice.text.trim() + ,m,goodstypeid=,u+ session! "gid" .tostringo + "',goodsisnew=,否;goodslntr

49、oduce"+ txtgintroduce.text.trimo + '",goodsphoto=n' + ddlphoto.selectedvalue+ "'where goodsld='" + request"goodsldhj.tostring() +sqlopcratc.datacom(sqlstr);protected void btnback_click(object sender, eventargs e)response.redirect(hgoodsmanage.aspxn);protected

50、 void ddlphoto_selectedindexchanged(object sender, eventargs e)i mgphoto. imageu rl = ddlphoto.selectedvalue;public void goodsid()string sqlstrbind = "select * from tb_goodstype where goodstypename=,m + ddlgtype.selectedvalue +；sql data adapter myda = new sqldataadaptcr( sqlstrbind, sqlconn);da

51、taset myds = new dataset();myda.fill(myds, htb_goodstype");datarowview mydrv = myds.tablesmtb_goodstypem.defaultviewoj;sessionf'gid" = convert.tostring(mydrv"goodstypeid");3.會員管理：查詢查詢條件：會員id 0關(guān)謹(jǐn)字:?員會員名地址電話 email會員充值詳細(xì)信息除1cjl 11l*9123詳細(xì)信息刪除public partial class adminmanage_edit

52、mcmbor : systemweb.ui.pagosqlopcrate sqloperate = new sqloperateo;sqlco rm cctionsqlconn=newsqlconnection(configurationmanager appsettingsconnectionstringz，);protected void pago_load(object sender, eventargs c)if (!ispostback) sqlconn. open ();string sqlstr = "select * from tb_member wheremembe

53、rid=，+request member!d，z. tostri ng () +sqldataadapter myapter = new sqldataadapter(sqlstr, sqlconn);dataset myds 二 new dataset (); myapter. fill(myds, "tb member);datarowview rowview = myds. tables"tbmcmbcr". i)cfaultvicwo; txtusertd.text = convert tostring(rowviewheinberid"); t

54、xtloginname .text = converttostring(rowview"membername"); txtpwd. text = convert. tostring(rowviewz，memberpwd，z); txttname .text = converttostring(rowview"membertname"); txtqucpwd.text = convert. tostring(rowvicwicmbcrque); txtanspwd.text = convert tostring(rowviewheinberans"

55、;); txttel.text = converttostring(rowviewmemberphone"); txtemai1text = converttostring(rowviewmemberemai1");ddlci ty. selectedvalue = convert tostring(rowview"membercity); txtaddress .text = convcr t tostring (rowview mcmberadclress); txtpostcode .text = converttostring(rowview"m

56、emberpostcode"); txtmoney text = converl toslring(rowview，zmembermoney"); string sqlstrbind = ''select * from tb_imagc" sqldataadapter mydabind = new sqldataadapter(sqlstrbind, sqlconn); dataset mydsbind = new dataset ();mydabind fill(mydsbind, 氣b_lmage");ddlpholo. dataso

57、urce = mydsbindtables"tb image" ddlphoto. datatextfield = "image"ddlphoto. databind ();igphoto. imageutl = convert.tostring(rowview"memberphoto"); if (convert. tostring(rowviewtmembersexj). trimo ="男") ddlscx scloctc?dindex = 0;if (convert. tostring(rowviewfmcmber