Форум программистов [Powered by Invision Power Board]

Код

public class SimpleAction extends ActionSupport implements SessionAware {
    public String getPassword() {
        return password;
    }
    private Map session;

    public void setSession ( Map session )
         {
              this.session = session;
         }

    

    public void setPassword(String password) {
        this.password = password;
    }

    private String password;

    public String getLogin() {
        return login;
    }

    public void setLogin(String login) {
        this.login = login;
    }

    private String login;

    public String getMess() {
        return mess;
    }

    public void setMess(String mess) {
        this.mess = mess;
    }

    private String mess;

    public String execute() {
           Connection conn = null;

        try {
            String userName = "root";
            String password = "admin";
            String url = "jdbc:mysql://localhost/usersl";
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            conn = DriverManager.getConnection(url, userName, password);
            Statement st = conn.createStatement();
            ResultSet res = st.executeQuery("select* from users;");
            while (res.next()) {
                if (res.getString(1).equals(getLogin()) && (res.getString(2).equals(getPassword()))) {
                    setMess("Пользователь успешно зашел на сайт");
                    session.put("admin","1");
                    return SUCCESS;
                }
            }
        }
        catch (Exception e) {

        }
        finally {
            if (conn != null) {
                try {
                    conn.close();

                }
                catch (Exception e) { /* ignore close errors */ }
            }
        }
        

        return SUCCESS;
    }