public static void updateCommercial(int id, int idservice, int idville, String nom, String prenom, String adresse1, String adresse2) throws SQLException {
        int result;
        String query;
        try {
            query = "UPDATE COMMERCIAL set ID_VILLE=?,COMMNOM=?,COMMPRENOM=?,COMMADRESSE1=?,COMMADRESSE2=? where ID_COMMERCIAL=? ";

            PreparedStatement pStatement = (PreparedStatement) ConnectionBDD.getInstance().getPreparedStatement(query);

            pStatement.setInt(6, id);
            pStatement.setInt(1, idville);
            pStatement.setString(2, nom);
            pStatement.setString(3, prenom);
            pStatement.setString(4, adresse1);
            pStatement.setString(5, adresse2);
            pStatement.executeUpdate();
            
           
        } catch (SQLException ex) {
            Logger.getLogger(RequetesCommercial.class.getName()).log(Level.SEVERE, null, ex);
            
        }
       
    }