menumanagelistservlet.java

来自「这是一个内容管理系统（CMS）以MVC方式写出,没有使用框架」· Java 代码 · 共 125 行

package servlet.article;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class for Servlet: MenuManageListServlet
 *
 */
 public class MenuManageListServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
	private static final long serialVersionUID = 1L;
		/* (non-Java-doc)
		 * @see javax.servlet.http.HttpServlet#HttpServlet()
		 */
		 //private DBControl DC=new DBControl();
	 	db.DB dt; 
	 	String webpath="";
		 PrintWriter out;
		public MenuManageListServlet() {
			super();
		}   	
		
		/* (non-Java-doc)
		 * @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
		 */
		protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
			response.setContentType("text/html;charset=gb2312");
			request.setCharacterEncoding("gb2312");//按中文方式编码
			out=response.getWriter();
			dt=new db.DB();
			webpath=request.getContextPath();
		      try {
		    	  ResultSet sqlRst=dt.getRs("select * from menu where Depth=1 order by OrderList");
		    	  out.println("<table width='100%' border='1' cellpadding='1' cellspacing='0' bordercolor='#EFEFEF'>");
		    	  out.println("<tr bgcolor='#C8E6FB'><td align='center'>栏目名</td><td align='center'>栏目编号</td><td align='center'>是否显示到首页</td><td align='center'>操作</td><td align='center'>排序</td></tr>");
		    	  while(sqlRst.next()) {
		    		  out.println("<tr><td>"+sqlRst.getString("MenuName")+"</td>");
		    		  out.println("<td align='center'>"+sqlRst.getString("Id")+"</td>");
		    		  String StatM="是";
		    		  if(sqlRst.getString("IsShow").trim().equals("0"))
		    			  StatM="否";
		    		  out.println("<td align='center'>"+StatM+"</td><td align='center'>");
		    		  out.println("<a href='"+request.getContextPath()+"/EnterEditMenuServlet?Id="+sqlRst.getString("Id").trim()+"'>编缉</a>");
		    		  if(sqlRst.getString("IsShow").trim().equals("0"))
		    			  out.println("<a href='"+webpath+"/MenuOperateServlet?action=enable&Id="+sqlRst.getString("Id").trim()+"'>显示</a>");
		    		  else
		    			  out.println("<a href='"+webpath+"/MenuOperateServlet?action=unenable&Id="+sqlRst.getString("Id").trim()+"'>不显示</a>");
		    		  out.println("<a href='"+webpath+"/MenuOperateServlet?action=delete&Id="+sqlRst.getString("Id").trim()+"' onclick='return delArticleSpecialConfirm()'>删除</a>");
		    		  out.println("</td><td align='center'><a href='"+webpath+"/MenuOperateServlet?action=orderup&Id="+
		    				  sqlRst.getString("Id").trim()+"' title='向上'>升↑</a><a href='"+
		    				  webpath+"/MenuOperateServlet?action=orderdown&Id="+sqlRst.getString("Id")+
		    				  "' title='向下'>降↓</a></td></tr>");
		    		  ChildMenuList(sqlRst.getInt("Id"));
		    	  }
		    	  out.println("</table>");
		    	  sqlRst.close();
		      }
		      catch(Exception e) {
		    	  System.out.println("MenuManageListServlet得到管理栏目列表时出错："+e.toString());
		      }
		      finally {dt.close();
		      out.close();
		      }
		}  	  	
		private void ChildMenuList(int ParentID){	
			//PreparedStatement p_Stm=null;
			ResultSet r_rs=dt.getRs("select * from menu where ParentID="+ParentID+" order by OrderList");
			try{
				//p_Stm=DC.conn.prepareStatement(sql);	r_rs=p_Stm.executeQuery();
					while(r_rs.next()){
						out.println("<tr>");
						String str="";
						for(int i=2;i<r_rs.getInt("Depth");i++)
						{
							if(i==2)
								str+="├";
							else
								str+="-";
						}
			    		out.println("<td>"+str+"├"+r_rs.getString("MenuName")+"</td>");
			    		out.println("<td align='center'>"+r_rs.getString("Id")+"</td>");
			    		  String StatM="是";
			    		  if(r_rs.getString("IsShow").trim().equals("0"))
			    			  StatM="否";
			    		  out.println("<td align='center'>"+StatM+"</td>");
			    		  out.println("<td align='center'>");
			    		  out.println("<a href='"+webpath+"/EnterEditMenuServlet?Id="+r_rs.getString("Id").trim()+"'>编缉</a>");
			    		  if(r_rs.getString("IsShow").trim().equals("0"))
			    			  out.println("<a href='"+webpath+"/MenuOperateServlet?action=enable&Id="+r_rs.getString("Id").trim()+"'>显示</a>");
			    		  else
			    			  out.println("<a href='"+webpath+"/MenuOperateServlet?action=unenable&Id="+r_rs.getString("Id").trim()+"'>不显示</a>");
			    		  out.println("<a href='"+webpath+"/MenuOperateServlet?action=delete&Id="+r_rs.getString("Id").trim()+"' onclick='return delArticleSpecialConfirm()'>删除</a>");
			    		  out.println("</td>");
			    		  out.println("<td align='center'>");
			    		  out.println("<a href='"+webpath+"/MenuOperateServlet?action=orderup&Id="+r_rs.getString("Id").trim()+"' title='向上'>升↑</a>");
			    		  out.println("<a href='"+webpath+"/MenuOperateServlet?action=orderdown&Id="+r_rs.getString("Id").trim()+"' title='向下'>降↓</a>");
			    		  out.println("</td>");
			    		  out.println("</tr>");
						ChildMenuList(r_rs.getInt("Id"));//用递归调用查找子菜单
					}
			}
			catch(SQLException ex){
				System.out.println("MenuManageListServlet得到管理栏目列表子菜单："+ex);
			}
			finally
			{
				try
				{
					r_rs.close();
					dt.close();
				}
				catch(SQLException ex)
				{
					System.out.println("MenuManageListServlet在查找子菜单关闭记录集时出错："+ex);
				}
				
			}		
		}	
	}