registaction.java

一本jsp自学教材

package user;
import java.sql.*;
import javax.servlet.ServletContext;
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 org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import javax.sql.DataSource;
public class RegistAction extends Action {
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
  DynaValidatorForm userform =(DynaValidatorForm) form;
  String username=(String) userform.get("username");
  String password=(String) userform.get("password");
  String age1=(String)userform.get("age");
  int age=Integer.parseInt(age1);
  String sex=(String) userform.get("sex");
  sex=new String(sex.getBytes("ISO-8859-1"));
  String qq=(String) userform.get("qq");
  String email=(String) userform.get("email");
  String action=(String) userform.get("action");
  String userid=(String) userform.get("userid");

  ServletContext context = servlet.getServletContext();
  DataSource dataSource = (DataSource)context.getAttribute("study");
  Connection connect=dataSource.getConnection();
  PreparedStatement pstmt=null;
  String pageforward="failed";
  boolean flag=true; 
  if(action.equals("1")){
    CheckUser CU=new CheckUser();
    ActionErrors errors=new ActionErrors ();
    flag=CU.userExist(username,dataSource);
    if(flag){
    ActionError err= new ActionError ("error.username.exist");
    errors.add(ActionErrors.GLOBAL_ERROR,err);   
    pageforward="to-reg-page";
    }
   this.saveErrors(request,errors);
  }
  if(action.equals("1")&&(!flag)){

    String sql1="INSERT INTO user VALUE(?,?,?,?,?,?,?)";
    pstmt=connect.prepareStatement(sql1);
    pstmt.setInt(1,0);
    pstmt.setString(2,username);
    pstmt.setString(3,password);
    pstmt.setInt(4,age);
    pstmt.setString(5,sex);
    pstmt.setString(6,qq);
    pstmt.setString(7,email);
    int su= pstmt.executeUpdate();
    if(su>0){
      pageforward="reg_success";
    }
  }
  if(action.equals("2")){
    String sql1="UPDATE user SET password=?,age=?,sex=?,qq=?,email=?"+
                 " WHERE id="+userid;
    pstmt=connect.prepareStatement(sql1);  
    pstmt.setString(1,password);
    pstmt.setInt(2,age);
    pstmt.setString(3,sex);
    pstmt.setString(4,qq);
    pstmt.setString(5,email);
    int su= pstmt.executeUpdate();
    if(su>0){
      pageforward="reg_success";
    }
  }  
  return mapping.findForward(pageforward);
 }
}