字符串拼接成insert语句[简单记录]

1.

001,自吸过滤式防颗粒物呼吸器,,False,1,0,,False,,
001001,随弃式面罩,,False,2,,,False,,
001002,可更换式半面罩,,False,2,,,False,,
001003,可更换式全面罩,,False,2,,,False,,
001001001,有呼气阀,,False,3,,,,,

生成下面这种格式

insert into base_productclass2 values('001','自吸过滤式防颗粒物呼吸器','','False',1,NULL,'',NULL,'','
')
insert into base_productclass2 values('001001','随弃式面罩','','False',2,NULL,'',NULL,'','
')
insert into base_productclass2 values('001002','可更换式半面罩','','False',2,NULL,'',NULL,'','
')
insert into base_productclass2 values('001003','可更换式全面罩','','False',2,NULL,'',NULL,'','
')
insert into base_productclass2 values('001001001','有呼气阀','','False',3,NULL,'',NULL,'','
')

2.

代码实现：

FileStream fs = new FileStream("cc.txt", FileMode.Open, FileAccess.Read);
StreamReader dr = new StreamReader(fs, Encoding.Default);
string str = dr.ReadToEnd();
string[] strArr = str.Split(new string[] { "\n" }, StringSplitOptions.RemoveEmptyEntries);

StringBuilder stringBuilder = new StringBuilder();
foreach (var s in strArr)
{
string[] strItem = s.Split(new string[] { "," }, StringSplitOptions.None);
stringBuilder.Append("insert into base_productclass2 values('" + strItem[0] + "','" + strItem[1] + "','" + strItem[2] + "','" + strItem[3] + "'," + strItem[4] + ",NULL,'" + strItem[6] + "',NULL,'" + strItem[8] + "','" + strItem[9] + "')");
stringBuilder.Append("\r\n");
}
File.WriteAllText("dd.txt", stringBuilder.ToString());
Console.Write("ok");
Console.ReadKey();

转载于:https://www.cnblogs.com/LpRightNow/archive/2013/01/22/2872334.html