usermangerlistservlet.java

这是一个内容管理系统（CMS）以MVC方式写出,没有使用框架

package servlet.user;

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

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

/**
 * Servlet implementation class for Servlet: UserMangerListServlet
 *
 */
 public class UserMangerListServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public UserMangerListServlet() {
		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");//按中文方式编码
		PrintWriter out = response.getWriter();
		String webpath = request.getContextPath();
	    db.DB dt=new db.DB();
	    try {
	    	  ResultSet sqlRst=dt.getRs("select * from useraccount order by Id");
	    	  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'>最后登录IP</td><td align='center'>最后登录时间</td><td align='center'>操作</td></tr>");
	    	  while(sqlRst.next()){
	    		  out.println("<tr><td>"+sqlRst.getString("UserName")+
	    				  "</td><td align='center'>");
	    		  if(sqlRst.getString("UserType").trim().equals("issupper"))
	    			  out.println("超级管理员");
	    		  else out.println("一般管理员");
	    		  out.println("</td><td>"
	    				+sqlRst.getString("UserIP")+"</td><td>"
	    				+sqlRst.getString("UserTime")
	    		  		+"</td><td align='center'><a href='"
	    		  		+webpath.trim()
	    		  		+"/jsjadmin/user/user_edit.jsp?Id="+sqlRst.getString("Id")+"'>修改权限</a>");
	    		  out.println("<a href='"+webpath.trim()+"/jsjadmin/user/user_passwordchange.jsp?UserName="+sqlRst.getString("UserName")+"'>修改密码</a>");
	    		  if(sqlRst.getString("NoDel").trim().equals("0")){
	    			  out.println("<a href='"+webpath.trim()+"/UserOperaServlet?Id="+sqlRst.getString("Id")+"' onclick='return delArticleSpecialConfirm()'>删除</a>");
	    		  }
	    		  out.println("</td></tr>");
	    	  }	  
	    	  out.println("</table>");
	      }
	      catch(Exception e){
	    	  System.out.println("MenuManageListServlet得到管理栏目列表时出错："+e.toString());
	      }
	      finally{
	    	  dt.close();	    	  
	      }
	}
	
	/* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
	}   	  	    
}