ASP.NET數據庫驅動類怎么實現

這篇文章主要講解了“ASP.NET數據庫驅動類怎么實現”，文中的講解內容簡單清晰，易于學習與理解，下面請大家跟著小編的思路慢慢深入，一起來研究和學習“ASP.NET數據庫驅動類怎么實現”吧！

下面這段代碼實現一個ASP.NET數據庫驅動類：DBHelper。

using System;  using System.Collections.Generic;  using System.Text;  using System.Data;  using System.Data.SqlClient;   namespace DBUtility  {      public static class SQLHelper      {          private static string connectionString =               @"server=.\SQLEXPRESS;uid=sa;pwd=;database=MyBookShop";          private static SqlConnection sqlConn;           /// < summary>          ///           /// < /summary>          /// < param name="sql">< /param>          /// < returns>< /returns>          public static SqlDataReader GetDataReader(string sql)          {              try             {                  sqlConn = new SqlConnection(connectionString);                  sqlConn.Open();                  SqlCommand sqlCmd = new SqlCommand(sql,sqlConn);                  SqlDataReader sqlDr =                       sqlCmd.ExecuteReader(CommandBehavior.CloseConnection);                  return sqlDr;               }              catch (SqlException ex)              {                  throw ex;              }                      }           public static object ExecScalar(string sql)          {              try             {                  sqlConn = new SqlConnection(connectionString);                  sqlConn.Open();                  SqlCommand sqlCmd = new SqlCommand(sql, sqlConn);                  object obj =                      sqlCmd.ExecuteScalar();                  return obj;               }              catch (SqlException ex)              {                  throw ex;              }              finally             {                  sqlConn.Close();              }           }           /// < summary>          /// ASP.NET數據庫驅動類：執行帶參的命令式的存儲過程          /// < /summary>          /// < param name="procName">存儲過程名稱< /param>          /// < param name="paras">為存儲過程的參數解決賦參的SqlParameter對象數組          /// (每一個SqlParameter對象為一個參數解決賦參)< /param>          /// < returns>存儲過程的返回值< /returns>          public static int ExecuteProc1(string procName,              SqlParameter[] paras)          {              try             {                  sqlConn = new SqlConnection(connectionString);                  sqlConn.Open();                  SqlCommand sqlCmd = new SqlCommand(procName, sqlConn);                  //執行存儲過程類型                  sqlCmd.CommandType = CommandType.StoredProcedure;                  sqlCmd.Parameters.AddRange(paras);                   SqlParameter p = new SqlParameter();                  //取存儲過程的返回值                  p.Direction = ParameterDirection.ReturnValue;                  p.SqlDbType = SqlDbType.Int;                   sqlCmd.Parameters.Add(p);                  sqlCmd.ExecuteNonQuery();                   int v = p.Value==null?-1:Convert.ToInt32(p.Value);                  return v;                            }              catch (SqlException ex)              {                  throw ex;              }              finally             {                  sqlConn.Close();              }          }           /// < summary>          /// ASP.NET數據庫驅動類：執行帶參的查詢式的存儲過程          /// < /summary>          /// < param name="procName">存儲過程名稱< /param>          /// < param name="paras">為存儲過程的參數解決賦參的SqlParameter對象數組          /// (每一個SqlParameter對象為一個參數解決賦參)< /param>          /// < returns>存儲過程執行完畢后如果在數據庫服務器端形成一個          /// 查詢結果集，則返回指向該結果集的一個數據讀取器對象< /returns>          public static SqlDataReader ExecuteProc2(string procName,              SqlParameter[] paras)          {              try             {                  sqlConn = new SqlConnection(connectionString);                  sqlConn.Open();                  SqlCommand sqlCmd = new SqlCommand(procName, sqlConn);                  //執行存儲過程類型                  sqlCmd.CommandType = CommandType.StoredProcedure;                  sqlCmd.Parameters.AddRange(paras);                                   SqlDataReader sqlDr =                       sqlCmd.ExecuteReader(CommandBehavior.CloseConnection);                                    return sqlDr;               }              catch (SqlException ex)              {                  throw ex;              }                     }      }  }

感謝各位的閱讀，以上就是“ASP.NET數據庫驅動類怎么實現”的內容了，經過本文的學習后，相信大家對ASP.NET數據庫驅動類怎么實現這一問題有了更深刻的體會，具體使用情況還需要大家實踐驗證。這里是億速云，小編將為大家推送更多相關知識點的文章，歡迎關注！