将文字提取到mysql_将文本数据提取导入到数据库

usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Data.SqlClient;usingSystem.Diagnostics;namespace从文本中提取数据到数据库中

{classProgram

{static void Main(string[] args)

{//项目中的Programe.cs文件必须加上以下神奇的代码，对数据库的操作才能生效

string dataDir =AppDomain.CurrentDomain.BaseDirectory;if (dataDir.EndsWith(@"\bin\Debug\")|| dataDir.EndsWith(@"\bin\Release\"))

{

dataDir=System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;

AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);

}//启用秒表来计时

Stopwatch timer = newStopwatch();

timer.Start();string[] lines = System.IO.File.ReadAllLines(@"D:\转账记录.txt", Encoding.Default);for (int i = 0; i < lines.Length; i++)

{string[] str=lines[i].Split('|');using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;

AttachDBFilename=|DataDirectory|\ZhuanZhang.mdf;Integrated Security=True;User Instance=True"))

{

conn.Open();using (SqlCommand cmd =conn.CreateCommand())

{

cmd.CommandText= "Insert into T_ZhuanZhang (CardNum,Money,Name) values (@CardNum,@Money,@Name)";

cmd.Parameters.Add(new SqlParameter("CardNum", str[0]));

cmd.Parameters.Add(new SqlParameter("Money", str[1]));

cmd.Parameters.Add(new SqlParameter("Name", str[2]));

cmd.ExecuteNonQuery();

}

}

}

Console.WriteLine("数据导入成功！");

timer.Stop();

Console.WriteLine(timer.Elapsed);

Console.ReadKey();

}

}

}