static void Main(string[] args)
{
Stopwatch sp = new Stopwatch();
sp.Start();
int count = 0;
string sql = "insert into Exe3.newStudent(stuName, stuSex, stuBirthdate, stuStudydate, stuAddress, stuEmail, stuPhone, stuIsDel, stuInputtime, classId) values(@stuName, @stuSex, @stuBirthdate, @stuStudydate, @stuAddress, @stuEmail, @stuPhone, @stuIsDel, @stuInputtime, @classId);";
string connStr = @"server=.\sqlexpress;database=HeiMa8;uid=sa;pwd=123;";
using (SqlConnection conn = new SqlConnection(connStr))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
using (StreamReader reader = new StreamReader("student.txt", Encoding.Default))
{
string temp = null;
while ((temp = reader.ReadLine()) != null)
{
// 循环读取每一个文本数据行
// stuName, stuSex, stuBirthdate, stuStudydate,
// stuAddress, stuEmail, stuPhone, stuIsDel,
// stuInputtime, classId
string[] temps = temp.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
SqlParameter[] ps =
{
new SqlParameter("@stuName", temps[1]),
new SqlParameter("@stuSex", temps[2]),
new SqlParameter("@stuBirthdate", temps[3]),
new SqlParameter("@stuStudydate", temps[4]),
new SqlParameter("@stuAddress", temps[5]),
new SqlParameter("@stuEmail", temps[6]),
new SqlParameter("@stuPhone", temps[7]),
new SqlParameter("@stuIsDel", temps[8]),
new SqlParameter("@stuInputtime", temps[9]),
new SqlParameter("@classId", temps[10]),
};
cmd.Parameters.AddRange(ps);
count += cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
}
}
}
sp.Stop();
Console.WriteLine("{0}行受影响,耗时{1}秒", count,sp.Elapsed);
Console.ReadKey();
}
{
Stopwatch sp = new Stopwatch();
sp.Start();
int count = 0;
string sql = "insert into Exe3.newStudent(stuName, stuSex, stuBirthdate, stuStudydate, stuAddress, stuEmail, stuPhone, stuIsDel, stuInputtime, classId) values(@stuName, @stuSex, @stuBirthdate, @stuStudydate, @stuAddress, @stuEmail, @stuPhone, @stuIsDel, @stuInputtime, @classId);";
string connStr = @"server=.\sqlexpress;database=HeiMa8;uid=sa;pwd=123;";
using (SqlConnection conn = new SqlConnection(connStr))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
using (StreamReader reader = new StreamReader("student.txt", Encoding.Default))
{
string temp = null;
while ((temp = reader.ReadLine()) != null)
{
// 循环读取每一个文本数据行
// stuName, stuSex, stuBirthdate, stuStudydate,
// stuAddress, stuEmail, stuPhone, stuIsDel,
// stuInputtime, classId
string[] temps = temp.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
SqlParameter[] ps =
{
new SqlParameter("@stuName", temps[1]),
new SqlParameter("@stuSex", temps[2]),
new SqlParameter("@stuBirthdate", temps[3]),
new SqlParameter("@stuStudydate", temps[4]),
new SqlParameter("@stuAddress", temps[5]),
new SqlParameter("@stuEmail", temps[6]),
new SqlParameter("@stuPhone", temps[7]),
new SqlParameter("@stuIsDel", temps[8]),
new SqlParameter("@stuInputtime", temps[9]),
new SqlParameter("@classId", temps[10]),
};
cmd.Parameters.AddRange(ps);
count += cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
}
}
}
sp.Stop();
Console.WriteLine("{0}行受影响,耗时{1}秒", count,sp.Elapsed);
Console.ReadKey();
}