modifyaction.java

一本jsp自学教材

package user;
import java.sql.*;
import javax.servlet.ServletContext;
import javax.servlet.http.HttpSession;
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.validator.DynaValidatorForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import javax.sql.DataSource;
public class ModifyAction extends Action {
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
  DynaValidatorForm userform = (DynaValidatorForm) form;
  String userid=(String) userform.get("userid");
  String pageforward="failed";
  HttpSession session=request.getSession(true);
  UserInfo UI=new UserInfo();
  ServletContext context = servlet.getServletContext();
  DataSource dataSource = (DataSource)context.getAttribute("study");
  Connection connect=dataSource.getConnection();
  Statement stmt=connect.createStatement();
  String sql="SELECT * FROM user WHERE id="+userid;
  UserLog ul=new UserLog();
  String path=request.getRealPath("/")+"userlog.txt";
  String info="SQL:"+sql;
  ul.Ulog(info,path);
  ResultSet rs=stmt.executeQuery(sql);
  if(rs.next()){
    UI.setUserid(rs.getInt("id"));
    UI.setUsername(rs.getString("username"));
    UI.setPassword(rs.getString("password"));
    UI.setAge(rs.getInt("age"));
    UI.setSex(rs.getString("sex"));
    UI.setQq(rs.getString("qq"));
    UI.setEmail(rs.getString("email"));
    pageforward="to-modify-page";
    session.setAttribute("userinfo",UI);
  }

  return mapping.findForward(pageforward);
 }
}