//提取用户的基本信息,调用方法将其存入数据库并返回成功或失败 public Boolean InsertIntoDB(Home.AnalyzeResult AnalyzeResult) { RecordWords RecordWord = new RecordWords(); RecordWord.HostIp = AnalyzeResult.RequestHeader.HostIp; RecordWord.Port = AnalyzeResult.RequestHeader.Port; RecordWord.Method = AnalyzeResult.RequestHeader.Method; RecordWord.URL = AnalyzeResult.RequestHeader.URL; RecordWord.TotalBytes = AnalyzeResult.RequestHeader.TotalBytes; if (AnalyzeResult.ResultReport == "该主机已被设置为黑名单,无法访问") { RecordWord.Visit_Limit = true; } else { RecordWord.Visit_Limit = false; } RecordWord.Remarks = AnalyzeResult.ResultReport; if (InsertRecord(RecordWord)) { return(true); } else { return(false); } }
//添加记录到数据库 private Boolean InsertRecord(RecordWords RecordWord) { try { conn = new MySqlConnection(mysqlcon); if (conn.State == System.Data.ConnectionState.Open) { return(false); } conn.Open(); comm = new MySqlCommand(); comm.CommandText = "insert into visitor_record(id,Visitor_IP,Visitor_Port," + "Visitor_Method,Visitor_Url,Flow_Rate,Visitor_Time,Visitor_Limit,Remarks)" + " value(null,@Visitor_IP,@Visitor_Port,@Visitor_Method,@Visitor_Url,@Flow_Rate," + "@Visitor_Time,@Visitor_Limit,@Remarks)"; comm.Connection = conn; MySqlParameter p1 = new MySqlParameter("@Visitor_IP", RecordWord.HostIp); comm.Parameters.Add(p1); MySqlParameter p2 = new MySqlParameter("@Visitor_Port", RecordWord.Port); comm.Parameters.Add(p2); MySqlParameter p3 = new MySqlParameter("@Visitor_Method", RecordWord.Method); comm.Parameters.Add(p3); MySqlParameter p4 = new MySqlParameter("@Visitor_Url", RecordWord.URL); comm.Parameters.Add(p4); MySqlParameter p5 = new MySqlParameter("@Flow_Rate", RecordWord.TotalBytes); comm.Parameters.Add(p5); MySqlParameter p6 = new MySqlParameter("@Visitor_Time", DateTime.Now); comm.Parameters.Add(p6); MySqlParameter p7 = new MySqlParameter("@Visitor_Limit", RecordWord.Visit_Limit); comm.Parameters.Add(p7); MySqlParameter p8 = new MySqlParameter("@Remarks", RecordWord.Remarks); comm.Parameters.Add(p8); if (comm.ExecuteNonQuery() > 0) { return(true); } else { return(false); } } catch { return(false); } finally { comm.Dispose(); conn.Close(); } }