etbjlook.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 EtbjLook 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 SG2 = af.getHttpRequest().getParameter("SG2");
		String TZ = af.getHttpRequest().getParameter("TZ");
		String CSRQ = af.getHttpRequest().getParameter("CSRQ");
		String TJSJ= af.getHttpRequest().getParameter("TJSJ");
		String  rdo= af.getHttpRequest().getParameter("rdo");
		StringBuffer sql = new StringBuffer();
		StringBuffer path = new StringBuffer();
		path.append(af.getHttpRequest().getContextPath()+"/Selevet.do?action=ETBJLOOK");
		sql.append("select ET_TJQK.*,replace(ET_TJQK.SG,'.00','') SG2,ET_TJQK.TJSJ2 TJSJ,DA_RKXZL.JMXM,DA_RKXZL.XB,((year(getdate())-year(convert(varchar(10), DA_RKXZL.CSRQ, 111)))+1) NL \n"); 
		sql.append(" from et_tjqk \n");
		sql.append("join DA_RKXZL on ET_TJQK.JMJKDAH=DA_RKXZL.JMJKDAH \n");
		sql.append(" where 1=1\n");
		if(!("".equals(JMJKDAH))&&(JMJKDAH!=null))
		{
			sql.append(" and ET_TJQK.JMJKDAH like '%"+JMJKDAH+"%'\n");
			path.append("&JMJKDAH="+JMJKDAH);
		}
		if(!("".equals(JMXM))&&(JMXM!=null))
		{
			sql.append(" and JMXM like'%"+JMXM+"%'\n");
			path.append("&JMXM="+JMXM);
		}
		if (!("".equals(SG2))&&(SG2!=null))
		{
			sql.append(" and ET_TJQK.SG='"+SG2+"'\n");
			path.append("&SG="+SG2);
		}
		if (!("".equals(TZ))&&(TZ!=null))
		{
			sql.append(" and ET_TJQK.TZ='"+TZ+"' \n");
			path.append("&TZ=" + TZ);
		}
		if (!("".equals(CSRQ))&&(CSRQ!=null))
		{
			sql.append(" and CSRQ='"+CSRQ+"' \n");
			path.append("&CSRQ=" + CSRQ);
		}
		if (!("".equals(TJSJ))&&(TJSJ!=null))
		{
			sql.append(" and TJSJ2 like'%"+TJSJ+"%' \n");
			path.append("&TJSJ=" +TJSJ);
		}
		if(!("".equals(id))&&id!=null)
			sql.append(" and ET_TJQK.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("SG2",SG2);
		af.getHttpRequest().setAttribute("TZ",TZ);
		af.getHttpRequest().setAttribute("CSRQ",CSRQ);
		af.getHttpRequest().setAttribute("TJSJ",TJSJ);
		if(rdo==null||"".equals(rdo)||rdo.equals("h")||rdo.equals("SL")){
		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_tjqk,da_rkxzl")).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;
	}
}