户外用品销售网站源程序代码.doc

重庆大学网络教育学院毕业论文范本户外用品销售网站源程序代码1、网站首页index.jsp代码清单4.2.1户外用品销售网站 a href= align=left隐藏 / a href=显示 登陆 | 新用户注册 | 管理员入口   % if(index+1 a href=# onclick=window.open(,s,width=850,height=600,scrollbars=yes,resizeable=yes,ststus=yes);img src= width=135 height=200 border=0 商品名： 类别： 单价：¥ a href=# onclick=window.open(,s,width=300,height=300,scrollbars=yes,resizeable=yes,ststus=yes);       % if(index+2 a href=# onclick=window.open(,s,width=850,height=600,scrollbars=yes,resizeable=yes,ststus=yes);img src= width=135 height=200 border=0 商品名： 类别： 单价：¥ a href=# onclick=window.open(,s,width=300,height=300,scrollbars=yes,resizeable=yes,ststus=yes);           % if(index+3 a href=# onclick=window.open(,s,width=850,height=600,scrollbars=yes,resizeable=yes,ststus=yes);img src= width=135 height=200 border=0 商品名： 类别： 单价：¥ a href=# onclick=window.open(,s,width=300,height=300,scrollbars=yes,resizeable=yes,ststus=yes);       % if(index+4 a href=# onclick=window.open(,s,width=850,height=600,scrollbars=yes,resizeable=yes,ststus=yes);img src= width=135 height=200 border=0 商品名： 类别： 单价：¥ a href=# onclick=window.open(,s,width=300,height=300,scrollbars=yes,resizeable=yes,ststus=yes);           % if(index+5 a href=# onclick=window.open(,s,width=850,height=600,scrollbars=yes,resizeable=yes,ststus=yes);img src= width=135 height=200 border=0 商品名： 类别： 单价：¥ a href=# onclick=window.open(,s,width=300,height=300,scrollbars=yes,resizeable=yes,ststus=yes);       % if(index+6 a href=# onclick=window.open(,s,width=850,height=600,scrollbars=yes,resizeable=yes,ststus=yes);img src= width=135 height=200 border=0 商品名： 类别： 单价：¥ a href=# onclick=window.open(,s,width=300,height=300,scrollbars=yes,resizeable=yes,ststus=yes);       % string aft=/outdoorshop/index.jsp?pg=+integer.tostring(index/6+2);string pre=/outdoorshop/index.jsp?pg=+integer.tostring(index/6);if(pg.equals(1) if(integer.parseint(pg) 上一页   共/页   a href=下一页 上一页   共/页   下一页 % else if(integer.parseint(pg) a href=上一页   共/页   a href=下一页 a href=上一页   共/页   下一页 2、showoutdoor.java的代码清单4.2.2/* * 该servlet接受来自index.jsp中户外用品导航链接及站内搜索的请求， * 用于判断需显示户外用品并从数据库中读出对应户外用品信息， * 最后将控制权交给index.jsp */import java.io.*;import java.sql.*;import java.util.*;import javax.servlet.*;import javax.servlet.http.*;import bean.outdoorinf;import bean.dbclass;import bean.strclass;public class showoutdoor extends httpservletpublic void doget(httpservletrequest request, httpservletresponse response)throws servletexception, ioexceptionrequest.setcharacterencoding(gb2312);string key=request.getparameter(key); /key变量用于储存用户搜索信息string message=;vector outdoorlist=new vector(); /outdoorlist变量用于显示待显示图书的信息httpsession session=request.getsession();string query=select * from outdoor where ; /query变量用于储存sql语句/* 移除session中已有outdoorlist变量 */if(session.getattribute(boolist)!=null)session.removeattribute(boolist);/* 判断哪些图书需要被显示 */if(key=null) /用户没有进行站内搜索if(request.getparameter(type)=null) query+=ifnew=yes; else string type=;if(request.getparameter(type).equals(dsx)type=登山鞋;if(request.getparameter(type).equals(tbx)type=徒步鞋;if(request.getparameter(type).equals(sxx)type=溯溪鞋;if(request.getparameter(type).equals(stx)type=沙滩鞋;if(request.getparameter(type).equals(gsx)type=高山鞋;if(request.getparameter(type).equals(dgnx)type=多功能鞋;if(request.getparameter(type).equals(xxhwx)type=休闲户外鞋;if(request.getparameter(type).equals(xxbb)type=小型背包;if(request.getparameter(type).equals(zxbb)type=中型背包;if(request.getparameter(type).equals(dxbb)type=大型背包;if(request.getparameter(type).equals(fyz)type=背包防雨罩;if(request.getparameter(type).equals(ybgb)type=腰包/挂包;if(request.getparameter(type).equals(shd)type=水袋;if(request.getparameter(type).equals(cfy)type=冲锋衣;if(request.getparameter(type).equals(zry)type=抓绒衣;if(request.getparameter(type).equals(hwny)type=户外内衣;if(request.getparameter(type).equals(hwkz)type=户外裤装;if(request.getparameter(type).equals(hwts)type=户外t恤;if(request.getparameter(type).equals(hwcs)type=户外衬衫;if(request.getparameter(type).equals(hwwz)type=户外袜子;if(request.getparameter(type).equals(zp)type=帐篷;if(request.getparameter(type).equals(sd)type=睡袋;if(request.getparameter(type).equals(fcd)type=防潮垫;if(request.getparameter(type).equals(xsb)type=洗漱包;if(request.getparameter(type).equals(kjkl)type=烤架/烤炉;if(request.getparameter(type).equals(tgcj)type=套锅餐具;if(request.getparameter(type).equals(qlyl)type=气炉油炉;if(request.getparameter(type).equals(ydd)type=营地灯/头灯;if(request.getparameter(type).equals(sdt)type=手电筒;if(request.getparameter(type).equals(znz)type=指南针;if(request.getparameter(type).equals(dsz)type=登山杖;if(request.getparameter(type).equals(hwyj)type=户外眼镜;query+=type=+ type + ; else /请求来自用户搜索query+=name like + %+ key+ % + or author like + %+ key + % + or publisher like + %+ key+ %; /* 数据库操作 */dbclass db=new dbclass(); db.connect(); resultset resultset=db.executequery(query);trywhile(resultset.next()outdoorinf outdoor=new outdoorinf(resultset.getstring(id), resultset.getstring(name), resultset.getstring(price), resultset.getstring(type);outdoorlist.addelement(outdoor);catch(sqlexception sqle)message=executeupdate:+sqle;db.closeconnection();/* 将outdoorlist写入session并转到index.jsp */session.setattribute(outdoorlist, outdoorlist);response.sendredirect(/outdoorshop/index.jsp);public void dopost(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception doget(request, response);3、outdoorinf.java的代码清单4.2.3/* * 这是一个用于储存户外用品信息的bean */package bean;import java.util.*;public class outdoorinfprivate string id; /商品号private string name; /商品名private string price;/单价private string type; /类型public outdoorinf()id=;name=;price=;type=;public outdoorinf(string id,string name,string price,string type)this.id=id;=name;this.price=price;this.type=type; public string getid() return id; public void setid(string id) this.id=id; public string getname() return name; public void setname(string name) =name; public string getprice() return price; public void setprice(string price) this.price=price; public string gettype() return type; public void settype(string type) this.type=type;4、menuhidden.java的代码清单4.2.4/* * 该servlet用于隐藏用户菜单 */import java.io.*;import javax.servlet.*;import javax.servlet.http.*;public class menuhidden extends httpservletpublic void doget(httpservletrequest request, httpservletresponse response)throws servletexception, ioexceptionhttpsession session=request.getsession();/* 如果session中没有hidden变量，则设置一个；否则保持原状 */if(session.getattribute(hidden)=null)session.setattribute(hidden,hidden);/* 返回发出请求的页面 */string tojsp=request.getparameter(jspurl)+?+request.getparameter(param);response.sendredirect(tojsp);5、menushow.java的代码清单4.2.5/* * 该servlet用于显示用户菜单 */import java.io.*;import javax.servlet.*;import javax.servlet.http.*;public class menushow extends httpservletpublic void doget(httpservletrequest request, httpservletresponse response)throws servletexception, ioexceptionhttpsession session=request.getsession();/* 如果session中有hidden变量，则移除；否则保持原状 */if(session.getattribute(hidden)!=null)session.removeattribute(hidden);/* 返回发出请求的页面 */string tojsp=request.getparameter(jspurl)+?+request.getparameter(param);response.sendredirect(tojsp);6、样式表css文件清单4.2.6/*/* emx_nav_left.css */* use with template halo_leftnav.html */*/*/* html tag styles */*/bodyfont-family: arial,sans-serif;color: #333333;line-height: 1.166;margin: 0px;padding: 0px;background: #cccccc url(bg_grad.jpg) fixed;/* hyperlink and anchor tag styles */a:link, a:visitedcolor: #005fa9;text-