Пример #1
0
  @Override
  public UserAccount selectRegistry(int iduser) throws SQLException {
    String query = "SELECT * FROM user WHERE iduser ="******";";

    MySql.rs = MySql.stm.executeQuery(query);
    MySql.stm = MySql.conn.createStatement();

    if (MySql.rs.next()) {
      UserAccount userData = new UserAccount();
      userData.setIdUser(Integer.parseInt(MySql.rs.getString("iduser")));
      userData.setName(MySql.rs.getString("name"));
      userData.setLogin(MySql.rs.getString("login"));
      userData.setPassword(MySql.rs.getString("password"));
      userData.setEmail(MySql.rs.getString("email"));
      return userData;
    } else {
      throw new SQLException();
    }
  }