public static void insertInterlocuteur(int idcommercial, int idville, int idservice, String nom, String prenom, String email) throws SQLException {
        String query;

        try {

            query = "INSERT INTO INTERLOCUTEUR (ID_COMMERCIAL,ID_VILLE,ID_SERVICE,INTNOM,INTPRENOM,INTEMAIL) VALUES (?,?,?,?,?,?) ";

            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(1, idcommercial);
            pStatement.setInt(2, idville);
            pStatement.setInt(3, idservice);
            pStatement.setString(4, nom.toUpperCase());
            pStatement.setString(5, prenom.toLowerCase());
            pStatement.setString(6, email.toUpperCase());
            pStatement.executeUpdate();

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


    }