office_searchmemberaction.java

来自「这个程序是花了好几十万请人开发的」· Java 代码 · 共 113 行

/*
 * 
 * @author 郑文金
 *
 * 这个action用于在"网上办公室"中查找会员
 *
 */
package struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import struts.form.Office_searchmemberForm;
import javabean.*;
import java.util.Vector;
import java.sql.*;


public class Office_searchmemberAction extends Action {


	private ConnectionPool pool;
	private Connection con;
	public Office_searchmemberAction() throws SQLException
	{
		pool=ConnectionPool.getInstance();               //初始化连接池
			
	}
		public ActionForward execute(
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,
			HttpServletResponse response)
			throws Exception 
		{
			Office_searchmemberForm searchForm =(Office_searchmemberForm) form;
			con=pool.getConnection();  //从池中获得一个连接
			Member_dao mem=new Member_dao(con);
			CodeString codestring=new CodeString();
		
			String rname=request.getParameter("rname");
			if(rname==null)
			{
				rname=searchForm.getRNAME();
			}
			rname=codestring.getString(rname);
			
			String company=request.getParameter("company");
			if(company==null)
			{
				company=searchForm.getCOMPANY();	
			}	
			company=codestring.getString(company);
		
			Vector vec=new Vector();

			PageNumber pagenumber=new PageNumber(con);
			int pagesize=8;
	
			String code=request.getParameter("code");
			if(code==null)
				code="1";
			pagenumber.setPagesize(pagesize);		
			if(company==null)
			{
				String str1="select * from MEMBER where rname like "+"'%"+rname+"%'";
				pagenumber.setRowcount(str1);
				pagenumber.setPagecount();
				vec=mem.memberquery(Integer.parseInt(code),pagesize,str1);
				request.setAttribute("rname",rname);
				request.setAttribute("vec",vec);
				request.setAttribute("code",code);
				request.setAttribute("pagecount",String.valueOf(pagenumber.getPagecount()));
			}
			if(rname==null)
			{
				String str1="select * from MEMBER where company like "+"'%"+company+"%'";
				pagenumber.setRowcount(str1);
				pagenumber.setPagecount();
				vec=mem.memberquery(Integer.parseInt(code),pagesize,str1);
				request.setAttribute("company",company);
				request.setAttribute("vec",vec);
				request.setAttribute("code",code);
				request.setAttribute("pagecount",String.valueOf(pagenumber.getPagecount()));
			}
			if(!(rname==null)&&!(company==null))
			{
				String str1="select * from MEMBER where rname like "+"'%"+rname+"%'"+" and company like "+"'%"+company+"%'";
				pagenumber.setRowcount(str1);
				pagenumber.setPagecount();
				vec=mem.memberquery(Integer.parseInt(code),pagesize,str1);
				request.setAttribute("rname",rname);
				request.setAttribute("company",company);
				request.setAttribute("vec",vec);
				request.setAttribute("code",code);
				request.setAttribute("pagecount",String.valueOf(pagenumber.getPagecount()));
			}
			searchForm.reset(mapping,request);
			con.commit();
			if(con!=null)
			{
				con.close();
			}
			return (mapping.findForward("office_searchResult"));
		}

}