adduseraction.java

一个运行成功的论坛

package mybbs;

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.validator.DynaValidatorForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import java.util.Date;
import java.sql.*;

public final class AddUserAction
    extends Action {
  public ActionForward execute(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response) throws Exception {
    HttpSession session=request.getSession();
    String ip = request.getRemoteAddr();
    Date date = new Date();
    DynaValidatorForm userform = (DynaValidatorForm) form;
    CAEncode encode = new CAEncode();
    DBConn conn = new DBConn();
    String username = encode.htmlEncode( (String) userform.get("username"));
    String password = encode.htmlEncode( (String) userform.get("password"));
    String password2 = encode.htmlEncode( (String) userform.get("password2"));
    String nickname = encode.htmlEncode( (String) userform.get("nickname"));
    String sex = encode.htmlEncode( (String) userform.get("sex"));
    String birthyear = encode.htmlEncode( (String) userform.get("birthyear"));
    String birthmonth = encode.htmlEncode( (String) userform.get("birthmonth"));
    String birthday = encode.htmlEncode( (String) userform.get("birthday"));
    String email = encode.htmlEncode( (String) userform.get("email"));
    String mobile = encode.htmlEncode( (String) userform.get("mobile"));
    String qq = encode.htmlEncode( (String) userform.get("qq"));
    String skype = encode.htmlEncode( (String) userform.get("skype"));
    String weblog = encode.htmlEncode( (String) userform.get("weblog"));
    String info = encode.htmlEncode( (String) userform.get("info"));
    String signature = encode.htmlEncode( (String) userform.get("signature"));
    String face = encode.htmlEncode( (String) userform.get("face"));
    String action=(String) userform.get("action");
    String PageForward="global";
  try{
    CheckUser CU = new CheckUser();
    if (action.equals("1")) {
      if (!CU.isExist(username, nickname)) {
        if (face.equals("")) {
          face = "image/a1.jpg";
        }
        String sql =
            "INSERT INTO bbsuser VALUE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        PreparedStatement pstmt = conn.getPstmt(sql);
        pstmt.setInt(1, 0);
        pstmt.setString(2, username);
        pstmt.setString(3, password);
        pstmt.setString(4, nickname);
        pstmt.setString(5, sex);
        pstmt.setString(6, birthyear);
        pstmt.setString(7, birthmonth);
        pstmt.setString(8, birthday);
        pstmt.setString(9, email);
        pstmt.setString(10, weblog);
        pstmt.setString(11, qq);
        pstmt.setString(12, skype);
        pstmt.setString(13, mobile);
        pstmt.setString(14, signature);
        pstmt.setString(15, date.toLocaleString());
        pstmt.setString(16, date.toLocaleString());
        pstmt.setString(17, ip);
        pstmt.setString(18, ip);
        pstmt.setString(19, info);
        pstmt.setString(20, face);
        pstmt.setInt(21, 0);
        pstmt.setInt(22, 0);
        pstmt.setInt(23, 100);
        pstmt.setInt(24, 0);
        pstmt.setInt(25, 0);
        pstmt.setString(26, "user");
        int flag = pstmt.executeUpdate();
        pstmt.close();
        if (flag > 0) {
          request.setAttribute("username", username);
          request.setAttribute("password", password);
          PageForward = "regsuccessed"; //新用户注册成功
        }
        else { //新用户注册失败
          PageForward = "global";
        }
      }
      else {
        PageForward = "global";
        request.setAttribute("throw", new String("用户名或呢称已存在！"));
      }
    }
    if (action.equals("2")) {
      String userid = (String) session.getAttribute("userid");
      String user = (String) session.getAttribute("username");
      if (!CU.nicknameExist(userid, nickname)) {
        String sql2 =
            "UPDATE bbsuser SET nickname=?,sex=?,birthyear=?,birthmonth=?,birthday=?," +
            "email=?,weblog=?,qq=?,skype=?,mobile=?,signature=?,info=?,face=? WHERE username='" +
            user + "' AND id=" + userid;
        PreparedStatement pstmt = conn.getPstmt(sql2);
        pstmt.setString(1, nickname);
        pstmt.setString(2, sex);
        pstmt.setString(3, birthyear);
        pstmt.setString(4, birthmonth);
        pstmt.setString(5, birthday);
        pstmt.setString(6, email);
        pstmt.setString(7, weblog);
        pstmt.setString(8, qq);
        pstmt.setString(9, skype);
        pstmt.setString(10, mobile);
        pstmt.setString(11, signature);
        pstmt.setString(12, info);
        pstmt.setString(13, face);
        int u = pstmt.executeUpdate();
        pstmt.close();
        if (u > 0) {
          PageForward = "updatesuccess";
        }
        else {
          PageForward = "global";
          request.setAttribute("throw", new String("用户资料更新失败！"));
        }
      }
    }
    if (action.equals("3")) {
      String user = (String) session.getAttribute("username");
      String userid = (String) session.getAttribute("userid");
      if (CU.checklogin(user, password)) {
        String sql3 = "UPDATE bbsuser SET password='" + password2 +
            "' WHERE username='" +
            user + "' AND id=" + userid;
        int u = conn.update(sql3);
        if (u > 0) {
          PageForward = "updatesuccess";
        }
        else {
          PageForward = "global";
          request.setAttribute("throw", new String("密码更新失败！"));
        }
      }
      else {
        PageForward = "global";
        request.setAttribute("throw", new String("原始密码不正确！"));
      }
    }
  }
  catch(Exception e){
    PageForward = "global";
    request.setAttribute("throw", new String("用户名已存在，或其他未预知的错误！"));
  }
    conn.DBclose();
    return mapping.findForward(PageForward);
  }
}