qtlistpage.java.svn-base

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

package com.chis.model.jbgl.qt;

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 QtListPage 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();
		
		//拼凑SQL语句和PATH路径
//		sbsql.append("SELECT * FROM JB_QTMB WHERE 1=1 and CORP_CODE='"+corp_code+"'  order by CREATE_DATE asc");
		sbsql.append("SELECT a.*,a.ID as QTID,b.JMXM,b.XB,((year(getdate())-year(convert(varchar(10), b.CSRQ, 111)))+1) as NL \n");
		sbsql.append(" ,convert(varchar(10),a.ZDRQ,23) as ZDRQB \n");
		sbsql.append(" FROM JB_QTMBDA 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=QT_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("qt_list",list);
		af.getHttpRequest().setAttribute("num", pageUtil.getContext().size());
		af.getHttpRequest().setAttribute("pagebar", pageUtil.pageBar());
		return 1;
	}

}