把excel表中的数据用insert into的方法插入数据库,在没有开启事务前,耗时巨大,开启事务后,插入速度很快,以下是代码,有需要的朋友可参考
SQLiteConnection cn = new SQLiteConnection("Data Source=" + System.Environment.CurrentDirectory + "\\分班数据库.db");
if (cn.State == ConnectionState.Closed) //如果数据库断开重连数据库
{
cn.Open();
}
SQLiteCommand cmd = new SQLiteCommand("",cn);
SQLiteTransaction tran =cn.BeginTransaction();//开启事务
for (int c = 1; c < h; c++)
{
string s2 = sht.readStr(c, 2);
string sql =$"INSERT INTO {s2}(姓名,性别,生源,民族,语文,数学,英语) VALUES('{sht.readStr(c, 0)}','{sht.readStr(c, 1)}','{sht.readStr(c, 2)}','{sht.readStr(c, 3)}',{sht.readStr(c, 4)},{sht.readSt