chaoshi.rar_maybell2_代码

package wyf.hxl; import java.io.*; import java.util.*; import javax.servlet.*; import javax.servlet.http.*; /** * Created by dell on 2018/9/10. */ @SuppressWarnings("serial") public class ManageServlet extends HttpServlet { public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException { this.doPost(request,response); } public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException { request.setCharacterEncoding("GBK"); response.setCharacterEncoding("GBK"); response.setContentType("text/html;charset=GBK"); HttpSession session=request.getSession(true); PrintWriter out=response.getWriter(); ManageBean spSearch = (ManageBean)session.getAttribute("spSearch"); if(spSearch==null){ spSearch = new ManageBean(); } String action=request.getParameter("action").trim(); if(action.equals("typeshanchu")) { String gidw = request.getParameter("deletetype"); int gid=Integer.parseInt(gidw); String sql5 = " use book_shop3;delete from Books where Books.CategoryId=(Select Categories.Id from Categories where Categories.Id=("+gid+"))delete from Categories where Id=("+gid+")"; sql5= new String(sql5.getBytes(),"GBK"); int flag = DB.updateMeg(sql5); String msg=null; if(flag==0) { msg = "删除商品类型失败，请重新添加！！！"; } else { msg = "删除商品类型成功！！！"; } request.setAttribute("msg",msg); ServletContext sc = getServletContext(); //得到上下文 RequestDispatcher rd = sc.getRequestDispatcher("/goodstypexg2.jsp"); rd.forward(request,response); } else if(action.equals("typexiugai")) { String gtw = request.getParameter("newtype"); String xgid = request.getParameter("xgid"); if(gtw==null){ System.out.print("这里为空"); } if(xgid==null){ System.out.print("为空"); } int newid = Integer.parseInt(xgid.trim()); String sql4 ="use book_shop3;update Categories set Name=('"+gtw+"') where Id='"+newid+"'"; sql4= new String(sql4.getBytes(),"GBK"); int flag = DB.updateMeg(sql4); String msg=null; if(flag==0) { msg = "修改商品类型失败，请重新添加！！！"; } else { msg = "修改商品类型成功！！！"; } request.setAttribute("msg",msg); ServletContext sc = getServletContext(); //得到上下文 RequestDispatcher rd = sc.getRequestDispatcher("/goodstypexg1.jsp"); rd.forward(request,response); } else if(action.equals("typetianjia")) { String gtw = request.getParameter("gtype").trim(); String typeidw = request.getParameter("typeid"); int typeid = Integer.parseInt(typeidw); String sql6 = "use book_shop3;set IDENTITY_INSERT Categories on;insert into Categories(Name,Id) values('"+gtw+"',"+typeid+")"; sql6= new String(sql6.getBytes(),"GBK"); int flag = DB.updateMeg(sql6); String msg=null; if(flag==0) { msg = "添加商品类型失败，请重新添加！！！"; } else { msg = "添加商品类型成功！！！"; } request.setAttribute("msg",msg); ServletContext sc = getServletContext(); //得到上下文 RequestDispatcher rd = sc.getRequestDispatcher("/goodstypexg.jsp"); rd.forward(request,response); } else if(action.equals("cbssc")) { String gidw = request.getParameter("deletecbs"); int gid= Integer.parseInt(gidw); String sql5 = "use book_shop3;delete from Books where PublisherId=(Select Publishers.Id from Publishers where Publishers.Id=("+gid+"))delete from Publishers where Id=("+gid+")"; sql5= new String(sql5.getBytes(),"GBK"); int flag = DB.updateMeg(sql5); String msg=null; if(flag==0) { msg = "删除出版社失败，请重新添加！！！"; } else { msg = "删除出版社成功！！！"; } request.setAttribute("msg",msg); ServletContext sc = getServletContext(); //得到上下文 RequestDispatcher rd = sc.getRequestDispatcher("/cbsxg2.jsp"); rd.forward(request,response); } else if(action.equals("cbsxiugai")) { String gtw = request.getParameter("newcbs"); String xgid = request.getParameter("xgid"); int newid = Integer.parseInt(xgid); String sql4 ="use book_shop3;update Publishers set Name=('"+gtw+"') where Id='"+newid+"'"; sql4= new String(sql4.getBytes(),"GBK"); int flag = DB.updateMeg(sql4); String msg=null; if(flag==0) { msg = "修改出版社失败，请重新添加！！！"; } else { msg = "修改出版社成功！！！"; } request.setAttribute("msg",msg); ServletContext sc = getServletContext(); //得到上下文 RequestDispatcher rd = sc.getRequestDispatcher("/cbsxg1.jsp"); rd.forward(request,response); } else if(action.equals("cbstianjia")) { String gtw = request.getParameter("gcbs").trim(); String typeidw = request.getParameter("cbsid"); int typeid = Integer.parseInt(typeidw); String sql6 = "use book_shop3;set IDENTITY_INSERT Publishers on;insert into Publishers(Name,Id) values('"+gtw+"',"+typeid+")"; sql6= new String(sql6.getBytes(),"GBK"); int flag = DB.updateMeg(sql6); String msg=null; if(flag==0) { msg = "添加出版社失败，请重新添加！！！"; } else { msg = "添加出版社成功！！！"; } request.setAttribute("msg",msg); ServletContext sc = getServletContext(); //得到上下文 RequestDispatcher rd = sc.getRequestDispatcher("/cbsxg.jsp"); rd.forward(request,response); } else if(action.equals("add")) { String gnw = request.getParameter("goodsname"); String auw = request.getParameter("Author"); String cbsw = request.getParameter("chubanshe"); request.getParameter("gdate"); String isw = request.getParameter("ISBN"); String wow = request.getParameter("WordsCount"); String gpw = request.getParameter("gprice"); String cdw = request.getParameter("gintroduction"); String adw = request.getParameter("AuthorDescription"); String ecw = request.getParameter("EditorComment"); String tocw= request.getParameter("TOC"); String gamountw = request.getParameter("gamount"); String Gimurlw = request.getParameter("Gimgurl"); String gtw = request.getParameter("gtype"); String cliw= request.getParameter("Clicks");