oracle数据库课程设计报告书

*/

private void doup(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

String currentPage = request.getParameter(\request.setAttribute(\

request.getRequestDispatcher(\request, response); }

}

购物车实现

public class CartServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request,response);}

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

String bookID = request.getParameter(\System.out.println(bookID);

String path = request.getContextPath(); HttpSession session = request.getSession();

UserMain userMain = (UserMain) session.getAttribute(\

List bList = DBHelper.findEasy(\bookID=?\

String bookstat=bList.get(0).getBookStat();

if(bookstat.equals(\下架\该商品已经下架不能购买\

request.setAttribute(\\type='button' value='返回' onclick='window.history.back()'/>\

request.getRequestDispatcher(\t, response); }

else{String userID=null;

if(userMain!=null){userID=userMain.getUserID(); String number = request.getParameter(\String count;//商品数量

if(number==null){count=\else{count=number;} int result=-1;

//判断该商品该用户在数据库中是否存在,如果存在则商品数量类加

List sList= DBHelper.findEasy(\where bookID=? and userID=?\

if(sList!=null&&sList.size()>0){

String count2=Integer.parseInt(count)+sList.get(0).getBookNumber()+\

String sql=\tb_shoppinginfo set booknumber=? where bookID=? and userID=?\

result=DBHelper.doUpdateEasy(sql,new String[]{count2,bookID,userID}); }

else{String sql = \

result=DBHelper.doUpdateEasy(sql,new String[]{count,bookID,userID});}

if(result>0){response.sendRedirect(path+\

else{request.setAttribute(\加入购物车失败！\

request.getRequestDispatcher(\response);}

}

else{request.setAttribute(\请先登录!\

request.getRequestDispatcher(\response); }

} }

} 将所选书籍从购物车中删除的实现

/**

* 将书籍从购物车中删除 * @author Administrator * */

public class DelCart extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request,response); }

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

HttpSession session = request.getSession();

UserMain user = (UserMain) session.getAttribute(\String userID = user.getUserID();

String bookID = request.getParameter(\

int result = DBHelper.doUpdateEasy(\tb_shoppinginfo where bookID=? and userID=?\

if(result>0){request.getRequestDispatcher(\forward(request, response); }

else{System.out.println(\删除商品失败\}

} }

管理员书籍管理中修改书籍信息实现

public class UpdateBooksServlet extends HttpServlet { /**

* The doGet method of the servlet.
*

* This method is called when a form has its tag value method equals to get. *

* @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred

* @throws IOException if an error occurred */

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request,response);}

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

JspFactory _jspxFactory = JspFactory.getDefaultFactory();

PageContext pageContext = _jspxFactory.getPageContext(this, request, response, null, true, 8192, true); // 初始化上传对象

SmartUpload smartUpload = new SmartUpload();

// ServletConfig config = this.getServletConfig();

//------------------------------获取参数------------------------------ //------------------------------获取参数------------------------------ //-------------------------------文件上传---------------------------- //smartUpload.initialize(config, request, response); smartUpload.initialize(pageContext); try {// 允许上传的文件

//smartUpload.setAllowedFilesList(\// 禁止上传的文件

// smartUpload.setDeniedFilesList(\// 上传文件

smartUpload.upload(); // 得到文件对象

// File smartFile=smartUpload.getFiles().getFile(0); // 得到文件名字(全名)

// String name=smartFile.getFilePathName(); // 名字(部分)

// String name=smartFile.getFileName(); // 获取参数值

// smartUpload.getRequest().getParameter(name); // 多个文件上传

// 将上传文件全部保存到指定目录

int count = smartUpload.save(\

File smartFile = smartUpload.getFiles().getFile(0);

String bookID = smartUpload.getRequest().getParameter(\String bookTitle=smartUpload.getRequest().getParameter(\String bookStat =smartUpload.getRequest().getParameter(\String bookType =smartUpload.getRequest().getParameter(\String bookPrice=smartUpload.getRequest().getParameter(\String bookNumber=smartUpload.getRequest().getParameter(\String author =smartUpload.getRequest().getParameter(\String bookDesc =smartUpload.getRequest().getParameter(\String froms = smartUpload.getRequest().getParameter(\

//String bookPicturePath=smartUpload.getRequest().getParameter(\ Date date = new Date();

String timeStr=String.valueOf(date.getTime()); String pictuerID=bookID+\

String pictuerName=pictuerID+\ if(smartFile.getFileName().equals(\

int result= DBHelper.doUpdateEasy( \tb_booksinfo set bookNumber=?,bookTitle=?,bookPrice=?,bookDesc=?,typeID=?,author=?,bookStat=?wherebookID=?\

String[]{bookNumber,bookTitle,bookPrice,bookDesc,bookType,author,bookStat,bookID});

if(result>0){request.setAttribute(\修改成功\

request.setAttribute(\返回列表 onclick=\\\put type='button' value='继续修改' onclick='window.history.back()'/>\ request.getRequestDispatcher(\response);}

else{request.setAttribute(\输入信息格式错误或数值过大，修改失败\

request.setAttribute(\\type='button' value='返回' onclick='window.history.back()'/>\

request.getRequestDispatcher(\response);}

}

else{int result= DBHelper.doUpdateEasy(\tb_booksinfo set bookNumber=?,bookTitle=?,bookPrice=?,bookPicture=?,bookDesc=?,typeID=?,author=?,bookStat=?wherebookID=?\

String[]{bookNumber,bookTitle,bookPrice,pictuerName,bookDesc,bookType,author,bookStat,bookID});

System.out.println(count+\个文件上传成功！
\

//for (int i = 0; i < smartUpload.getFiles().getCount(); i++) { // 若文件不存在则继续

//if (smartFile.isMissing()) //continue;

System.out.println(pictuerName);

smartFile.saveAs(\ smartFile.SAVEAS_VIRTUAL);

if(result>0){request.setAttribute(\修改成功\

request.getRequestDispatcher(\response); }

else{request.setAttribute(\输入信息格式错误或数值过大，修改失败\ request.setAttribute(\\type='button' value='返回' onclick='window.history.back()'/>\

request.getRequestDispatcher(\response); }