title: How to return a single data from a database using Java?
body: <p>Basically there is a table with the fields: id(PK), name, total of votes.
  And I need to add 1 vote for this specific id per turn the program is used, I was intending to only get the total votes of this id, add plus 1 vote and store it again in the same id. I was using this code:</p>
  
  <pre><code>    String user = "root";
      String pass = "";
      String url = "jdbc:mysql://127.0.0.1:3306/provapaoo_22_06_2018";
  
      String takeVotes = String.format("select `Total Votes` "
              + "from `%s` where id= ?", nameOfTable);
  
      String addVote = String.format("update `%s` set "
              + "`Total votes` = ?", nameOfTable);
      try{
      Connection conec =
              DriverManager.getConnection(url, usuario, senha);
  
          PreparedStatement comand =
                  conexão.prepareStatement(takeVotes);
  
          comando.setInt(1, id);
  
          ResultSet result = comand.executeQuery();
  
          int qtdVotes = 0;
  
          while(resultado.next()){
              qtdVotes = result.getInt("Total Votes");
          }
  
          qtdVotes++;
  
          comand = conec.prepareStatement(addVote);
  
          comand.setInt(1, qtdVotes);
  
          comand.executeUpdate();
  
          comand.close();
          conec.close();
  
      }catch(SQLException e){
          e.printStackTrace();
      }
  </code></pre>
  
  <p>The program is running good but the problem is the resultSet, it's not returning only the total votes of that id, it's returning the total votes of everyone, it's  almost like the sql syntax isn't working.</p>