ycfylistpage.java

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

package com.chis.model.etjz;

import java.util.List;

import com.stframe.dao.DaoUtil;
import com.stframe.dao.PageUtil;
import com.stframe.form.ActionForm;
import com.stframe.servlet.ActionInstance;
/**
 * 计划免疫异常反应记录列表分页
 * @author zxh
 *
 */
public class YcfyListPage extends ActionInstance{

	@Override
	public int execute(ActionForm af) throws Exception {
		String corp_code =af.getHttpSession().getAttribute("CORP_CODE").toString();
		
		String JMJKDAH = af.getHttpRequest().getParameter("JMJKDAH");
		String NAME = af.getHttpRequest().getParameter("NAME");
		String YMMC = af.getHttpRequest().getParameter("YMMC");
		String FYRQ = af.getHttpRequest().getParameter("FYRQ");
		String FYRQ2 = af.getHttpRequest().getParameter("FYRQ2");
		String JZSJ = af.getHttpRequest().getParameter("JZSJ");
		String JZSJ2 = af.getHttpRequest().getParameter("JZSJ2");
		int currentpage = 0;
		int pagesize = 15;
		
		StringBuffer sbsql = new StringBuffer();
		StringBuffer sbpath = new StringBuffer();
		
		//拼凑SQL语句和PATH路径
//		sbsql.append("SELECT * FROM MY_YCFYJL WHERE 1=1 and CORP_CODE='"+corp_code+"'  order by CREATE_DATE asc");
		sbsql.append("select e.*,a.ZZMC,a.ID as YCFYID,c.MYZPMC,((year(getdate())-year(e.CSRQ))+1) as NL,\n " +
				"convert(varchar(10),a.SJJZSJ,120) as SJJZSJ,\n " +
				"convert(varchar(10),a.FYRQ,120) as FYRQ,convert(varchar(10),b.SJJZSJ,120) as SJJZSJ2 from MY_YCFYJL a \n");
		sbsql.append(" left join MY_YFJZ b on b.ID=a.YFJZ_ID \n");
		sbsql.append(" left join MY_JHMY c on b.ETJHMY_ID=c.ID \n");
		sbsql.append(" left join DA_RKXZL e on a.JMJKDAH=e.JMJKDAH \n");
		sbsql.append("WHERE 1=1 and a.CORP_CODE='"+corp_code+"' \n");
		if (!(JMJKDAH == null) && !JMJKDAH.equals("")) {
			sbsql.append(" and e.JMJKDAH='" + JMJKDAH + "' \n");
		}
		if (NAME != null && !NAME.equals("")) {
			sbsql.append(" and e.JMXM like '%" + NAME + "%'");
		}
		if (YMMC != null && !YMMC.equals("")) {
			sbsql.append(" and c.MYZPMC like '%" + YMMC + "%' \n");
		}
		if (FYRQ != null && !FYRQ.equals("")) {
			sbsql.append(" and convert(varchar(10),a.FYRQ,120) >='" + FYRQ + "' \n");
		}
		if (FYRQ2 != null && !FYRQ2.equals("")) {
			sbsql.append(" and convert(varchar(10),a.FYRQ,120) <= '" + FYRQ2 + "' \n");
		}
		if (JZSJ != null && !JZSJ.equals("")) {
			sbsql.append(" and convert(varchar(10),b.SJJZSJ,120) >='" + JZSJ + "' \n");
		}
		if (JZSJ2 != null && !JZSJ2.equals("")) {
			sbsql.append(" and convert(varchar(10),b.SJJZSJ,120) <= '" + JZSJ2 + "' \n");
		}
		sbsql.append(" order by e.JMJKDAH asc \n");
		
		sbpath.append(af.getHttpRequest().getContextPath()+"/Selevet.do?action=Selevet.do?action=YCFY_LIST_PAGE");

		try {
			currentpage = Integer.parseInt(af.getHttpRequest().getParameter("currentpage"));
		} catch (Exception e) {
			currentpage = 1;
		}
		
		
		PageUtil pageUtil = (PageUtil)DaoUtil.selectPage(af.getConnection(),sbsql.toString(),currentpage, pagesize);
		pageUtil.setPath(sbpath.toString());
		List list= pageUtil.getContext();
		
		
		af.getHttpRequest().setAttribute("JZSJ", JZSJ);
		af.getHttpRequest().setAttribute("JZSJ2", JZSJ2);
		af.getHttpRequest().setAttribute("NAME", NAME);
		af.getHttpRequest().setAttribute("YMMC", YMMC);
		af.getHttpRequest().setAttribute("FYRQ", FYRQ);
		af.getHttpRequest().setAttribute("FYRQ2", FYRQ2);
		af.getHttpRequest().setAttribute("JMJKDAH", JMJKDAH);
		af.getHttpRequest().setAttribute("ycfy_list",list);
		af.getHttpRequest().setAttribute("num", pageUtil.getContext().size());
		af.getHttpRequest().setAttribute("pagebar", pageUtil.pageBar());
		return 1;
	}

}