jtjkwtlist.java

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

package com.chis.model.family;

import java.util.List;

import com.stframe.dao.DaoUtil;
import com.stframe.form.ActionForm;
import com.stframe.form.DataForm;
import com.stframe.servlet.ActionInstance;

/**
 * 家庭健康问题信息查询
 * 
 * @author 翟昌强
 * 
 */ 
public class JtJkwtList extends ActionInstance {
	public int execute(ActionForm af) throws Exception {
		String corp_code = af.getHttpSession().getAttribute("CORP_CODE").toString();
		String jtid = af.getHttpRequest().getParameter("JT_ID");
		
		StringBuffer sql = new StringBuffer();
		sql.append("select *,c.ID JKWTID \n");
		sql.append(" from DA_JT a,DA_RKXZL b,DA_JKWT c \n");
		sql.append("where 1=1 \n");
		sql.append("and a.ID=b.JT_ID and b.JMJKDAH=c.JMJKDAH \n");
		sql.append("and a.ID='"+jtid+"' \n");
		sql.append("and a.CORP_CODE='"+corp_code+"'\n");
		sql.append("order by FSRQ asc");
		List list = DaoUtil.select(af.getConnection(), sql.toString(), new DataForm("DA_JKWT"));
		af.getHttpRequest().setAttribute("jkwtlist", list);
		return 1;
	}
}