public static Tva selectTvaById(int id)  throws SQLException {
        String query = null;
      
        Tva tva = new Tva();
        ResultSet resultat;
            
        try {
            query = "SELECT * from TVA where ID_TVA=? ";

            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(1, id);
            resultat = pStatement.executeQuery();
          
            while (resultat.next()) {
                //System.out.println(resultat.getString("PAYS"));
                tva = new Tva(resultat.getInt("ID_TVA"), resultat.getString("TVALIBELLE"),resultat.getFloat("TVATX"));
            }

        } catch (SQLException ex) {
            Logger.getLogger(RequetesTva.class.getName()).log(Level.SEVERE, null, ex);

        }
        return tva;

    }