systemuserationaction.java

自己制作的联通CRM,支持客户分类,管理,升级,积分管理等等..

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.jn0801.login.systemuser.struts;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

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

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;
import com.jn0801.grademanage.RuleManageInf;
import com.jn0801.login.systemuser.SystemuaerDAO;
import com.jn0801.login.systemuser.SystemuserBean;
import com.jn0801.menuLink.RuleBean;
import com.jn0801.tools.DBConnection;
import com.jn0801.tools.PageDAO;

/** 
 * MyEclipse Struts
 * Creation date: 08-14-2008
 * 
 * XDoclet definition:
 * @struts.action path="/systemUserAtion" name="systemUserAtionForm" input="/form/systemUserAtion.jsp" scope="request" validate="true"
 */
public class SystemUserAtionAction extends DispatchAction {
	
 
	/**
	 * 显示系统用户列表的方法
	 *  跳转到用户列表页面
	 */
	public ActionForward show(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		SystemUserAtionForm systemUserAtionForm = (SystemUserAtionForm) form;
		SystemuaerDAO dao = new SystemuaerDAO(); 
		//ArrayList list = new ArrayList();
		//list = (ArrayList)dao.selectUser();
		//request.setAttribute("userlists", list);
		
		List list1 = dao.listGradeRule(null,request);
		request.setAttribute("userlists", list1);
		
		return mapping.findForward("userlist");
	}
	/**
	 * 跳转到添加页面
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward insert(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		SystemUserAtionForm systemUserAtionForm = (SystemUserAtionForm) form;
	
		SystemuaerDAO dao = new SystemuaerDAO();
		SystemuserBean bean = dao.serchrealname();
		List<RuleBean> rule =dao.selectRule();
		
		int aa =bean.getRealname();
	
		request.setAttribute("rolelist", rule);
		
		request.setAttribute("bean", aa+1);
		
		return mapping.findForward("userupdate");
	}
	/**
	 * 实现用户添加
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward insertuser(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		SystemUserAtionForm systemUserAtionForm = (SystemUserAtionForm) form;
	
		//显示用户数据操作
		SystemuaerDAO dao = new SystemuaerDAO();
		SystemuserBean bean = new SystemuserBean();
		  
		bean.setRealname(systemUserAtionForm.getRealname());
		
		bean.setRealnametwo(systemUserAtionForm.getRealnametwo());
		
		bean.setPassword(systemUserAtionForm.getPassword());
		bean.setRoleid(systemUserAtionForm.getRoleid());
		bean.setUsername(systemUserAtionForm.getUsername());
		
		
		if(systemUserAtionForm.getRoleid()==2){
			
			bean.setRealname(systemUserAtionForm.getRealname());
			bean.setRealnametwo(0);
			bean.setLoginname(systemUserAtionForm.getRealname());
			
			SystemuserBean beans = dao.serchrealname();
			int s1 =beans.getRealname();
			request.setAttribute("bean", s1+1);
		}
		if(systemUserAtionForm.getRoleid()==3){
			
			bean.setRealname(0);
			bean.setRealnametwo(systemUserAtionForm.getRealname());
			bean.setLoginname(systemUserAtionForm.getRealname());
			
			SystemuserBean beans = dao.serchrealnametwo();
			int s2 =beans.getRealnametwo();
			request.setAttribute("bean", s2+1);
			
		}
	
		String  username = systemUserAtionForm.getUsername();
		PrintWriter out;
		
//		if(dao.searchUser(username)==null){
			
			boolean aa = dao.insertUser(bean);
			
//		}else{
//			request.setAttribute("manage", "对不起添加失败,您所输入的用户名已被占用，请重新添加！");
//			return mapping.findForward("manage"); 
//		}

//		try {
//			response.sendRedirect(request.getContextPath()+"/systemUserAtion.do?task=show");
//		} catch (IOException e) {
//			// TODO 自动生成 catch 块
//			e.printStackTrace();
//		}
//		return null;
		
		SystemuserBean beanss = dao.serchrealname();
		int ww =beanss.getRealname();
		String nn = bean.getUsername();
		request.setAttribute("manage", "<br>恭喜您已添加成功，请点击 <返回列表> 按扭,查看添加信息或者其他操作！<br><br>您的所添加ID号为:"+ww+
				"  真实姓名为:"+nn+"<br><br>请记住密码退出系统后,可以进行登陆!");
		return mapping.findForward("manage");
	}
	/**
	 * 实现删除功能的方法
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward delete(ActionMapping mapping, ActionForm form,
		HttpServletRequest request, HttpServletResponse response) {
		
		SystemUserAtionForm systemUserAtionForm = (SystemUserAtionForm) form;
		SystemuaerDAO delete = new SystemuaerDAO();
		
		String aa= request.getParameter("nid");
		
		int id = Integer.parseInt(aa);
		
		boolean del = delete.deleteUser(id);
		
		
		PrintWriter out = null;
		try {
			out = response.getWriter();
		}
		catch (Exception e) {
			e.printStackTrace();
		}
		
		String url = "systemUserAtion.do?tag=show";
		if(del)
		{
			if(request.getParameter("currentpage") != null && !request.getParameter("currentpage").equals(""))
			{
				url = url + "&currentpage=" + request.getParameter("currentpage");
			}
			out.println("<script>alert('删除成功!');window.location.href='" + url +"'</script>");
		}
		else
		{
			out.println("<script>alert('删除失败!');window.history.back</script>");
		} 
		return null;
}
	/**
	 * 实现修改的功能
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward update(ActionMapping mapping, ActionForm form,
	HttpServletRequest request, HttpServletResponse response) {
		SystemUserAtionForm systemUserAtionForm = (SystemUserAtionForm) form;
		
		
		SystemuaerDAO daoa = new SystemuaerDAO();
		List rule =daoa.selectRule();
		request.setAttribute("rolelist", rule);
		
		
		SystemuaerDAO dao = new SystemuaerDAO();
		
		String aa=request.getParameter("nid");
		
		int id = Integer.parseInt(aa);
		
		SystemuserBean bean = dao.searchuser(id);
		
		Map map = new HashMap();
		if(request.getParameter("serchname") != null && !request.getParameter("serchname").equals(""))
		{
			map.put("serchname", request.getParameter("serchname"));
		}
		if(request.getParameter("currentpage") != null && !request.getParameter("currentpage").equals(""))
		{
			map.put("currentpage", request.getParameter("currentpage"));
		}
		request.setAttribute("map", map);
		
		request.setAttribute("userlist", bean);
		 
		return mapping.findForward("update");
	}
	/**
	 * 实现用户名称查询的功能
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward select(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		SystemUserAtionForm systemUserAtionForm = (SystemUserAtionForm) form;
		SystemuaerDAO dao = new SystemuaerDAO();
		SystemuserBean bean = new SystemuserBean();
		
		ArrayList list = new ArrayList();
		
		String name = request.getParameter("serchname");
		
		list = (ArrayList)dao.selectname(name);
		
		request.setAttribute("userlists", list);
		
//		List list1 = dao.listGradeRule(null,request);
//		
//		request.setAttribute("userlists", list1);
		
		return mapping.findForward("userlist");
	}
	
	/**
	 * 实现用户信息修改的功能
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return
	 */
	public ActionForward updateuser(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
				SystemUserAtionForm systemUserAtionForm = (SystemUserAtionForm) form;
				
				SystemuaerDAO dao = new SystemuaerDAO();
				SystemuserBean userbean = new SystemuserBean();
				
				userbean.setRealname(systemUserAtionForm.getRealname());
				userbean.setNid(systemUserAtionForm.getNid());
				userbean.setRoleid(systemUserAtionForm.getRoleid());
				userbean.setUsername(systemUserAtionForm.getUsername());
				
				boolean update=dao.updateUser(userbean);
				
				PrintWriter out = null;
				try {
					out = response.getWriter();
				} catch (IOException e) {
					// TODO 自动生成 catch 块
					e.printStackTrace();
				}
				String url="systemUserAtion.do?tag=show";
				if(update){
					if(request.getParameter("serchname") != null && !request.getParameter("serchname").equals(""))
					{
						url = url + "&serchname=" + request.getParameter("serchname");
					}
					if(request.getParameter("currentpage") != null && !request.getParameter("currentpage").equals(""))
					{
						url = url + "&currentpage=" + request.getParameter("currentpage");
					}
					out.println("<script>alert('修改成功!');window.location.href='" + url +"'</script>");
				}else{
					out.println("<script>alert('修改失败!');window.history.back</script>");
				}
				
				
				return null;
				
//				request.setAttribute("manage", "<br>恭喜您已修改成功，请点击 <返回列表> 按扭,查看修改信息或者其他操作！<br><br>"+
//						"  修改后的真实姓名为: "+userbean.getUsername()+"  !<br>");
//				
//				return mapping.findForward("manage");
				

//				PrintWriter out;  这段也是关键技术
//				try {
//					out = response.getWriter();
//					out.println("<script>window.location.href='"+request.getContextPath()+
//							"/systemUserAtion.do?task=show'</script>");
//				} catch (IOException e) {
//					// TODO 自动生成 catch 块
//					e.printStackTrace();
//				} 
			}
		/**
		 * 转到密码修改页面
		 * @param mapping
		 * @param form
		 * @param request
		 * @param response
		 * @return
		 */
		public ActionForward passwords(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
			SystemUserAtionForm systemUserAtionForm = (SystemUserAtionForm) form;
			
			return mapping.findForward("password");
		}
		public ActionForward passwordss(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
			SystemUserAtionForm systemUserAtionForm = (SystemUserAtionForm) form;
			
			return mapping.findForward("main");
		}
			/**
			 * 实现密码修改
			 * @param mapping
			 * @param form
			 * @param request
			 * @param response
			 * @return
			 */
	    public ActionForward password(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
			SystemUserAtionForm systemUserAtionForm = (SystemUserAtionForm) form;
			
			SystemuaerDAO passworddao = new SystemuaerDAO(); 
			SystemuserBean bean = new SystemuserBean();
			
			HttpSession session = request.getSession();
			SystemuserBean userbean=(SystemuserBean)session.getAttribute("userbean");	
			int nid = userbean.getNid();//session中获取登陆用户名 
			
			String aa = request.getParameter("password1");//获取页面原密码数据
			
			 if( passworddao.ispassword(aa)!=null)
			 {
				 bean.setPassword(systemUserAtionForm.getPassword2());
				 bean.setNid(nid); 
				 boolean password= passworddao.updatePassword(bean);
				 PrintWriter out= null;
				 try {
					out= response.getWriter();
				} catch (IOException e) {
					// TODO 自动生成 catch 块
					e.printStackTrace();
				}
				String url="show/rightw.jsp";
				if(password)
				{
					 
					out.println("<script>alert('密码修改成功!');window.location.href='" + url +"'</script>");
				}
				else
				{
					out.println("<script>alert('密码修改失败!');window.history.back</script>");
				} 
				
				 request.setAttribute("manage", "您的密码修改成功，需要验证请重新登陆！");
				 //操作密码修改 修改密码实现类写一个
			  }else{ 
				  request.setAttribute("manage", "您输入的原密码错误，请确认后重新输入！");
			  }
//			return mapping.findForward("password");
			 return null;
		}
			/**
			 * 根据传进来的参数来显示不同的用户ID的Action
			 * @param mapping
			 * @param form
			 * @param request
			 * @param response
			 * @return
			 */
			public ActionForward changeuserid(ActionMapping mapping, ActionForm form,
					HttpServletRequest request, HttpServletResponse response) {
					SystemUserAtionForm systemUserAtionForm = (SystemUserAtionForm) form;
					SystemuaerDAO systemuser = new SystemuaerDAO();
					SystemuserBean systemBean = new SystemuserBean();
					String roleid =  request.getParameter("roleid");//取出角色名
					PrintWriter out = null;
					int rs = 0;
					int rs2 = 0;
					try {
						out = response.getWriter();
					} catch (IOException e) {
						// TODO 自动生成 catch 块
						e.printStackTrace();
					}
					
					if(roleid.equals("2")){
						
						systemBean =systemuser.serchrealname();
						rs =  systemBean.getRealname()+1;		
						out.print(rs);
						out.flush();			
					}
					if(roleid.equals("3")){
						systemBean =systemuser.serchrealnametwo();
						rs2 =  systemBean.getRealname()+1;		
						out.print(rs2);
						out.flush();
					}
					return null;
			} 
}