sysuserfrozen.java

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

package com.chis.model.user;

import com.stframe.dao.DaoUtil;
import com.stframe.form.ActionForm;
import com.stframe.servlet.ActionInstance;
/**
 * 用户冻结操作
 * @author zxh
 *
 */
public class SysUserFrozen extends ActionInstance{


	public int execute(ActionForm af) throws Exception {
		String userid = af.getHttpRequest().getParameter("id");
		String status = af.getHttpRequest().getParameter("status");
		try{
			String sql = "UPDATE SYS_USER SET STATUS='"+status+"' WHERE ID='"+userid+"'";
			DaoUtil.execute(af.getConnection(),sql);
			sql = "UPDATE EMPLOYEE SET STATUS='"+status+"' WHERE USER_ID='"+userid+"'";
			DaoUtil.execute(af.getConnection(),sql);
			
			af.getHttpRequest().setAttribute("result","操作");
			af.getHttpRequest().setAttribute("goto","Selevet.do?action=BASE_SYSUSER_LIST");
			af.getHttpRequest().setAttribute("CMD",af.getHttpRequest().getParameter("CMD"));
			return 1;
		}catch(Exception e)
		{
			e.printStackTrace();
			af.getHttpRequest().setAttribute("resutl","操作");
			return 0;
		}
	}

}