mainaction.java

地址薄

package actions;

import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
import java.util.Vector;

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

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.LookupDispatchAction;


import javabean.LinkMan;
import javabean.LinkManManager;
import javabean.UserInfo;
import forms.LinkManForm;
import javabean.Pager;
public class MainAction extends LookupDispatchAction {

	static Pager pager=new Pager(5);
	
	@Override
	protected Map getKeyMethodMap() {
		// TODO Auto-generated method stub
	    Map map=new HashMap();
	    map.put("add", "addLinkMan");   //添加按钮触发的事件
	    map.put("update", "updateLinkMan");  //更新按钮触发的事件
	    map.put("updateOfLink", "updateLinkManOfLink");  //更新链接触发的事件
	    map.put("deleteOfLink", "deleteLinkManOfLink");  //删除链接触发的事件
	    map.put("query", "queryLinkMan");
	    map.put("display", "displayLinkMan");
	    map.put("logout", "logout");
	    return map;
	}

	//更新按钮触发的事件,更新联系人的信息
	public ActionForward updateLinkMan(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		// TODO Auto-generated method stub
		LinkManForm linkManForm=(LinkManForm) form;
		LinkManManager manager=new LinkManManager();
		LinkMan linkMan=new LinkMan();
		linkMan.setId(linkManForm.getId());
		linkMan.setAddress(linkManForm.getAddress());
		linkMan.setName(linkManForm.getName());
		linkMan.setSex(linkManForm.getSex());
		linkMan.setPhone(linkManForm.getPhone());
		manager.updateLinkMan(linkMan);
		UserInfo userInfo=(UserInfo)request.getSession().getAttribute("userInfo");
		String condition="select linkman.* from linkman,userInfo where linkman.userid=userInfo.id and userInfo.id="
			+userInfo.getId()+" order by linkman.id desc";
		pager.setQuerySql(condition);
		String countSql="select count(*) from linkman,userInfo where linkman.userid=userInfo.id and userInfo.id="
			+userInfo.getId();
		pager.setCountSql(countSql);
		//String countSql="sel"
		int currentPage=Integer.parseInt(request.getSession().getAttribute("currentPage").toString());
		Vector vector1=pager.pageData(currentPage);
		
		request.setAttribute("totalPage",pager.getTotalPage());// 保存总页数
		request.setAttribute("totalCount", pager.getTotalCount());//保存记录总数
		request.getSession().setAttribute("currentPage", currentPage);// 保存当前页码
		request.getSession().setAttribute("linkMans", vector1);
		return mapping.findForward("success");
	}
	//更新链接触发的事件,将链接所在行的信息显示在form中
	public ActionForward updateLinkManOfLink(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		// TODO Auto-generated method stub
		String id=request.getParameter("id");
		LinkManManager linkManManager=new LinkManManager();
		String condition="select * from linkMan where id="+id;
		Vector vector=linkManManager.queryLinkMan(condition);
		LinkMan linkMan=(LinkMan) vector.elementAt(0);
		LinkManForm linkManForm=new LinkManForm();
		linkManForm.setId(linkMan.getId());
		linkManForm.setName(linkMan.getName());
		linkManForm.setSex(linkMan.getSex());
		linkManForm.setPhone(linkMan.getPhone());
		linkManForm.setAddress(linkMan.getAddress());
		linkManForm.setUserId(linkMan.getUserId());
		request.setAttribute("updateLinkMan", linkManForm);
		return mapping.findForward("success");
	}
	
	/**
	 * 添加按钮触发的事件,添加新的联系人
	 * 
	 * @param 
	 * @param 
	 * 
	 * @return
	 */
	public ActionForward addLinkMan(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		// TODO Auto-generated method stub
		LinkManForm linkManForm=(LinkManForm) form;
		UserInfo userInfo=(UserInfo)request.getSession().getAttribute("userInfo");
		linkManForm.setUserId(userInfo.getId());
		LinkManManager linkManManager=new LinkManManager();
		LinkMan linkMan=new LinkMan();
		linkMan.setUserId(linkManForm.getUserId());
		linkMan.setName(linkManForm.getName());
		linkMan.setSex(linkManForm.getSex());
		linkMan.setPhone(linkManForm.getPhone());
		linkMan.setAddress(linkManForm.getAddress());
		linkManManager.insertLinkMan(linkMan);
		
		String condition="select linkman.* from linkman,userInfo where linkman.userid=userInfo.id and userInfo.id="
			+userInfo.getId()+" order by linkman.id desc";
		pager.setQuerySql(condition);
		String countSql="select count(*) from linkman,userInfo where linkman.userid=userInfo.id and userInfo.id="
			+userInfo.getId();
		pager.setCountSql(countSql);
		//String countSql="sel"
	//	int currentPage=Integer.parseInt(request.getSession().getAttribute("currentPage").toString());
		Vector vector1=pager.pageData(1);
		
		request.setAttribute("totalPage",pager.getTotalPage());// 保存总页数
		request.setAttribute("totalCount", pager.getTotalCount());//保存记录总数
		request.getSession().setAttribute("currentPage", 1);// 保存当前页码
		request.getSession().setAttribute("linkMans", vector1);
		return mapping.findForward("success");
	}
	
