using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; /// <summary> /// 数据库操作类 /// </summary> public class Common { private static SqlConnection conn = new SqlConnection(); private static SqlCommand comm = new SqlCommand(); public Common() { // // TODO: 在此处添加构造函数逻辑 // } /// <summary> /// 打开连接 /// </summary> private static void openConnection() { if (conn.State == ConnectionState.Closed) { try { conn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["connStr"].ConnectionString; comm.Connection = conn; conn.Open(); } catch(Exception e) { throw new Exception(e.Message); } } } /// <summary> /// 关闭连接 /// </summary> private static void closeConnection() { if (conn.State == ConnectionState.Open) { conn.Close(); conn.Dispose(); comm.Dispose(); } } /// <summary> /// 执行一条sql语句 /// </summary> /// <param name="sqlStr">sql语句</param> public static void ExecuteSql(string sqlStr) { try { openConnection(); comm.CommandType = CommandType.Text; comm.CommandText = sqlStr; comm.ExecuteNonQuery(); } catch (Exception e) { throw new Exception(e.Message); } finally { closeConnection(); } } /// <summary> /// 返回一个数据集 /// </summary> /// <param name="sqlStr">sql语句</param> /// <returns></returns> public static DataSet dataSet(string sqlStr) { SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); try { openConnection(); comm.CommandType = CommandType.Text; comm.CommandText = sqlStr; da.SelectCommand = comm; da.Fill(ds); } catch(Exception e) { throw new Exception(e.Message); } finally { closeConnection(); } return ds; } }