usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Configuration;usingSystem.Data.SqlClient;usingSystem.Data;namespaceStudentMgr
{public static classSqlHelper
{public static readonly string connstr =ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;//新建连接对象
public staticSqlConnection OpenConnection()
{
SqlConnection conn= newSqlConnection(connstr);
conn.Open();returnconn;
}public static int ExecuteNonQuery(stringcmdText,paramsSqlParameter[] parameters)
{using (SqlConnection conn = newSqlConnection(connstr))
{
conn.Open();returnExecuteNonQuery(conn, cmdText, parameters);
}
}//查询单个值
public static object ExecuteScalar(stringcmdText,paramsSqlParameter[] parameters)
{using (SqlConnection conn = newSqlConnection(connstr))
{
conn.Open();returnExecuteScalar(conn, cmdText, parameters);
}
}public static DataTable ExecuteDataTable(stringcmdText,paramsSqlParameter[] parameters)
{using (SqlConnection conn = newSqlConnection(connstr))
{
conn.Open();returnExecuteDataTable(conn, cmdText, parameters);
}
}public static int ExecuteNonQuery(SqlConnection conn,stringcmdText,paramsSqlParameter[] parameters)
{using (SqlCommand cmd =conn.CreateCommand())
{
cmd.CommandText=cmdText;
cmd.Parameters.AddRange(parameters);returncmd.ExecuteNonQuery();
}
}public static object ExecuteScalar(SqlConnection conn, stringcmdText,paramsSqlParameter[] parameters)
{using (SqlCommand cmd =conn.CreateCommand())
{
cmd.CommandText=cmdText;
cmd.Parameters.AddRange(parameters);returncmd.ExecuteScalar();
}
}public static DataTable ExecuteDataTable(SqlConnection conn, stringcmdText,paramsSqlParameter[] parameters)
{using (SqlCommand cmd =conn.CreateCommand())
{
cmd.CommandText=cmdText;
cmd.Parameters.AddRange(parameters);using (SqlDataAdapter adapter = newSqlDataAdapter(cmd))
{
DataTable dt= newDataTable();
adapter.Fill(dt);returndt;
}
}
}public static object ToDBValue(this objectvalue)
{return value == null ?DBNull.Value : value;
}public static object FromDBValue(this objectdbValue)
{return dbValue == DBNull.Value ? null: dbValue;
}
}
}