public static Commercial selectCommercialById(int id) throws SQLException {
        String query = null;

        Commercial Util = new Commercial();
        ResultSet resultat;

        try {
            query = "SELECT * from COMMERCIAL where ID_COMMERCIAL=? ";

            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(1, id);
            resultat = pStatement.executeQuery();

            while (resultat.next()) {
                //System.out.println(resultat.getString("PAYS"));
                Util = new Commercial(resultat.getInt("ID_COMMERCIAL"),  resultat.getInt("ID_VILLE"), resultat.getString("COMMNOM"), resultat.getString("COMMPRENOM"), resultat.getString("COMMADRESSE1"), resultat.getString("COMMADRESSE2"));
            }

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

        }
        return Util;

    }