namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
SqlConnection conn = new SqlConnection();
SqlCommand comm = new SqlCommand();
DateTime t1, t2;
int count = 10000; //循环次数
string times;
conn.ConnectionString = \"Data Source=.;Initial Catalog=Server;Integrated Security=True\";
comm.CommandText = \"insert into test (Cid,Cvalue) values(\'1\',\'1\')\"; //数据插入
comm.Connection = conn;
Console.WriteLine(\"开始插入数据\\r\\n开始时间:\" +(t1=DateTime.Now).ToLongTimeString());
try
{
conn.Open();
for (int i = 1; i <= count; i++)
{
comm.ExecuteNonQuery(); //执行查询
}
Console.WriteLine(\"结束时间:\" + (t2 = DateTime.Now).ToLongTimeString());
times = GetTimeSpan(t1, t2).ToString();
Console.WriteLine(\"持续时间:\" + times.Substring(0, times.LastIndexOf(\".\") + 4));
Console.WriteLine(\"本次测试总共对数据库进行了\" + count + \"次数据插入操作!\");
//comm.CommandText = \"delete from test\";
//comm.ExecuteNonQuery();
//Console.WriteLine(\"测试数据已删除\");
}
catch (Exception err)
{
Console.WriteLine(err.Message);
}
finally
{
comm = null;
conn.Close();
conn.Close();
}
Console.ReadKey();
}
/// <summary>
/// 返回两个时间对象的时间间隔
/// </summary>
private static TimeSpan GetTimeSpan(DateTime t1, DateTime t2)
{
DateTime t3;
if (DateTime.Compare(t1, t2) == 1)
{
t3 = t1;
t1 = t2;
t2 = t3;
}
return t2.Subtract(t1);
}
}
}
本文地址:https://www.stayed.cn/item/3674
转载请注明出处。
本站部分内容来源于网络,如侵犯到您的权益,请 联系我