myactionform.java

Struts入门学习经典实例教程

package strutsdemo.forms;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionMapping;
import javax.servlet.http.HttpServletRequest;
import java.sql.*;
import org.apache.struts.action.ActionError;


public class myActionForm
    extends ActionForm {
  private String passWord;
  private String userName;
  public String getPassWord() {
    return passWord;
  }

  public void setPassWord(String passWord) {
    this.passWord = passWord;
  }

  public void setUserName(String userName) {
    this.userName = userName;
  }

  public String getUserName() {
    return userName;
  }

  public ActionErrors validate(ActionMapping actionMapping,
                               HttpServletRequest httpServletRequest) {
     //登陆 数据库验证
     java.sql.Connection con=this.getConn();
     ActionErrors errs=new ActionErrors();
    try {
      if(this.getUserName()==null || this.getUserName().length()<1){
        errs.add(ActionErrors.GLOBAL_ERROR,new ActionError("login.errs.userName"));
      }
      if(this.getPassWord()==null || this.getPassWord().length()<1){
        errs.add(ActionErrors.GLOBAL_ERROR,new ActionError("login.errs.passWord"));
      }
      if(errs.size()>0){
        return errs;
      }

      java.sql.PreparedStatement stmt = con.prepareStatement(
          "SELECT * FROM login WHERE name=? AND password=?");
      stmt.setString(1,userName);
      stmt.setString(2,passWord);
      java.sql.ResultSet rs=stmt.executeQuery();
      if(!rs.next()){
          errs.add(ActionErrors.GLOBAL_ERROR,new ActionError("login.errs.logionfalse"));
      }


    }
    catch (SQLException ex) {
      ex.printStackTrace();
      errs.add(ActionErrors.GLOBAL_ERROR,new ActionError("sql.errs.sqlException"));
    }
      return errs;


  }

  public void reset(ActionMapping actionMapping,
                    HttpServletRequest servletRequest) {
  }
  private java.sql.Connection getConn(){
    java.sql.Connection con=null;
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con=java.sql.DriverManager.getConnection("jdbc:odbc:MSdb");
      System.out.println("server is close ?"+con.isClosed());
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }

    return con;
  }

  public static void main(String[] args) {

  }
}