grjkinfo.java

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

package com.chis.model.person;

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 翟昌强
 * 
 */ 
public class GrjkInfo extends ActionInstance {
	public int execute(ActionForm af) throws Exception {	
 		String JMJKDAH = af.getHttpRequest().getParameter("JMJKDAH");
		String corp_code = af.getHttpSession().getAttribute("CORP_CODE").toString();
         
         StringBuffer sql = new StringBuffer();
		 sql.append(" select a.*,convert(char(10),DCRQ,20) NDCRQ  \n"); 
		 sql.append(" from DA_JKJC a  \n");
		 sql.append(" where 1=1 and CORP_CODE='"+corp_code+"'\n");
		 sql.append(" and JMJKDAH ='"+JMJKDAH+"'\n");

		 sql.append("order by DCRQ asc");
		 DataForm df = (DataForm)DaoUtil.select(af.getConnection(), sql.toString(), new DataForm("DA_JKJC")).get(0);
		 af.getHttpRequest().setAttribute("grjkinfo", df);
		 return 1;
	}

}