rkxzllistpage.java.svn-base

用JSP JAVA 做的 系统 只是初来扎到还望西黄！别乱来哦！

package com.chis.model.person;

import com.stframe.dao.DaoUtil;
import com.stframe.dao.PageUtil;
import com.stframe.form.ActionForm;
import com.stframe.form.DataForm;
import com.stframe.servlet.ActionInstance;

/**
 * 人口学资料分页列表
 * 
 * @author 翟昌强
 * 
 */  
public class RkxzlListPage extends ActionInstance {
	public int execute(ActionForm af) throws Exception {
		String corp_code=af.getHttpSession().getAttribute("CORP_CODE").toString();
        String page =(String)af.getHttpRequest().getParameter("currentpage");	
        String JMJKDAH = af.getHttpRequest().getParameter("JMJKDAH");
        String JMXM = af.getHttpRequest().getParameter("JMXM");
        String XB = af.getHttpRequest().getParameter("XB"); 
		String begin_date=af.getHttpRequest().getParameter("begindate");
		String end_date=af.getHttpRequest().getParameter("enddate");
		String WHCD = af.getHttpRequest().getParameter("WHCD");
		String MZ = af.getHttpRequest().getParameter("MZ");
		String rkxzl = af.getHttpRequest().getParameter("rkxzl");
		
		StringBuffer sql = new StringBuffer();
		StringBuffer path = new StringBuffer();
		path.append(af.getHttpRequest().getContextPath()+"/Selevet.do?action=RKXZL_LIST");
		sql.append(" select a.*,((year(getdate())-year(convert(varchar(10), a.CSRQ, 111)))+1) NL \n"); 
		sql.append(" from DA_RKXZL a  \n");
		sql.append(" where 1=1 and CORP_CODE='"+corp_code+"'\n");
		if(!(JMJKDAH==null)&&!("".equals(JMJKDAH)))
		{
			sql.append(" and JMJKDAH ='"+JMJKDAH+"'\n");
			path.append("&JMJKDAH=" + JMJKDAH);
		}
		if(!(JMXM==null)&&!("".equals(JMXM)))
		{
			sql.append(" and JMXM like '%"+JMXM+"%' \n");
			path.append("&JMXM=" + JMXM);
		}
		if(!(XB==null)&&!("".equals(XB)))
		{
			sql.append(" and XB ='"+XB+"'\n");
			path.append("&XB=" + XB);
		}
		if(!(begin_date==null)&&!("".equals(begin_date)))
		{
			sql.append(" and CSRQ >='"+begin_date+"'\n");
			path.append("&begindate=" + begin_date);
		}
		if(!(end_date==null)&&!("".equals(end_date)))
		{
			sql.append(" and CSRQ <='"+end_date+"'\n");
			path.append("&enddate=" + end_date);
		}
		if(!(WHCD==null)&&!("".equals(WHCD)))
		{
			sql.append(" and WHCD ='"+WHCD+"'\n");
			path.append("&WHCD=" + WHCD);
		}
		if(!(XB==null)&&!("".equals(MZ)))
		{
			sql.append(" and MZ ='"+MZ+"'\n");
			path.append("&MZ=" + MZ);
		}

        sql.append("order by JMJKDAH asc");
		
		int ipage = 0;
		if (page!=null&&!page.equals("")){
			ipage=Integer.valueOf(page);
		}

		PageUtil pageUtil = (PageUtil)DaoUtil.selectPage(af.getConnection(), sql.toString(),ipage, 20);
		pageUtil.setPath(path.toString());
		af.getHttpRequest().setAttribute("rkxzllist",pageUtil.getContext());
		af.getHttpRequest().setAttribute("pagebar", pageUtil.pageBar());
	
		af.getHttpRequest().setAttribute("JMJKDAH", JMJKDAH);
		af.getHttpRequest().setAttribute("JMXM", JMXM);
		af.getHttpRequest().setAttribute("XB", XB);
		af.getHttpRequest().setAttribute("begindate", begin_date);
		af.getHttpRequest().setAttribute("enddate", end_date);
		af.getHttpRequest().setAttribute("WHCD", WHCD);
		af.getHttpRequest().setAttribute("MZ", MZ);
		
		if(rkxzl!=null && rkxzl.equals("g")) return 2;
		else return 1;
	} 
}