jkdahlook.java.svn-base

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

package com.chis.model.etbj;
import java.util.List;

import com.stframe.dao.DaoUtil;
import com.stframe.dao.PageUtil;
import com.stframe.form.ActionForm;
import com.stframe.servlet.ActionInstance;
public class JKDAHLOOK extends ActionInstance {
	public int execute(ActionForm af) throws Exception {
		String pagenum=(String)af.getHttpRequest().getParameter("currentpage");
		String JMJKDAH= af.getHttpRequest().getParameter("JMJKDAH");
		String JMXM = af.getHttpRequest().getParameter("JMXM");
		String XB= af.getHttpRequest().getParameter("XB");
		StringBuffer sql = new StringBuffer();
		StringBuffer path = new StringBuffer();
		sql.append("select *,((year(getdate())-year(convert(varchar(10), DA_RKXZL.CSRQ, 111)))) NL from DA_RKXZL where 1=1 \n");
		if(JMJKDAH!=null&&!JMJKDAH.equals(""))
		{
			sql.append(" and JMJKDAH like '%"+JMJKDAH+"%'\n");
		   path.append("&JMJKDAH="+JMJKDAH);
	    }
		if(JMXM!=null&&!JMXM.equals(""))
		{
			sql.append(" and JMXM like'%"+JMXM+"%'\n");
		   path.append("&JMXM="+JMXM);
	    }
		if(XB!=null&&!XB.equals(""))
		sql.append(" and XB='"+XB+"'\n");
		sql.append("order by JMJKDAH asc");
		af.getHttpRequest().setAttribute("JMJKDAH",JMJKDAH);
		af.getHttpRequest().setAttribute("JMXM",JMXM);
		af.getHttpRequest().setAttribute("XB",XB);
		int ipage = 1;
		if (pagenum!=null&&!pagenum.equals("")){
			ipage=Integer.valueOf(pagenum).intValue();
		}	
		PageUtil pageUtil =(PageUtil) DaoUtil.selectPage(af.getConnection(),sql.toString(),ipage, 15);
		pageUtil.setPath(path.toString());
       af.getHttpRequest().setAttribute("rkxzllist", pageUtil.getContext());
		af.getHttpRequest().setAttribute("pagebar", pageUtil.pageBar());
		return 1;
	}

}