图书销售电子商务网站设计方案

图书销售电子商务网站设计方案1、设计目的2、怎样设计3、设计哪些功能4、系统流程图条件：身份验证条件：多类型查询图书电子商务流程图客户供应商查看信息商品上架选购商品购物车订购单出货单发货单销售单结算单登陆登陆选购购物处理货物、钱的统计结算主页系统主要功能图数据库设计用户表：图书表：------分类表购物表：（user_id,book_id,num）订单表：（user_id,book_id,num,price,total）结算表：(user_id,book_id,num,price,total,all,all-dz,money)技术路线（系统实现）一、采用工具二、主要功能的实现1、商品上架HTMLHEADLINKhref=css.cssrel=stylesheettype=text/cssTITLE/TITLE/HEADBODYcentertableborder=0cellpadding=0cellspacing=0width=760formaction=AddNews.jspmethod=postname=fbFormtralign=centerheight=40tdcolspan=2b商品发布/b/td/tr商品上架选购中心购物车结算用户管理trheight=40tdimgsrc=images/yd.gif名称*：/tdtdinputtype=textname=titlesize=72/tdtrheight=40tdimgsrc=images/yd.gif简介：/tdtdtextareaname=contextrows=15cols=72style=COLOR:#606060;FONT-SIZE:12px;border-style:solid;border-width:1;/textarea/td/trtrheight=40tdimgsrc=images/yd.gif类别*：/tdtdselectname=bmoptionvalue=0--请选择--/option%ResultSetrs=null;try{db.creatConnection();rs=db.stmt.executeQuery(select*fromtzbm);while(rs.next()){out.print(optionvalue=+rs.getString(1)+--+newString(rs.getString(2).trim().getBytes(iso8859_1))+--/option);}%/select/td/trtrtdimgsrc=images/yd.gif商品类型*：/tdtdselectname=typeoptionvalue=0----请选择----/option%rs=db.stmt.executeQuery(select*fromnews_type);while(rs.next()){out.print(optionvalue=+rs.getString(1)+-----+newString(rs.getString(2).trim().getBytes(iso8859_1))+-----/option);}%/select/td/trtrheight=40tdimgsrc=images/yd.gif其它：/tdtdinputtype=inputname=urlsize=72/td/trtrheight=40td/tdtdinputtype=submitvalue=提交    inputtype=resetvalue=清空/td/tr/table/form/center/BODY/HTML%Stringtitle=request.getParameter(title);StringtypeId=request.getParameter(type);Stringbm=request.getParameter(bm);Stringbdcs=request.getParameter(bdcs);Stringputtime=request.getParameter(puttime);if(title==null||title.length()==0||typeId.equals(0)){out.print(scriptwindow.alert('您可能漏填或漏选了某项');history.back()/script);return;}Stringcontent=request.getParameter(context);Stringurl=request.getParameter(url);ResultSetrs=null;try{db.creatConnection();db.stmt.executeUpdate(insertintonews_dt(user_id,title,content,type_id,bm_id,url,bdcs,puttime)values+('+userId+','+title+','+content+','+typeId+','+bm+','+url+','0',getdate()));out.print(恭喜您!!发布已成功,页面在fontcolor=red3/font秒后自动跳转);out.print(metahttp-equiv=refreshcontent=2;url=newsview.jsp);%%}catch(Exceptione){out.print(发生意外错误：+e.toString());}finally{if(rs!=null){rs.close();rs=null;}db.closeConnection();}%2、查看信息%StringnewsId=request.getParameter(news_id);ResultSetrs=null;try{db.creatConnection();db.stmt.executeUpdate(updatenews_dtsetbdcs=bdcs+1wherenews_id='+newsId+');rs=db.stmt.executeQuery(selectnews_dt.title,usergl.name,tzbm.bm_name,news_dt.content,+news_dt.url,news_dt.bdcs,news_dt.puttimefromnews_dt,tzbm,userglwherenews_dt.news_id='+newsId+'+andnews_dt.bm_id=tzbm.bm_idandusergl.id=news_dt.user_id);if(!rs.next()){db.closeConnection();out.print(此条信息可能已被删除！);return;}Stringurl=rs.getString(5);if(url!=null&&url.length()!=0&&!url.equals(null)){%3、购物车放货try{db.creatConnection();db.stmt.executeUpdate(insertintonews_dt(user_id,title,content,type_id,bm_id,url,bdcs,puttime)values+('+userId+','+title+','+content+','+typeId+','+bm+','+url+','0',getdate()));out.print(恭喜您!!发布已成功,页面在fontcolor=red3/font秒后自动跳转);out.print(metahttp-equiv=refreshcontent=2;url=newsview.jsp);%查货＜%try{db.creatConnection();db.stmt.executeUpdate(updatenews_dtsetbdcs=bdcs+1wherenews_id='+newsId+');rs=db.stmt.executeQuery(selectnews_dt.title,usergl.name,tzbm.bm_name,news_dt.content,+news_dt.url,news_dt.bdcs,news_dt.puttimefromnews_dt,tzbm,userglwherenews_dt.news_id='+newsId+'+andnews_dt.bm_id=tzbm.bm_idandusergl.id=news_dt.user_id);if(!rs.next()){db.closeConnection();out.print(此条信息可能已被删除！);return;}Stringurl=rs.getString(5);if(url!=null&&url.length()!=0&&!url.equals(null)){%5、效益分析