Example #1
0
  public static usuarioBean login(usuarioBean bean) {
    Connection c = UsuarioDAO.getConnection();
    PreparedStatement ps = null;
    ResultSet rs = null;
    try {
      ps =
          c.prepareStatement(
              "select login, senha, nome from usuario where login = ? and senha = ?");
      ps.setString(1, bean.getLogin());
      ps.setString(2, bean.getSenha());

      rs = ps.executeQuery();

      if (rs.next()) {

        bean.setNome(rs.getString("nome"));
        bean.setLogin(rs.getString("login"));
        bean.setSenha(rs.getString("senha"));
        bean.setCpf(rs.getString("cpf"));
        bean.setEmail(rs.getString("email"));
        bean.setUsuarioValido(true);
      }
      return bean;
    } catch (SQLException e) {
      e.printStackTrace();
    } finally {
      if (rs != null) {
        try {
          rs.close();
        } catch (SQLException e) {;
        }
        rs = null;
      }
      if (ps != null) {
        try {
          ps.close();
        } catch (SQLException e) {;
        }
        ps = null;
      }
      if (c != null) {
        try {
          c.close();
        } catch (SQLException e) {;
        }
        c = null;
      }
    }
    return null;
  }
Example #2
0
  public static usuarioBean login2(usuarioBean bean) {

    Statement stmt = null;
    String login = bean.getLogin();
    String senha = bean.getSenha();

    String searchQuery =
        "select login,"
            + "       senha,"
            + "       nome"
            + "  from usuario "
            + " where login='******'"
            + "   and senha='"
            + senha
            + "';";

    System.out.println("Login: "******"Senha: " + senha);
    System.out.println("Query: " + searchQuery);

    /*try {
    currentCon = ConnectionManager.getConnection();
    stmt = currentCon.createStatement();
    rs = stmt.executeQuery(searchQuery);
    boolean result = rs.next();

    if (!result) {
    //login e senha informados invalidos
    bean.setUsuarioValido(false);
    }
    else if (result) {
    //                bean.setNome(rs.getString("nome"));
    //                bean.setLogin(rs.getString("login"));
    //                bean.setSenha(rs.getString("senha"));
    //                bean.setCpf(rs.getString("cpf"));
    //                bean.setEmail(rs.getString("email"));
    //                bean.setUsuarioValido(true);*/
    bean.setNome("nome");
    bean.setLogin("login");
    bean.setSenha("senha");
    bean.setCpf("cpf");
    bean.setEmail("email");
    bean.setUsuarioValido(true);

    /*}
    } catch (Exception ex) {
    System.out.println("Erro no login: " + ex);
    }
    finally {
    if (rs != null) {
    try {
    rs.close();
    } catch (Exception e) {
    }
    rs = null;
    }

    if (stmt != null) {
    try {
    stmt.close();
    } catch (Exception e) {
    }
    stmt = null;
    }

    if (currentCon != null) {
    try {
    currentCon.close();
    } catch (Exception e) {
    }
    currentCon = null;
    }
    }*/
    return bean;
  }