selectuserservlet.java

一个完整的代码管理系统的源代码

package hunnu.edu.cn.product.servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
//import javax.servlet.http.HttpSession;


import hunnu.edu.cn.product.common.db.dao.implement.DaoFactory;
import hunnu.edu.cn.product.common.db.model.TB_USER_MST;
import hunnu.edu.cn.product.common.splitPages.*; 



public class SelectUserServlet extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	/**
	 * Constructor of the object.
	 */
	public SelectUserServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html; charset=gbk");
		HttpSession session = request.getSession(true);
		PrintWriter out = response.getWriter();
		String user_login=request.getParameter("user_login");
		String user_group_id=request.getParameter("user_group_id");
		String user_flag=request.getParameter("user_flg");
		String sql;
		String user_id=request.getParameter("user_id");
		String str= (String)session.getAttribute("selectUser");
		String type= request.getParameter("type");
		String page= request.getParameter("page");
		
		 PagedStatementOracleImpl pso =null;
		 int pageNo;
		if(user_id!=null){
			int id= Integer.parseInt(user_id);
			DaoFactory factory=DaoFactory.newInstance();
		    TB_USER_MST user1=factory.newTB_USER_MSTDao().getByID(id);
		    request.setAttribute("user1", user1);
//		    sql="select user_id,user_login,user_flg_name ,user_group_name,user_name from tb_user_mst u ,tb_user_flg_mst f,tb_user_group_mst g where u.user_login='"+user1.getUser_login()+"'and u.user_group_id='"+user1.getUser_group_id()+"'and u.user_flg='"+user1.getUser_flg()+"'"+" and u.user_flg=f.user_flg and u.user_group_id=g.user_group_id";
		}
		if(type==null){
          
		 if((user_login!=null)&&(user_group_id!=null)&&(user_flag!=null))
			sql="select user_id,user_login,user_flg_name ,user_group_name,user_name from tb_user_mst u ,tb_user_flg_mst f,tb_user_group_mst g where u.user_login='"+user_login+"'and u.user_group_id='"+user_group_id+"'and u.user_flg='"+user_flag+"'"+"and u.user_flg=f.user_flg and u.user_group_id=g.user_group_id";
		
		 else{
		 if(str!=null)
		{
			sql=str;
			
		}
			
		else
			sql="select user_id,user_login,user_flg_name ,user_group_name,user_name from tb_user_mst u ,tb_user_flg_mst f,tb_user_group_mst g where u.user_flg=f.user_flg and u.user_group_id=g.user_group_id";
		 }
		}
		else{
			
			sql="select user_id,user_login,user_flg_name ,user_group_name,user_name from tb_user_mst u ,tb_user_flg_mst f,tb_user_group_mst g where u.user_flg=f.user_flg and u.user_group_id=g.user_group_id";
		}
	     session.setAttribute("selectUser", sql);
		 
	    if(page!=null){
			  pageNo =Integer.parseInt(page);
			  
			   pso =  new PagedStatementOracleImpl(sql,pageNo,4);
		       }
	     else {
			    pso =  new PagedStatementOracleImpl(sql,1,4);
			   }
	        try{
	        	RowSetPage rsp  = pso.executeQuery();
	  	        request.setAttribute("rsp", rsp);
	  	       RequestDispatcher rd; 
	  		   rd=request.getRequestDispatcher("UserManager.jsp"); 
	  		   rd.forward(request,response);
//	            out.println("<table width='85%' border='1' align='center' cellpadding='1' cellspacing='1'>");
//                out.println("<tr><td width='18%'>用户ID</td><td width='19%'>用户登录名</td><td width='21%'>用户状态</td><td width='21%'>用户组信息</td><td width='21%'>用户真实姓名</td></tr>");
 //              
	//           while(rs.next()){
//	            	System.out.print(rs.getString(1));
//	        }
//	            	System.out.print("     ");
//	            	System.out.println(rs.getString(2));
//	            	out.print("<tr><td>");
//	            	out.print(rs.getString(1));
//	            	out.print("</td><td>");
//	            	out.print(rs.getString(2));
//	            	out.print("</td><td>");
//	            	out.print(rs.getString(7));
//	            	out.print("</td><td>");
//	            	out.print(rs.getString(6));
//	            	out.print("</td><td>");
//	            	out.print(rs.getString(4));
//	            	out.print("<tr>");
            //    }
	           
//	            System.out.println(i);
//	            System.out.println(j);
//	            System.out.println(k);
	     }catch (Exception e){
	        	
	        	System.out.print(e.getMessage());
	        }

		
		out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
		out.println("<HTML>");
		out.println("  <HEAD><TITLE>A Servlet</TITLE></HEAD>");
		out.println("  <BODY>");
		out.print("    This is ");
		out.print(this.getClass());
		out.println(", using the GET method");
		out.println("  </BODY>");
		out.println("</HTML>");
		out.flush();
		out.close();
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doGet(request,response);
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}