xesblist.java

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

package com.chis.model.etbj;
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;

public class XesbList extends ActionInstance{
	  public int execute(ActionForm af) throws Exception {
		String pagenum=(String)af.getHttpRequest().getParameter("currentpage");
		String id= af.getHttpRequest().getParameter("id");
		String JMJKDAH= af.getHttpRequest().getParameter("JMJKDAH");
		String JMXM = af.getHttpRequest().getParameter("JMXM");
		String DJSJ= af.getHttpRequest().getParameter("DJSJ");
		String ZGRQ = af.getHttpRequest().getParameter("ZGRQ");
		String CSRQ = af.getHttpRequest().getParameter("CSRQ");
		String XESBMC= af.getHttpRequest().getParameter("XESBMC");
		String  rdo= af.getHttpRequest().getParameter("rdo");
		StringBuffer sql = new StringBuffer();
		StringBuffer path = new StringBuffer();
		path.append(af.getHttpRequest().getContextPath()+"/Selevet.do?action=XESB_LIST");
		sql.append("select ET_XESB.*,DA_RKXZL.JMXM,DA_RKXZL.XB,DA_RKXZL.CSRQ,((year(getdate())-year(convert(varchar(10), DA_RKXZL.CSRQ, 111)))+1) NL\n"); 
		sql.append(" from et_xesb \n");
		sql.append("join DA_RKXZL on ET_XESB.JMJKDAH=DA_RKXZL.JMJKDAH \n");
		sql.append(" where 1=1\n");
		if(!("".equals(JMJKDAH))&&(JMJKDAH!=null))
		{
			sql.append(" and ET_XESB.JMJKDAH like '%"+JMJKDAH+"%'\n");
			path.append("&ET_XESB.JMJKDAH="+JMJKDAH);
		}
		if(!("".equals(JMXM))&&(JMXM!=null))
		{
			sql.append(" and JMXM like'%"+JMXM+"%'\n");
			path.append("&JMXM="+JMXM);
		}
		if (!("".equals(DJSJ))&&(DJSJ!=null))
		{
			sql.append(" and DJSJ like '%"+DJSJ+"%'\n");
			path.append("&DJSJ=" + DJSJ);
		}
		if (!("".equals(ZGRQ))&&(ZGRQ!=null))
		{
			sql.append(" and ZGRQ='"+ZGRQ+"' \n");
			path.append("&ZGRQ=" + ZGRQ);
		}
		if (!("".equals(CSRQ))&&(CSRQ!=null))
		{
			sql.append(" and CSRQ='"+CSRQ+"' \n");
			path.append("&CSRQ=" + CSRQ);
		}
		if (!("".equals(XESBMC))&&(XESBMC!=null))
		{
			sql.append(" and XESBMC='"+XESBMC+"' \n");
			path.append("&XESBMC=" +XESBMC);
		}
		if(!(id==null)&&!("".equals(id)))
			sql.append(" and ET_XESB.ID ='"+id+"'\n");
        sql.append("order by JMJKDAH asc");
        int ipage = 1;
		if (pagenum!=null&&!pagenum.equals("")){
			ipage=Integer.valueOf(pagenum).intValue();
		}	
		af.getHttpRequest().setAttribute("JMJKDAH",JMJKDAH);
		af.getHttpRequest().setAttribute("JMXM",JMXM);
		af.getHttpRequest().setAttribute("DJSJ",DJSJ);
		af.getHttpRequest().setAttribute("ZGRQ",ZGRQ);
		af.getHttpRequest().setAttribute("CSRQ",CSRQ);
		af.getHttpRequest().setAttribute("XESBMC",XESBMC);
		if(rdo==null||rdo.equals("h")){
		PageUtil pageUtil = (PageUtil)DaoUtil.selectPage(af.getConnection(), sql.toString(),ipage, 10);
		pageUtil.setPath(path.toString());
		af.getHttpRequest().setAttribute("pagenum",pageUtil.getContext());
		af.getHttpRequest().setAttribute("pagebar", pageUtil.pageBar());
		}
		else
		{
			DataForm df = (DataForm)DaoUtil.select(af.getConnection(), sql.toString(), new DataForm("ET_XESB")).get(0);
			af.getHttpRequest().setAttribute("pagenum", df);
		}
		if(rdo.equals("h")||rdo.equals(""))
			return 1;
		if(rdo.equals("L"))
			return 2;
	    if(rdo.equals("U"))
		    return 3;
	    if(rdo.equals("SL"))
	    	return 4;
	     return 0;
	  }
}