商城实验 java servlet javabean mysql

package com.niit.shopping.servlet; import java.io.File; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.apache.commons.fileupload.FileItem; import org.apache.commons.fileupload.disk.DiskFileItemFactory; import org.apache.commons.fileupload.servlet.ServletFileUpload; import com.niit.shopping.DAO.goodDAO; import com.niit.shopping.Impl.goodImpl; import com.niit.shopping.bean.Goods; import com.niit.shopping.DB.DBUtil; /** * 对商品数据的增删查改 * @author lenovo * *商品的大体思路就是商品jsp页面传入数据，在servlet中对数据进行处理加工。 *如果需要存入数据库，或者需要与数据库中的数据验证的话，就在implament中定义与数据库交互的方法，对传入的参数进行处理加工，dao中定义数据库的方法便于管理。 *处理完成之后再将处理过的数据传入到jsp中，在jsp中对数据进行显示。 * */ public class goodsServlet extends HttpServlet { private Connection conn; goodDAO dao; public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); String flag = request.getParameter("flag"); HttpSession session = request.getSession(); dao = new goodImpl(); /*if ("cn".equals(flag)) { //判断商品名字是否非法 String userName = request.getParameter("goodName"); String f = null; if (dao.checkName(userName)) { //检查商品的名字 f = "invalid"; } else { f = "valid"; } // 回复xml至jsp response.setContentType("text/xml"); PrintWriter out = response.getWriter(); out.write("<msg>" + f + "</msg>"); out.flush(); out.close(); } else*/ if("shouye".equals(flag)){ //跳转回首页消除左边的框架 PrintWriter pw = response.getWriter(); pw.write("<script language=javaScript> parent.location.href='/Shopping/InitServlet';</script>"); } else if ("reg".equals(flag)) { //正常的注册 // 正常注册 // 图片上传 enctype="multipart/form-data" String goodName = null; String Price = null; // String sex = null; String shuoming = ""; String image = ""; DiskFileItemFactory factory = new DiskFileItemFactory(); ServletFileUpload upload = new ServletFileUpload(factory); try { List items = upload.parseRequest(request); Iterator itr = items.iterator(); while (itr.hasNext()) { FileItem item = (FileItem) itr.next(); if (item.isFormField()) { // 获取参数值 if (item.getFieldName().equals("goodName")) { goodName = item.getString("UTF-8"); } else if (item.getFieldName().equals("price")) { Price = item.getString("UTF-8"); } else if (item.getFieldName().equals("shuoming")) { shuoming = item.getString("UTF-8"); } } else { // 文件上传操作 if (item.getSize() != 0) { String[] ss = item.getName().split("\\."); image = goodName + "." + ss[ss.length - 1]; File tempFile = new File(image); File file = new File(this.getServletContext() .getRealPath("/pic"), tempFile.getName()); item.write(file); } else { image = "flo.jpg"; } } } } catch (Exception e) { e.printStackTrace(); } double price = Double.parseDouble(Price); dao.addGood(goodName, price, shuoming, image); request.getRequestDispatcher("/admin/succA.jsp").forward(request, response); } else if ("search".equals(flag)) { //搜索功能的实现 String index = request.getParameter("index"); ArrayList<Goods> Goods = dao.search(index); request.setAttribute("goods", Goods); request.getRequestDispatcher("/show.jsp") .forward(request, response); } else if ("del".equals(flag)) { //商品删除功能的实现 // 通过用户名获取User对象 String GoodId = request.getParameter("goodId"); // System.out.println("yes"); int goodId = Integer.parseInt(GoodId); dao.deleteDingdan(goodId); dao.delete(goodId); dao.deleteGood(goodId); request.getRequestDispatcher("/admin/del.jsp") .forward(request, response); } else if ("xiugai".equals(flag)) { //商品修改功能 的实现 // 通过用户名获取User对象 // String userName = (String)session.getAttribute("userName"); String image = ""; String goodName = ""; String Price = ""; String GoodId = ""; String info = ""; DiskFileItemFactory factory = new DiskFileItemFactory(); ServletFileUpload upload = new ServletFileUpload(factory); try { List items = upload.parseRequest(request); Iterator itr = items.iterator(); while (itr.hasNext()) { FileItem item = (FileItem) itr.next(); if (item.isFormField()) { // 获取参数值 if (item.getFieldName().equals("goodId")) { GoodId = item.getString("UTF-8"); } else if (item.getFieldName().equals("shuoming")) { info = item.getString("UTF-8"); } else if (item.getFieldName().equals("price")) { Price = item.getString("UTF-8"); } else if (item.getFieldName().equals("goodName")) { goodName = item.getString("UTF-8"); } } else { // 文件上传操作 if (item.getSize() != 0) { String[] ss = item.getName().split("\\."); image = goodName + "." + ss[ss.length - 1]; System.out.println(image); File tempFile = new File(image); File file = new File(this.getServletContext() .getRealPath("/pic"), tempFile.getName()); item.write(file); } } } } catch (Exception e) { e.printStackTrace(); } // System.out.println(GoodId); int goodId = Integer.parseInt(GoodId); double price = Double.parseDouble(Price); // System.out.println(goodId+GoodId); dao.updateInfo(goodId, goodName, price, info, image); request.getRequestDispatcher("/admin/upGood.jsp") .forward(request, response); } else if ("xiu".equals(flag)) { //将参数传到修改中 让修改方法去执行 // 通过用户名获取User对象 // String userName = (String)session.getAttribute("userName"); String goodName = request.getParameter("goodName"); String Price = request.getParameter("price"); String GoodId = request.getParameter("goodId"); String image = request.getParameter("image"); int goodId = Integer.parseInt(GoodId); double price = Double.parseDouble(Price); request.setAttribute("goodId", goodId); request.setAttribute("goodName", goodName); request.setAttribute("price", price); request.setAttribute("image", image); request.getRequestDispatcher("/admin/up.jsp").forward(request, response); } } }