毕业设计：基于jsp的鞋店管理系统

package servlet; import java.io.IOException; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import model.TXiezi; import db.DB; public class xiezi_servlet extends HttpServlet{ public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException { String type=req.getParameter("type"); if(type.endsWith("xieziMana")) { xieziMana(req, res); } if(type.endsWith("xieziAll")) { xieziAll(req, res); } if(type.endsWith("kucun")) { kucun(req, res); } if(type.endsWith("xieziAdd")) { xieziAdd(req, res); } if(type.endsWith("xieziUpd")) { xieziUpd(req, res); } if(type.endsWith("xieziDele")) { xieziDele(req, res); } } public void xieziAdd(HttpServletRequest req,HttpServletResponse res){ String bianhao = req.getParameter("bianhao"); String mingcheng = req.getParameter("mingcheng"); String pinpai= req.getParameter("pinpai"); String chima = req.getParameter("chima"); String yanse = req.getParameter("yanse"); String danjia = req.getParameter("danjia"); int shuliang = 0; String del = "no"; String sql = "insert into t_xiezi values (?,?,?,?,?,?,?,?)"; Object[] params={bianhao,mingcheng,pinpai,chima,yanse,danjia,shuliang,del}; DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed(); req.setAttribute("message", "操作成功"); req.setAttribute("path", "xiezi?type=xieziMana"); String targetURL = "/common/success.jsp"; dispatch(targetURL, req, res); } public void xieziUpd(HttpServletRequest req,HttpServletResponse res){ String id = req.getParameter("id"); String bianhao = req.getParameter("bianhao"); String mingcheng = req.getParameter("mingcheng"); String pinpai= req.getParameter("pinpai"); String chima = req.getParameter("chima"); String yanse = req.getParameter("yanse"); String danjia = req.getParameter("danjia"); String sql = "update t_xiezi set bianhao=?,mingcheng=?,pinpai=?,chima=?,yanse=?," + "danjia=? where id=?"; Object[] params={bianhao,mingcheng,pinpai,chima,yanse,danjia,id}; DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed(); req.setAttribute("message", "操作成功"); req.setAttribute("path", "xiezi?type=xieziMana"); String targetURL = "/common/success.jsp"; dispatch(targetURL, req, res); } public void xieziDele(HttpServletRequest req,HttpServletResponse res){ String id = req.getParameter("id"); String del = "yes"; String sql = "update t_xiezi set del=? where id=?"; Object[] params={del,id}; DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed(); req.setAttribute("message", "操作成功"); req.setAttribute("path", "xiezi?type=xieziMana"); String targetURL = "/common/success.jsp"; dispatch(targetURL, req, res); } public void xieziMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException { List xieziList = new ArrayList(); String sql = "select * from t_xiezi where del = 'no'"; Object[] params={}; DB mydb=new DB(); try { mydb.doPstm(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()) { TXiezi xiezi = new TXiezi(); xiezi.setId(rs.getInt("id")); xiezi.setBianhao(rs.getString("bianhao")); xiezi.setMingcheng(rs.getString("mingcheng")); xiezi.setPinpai(rs.getString("pinpai")); xiezi.setChima(rs.getString("chima")); xiezi.setYanse(rs.getString("yanse")); xiezi.setDanjia(rs.getString("danjia")); xiezi.setShuliang(rs.getInt("shuliang")); xieziList.add(xiezi); } rs.close(); } catch(Exception e) { e.printStackTrace(); } mydb.closed(); req.setAttribute("xieziList", xieziList); req.getRequestDispatcher("admin/xiezi/xieziMana.jsp").forward(req, res); } public void xieziAll(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException { List xieziList = new ArrayList(); String sql = "select * from t_xiezi where del = 'no'"; Object[] params={}; DB mydb=new DB(); try { mydb.doPstm(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()) { TXiezi xiezi = new TXiezi(); xiezi.setId(rs.getInt("id")); xiezi.setBianhao(rs.getString("bianhao")); xiezi.setMingcheng(rs.getString("mingcheng")); xiezi.setPinpai(rs.getString("pinpai")); xiezi.setChima(rs.getString("chima")); xiezi.setYanse(rs.getString("yanse")); xiezi.setDanjia(rs.getString("danjia")); xiezi.setShuliang(rs.getInt("shuliang")); xieziList.add(xiezi); } rs.close(); } catch(Exception e) { e.printStackTrace(); } mydb.closed(); req.setAttribute("xieziList", xieziList); req.getRequestDispatcher("admin/xiezi/xieziSele.jsp").forward(req, res); } public void kucun(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException { List xieziList = new ArrayList(); String sql = "select ta.*,tb.gonghuoshang from t_xiezi ta,t_jinhuo tb where ta.id=tb.xiezi_id and del = 'no'"; Object[] params={}; DB mydb=new DB(); try { mydb.doPstm(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()) { TXiezi xiezi = new TXiezi(); xiezi.setId(rs.getInt("id")); xiezi.setBianhao(rs.getString("bianhao")); xiezi.setMingcheng(rs.getString("mingcheng")); xiezi.setPinpai(rs.getString("pinpai")); xiezi.setChima(rs.getString("chima")); xiezi.setYanse(rs.getString("yanse")); xiezi.setDanjia(rs.getString("danjia")); xiezi.setShuliang(rs.getInt("shuliang")); xiezi.setGonghuoshang(rs.getString("gonghuoshang")); xieziList.add(xiezi); } rs.close(); } catch(Exception e) { e.printStackTrace(); } mydb.closed(); req.setAttribute("xieziList", xieziList); req.getRequestDispatcher("admin/xiezi/kucun.jsp").forward(req, res); } public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) { RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI); try { dispatch.forward(request, response); return; } catch (ServletException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } }