html可以导入MySQL吗_解析HTML文件并插入数据库保存起来

【实例简介】

【实例截图】

【核心代码】

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.IO;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Web;

using System.Net;

using System.Text.RegularExpressions;//正则表达式

using System.Data.SqlClient;

namespace HTML_Read_30_Aug

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

#region 定义FMC文件变量

public string Programname = string.Empty;

public string Processtime = string.Empty;

public string Endtime = string.Empty;

public string Processdate = string.Empty;

public string Filename = string.Empty;

#endregion

#region Public Function

public static string GetHtmlStr(string url, string encoding)

{

string htmlStr = "";

try

{

if (!String.IsNullOrEmpty(url))

{

WebRequest request = WebRequest.Create(url); //实例化WebRequest对象

WebResponse response = request.GetResponse(); //创建WebResponse对象

Stream datastream = response.GetResponseStream(); //创建流对象

Encoding ec = Encoding.Default;

if (encoding == "UTF8")

{

ec = Encoding.UTF8;

}

else if (encoding == "Default")

{

ec = Encoding.Default;

}

StreamReader reader = new StreamReader(datastream, ec);

htmlStr = reader.ReadToEnd(); //读取网页内容

reader.Close();

datastream.Close();

response.Close();

}

}

catch { }

return htmlStr;

}

public static void WriteLogRecord()

{

StreamWriter write = null;

//string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //年-月-日 时：分：秒

string LogName = "Record.log";//日志名称

string LogPath = System.Windows.Forms.Application.StartupPath "//Record//";//日志存放路径

string Log = LogPath LogName;//路径 名称

if (!File.Exists(Log))//是否存在

{

Directory.CreateDirectory(LogPath);//创建文件夹

write = File.CreateText(LogName);// 创建日志

}

else

{

write = File.AppendText(Log);//追加，添加错误信息

}

//TimeSpan ts = EndTime.Subtract(StartTime);

//write.WriteLine(EndTime.ToString("yyyy-MM-dd HH:mm:ss"));

//write.WriteLine("系统开始运行时间：" StartTime.ToString());

//write.WriteLine("系统结束运行时间：" EndTime.ToString());

//rite.WriteLine("系统总运行时间：" ts.ToString());

write.WriteLine(GetHtmlStr(@"C:\Users\lucaslau\Desktop\HTML读取\WORK_070717.htm", "Default"));

write.WriteLine("\r\n#########################################");

write.Flush();

//write.Close();

write.Dispose();

}

public bool Check_BIMA_IE_Data_Date(string UploadFileName)

{

SqlConnection cnn = new SqlConnection();

cnn.ConnectionString =