/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package kignbi.dong.action;

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

import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

import kignbi.dong.Constants;
import kignbi.dong.DB;
import kignbi.dong.Users;
import kignbi.dong.form.UpUsersForm;
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 org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;

/** 
 * MyEclipse Struts
 * Creation date: 01-31-2008
 * 
 * XDoclet definition:
 * @struts.action path="/upUsers" name="upUsersForm" input="/admin/upusers.jsp" scope="request" validate="true"
 * @struts.action-forward name="success" path="/admin/userlist.jsp"
 * @struts.action-forward name="false" path="/admin/upusers.jsp"
 */
public class UpUsersAction extends Action {
	/*
	 * Generated Methods
	 */

	/** String uid=addUserForm.getUid();
		String uname=addUserForm.getUname();
		String usex=addUserForm.getUsex();
		String upassword=addUserForm.getUpassword();
		String uclass=addUserForm.getUclass();
		String ugrade=addUserForm.getUgrade();
	
		
		//HttpSession session = request.getSession(true);
		ActionMessages errors = new ActionMessages();
		String PageForward = "false";
		ServletContext context = servlet.getServletContext();
		DataSource dataSource = (DataSource) context.getAttribute(Constants.DATASOURCE_KEY);
		DB db = new DB(dataSource);
		String str="select * from users ";
		String sql="insert into users(uid,uname,upassword,usex,uclass,ugrade) "
		 +"values('"+uid+"','"+uname+"','"+upassword+"','"+usex+"','"+uclass+"','"+ugrade+"')";
		try{ int status=db.ExecSql(sql);
	     if(status==1)
	     {
	    	ResultSet rs=db.OpenSql(str); 
	    	ArrayList res=new ArrayList();
	    	int i=0;
	    	while(rs.next()){
	    		i=i+1;
	    		Users user=new Users();
	    		user.setUid(rs.getString("uid"));
	    		user.setUname(rs.getString("uname"));
	    		user.setUpassword(rs.getString("upassword"));
	    		user.setUsex(rs.getString("usex"));
	    		user.setUclass(rs.getString("uclass"));
	    		user.setUgrade(rs.getString("ugrade"));

	    		res.add(user);
	    	}
	    	  String count=Integer.toString(i);
	          request.setAttribute("count", count);
	          request.setAttribute("users",res);
	          PageForward="success";
	     }
	     else {
			  errors.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage("add.user.failture"));
	         if (!errors.isEmpty()) {
		       saveErrors(request, errors);
		     }
	     }
	}
	     catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			    }
				db.close();
				return mapping.findForward(PageForward);
   }

}
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		UpUsersForm upUsersForm = (UpUsersForm) form;// TODO Auto-generated method stub
		String uid=upUsersForm.getUid();
		String uname=upUsersForm.getUname();
		String usex=upUsersForm.getUsex();
		String upassword=upUsersForm.getUpassword();
		String uclass=upUsersForm.getUclass();
		String ugrade=upUsersForm.getUgrade();
	
		
		//HttpSession session = request.getSession(true);
		ActionMessages errors = new ActionMessages();
		String PageForward = "false";
		ServletContext context = servlet.getServletContext();
		DataSource dataSource = (DataSource) context.getAttribute(Constants.DATASOURCE_KEY);
		DB db = new DB(dataSource);
		String str="select * from users ";
		String sql="update  users   set uname='"+uname+"',upassword='"+upassword+"',usex='"+usex
		+"',ugrade='"+ugrade+"',uclass='"+uclass+"' where uid='"+uid+"'";
		try{ int status=db.ExecSql(sql);
	     if(status==1)
	     {
	    	ResultSet rs=db.OpenSql(str); 
	    	ArrayList res=new ArrayList();
	    	int i=0;
	    	while(rs.next()){
	    		i=i+1;
	    		Users user=new Users();
	    		user.setUid(rs.getString("uid"));
	    		user.setUname(rs.getString("uname"));
	    		user.setUpassword(rs.getString("upassword"));
	    		user.setUsex(rs.getString("usex"));
	    		user.setUclass(rs.getString("uclass"));
	    		user.setUgrade(rs.getString("ugrade"));

	    		res.add(user);
	    	}
	    	  String count=Integer.toString(i);
	          request.setAttribute("count", count);
	          request.setAttribute("users",res);
	          PageForward="success";
	     }
	     else {
			  errors.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage("update.user.failture"));
	         if (!errors.isEmpty()) {
		       saveErrors(request, errors);
		     }
	     }
	}
	     catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			    }
				db.close();
				return mapping.findForward(PageForward);
   }

}