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

import java.sql.*;
import java.util.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
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 yy.jdbc;
import com.test.Users;

/** 
 * MyEclipse Struts
 * Creation date: 05-09-2009
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 * @struts.action-forward name="modify" path="/modify.jsp"
 */
public class ModifyinfoAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		if(request.getSession().getAttribute("UserName") == null) {
            return mapping.findForward("modify");
        }
		else
		{
			try{
			   String sql="select * from Users where UserName='"+request.getSession().getAttribute("UserName")+"'";
               jdbc j=new jdbc();
               Users user=new Users();
               Connection con=j.getConn();
               Statement  stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
               ResultSet  rs=null;
               rs=stmt.executeQuery(sql);
               if(rs.next())
               {
            	   user.setId(rs.getInt("id"));
            	   user.setUserName(rs.getString("UserName"));
            	   user.setPwd(rs.getString("Pwd"));
            	   user.setSex(rs.getString("Sex"));
            	   user.setEmail(rs.getString("Email"));
            	   user.setQq(rs.getString("QQ"));
            	   user.setAddress(rs.getString("Address"));
            	   user.setPhone(rs.getString("Phone"));
            	   user.setPower(rs.getString("Power"));
            	   request.setAttribute("user", user);
            	   return mapping.findForward("modify");
               }
               return mapping.findForward("errorPage");
			}
			catch(Exception e)
			{
				System.out.println(e.getMessage());
				return mapping.getInputForward();
			}
		}
	}
}