selectuseraction.java

商品管理系统

//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.1.1/xslt/JavaClass.xsl

package com.accp.struts.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.accp.struts.Bean.UserBean;
import com.accp.struts.form.UserLogoForm;

/** 
 * MyEclipse Struts
 * Creation date: 09-08-2007
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 */
public class SelectUserAction extends Action {

	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)throws IOException {
		UserLogoForm uf=null;
		
		HttpSession session=request.getSession();
		
	 	
	 	ArrayList list=new ArrayList();
	 	UserBean ub=new UserBean();
	 	ResultSet rs=null;
	 	rs=ub.selectAllUser();
	 	try{
	 		while(rs.next()){
	 			uf=new UserLogoForm();
	 			uf.setUser_id(rs.getInt(1));
	 			uf.setUser_name(rs.getString(2));
	 			uf.setPrivil(rs.getString(4));
	 			list.add(uf);
	 		}
	 		session.setAttribute("list",list);
	 		ub.close();
	 		
	 		return mapping.findForward("showUser");
	 	}catch(SQLException ex){
	 		System.out.println(ex);
	 		ub.close();
	 		return mapping.findForward("error");
	 	}
	 	
	
	}

}