public class SqlHelper
{
/// <summary>
/// 连接字段
/// </summary>
private static readonly string SqlCoon = ConfigurationManager.ConnectionStrings["SqlCoon"].ConnectionString;
/// <summary>
/// 执行增删改的方法,返回受影响的行数
/// </summary>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <returns></returns>
public static int ExecNowQuery(string sql, params SqlParameter[] param)
{
//声明数据库
using (SqlConnection Coon = new SqlConnection(SqlCoon))
{
//声明命令
using (SqlCommand cmd = new SqlCommand(sql, Coon))
{
//如果数据库是关闭,那么打开数据库
if (Coon.State == ConnectionState.Closed)
{
Coon.Open();
}
//如果可变参数不为空,那么添加参数
if (param != null && param.Length > 0)
{
cmd.Parameters.AddRange(param);
}
//执行命令
return cmd.ExecuteNonQuery();
}
}
}
/// <summary>
/// 执行查询,返回首行首列
/// </summary>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <returns></returns>
public static object ExecuteScalar(string sql, params SqlParameter[] param)
{
//声明数据库连接
using (SqlConnection Coon = new SqlConnection(SqlCoon))
{
//声明命令
using (SqlCommand cmd = new SqlCommand(sql,Coon))
{
//如果是数据库关闭的,那么打开
if (Coon.State == ConnectionState.Closed)
{
Coon.Open();
}
//如果可变参数不为空,添加参数
if (param != null && param.Length > 0)
{
cmd.Parameters.AddRange(param);
}
//执行命令
return cmd.ExecuteScalar();
}
}
}
public static DataTable ExecQueryTable(string sql,params SqlParameter[] param)
{
//声明SqlDataAdapter对象
using (SqlDataAdapter Coon=new SqlDataAdapter(sql,SqlCoon))
{
//如果可变参数不为空,那么添加参数
if (param!=null&¶m.Length>0)
{
Coon.SelectCommand.Parameters.AddRange(param);
}
//表
DataTable dt = new DataTable();
Coon.Fill(dt);
return dt;
}
}
public static SqlDataReader ExecuteReader(string sql, params SqlParameter[] param)
{
//声明连接
SqlConnection Coon=new SqlConnection(SqlCoon)
//声明命令
using (SqlCommand cmd=new SqlCommand(sql,Coon))
{
//打开数据库
if (Coon.State==ConnectionState.Closed)
{
Coon.Open();
}
//判断可变参数
if (param!=null&¶m.Length>0)
{
cmd.Parameters.AddRange(param);
}
//执行命令
return cmd.ExecuteReader(CommandBehavior.CloseConnection) ;
}
}
}