ASP.NET數(shù)據(jù)庫(kù)驅(qū)動(dòng)類怎么實(shí)現(xiàn)

這篇文章主要講解了“ASP.NET數(shù)據(jù)庫(kù)驅(qū)動(dòng)類怎么實(shí)現(xiàn)”，文中的講解內(nèi)容簡(jiǎn)單清晰，易于學(xué)習(xí)與理解，下面請(qǐng)大家跟著小編的思路慢慢深入，一起來(lái)研究和學(xué)習(xí)“ASP.NET數(shù)據(jù)庫(kù)驅(qū)動(dòng)類怎么實(shí)現(xiàn)”吧！

下面這段代碼實(shí)現(xiàn)一個(gè)ASP.NET數(shù)據(jù)庫(kù)驅(qū)動(dòng)類：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數(shù)據(jù)庫(kù)驅(qū)動(dòng)類：執(zhí)行帶參的命令式的存儲(chǔ)過(guò)程          /// < /summary>          /// < param name="procName">存儲(chǔ)過(guò)程名稱< /param>          /// < param name="paras">為存儲(chǔ)過(guò)程的參數(shù)解決賦參的SqlParameter對(duì)象數(shù)組          /// (每一個(gè)SqlParameter對(duì)象為一個(gè)參數(shù)解決賦參)< /param>          /// < returns>存儲(chǔ)過(guò)程的返回值< /returns>          public static int ExecuteProc1(string procName,              SqlParameter[] paras)          {              try             {                  sqlConn = new SqlConnection(connectionString);                  sqlConn.Open();                  SqlCommand sqlCmd = new SqlCommand(procName, sqlConn);                  //執(zhí)行存儲(chǔ)過(guò)程類型                  sqlCmd.CommandType = CommandType.StoredProcedure;                  sqlCmd.Parameters.AddRange(paras);                   SqlParameter p = new SqlParameter();                  //取存儲(chǔ)過(guò)程的返回值                  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數(shù)據(jù)庫(kù)驅(qū)動(dòng)類：執(zhí)行帶參的查詢式的存儲(chǔ)過(guò)程          /// < /summary>          /// < param name="procName">存儲(chǔ)過(guò)程名稱< /param>          /// < param name="paras">為存儲(chǔ)過(guò)程的參數(shù)解決賦參的SqlParameter對(duì)象數(shù)組          /// (每一個(gè)SqlParameter對(duì)象為一個(gè)參數(shù)解決賦參)< /param>          /// < returns>存儲(chǔ)過(guò)程執(zhí)行完畢后如果在數(shù)據(jù)庫(kù)服務(wù)器端形成一個(gè)          /// 查詢結(jié)果集，則返回指向該結(jié)果集的一個(gè)數(shù)據(jù)讀取器對(duì)象< /returns>          public static SqlDataReader ExecuteProc2(string procName,              SqlParameter[] paras)          {              try             {                  sqlConn = new SqlConnection(connectionString);                  sqlConn.Open();                  SqlCommand sqlCmd = new SqlCommand(procName, sqlConn);                  //執(zhí)行存儲(chǔ)過(guò)程類型                  sqlCmd.CommandType = CommandType.StoredProcedure;                  sqlCmd.Parameters.AddRange(paras);                                   SqlDataReader sqlDr =                       sqlCmd.ExecuteReader(CommandBehavior.CloseConnection);                                    return sqlDr;               }              catch (SqlException ex)              {                  throw ex;              }                     }      }  }

感謝各位的閱讀，以上就是“ASP.NET數(shù)據(jù)庫(kù)驅(qū)動(dòng)類怎么實(shí)現(xiàn)”的內(nèi)容了，經(jīng)過(guò)本文的學(xué)習(xí)后，相信大家對(duì)ASP.NET數(shù)據(jù)庫(kù)驅(qū)動(dòng)類怎么實(shí)現(xiàn)這一問(wèn)題有了更深刻的體會(huì)，具體使用情況還需要大家實(shí)踐驗(yàn)證。這里是億速云，小編將為大家推送更多相關(guān)知識(shí)點(diǎn)的文章，歡迎關(guān)注！