22,209
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace TestConnection
{
class Program
{
static void Main(string[] args)
{
DateTime t1 = DateTime.Now;
for (int i = 0; i < 20001; i++)
{
MyConnection myy = new MyConnection();
myy.Open();
if (i % 3 == 0)
{
myy.Update();
}
else if (i % 3 == 2)
{
myy.Query();
}
else
{
myy.AddRows();
}
//myy.;
Console.WriteLine(i.ToString());
}
DateTime t2 = DateTime.Now;
TimeSpan ts = t2.Subtract(t1);
Console.WriteLine(ts.TotalMilliseconds.ToString());
//myy.Close();
Console.ReadLine();
}
}
public class MyConnection
{
public SqlConnection con = null;
public MyConnection()
{
con = new SqlConnection("data source=IDC\\SQL2012;uid=sa;pwd=123456;initial catalog=hhhhh;pooling=true;connection lifetime=0;min pool size = 1;max
pool size=40000");
}
public void Open()
{
con.Open();
}
public void Close()
{
con.Close();
con.Dispose();
}
public void Query()
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select top 1 * from UserInfo where id=" + new Random().Next(1, 2700000) + "";
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
string s = reader[0].ToString();
}
reader.Close();
cmd.Dispose();
}
public void Update()
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "update userInfo set Balance=8886.99,Rebot=1,updateDate=getdate() where id=" + new Random().Next(1, 2700000) + " ";
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public void AddRows()
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
String stSQL = " INSERT INTO [dbo].[UserInfo]([Name],[Sex],[Intro],[AddDate],[UpdateDate],[IsUpdate],[IsLogin],[Balance],[Mobile],[QQ],[Email],
[Address],[Pid]";
stSQL += ",[PostT],[GetT],[ReturnT],[BornT],[FilePath],[Vip],[Daili],[Question],[Answer],[RegIP],[LoginIP],[LastLogin],[OnlineTime],[NickName],
[UserName]";
stSQL += " ,[IsSay],[IsSayDate],[Md5Phone],[Rebot],[IsTestUser],[FromUser],[FromUserStatus])";
stSQL += " values('美女好人','1',N'爱立信将在瑞典裁掉3000名员工和900名顾问爱立信宣布的这一消息证实了瑞典媒体此前的报道。瑞典媒体早在7月就报道称,
由于市场行情艰难,爱立信将采取一些措施来提高效率。爱立信在2014年时就宣布了一项成本削减计划,削减目标为90亿瑞典克朗',";
stSQL += "getdate(),getdate(),1,0," + new Random().Next(1, 100000) + ",'13348195578','26336165899','ddddddd@hotmail.com',N'河南三闯火海救火英雄王
锋遗体告别仪式在京举行','22689',200,300,400,999.35,'/library/asdfa/asdfdasf/adsfads/asdf',";
stSQL += "'isvipandno',1,'我爱什么','喜欢爱啦','218.25.66.189','61.139.2.77',getdate(),'adfsfsfsfdsfdsfds','为爱的信子','aaaahonglan',1,getdate
(),'dddddddddddddddddddddddddddddddd',0,0,'lihaibokkkk','0'";
stSQL += ")";
cmd.CommandText = stSQL;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public void Insert()
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into testTable2(username,reuserName,setUserName,isLeft) values('a','b','c',1)";
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
}
INSERT INTO [dbo].[UserInfo]([Name],[Sex],[Intro],[AddDate],[UpdateDate],[IsUpdate],[IsLogin],[Balance],[Mobile],[QQ],[Email],[Address],[Pid],[PostT],[GetT],[ReturnT],[BornT],[FilePath],[Vip],[Daili],[Question],[Answer],[RegIP],[LoginIP],[LastLogin],[OnlineTime],[NickName],[UserName] ,[IsSay],[IsSayDate],[Md5Phone],[Rebot],[IsTestUser],[FromUser],[FromUserStatus]) values('美女好人','1',N'爱立信将在瑞典裁掉3000名员工和900名顾问爱立信宣布的这一消息证实了瑞典媒体此前的报道。瑞典媒体早在7月就报道称,由于市场行情艰难,爱立信将采取一些措施来提高效率。爱立信在2014年时就宣布了一项成本削减计划,削减目标为90亿瑞典克朗',getdate(),getdate(),1,0,18470,'13348195578','26336165899','ddddddd@hotmail.com',N'河南三闯火海救火英雄王锋遗体告别仪式在京举行','22689',200,300,400,999.35,'/library/asdfa/asdfdasf/adsfads/asdf','isvipandno',1,'我爱什么','喜欢爱啦','218.25.66.189','61.139.2.77',getdate(),'adfsfsfsfdsfdsfds','为爱的信子','aaaahonglan',1,getdate(),'dddddddddddddddddddddddddddddddd',0,0,'lihaibokkkk','0')
USE [hhhhh]
GO
/****** Object: Table [dbo].[UserInfo] Script Date: 2016/10/6 12:23:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[UserInfo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NULL,
[Sex] [bit] NULL,
[Intro] [nvarchar](500) NULL,
[AddDate] [datetime] NULL,
[UpdateDate] [datetime] NULL,
[IsUpdate] [bit] NULL,
[IsLogin] [bit] NULL,
[Balance] [decimal](18, 4) NULL,
[Mobile] [nvarchar](50) NULL,
[QQ] [varchar](50) NULL,
[Email] [varchar](255) NULL,
[Address] [nvarchar](255) NULL,
[Pid] [int] NULL,
[PostT] [decimal](18, 4) NULL,
[GetT] [decimal](18, 4) NULL,
[ReturnT] [decimal](18, 4) NULL,
[BornT] [decimal](18, 4) NULL,
[FilePath] [varchar](255) NULL,
[Vip] [varchar](50) NULL,
[Daili] [bit] NULL,
[Question] [nvarchar](50) NULL,
[Answer] [nvarchar](50) NULL,
[RegIP] [varchar](50) NULL,
[LoginIP] [varchar](50) NULL,
[LastLogin] [datetime] NULL,
[OnlineTime] [nvarchar](50) NULL,
[NickName] [nvarchar](50) NULL,
[UserName] [varchar](50) NULL,
[IsSay] [bit] NULL,
[IsSayDate] [datetime] NULL,
[Md5Phone] [varchar](50) NULL,
[Rebot] [bit] NULL,
[IsTestUser] [bit] NULL,
[FromUser] [varchar](50) NULL,
[FromUserStatus] [bit] NULL,
CONSTRAINT [PK_UserInfo] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO