//提取用户的基本信息,调用方法将其存入数据库并返回成功或失败
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();
}
}
