namespace BookShop.DAL
{
public static class SQLHelper
{
//数据库连接对象
private static SqlConnection conn;
private static string connStr; static SQLHelper()
{
//从配置文件中获取数据库连接字符串
connStr = ConfigurationManager.ConnectionStrings["BookShopconnStr"].ToString();
conn = new SqlConnection(connStr);
} #region 数据库连接
/// <summary>
/// 打开数据库连接
/// </summary>
private static void OpenConnection()
{
//如果关闭了数据库连接
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
} /// <summary>
/// 关闭数据库连接
/// </summary>
private static void CloseConnection()
{
//如果打开了数据库连接
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
} public static int ExecuteNonQuery(string sql, CommandType typeText, SqlParameter[] parames)
{
int count = 0;
try
{
SqlCommand comm = new SqlCommand();
comm.CommandText = sql;
comm.CommandType = typeText;
comm.Connection = conn; //comm.Parameters.AddRange(parames); if (parames != null && parames.Length > 0)
{
//循环为参数赋值
for (int i = 0; i < parames.Length; i++)
{
comm.Parameters.Add(parames[i]);
}
}
//如果sql语句为空不执行
if (!string.IsNullOrEmpty(sql))
{
OpenConnection();
//执行sql语句返回受影响的行数
count = comm.ExecuteNonQuery();
CloseConnection();
}
}
catch(Exception ex)
{
CloseConnection();
throw ex;
}
return count;
}
这种写连接数据库方法如果同时在线100人以上操作会有问题么?
{
public static class SQLHelper
{
//数据库连接对象
private static SqlConnection conn;
private static string connStr; static SQLHelper()
{
//从配置文件中获取数据库连接字符串
connStr = ConfigurationManager.ConnectionStrings["BookShopconnStr"].ToString();
conn = new SqlConnection(connStr);
} #region 数据库连接
/// <summary>
/// 打开数据库连接
/// </summary>
private static void OpenConnection()
{
//如果关闭了数据库连接
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
} /// <summary>
/// 关闭数据库连接
/// </summary>
private static void CloseConnection()
{
//如果打开了数据库连接
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
} public static int ExecuteNonQuery(string sql, CommandType typeText, SqlParameter[] parames)
{
int count = 0;
try
{
SqlCommand comm = new SqlCommand();
comm.CommandText = sql;
comm.CommandType = typeText;
comm.Connection = conn; //comm.Parameters.AddRange(parames); if (parames != null && parames.Length > 0)
{
//循环为参数赋值
for (int i = 0; i < parames.Length; i++)
{
comm.Parameters.Add(parames[i]);
}
}
//如果sql语句为空不执行
if (!string.IsNullOrEmpty(sql))
{
OpenConnection();
//执行sql语句返回受影响的行数
count = comm.ExecuteNonQuery();
CloseConnection();
}
}
catch(Exception ex)
{
CloseConnection();
throw ex;
}
return count;
}
这种写连接数据库方法如果同时在线100人以上操作会有问题么?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货