[转]强壮的DBHelper（6）

Version6.0：

    public class DBHelper
    {
        //在配置文件中，连接字符串应该如下编写：
        //server=.;uid=sa;pwd=;database=testDB;min pool size=4;max pool size=40;
        string cnnString=System.Configuration.ConfigurationManager.ConnectionStrings["SqlServerConntionString"].ConnectionString;
        public int ExecuteNonQuery(string procName, SqlParameter[] ps)
        {
            SqlConnection cnn = new SqlConnection(cnnString);
            SqlCommand cmd = cnn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = procName;
            cmd.Parameters.AddRange(ps);

            cnn.Open();
            int x = cmd.ExecuteNonQuery();
            cnn.Close();
            return x;
        }

        public DataTable GetTable(string procName, SqlParameter[] ps)
        {
            SqlConnection cnn = new SqlConnection(cnnString);
            SqlCommand cmd = cnn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = procName;
            cmd.Parameters.AddRange(ps);

            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            return dt;
        }

        public object GetScalar(string procName, SqlParameter[] ps)
        {
            SqlConnection cnn = new SqlConnection(cnnString);
            SqlCommand cmd = cnn.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = procName;
            cmd.Parameters.AddRange(ps);

            cnn.Open();
            object obj = cmd.ExecuteScalar();
            cnn.Close();
            return obj;
        }

        public int ExecuteNonQuery(string[] procNames, SqlParameter[][] ps)
        {
            SqlConnection cnn = new SqlConnection(cnnString);
            SqlTransaction tran = cnn.BeginTransaction();
            SqlCommand[] cmds=new SqlCommand[procNames.Length];
            for (int i = 0; i < procNames.Length; i++)
            {
                cmds[i] = cnn.CreateCommand();
                cmds[i].CommandType = CommandType.StoredProcedure;
                cmds[i].CommandText = procNames[i];
                cmds[i].Parameters.AddRange(ps[i]);
                cmds[i].Transaction = tran;
            }

            try
            {
                for (int i = 0; i < cmds.Length; i++)
                {
                    cmds[i].ExecuteNonQuery();
                }
                tran.Commit();
                return 0;
            }
            catch (Exception)
            {
                tran.Rollback();
                return -1;
            }
        }
    }

    这个版本的问题在于：在使用这个类的时候，每次都要实例化，麻烦。

    土鳖扛铁牛。