网上购物系统 - 图文(6)

第四章 系统的实现及功能流程

String tate = \; String path = \; String str = \;

SmartUpload mySmartUpload = new SmartUpload();//init mySmartUpload.initialize(config,request,response); try {

mySmartUpload.upload();

name = mySmartUpload.getRequest().getParameter(\).trim(); author = mySmartUpload.getRequest().getParameter(\).trim(); publishing =

number = mySmartUpload.getRequest().getParameter(\).trim(); price = mySmartUpload.getRequest().getParameter(\).trim(); storage = mySmartUpload.getRequest().getParameter(\).trim(); brief = mySmartUpload.getRequest().getParameter(\).trim(); type = mySmartUpload.getRequest().getParameter(\).trim(); tate = mySmartUpload.getRequest().getParameter(\).trim();

int count = 0;

SmartFile file = mySmartUpload.getFiles().getFile(0); String fileExt = file.getFileExt(); path=\;

InsertUpdateDelBean ib = new InsertUpdateDelBean();

mySmartUpload.getRequest().getParameter(\).trim();

String sql = \into books([name], [author], [publishing], [number],

\

[price], [storage], [brief], [type], [tate], [imgpath])\ +

values('\+name+\+author+\+publishing+\+number+\+price+\+storage+\+brief+\+type+\+tate+\+path.substring(1)+\+file.getFileName()+\;

}

20

int flag = ib.insertANDupdateANDdel(sql); if(flag == -1){ }

count = mySmartUpload.save(path); // TODO自动生成 catch 块 e.printStackTrace();

str = \;

request.setAttribute(\, \); str = \; request.setAttribute(\, \);

}else{

} catch (SmartUploadException e) {

}

RequestDispatcher rd=request.getRequestDispatcher(str);

rd.forward(request,response);

publicvoid doPost(HttpServletRequest request, HttpServletResponse response) }

throws ServletException, IOException { doGet(request,response);

修改已有商品的界面和主要代码如下

图4.15 修改已有商品界面图

publicvoid doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException { Validate vd = new Validate();

String id = vd.getUnicode(request.getParameter(\)); String name = vd.getUnicode(request.getParameter(\)); String author = vd.getUnicode(request.getParameter(\));

String publishing = vd.getUnicode(request.getParameter(\)); String number = vd.getUnicode(request.getParameter(\)); String price = vd.getUnicode(request.getParameter(\)); String storage = vd.getUnicode(request.getParameter(\));

21

第四章 系统的实现及功能流程

String brief = vd.getUnicode(request.getParameter(\)); String type = vd.getUnicode(request.getParameter(\)); String sql =\

name='\+name+\+author+\+publishing+\+number+\+price+\+storage+\+brief+\+type+\+id+\;

InsertUpdateDelBean ib = new InsertUpdateDelBean(); ib.insertANDupdateANDdel(sql); SelectBean sb = new SelectBean();

String sql2 = \+id+\; String[] args2 =

{\,\,\,\,\,\,\,\,\,\,\,\};

RequestDispatcher

rd=request.getRequestDispatcher(\); rd.forward(request,response);

}

ArrayList al2 = sb.select(sql2, args2); request.setAttribute(\, al2);

删除商品的界面和主要代码如下

图4.16 删除商品界面图

if(bookid != null&& !bookid.equals(\)){

}

str = \;

sql = \+bookid+\; ib.insertANDupdateANDdel(sql);

4.3.5库销管理

及时了解库存和销售情况，能够使我们更好的知道商品现状，也就能够更好的制作销售和库存计划。库销管理的界面和主要代码如下：

22

图4.17 库销管理界面图

publicvoid doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException { Validate vd = new Validate();

String kuda = vd.getUnicode(request.getParameter(\)); String kuxiao = vd.getUnicode(request.getParameter(\)); String souda = vd.getUnicode(request.getParameter(\)); String souxiao = vd.getUnicode(request.getParameter(\)); String sql = \; String[] args =

{\,\,\,\,\,\,\,\,\,\,\,\};

}

if(kuda != null&& !kuda.equals(\)){ }

if(kuxiao != null&& !kuxiao.equals(\)){ }

if(souda != null&& !souda.equals(\)){ }

if(souxiao != null&& !souxiao.equals(\)){ }

SelectBean sb = new SelectBean(); ArrayList al = sb.select(sql, args); request.setAttribute(\, al);

RequestDispatcher rd=request.getRequestDispatcher(\);

sql += \+souxiao; sql += \+souda; sql += \+kuxiao; sql += \+kuda;

rd.forward(request,response);

4.3.6公告管理功能

在购物网站中显示公告，有利于提高系统的质量。对公告的管理包括添加新的公告，删除和修改已添加的公告。

添加新公告的界面和主要代码如下

23

第四章 系统的实现及功能流程

图4.18 添加公告界面图

publicvoid doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException { Validate vd = new Validate();

String name = vd.getUnicode(request.getParameter(\)); String content = vd.getUnicode(request.getParameter(\)); String sql =\InsertUpdateDelBean ib = new InsertUpdateDelBean(); int flag = ib.insertANDupdateANDdel(sql); String str = \; if(flag == -1){ }

RequestDispatcher rd=request.getRequestDispatcher(str); rd.forward(request,response);

24

values('\+name+\+content+\;

str = \; request.setAttribute(\, \); str = \; request.setAttribute(\, \);

}else{