package com.action; import java.io.IOException; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import javax.servlet.RequestDispatcher; import javax.servlet.ServletConfig; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.dao.DB; import com.orm.Tcatelog; import com.service.liuService; public class catelog_servlet extends HttpServlet { @Override public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException { String type=req.getParameter("type"); if(type.endsWith("catelogAdd")) { catelogAdd(req, res); } if(type.endsWith("catelogDel")) { catelogDel(req, res); } if(type.endsWith("catelogMana")) { catelogMana(req, res); } if(type.endsWith("catelogAll")) { catelogAll(req, res); } if(type.endsWith("catelogDetail")) { catelogDetail(req, res); } } public void catelogAdd(HttpServletRequest req,HttpServletResponse res) { String id=null; String name=req.getParameter("name"); String jieshao=req.getParameter("jieshao"); String del="no"; String sql="insert into t_catelog(id,name,jieshao,del) values(?,?,?,?)"; Object[] params={id,name,jieshao,del}; DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed(); req.setAttribute("message", "²Ù×÷³É¹¦"); req.setAttribute("path", "catelog?type=catelogMana"); String targetURL = "/common/success.jsp"; dispatch(targetURL, req, res); } public void catelogDel(HttpServletRequest req,HttpServletResponse res) { String sql="update t_catelog set del='yes' where id="+Integer.parseInt(req.getParameter("id")); Object[] params={}; DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed(); req.setAttribute("message", "²Ù×÷³É¹¦"); req.setAttribute("path", "catelog?type=catelogMana"); String targetURL = "/common/success.jsp"; dispatch(targetURL, req, res); } public void catelogMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException { List catelogList=new ArrayList(); String sql="select * from t_catelog where del='no'"; Object[] params={}; DB mydb=new DB(); try { mydb.doPstm(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()) { Tcatelog catelog=new Tcatelog(); catelog.setId(rs.getInt("id")); catelog.setName(rs.getString("name")); catelog.setJieshao(rs.getString("jieshao")); catelogList.add(catelog); } rs.close(); } catch(Exception e) { e.printStackTrace(); } mydb.closed(); req.setAttribute("catelogList", catelogList); req.getRequestDispatcher("admin/catelog/catelogMana.jsp").forward(req, res); } public void catelogAll(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException { List catelogList=new ArrayList(); String sql="select * from t_catelog where del='no'"; Object[] params={}; DB mydb=new DB(); try { mydb.doPstm(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()) { Tcatelog catelog=new Tcatelog(); catelog.setId(rs.getInt("id")); catelog.setName(rs.getString("name")); catelog.setJieshao(rs.getString("jieshao")); catelog.setZhutiList(liuService.getZhutiListQian8(rs.getInt("id"))); catelogList.add(catelog); } rs.close(); } catch(Exception e) { e.printStackTrace(); } mydb.closed(); req.setAttribute("catelogList", catelogList); req.getRequestDispatcher("qiantai/catelog/catelogAll.jsp").forward(req, res); } public void catelogDetail(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException { List catelogList=new ArrayList(); int id=Integer.parseInt(req.getParameter("id")); String sql="select * from t_catelog where del='no' and id="+id; Object[] params={}; DB mydb=new DB(); try { mydb.doPstm(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()) { Tcatelog catelog=new Tcatelog(); catelog.setId(rs.getInt("id")); catelog.setName(rs.getString("name")); catelog.setJieshao(rs.getString("jieshao")); catelog.setZhutiList(liuService.getZhutiListAll(rs.getInt("id"))); catelogList.add(catelog); } rs.close(); } catch(Exception e) { e.printStackTrace(); } mydb.closed(); req.setAttribute("catelogList", catelogList); req.getRequestDispatcher("qiantai/catelog/catelogDetail.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(); } } @Override public void init(ServletConfig config) throws ServletException { super.init(config); } @Override public void destroy() { } }