新闻发布系统设计源码及新闻发布系统设计说明书.docVIP

/ * *说明：数据库助手类 */ using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.SqlClient; using System.Configuration; namespace DAL { public class SQLHelper { private SqlConnection conn = null; private SqlCommand cmd = null; private SqlDataReader sdr = null; public SQLHelper() { string connStr = ConfigurationManager.ConnectionStrings[connStr].ConnectionString; conn = new SqlConnection(connStr); } private SqlConnection GetConn() { if (conn.State == ConnectionState.Closed) { conn.Open(); } return conn; } /// summary /// 执行不带参数的增删改SQL语句或存储过程 /// /summary /// param name=cmdText增删改SQL语句或存储过程/param /// param name=ct命令类型/param /// returns/returns public int ExecuteNonQuery(string cmdText, CommandType ct) { int res; try { cmd = new SqlCommand(cmdText, GetConn()); cmd.CommandType = ct; res = cmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } return res; } /// summary /// 执行带参数的增删改SQL语句或存储过程 /// /summary /// param name=cmdText增删改SQL语句或存储过程/param /// param name=ct命令类型/param /// returns/returns public int ExecuteNonQuery(string cmdText, SqlParameter[] paras, CommandType ct) { int res; using (cmd = new SqlCommand(cmdText, GetConn())) { cmd.CommandType = ct; cmd.Parameters.AddRange(paras); res = cmd