官网下载地址

wireshark download

场景1：抓某一个接口指定查询sql语句(例如jpa中调用的sql展示)

1. 选择需要监听的网卡

   
   屏幕快照 2020-04-15 上午11.27.17.png

2. 开始抓包后选择需要监听的内容
   tcp.dstport == 3306 and mysql.query contains select

   
   屏幕快照 2020-04-15 上午11.25.19.png

3. 点击记录详情，查看完整的sql语句

/* load one-to-many com.aihuishou.service.tic.entity.BaseTradeInOrder.tradeInOrderRefunds */ select tradeinord0_.trade_in_order_id as trade_i17_8_1_, tradeinord0_.id as id1_8_1_, tradeinord0_.id as id1_8_0_, tradeinord0_.after_sale_no as after_sa2_8_0_, tradeinord0_.amount as amount3_8_0_, tradeinord0_.created_dt as created_4_8_0_, tradeinord0_.gateway_serial_no as gateway_5_8_0_, tradeinord0_.gateway_type as gateway_6_8_0_, tradeinord0_.memo as memo7_8_0_, tradeinord0_.order_no as order_no8_8_0_, tradeinord0_.origin_amount as origin_a9_8_0_, tradeinord0_.out_serial_no as out_ser10_8_0_, tradeinord0_.refund_fail_dt as refund_11_8_0_, tradeinord0_.refund_reason as refund_12_8_0_, tradeinord0_.refund_status as refund_13_8_0_, tradeinord0_.refund_success_dt as refund_14_8_0_, tradeinord0_.trade_in_order_id as trade_i17_8_0_, tradeinord0_.updated_dt as updated15_8_0_, tradeinord0_.user_key as user_ke16_8_0_ from trade_in_order_refund tradeinord0_ where tradeinord0_.trade_in_order_id in (6169, 6178, 6177, 6176, 6175, 6174, 6173, 6172, 6171, 6170)

屏幕快照 2020-04-15 上午11.29.41.png

4. 过滤表达式如何写

Analyze->Display Filter Expression

屏幕快照 2020-04-15 上午11.17.25.png

场景2：抓包本地http请求

选择lo0这个本地有流量的

屏幕快照 2020-04-15 上午11.49.50.png

抓包本地http

屏幕快照 2020-04-15 上午11.48.58.png