官方版

Log Sessions to Local Database

1. Add Rules to Fiddler to create a new menu item as follows:

   // Log the currently selected sessions in the list to a database.
   // Note: The DB must already exist and you must have permissions to write to it.
   public static ToolsAction("Log Selected Sessions") 
   function DoLogSessions(oSessions: Fiddler.Session[]){
   if (null == oSessions || oSessions.Length < 1){
   MessageBox.Show("Please select some sessions first!");
   return;
   }
   var strMDB = "C:\\log.mdb";
   var cnn = null;
   var sdr = null;
   var cmd = null;
   try
   {
   cnn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strMDB);
   cnn.Open();
   cmd = new OleDbCommand();
   cmd.Connection = cnn;
   for (var x = 0; x < oSessions.Length; x++){
    var strSQL = "INSERT into tblSessions ([ResponseCode],[URL]) Values (" + 
    oSessions[x].responseCode + ", '" + oSessions[x].url + "')";
    cmd.CommandText = strSQL;
    cmd.ExecuteNonQuery();
   }
   }
   catch (ex){
   MessageBox.Show(ex);
   }
   finally
   {
   if (cnn != null ){
    cnn.Close();
   }
   }
   }

   List the new import at the top of your rules script as follows:

   import System.Data.OleDb;

   Note: This example relies upon OLEDB 4.0 which is not available for 64bit processes. Either:

• Select another data provider (for example, SQLServer); or
• Force Fiddler to run in 32bit mode

谷歌翻译版

将会话记录保存到本地数据库

1. 向Fiddler添加一个规则以创建一个新的菜单项，如下所示:

   // Log the currently selected sessions in the list to a database.
   // Note: The DB must already exist and you must have permissions to write to it.
   public static ToolsAction("Log Selected Sessions") 
   function DoLogSessions(oSessions: Fiddler.Session[]){
   if (null == oSessions || oSessions.Length < 1){
   MessageBox.Show("Please select some sessions first!");
   return;
   }
   var strMDB = "C:\\log.mdb";
   var cnn = null;
   var sdr = null;
   var cmd = null;
   try
   {
   cnn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strMDB);
   cnn.Open();
   cmd = new OleDbCommand();
   cmd.Connection = cnn;
   for (var x = 0; x < oSessions.Length; x++){
    var strSQL = "INSERT into tblSessions ([ResponseCode],[URL]) Values (" + 
    oSessions[x].responseCode + ", '" + oSessions[x].url + "')";
    cmd.CommandText = strSQL;
    cmd.ExecuteNonQuery();
   }
   }
   catch (ex){
   MessageBox.Show(ex);
   }
   finally
   {
   if (cnn != null ){
    cnn.Close();
   }
   }
   }

   在您的规则脚本顶部列出新的导入，如下所示：

   import System.Data.OleDb;

   注意：此示例依赖于OLEDB 4.0，该软件不适用于64位进程。 要么：

• 选择另一个数据提供者(例如，SQLServer); 要么
• 强制Fiddler以32位运行