public static void deleteBillet(int numPasseport) {
        logger.info("Suppression d'un billet");

        try {
            PreparedStatement pstmt = bdConnection().prepareStatement(ScriptSql.requestDeleteBillet);

            pstmt.setInt(1, numPasseport);

            logger.info(ScriptSql.requestDeleteBillet);
            pstmt.executeUpdate();

        } catch (SQLException s) {
            logger.info(s.getMessage());
        }
    }



    public static void deletePassager(int numPasseport) {
        logger.info("Suppression d'un passager");

        try {
            PreparedStatement pstmt = bdConnection().prepareStatement(ScriptSql.requestDeletePassager);

            pstmt.setInt(1, numPasseport);

            logger.info(ScriptSql.requestDeletePassager);
            pstmt.executeUpdate();

        } catch (SQLException s) {
            logger.info(s.getMessage());
        }
    }






















    public static final String requestDeleteBillet =
        "DELETE FROM APP.BILLET WHERE PASSAGER = ?";


    public static final String requestDeletePassager =
        "DELETE FROM APP.PASSAGER WHERE NUM_PASSEPORT = ?";