public static void insertCommercial(int idservice,  String nom, String prenom, String adresse1, String adresse2 ) throws SQLException {

        String query;

        try {

            query = "INSERT INTO COMMERCIAL (ID_VILLE,COMMNOM,COMMPRENOM,COMMADRESSE1,COMMADRESSE2) VALUES (?,?,?,?,?) ";

            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(1, idservice);
            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);

        }
    }