public static class SqlHelper
{
//连接字符串
private static string conStr = ConfigurationManager.ConnectionStrings["conStr"].ConnectionString;
//增删改
public static int ExecuteNonQuery(string sqlStr, CommandType ct, params SqlParameter[] sq)
{
using (SqlConnection sqlCon = new SqlConnection(conStr))
{
using (SqlCommand cmd = new SqlCommand(sqlStr, sqlCon))
{
cmd.CommandType = ct;
if (sq != null)
{
cmd.Parameters.AddRange(sq);
}
//打开连接
sqlCon.Open();
return cmd.ExecuteNonQuery();
}
}
}
//scalar
public static object ExecuteScalar(string sqlStr, CommandType ct, params SqlParameter[] sq)
{
using (SqlConnection sqlCon = new SqlConnection(conStr))
{
using (SqlCommand cmd = new SqlCommand(sqlStr, sqlCon))
{
cmd.CommandType = ct;
if (sq != null)
{
cmd.Parameters.AddRange(sq);
}
//打开连接
sqlCon.Open();
return cmd.ExecuteScalar();
}
}
}
//reader
public static SqlDataReader ExecuteReader(string sqlStr, CommandType ct, params SqlParameter[] sq)
{
SqlConnection sqlCon = new SqlConnection(conStr);
using (SqlCommand cmd = new SqlCommand(sqlStr, sqlCon))
{
cmd.CommandType = ct;
if (sq != null)
{
cmd.Parameters.AddRange(sq);
}
//打开连接
try
{
sqlCon.Open();
return cmd.ExecuteReader(CommandBehavior.CloseConnection); //当对象释放时,数据库连接自动关闭
}
catch (Exception)
{
sqlCon.Dispose();
throw;
}
}
}
//table
public static DataTable ExecuteDataTable(string sqlStr, CommandType ct, params SqlParameter[] sq)
{
DataTable dt = new DataTable();
using (SqlDataAdapter sda=new SqlDataAdapter(sqlStr,conStr))
{
sda.SelectCommand.CommandType = ct;
if (sq != null)
{
sda.SelectCommand.Parameters.AddRange(sq);
}
sda.Fill(dt);
return dt;
}
}
}
SqlHelp
最新推荐文章于 2021-02-02 00:54:27 发布