	/**
	 * 
	 * 删除链接触发的事件,删除所在行的联系人
	 * @return
	 */
	public ActionForward deleteLinkManOfLink(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		// TODO Auto-generated method stub
		String id=request.getParameter("id");
		LinkManManager linkManManager=new LinkManManager();
		linkManManager.deleteLinkMan(Integer.parseInt(id));
		UserInfo userInfo=(UserInfo)request.getSession().getAttribute("userInfo");
		String condition="select linkman.* from linkman,userInfo where linkman.userid=userInfo.id and userInfo.id="
			+userInfo.getId()+" order by linkman.id desc";
		pager.setQuerySql(condition);
		String countSql="select count(*) from linkman,userInfo where linkman.userid=userInfo.id and userInfo.id="
			+userInfo.getId();
		pager.setCountSql(countSql);
		//String countSql="sel"
		int currentPage=Integer.parseInt(request.getSession().getAttribute("currentPage").toString());
		Vector vector1=pager.pageData(currentPage);
		
		request.setAttribute("totalPage",pager.getTotalPage());// 保存总页数
		request.setAttribute("totalCount", pager.getTotalCount());//保存记录总数
		request.getSession().setAttribute("currentPage", currentPage);// 保存当前页码
		request.getSession().setAttribute("linkMans", vector1);
		return mapping.findForward("success");
	}
	
   
    
  //查询按钮触发的事件,根据信息查询联系人的信息
	public ActionForward queryLinkMan(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		// TODO Auto-generated method stub
		LinkManForm linkManForm1=(LinkManForm) form;
		String s=linkManForm1.getCondition();
		UserInfo userInfo=(UserInfo)request.getSession().getAttribute("userInfo");
    	//LinkManManager linkManManager=new LinkManManager();
		String condition="select distinct linkman.* from linkman,userInfo where linkman.userid=userInfo.id and (linkman.name like '%"
			    +s+"%' or linkman.address like '%"+s+"%') and userInfo.id="+userInfo.getId()
			     +" order by linkman.id desc";
		pager.setQuerySql(condition);
		String countSql="select count(*) from linkman,userInfo where linkman.userid=userInfo.id and (linkman.name like '%"
		    +s+"%' or linkman.address like '%"+s+"%') and userInfo.id="+userInfo.getId();
		pager.setCountSql(countSql);
		
		
		Vector vector1=pager.pageData(1);
		
		request.setAttribute("totalPage",pager.getTotalPage());// 保存总页数
		request.setAttribute("totalCount", pager.getTotalCount());//保存记录总数
		request.getSession().setAttribute("currentPage", 1);// 保存当前页码
		request.getSession().setAttribute("linkMans", vector1);
		return mapping.findForward("success");
	}
	
	//分页显示联系人的信息
	public ActionForward displayLinkMan(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		// TODO Auto-generated method stub
		UserInfo userInfo=(UserInfo)request.getSession().getAttribute("userInfo");
        if(pager.getQuerySql()==null||pager.getCountSql()==null)
        {
        	String condition="select linkman.* from linkman,userInfo where linkman.userid=userInfo.id and userInfo.id="
				+userInfo.getId()+" order by linkman.id desc";
			pager.setQuerySql(condition);
			String countSql="select count(*) from linkman,userInfo where linkman.userid=userInfo.id and userInfo.id="
				+userInfo.getId();
			pager.setCountSql(countSql);
        }
		String pageString=request.getParameter("page");
		
		if(pageString == null || pageString.length() == 0) {
		pageString = "1";
		}
		int currentPage= 0 ;
		try {
		currentPage = Integer.parseInt(pageString);// 当前页码
		} catch(Exception e) {}
		if(currentPage == 0) {
		currentPage = 1;
		}
		Vector vector1=pager.pageData(currentPage);
		request.getSession().setAttribute("linkMans", vector1);// 保存用户列表
		request.setAttribute("totalPage",pager.getTotalPage());// 保存总页数
		request.setAttribute("totalCount", pager.getTotalCount());//保存记录总数
		request.getSession().setAttribute("currentPage", currentPage);// 保存当前页码
		return mapping.findForward("success");
	}
	
	/**
	 * 退出链接触发的事件
	 * @param mapping  映射
	 * @param form  表单
	 * @param request  请求
	 * @param response  应答
	 * @return
	 * @throws Exception
	 */
	public ActionForward logout(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		// TODO Auto-generated method stub
		
		request.getSession().invalidate();
		return mapping.findForward("logout");
	}
}