wxyslist.java.svn-base

用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 WxysList extends ActionInstance {
	public int execute(ActionForm af) throws Exception {
		String JMJKDAH = af.getHttpRequest().getParameter("JMJKDAH");
		String id = af.getHttpRequest().getParameter("wxysid");
		String wxys = af.getHttpRequest().getParameter("wxys");
		
		StringBuffer sql = new StringBuffer();
		sql.append("select a.*  from DA_WXYS a \n");
		sql.append("where 1=1 \n");
		if(!(JMJKDAH==null)&&!("".equals(JMJKDAH))) 
		{
		    sql.append("and JMJKDAH="+JMJKDAH+"\n");
		}
		if(!(id==null)&&!("".equals(id)))
		{
			sql.append(" and ID ='"+id+"'\n");
			DataForm df = (DataForm)DaoUtil.select(af.getConnection(), sql.toString(), new DataForm("DA_WXYS")).get(0);
			af.getHttpRequest().setAttribute("wxysinfo", df);
			if(wxys.equals("e")) return 2;
			else return 3;
		}else
		{
			List list = DaoUtil.select(af.getConnection(), sql.toString(), new DataForm("DA_WXYS"));
			if(list.isEmpty()) 
			{
			  af.getHttpRequest().setAttribute("num",0);
			}
			af.getHttpRequest().setAttribute("wxyslist", list);
			return 1;
		}
	}
}