gxyflistpage.java.svn-base

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

package com.chis.model.jbgl.gxy;

import java.util.List;

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 zxh
 *
 */
public class GxyfListPage extends ActionInstance{

	@Override
	public int execute(ActionForm af) throws Exception {
		String corp_code =af.getHttpSession().getAttribute("CORP_CODE").toString();
		int currentpage = 0;
		int pagesize = 15;
		
		StringBuffer sbsql = new StringBuffer();
		StringBuffer sbpath = new StringBuffer();
		DataForm df=new DataForm("JB_GXY","ID");
		//拼凑SQL语句和PATH路径
//		sbsql.append("SELECT * FROM JB_GXY WHERE 1=1 and CORP_CODE='"+corp_code+"'  order by CREATE_DATE asc");
		sbsql.append("SELECT a.ID GXYID,a.JMJKDAH,b.JMXM,b.XB,((year(getdate())-year(b.CSRQ))+1) as NL \n");
		sbsql.append(" ,a.SFYS,convert(varchar(10),a.SFRQ,23) as SFRQ,a.ZSZZ,a.XYZGY \n");
		sbsql.append(" FROM JB_GXY a \n");
		sbsql.append(" left join DA_RKXZL b on a.JMJKDAH=b.JMJKDAH \n");
		sbsql.append(" WHERE 1=1 and a.CORP_CODE='"+corp_code+"' \n");
		sbsql.append(" order by a.CREATE_DATE asc ");
		
		sbpath.append(af.getHttpRequest().getContextPath()+"/Selevet.do?action=Selevet.do?action=GXYF_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();
		List list=DaoUtil.select(af.getConnection(),sbsql.toString(),df);
		
		
		
		
		
		af.getHttpRequest().setAttribute("gxyf_list",list);
		af.getHttpRequest().setAttribute("num", pageUtil.getContext().size());
		af.getHttpRequest().setAttribute("pagebar", pageUtil.pageBar());
		return 1;
	}

}