jzbslist.java

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

package com.chis.model.person;

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 JzbsList extends ActionInstance {
	public int execute(ActionForm af) throws Exception {
	String JMJKDAH = af.getHttpRequest().getParameter("JMJKDAH");
	String corp_code = af.getHttpSession().getAttribute("CORP_CODE").toString();
	String id = af.getHttpRequest().getParameter("jzbsid");
	String jzbs = af.getHttpRequest().getParameter("jzbs");
	 
	StringBuffer sql = new StringBuffer();
	sql.append("select a.* \n");
	sql.append("from DA_JZBS a \n");
	sql.append("where 1=1 \n");
	if(!(JMJKDAH==null)&&!("".equals(JMJKDAH))) 
	{
	    sql.append("and JMJKDAH= '"+JMJKDAH+"'\n");
	}
	sql.append("and CORP_CODE='"+ corp_code + "' \n");
	if(!(id==null)&&!("".equals(id)))
	{
		sql.append(" and ID ='"+id+"'\n");
		sql.append("order by CREATE_DATE asc");
		DataForm df = (DataForm)DaoUtil.select(af.getConnection(), sql.toString(), new DataForm("DA_JZBS")).get(0);
		af.getHttpRequest().setAttribute("jzbsinfo", df);
		if(jzbs.equals("e"))  return 2;
		else return 3;
	}else
	{
		sql.append("order by CREATE_DATE asc");
		List list = DaoUtil.select(af.getConnection(), sql.toString(), new DataForm("DA_JZBS"));
		af.getHttpRequest().setAttribute("jzbslist", list);
		return 1;
	}
}

}