当前位置：Gxlcms > 数据库问题 > C#：SqlHelper

C#：SqlHelper

时间：2021-07-01 10:21:17 帮助过：13人阅读

一、底层

注：引用命名空间

using System.Data;
using System.Data.SqlClient;

  1. <span style="color: #008080">  1</span>     <span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> SqlHelper
  2. </span><span style="color: #008080">  2</span> <span style="color: #000000">    {
  3. </span><span style="color: #008080">  3</span>         <span style="color: #808080">///</span> <span style="color: #808080"><summary></span>
  4. <span style="color: #008080">  4</span>         <span style="color: #808080">///</span><span style="color: #008000"> 数据库连接字符串
  5. </span><span style="color: #008080">  5</span>         <span style="color: #808080">///</span><span style="color: #008000"> Data Source=数据库地址;Initial Catalog=数据库名称;Persist Security Info=True;User ID=用户名;Password=密码
  6. </span><span style="color: #008080">  6</span>         <span style="color: #808080">///</span> <span style="color: #808080"></summary></span>
  7. <span style="color: #008080">  7</span>         <span style="color: #0000ff">private</span> <span style="color: #0000ff">string</span> _SqlConnectionStr = <span style="color: #800000">""</span><span style="color: #000000">;
  8. </span><span style="color: #008080">  8</span>         <span style="color: #0000ff">public</span> <span style="color: #0000ff">string</span> SqlConnectionStr { <span style="color: #0000ff">get</span> { <span style="color: #0000ff">return</span><span style="color: #000000"> _SqlConnectionStr; } }
  9. </span><span style="color: #008080">  9</span>         <span style="color: #0000ff">public</span> SqlHelper(<span style="color: #0000ff">string</span><span style="color: #000000"> connStr)
  10. </span><span style="color: #008080"> 10</span> <span style="color: #000000">        {
  11. </span><span style="color: #008080"> 11</span>             <span style="color: #0000ff">this</span>._SqlConnectionStr =<span style="color: #000000"> connStr;
  12. </span><span style="color: #008080"> 12</span> <span style="color: #000000">        }
  13. </span><span style="color: #008080"> 13</span>         <span style="color: #0000ff">#region</span> 单值查询      
  14. <span style="color: #008080"> 14</span>         <span style="color: #0000ff">public</span> <span style="color: #0000ff">string</span> GetSingle(<span style="color: #0000ff">string</span><span style="color: #000000"> sqlStr)
  15. </span><span style="color: #008080"> 15</span> <span style="color: #000000">        {
  16. </span><span style="color: #008080"> 16</span>             <span style="color: #0000ff">using</span> (SqlConnection conn = <span style="color: #0000ff">new</span> SqlConnection(<span style="color: #0000ff">this</span><span style="color: #000000">._SqlConnectionStr))
  17. </span><span style="color: #008080"> 17</span> <span style="color: #000000">            {
  18. </span><span style="color: #008080"> 18</span>                 <span style="color: #0000ff">using</span> (SqlCommand cmd = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlCommand(sqlStr, conn))
  19. </span><span style="color: #008080"> 19</span> <span style="color: #000000">                {
  20. </span><span style="color: #008080"> 20</span>                     <span style="color: #0000ff">try</span>
  21. <span style="color: #008080"> 21</span> <span style="color: #000000">                    {
  22. </span><span style="color: #008080"> 22</span> <span style="color: #000000">                        conn.Open();
  23. </span><span style="color: #008080"> 23</span>                         <span style="color: #0000ff">return</span> String.Format(<span style="color: #800000">"</span><span style="color: #800000">{0}</span><span style="color: #800000">"</span><span style="color: #000000">, cmd.ExecuteScalar());
  24. </span><span style="color: #008080"> 24</span> <span style="color: #000000">                    }
  25. </span><span style="color: #008080"> 25</span>                     <span style="color: #0000ff">catch</span><span style="color: #000000">(SqlException e)
  26. </span><span style="color: #008080"> 26</span> <span style="color: #000000">                    {
  27. </span><span style="color: #008080"> 27</span>                         <span style="color: #0000ff">throw</span><span style="color: #000000"> e;
  28. </span><span style="color: #008080"> 28</span> <span style="color: #000000">                    }
  29. </span><span style="color: #008080"> 29</span>                     <span style="color: #0000ff">finally</span>
  30. <span style="color: #008080"> 30</span> <span style="color: #000000">                    {
  31. </span><span style="color: #008080"> 31</span> <span style="color: #000000">                        conn.Close();
  32. </span><span style="color: #008080"> 32</span> <span style="color: #000000">                    }
  33. </span><span style="color: #008080"> 33</span> <span style="color: #000000">                }
  34. </span><span style="color: #008080"> 34</span> <span style="color: #000000">            }
  35. </span><span style="color: #008080"> 35</span> <span style="color: #000000">        }
  36. </span><span style="color: #008080"> 36</span>         <span style="color: #0000ff">public</span> <span style="color: #0000ff">string</span> GetSingle(<span style="color: #0000ff">string</span><span style="color: #000000"> sqlStr,SqlParameter[] cmdParams)
  37. </span><span style="color: #008080"> 37</span> <span style="color: #000000">        {
  38. </span><span style="color: #008080"> 38</span>             <span style="color: #0000ff">using</span> (SqlConnection conn = <span style="color: #0000ff">new</span> SqlConnection(<span style="color: #0000ff">this</span><span style="color: #000000">._SqlConnectionStr))
  39. </span><span style="color: #008080"> 39</span> <span style="color: #000000">            {
  40. </span><span style="color: #008080"> 40</span>                 <span style="color: #0000ff">using</span> (SqlCommand cmd = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlCommand())
  41. </span><span style="color: #008080"> 41</span> <span style="color: #000000">                {
  42. </span><span style="color: #008080"> 42</span>                     <span style="color: #0000ff">try</span>
  43. <span style="color: #008080"> 43</span> <span style="color: #000000">                    {
  44. </span><span style="color: #008080"> 44</span> <span style="color: #000000">                        conn.Open();
  45. </span><span style="color: #008080"> 45</span>                         cmd.Connection =<span style="color: #000000"> conn;
  46. </span><span style="color: #008080"> 46</span>                         cmd.CommandType =<span style="color: #000000"> CommandType.Text;
  47. </span><span style="color: #008080"> 47</span>                         cmd.CommandText =<span style="color: #000000"> sqlStr;
  48. </span><span style="color: #008080"> 48</span> <span style="color: #000000">                        cmd.Parameters.AddRange(cmdParams);
  49. </span><span style="color: #008080"> 49</span>                         <span style="color: #0000ff">return</span> String.Format(<span style="color: #800000">"</span><span style="color: #800000">{0}</span><span style="color: #800000">"</span><span style="color: #000000">, cmd.ExecuteScalar());
  50. </span><span style="color: #008080"> 50</span> <span style="color: #000000">                    }
  51. </span><span style="color: #008080"> 51</span>                     <span style="color: #0000ff">catch</span><span style="color: #000000">(SqlException e)
  52. </span><span style="color: #008080"> 52</span> <span style="color: #000000">                    {
  53. </span><span style="color: #008080"> 53</span>                         <span style="color: #0000ff">throw</span><span style="color: #000000"> e;
  54. </span><span style="color: #008080"> 54</span> <span style="color: #000000">                    }
  55. </span><span style="color: #008080"> 55</span>                     <span style="color: #0000ff">finally</span>
  56. <span style="color: #008080"> 56</span> <span style="color: #000000">                    {
  57. </span><span style="color: #008080"> 57</span> <span style="color: #000000">                        conn.Close();
  58. </span><span style="color: #008080"> 58</span> <span style="color: #000000">                    }
  59. </span><span style="color: #008080"> 59</span> <span style="color: #000000">                }
  60. </span><span style="color: #008080"> 60</span> <span style="color: #000000">            }
  61. </span><span style="color: #008080"> 61</span> <span style="color: #000000">        }
  62. </span><span style="color: #008080"> 62</span>         <span style="color: #0000ff">#endregion</span>
  63. <span style="color: #008080"> 63</span> 
  64. <span style="color: #008080"> 64</span>         <span style="color: #0000ff">#region</span> 查询数据集        
  65. <span style="color: #008080"> 65</span>         <span style="color: #0000ff">public</span> DataSet Query(<span style="color: #0000ff">string</span><span style="color: #000000"> sqlStr)
  66. </span><span style="color: #008080"> 66</span> <span style="color: #000000">        {
  67. </span><span style="color: #008080"> 67</span>             <span style="color: #0000ff">using</span> (SqlConnection conn = <span style="color: #0000ff">new</span> SqlConnection(<span style="color: #0000ff">this</span><span style="color: #000000">._SqlConnectionStr))
  68. </span><span style="color: #008080"> 68</span> <span style="color: #000000">            {
  69. </span><span style="color: #008080"> 69</span>                 <span style="color: #0000ff">using</span> (SqlDataAdapter ada = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlDataAdapter(sqlStr, conn))
  70. </span><span style="color: #008080"> 70</span> <span style="color: #000000">                {
  71. </span><span style="color: #008080"> 71</span>                     <span style="color: #0000ff">try</span>
  72. <span style="color: #008080"> 72</span> <span style="color: #000000">                    {
  73. </span><span style="color: #008080"> 73</span> <span style="color: #000000">                        conn.Open();
  74. </span><span style="color: #008080"> 74</span>                         DataSet ds = <span style="color: #0000ff">new</span><span style="color: #000000"> DataSet();
  75. </span><span style="color: #008080"> 75</span> <span style="color: #000000">                        ada.Fill(ds);
  76. </span><span style="color: #008080"> 76</span>                         <span style="color: #0000ff">return</span><span style="color: #000000"> ds;
  77. </span><span style="color: #008080"> 77</span> <span style="color: #000000">                    }
  78. </span><span style="color: #008080"> 78</span>                     <span style="color: #0000ff">catch</span><span style="color: #000000">(SqlException e)
  79. </span><span style="color: #008080"> 79</span> <span style="color: #000000">                    {
  80. </span><span style="color: #008080"> 80</span>                         <span style="color: #0000ff">throw</span><span style="color: #000000"> e;
  81. </span><span style="color: #008080"> 81</span> <span style="color: #000000">                    }
  82. </span><span style="color: #008080"> 82</span>                     <span style="color: #0000ff">finally</span>
  83. <span style="color: #008080"> 83</span> <span style="color: #000000">                    {
  84. </span><span style="color: #008080"> 84</span> <span style="color: #000000">                        conn.Close();
  85. </span><span style="color: #008080"> 85</span> <span style="color: #000000">                    }
  86. </span><span style="color: #008080"> 86</span> <span style="color: #000000">                }
  87. </span><span style="color: #008080"> 87</span> <span style="color: #000000">            }
  88. </span><span style="color: #008080"> 88</span> <span style="color: #000000">        }
  89. </span><span style="color: #008080"> 89</span>         <span style="color: #0000ff">public</span> DataSet Query(<span style="color: #0000ff">string</span><span style="color: #000000"> sqlStr,SqlParameter[] cmdParams)
  90. </span><span style="color: #008080"> 90</span> <span style="color: #000000">        {
  91. </span><span style="color: #008080"> 91</span>             <span style="color: #0000ff">using</span> (SqlConnection conn = <span style="color: #0000ff">new</span> SqlConnection(<span style="color: #0000ff">this</span><span style="color: #000000">._SqlConnectionStr))
  92. </span><span style="color: #008080"> 92</span> <span style="color: #000000">            {
  93. </span><span style="color: #008080"> 93</span>                 <span style="color: #0000ff">using</span> (SqlCommand cmd = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlCommand())
  94. </span><span style="color: #008080"> 94</span> <span style="color: #000000">                {
  95. </span><span style="color: #008080"> 95</span>                     <span style="color: #0000ff">using</span> (SqlDataAdapter ada = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlDataAdapter(cmd))
  96. </span><span style="color: #008080"> 96</span> <span style="color: #000000">                    {
  97. </span><span style="color: #008080"> 97</span>                         <span style="color: #0000ff">try</span>
  98. <span style="color: #008080"> 98</span> <span style="color: #000000">                        {
  99. </span><span style="color: #008080"> 99</span> <span style="color: #000000">                            conn.Open();
  100. </span><span style="color: #008080">100</span>                             cmd.Connection =<span style="color: #000000"> conn;
  101. </span><span style="color: #008080">101</span>                             cmd.CommandType =<span style="color: #000000"> CommandType.Text;
  102. </span><span style="color: #008080">102</span>                             cmd.CommandText =<span style="color: #000000"> sqlStr;
  103. </span><span style="color: #008080">103</span> <span style="color: #000000">                            cmd.Parameters.AddRange(cmdParams);
  104. </span><span style="color: #008080">104</span> 
  105. <span style="color: #008080">105</span>                             DataSet ds = <span style="color: #0000ff">new</span><span style="color: #000000"> DataSet();
  106. </span><span style="color: #008080">106</span> <span style="color: #000000">                            ada.Fill(ds);
  107. </span><span style="color: #008080">107</span>                             <span style="color: #0000ff">return</span><span style="color: #000000"> ds;                            
  108. </span><span style="color: #008080">108</span> <span style="color: #000000">                        }
  109. </span><span style="color: #008080">109</span>                         <span style="color: #0000ff">catch</span><span style="color: #000000">(SqlException e)
  110. </span><span style="color: #008080">110</span> <span style="color: #000000">                        {
  111. </span><span style="color: #008080">111</span>                             <span style="color: #0000ff">throw</span><span style="color: #000000"> e;
  112. </span><span style="color: #008080">112</span> <span style="color: #000000">                        }
  113. </span><span style="color: #008080">113</span>                         <span style="color: #0000ff">finally</span>
  114. <span style="color: #008080">114</span> <span style="color: #000000">                        {
  115. </span><span style="color: #008080">115</span> <span style="color: #000000">                            conn.Close();
  116. </span><span style="color: #008080">116</span> <span style="color: #000000">                        }
  117. </span><span style="color: #008080">117</span> <span style="color: #000000">                    }
  118. </span><span style="color: #008080">118</span> <span style="color: #000000">                }
  119. </span><span style="color: #008080">119</span> <span style="color: #000000">            }
  120. </span><span style="color: #008080">120</span> <span style="color: #000000">        }
  121. </span><span style="color: #008080">121</span>         <span style="color: #0000ff">public</span> DataSet RunProcedure(<span style="color: #0000ff">string</span><span style="color: #000000"> procName,SqlParameter[] cmdParams)
  122. </span><span style="color: #008080">122</span> <span style="color: #000000">        {
  123. </span><span style="color: #008080">123</span>             <span style="color: #0000ff">using</span> (SqlConnection conn = <span style="color: #0000ff">new</span> SqlConnection(<span style="color: #0000ff">this</span><span style="color: #000000">._SqlConnectionStr))
  124. </span><span style="color: #008080">124</span> <span style="color: #000000">            {
  125. </span><span style="color: #008080">125</span>                 <span style="color: #0000ff">using</span> (SqlCommand cmd = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlCommand())
  126. </span><span style="color: #008080">126</span> <span style="color: #000000">                {
  127. </span><span style="color: #008080">127</span>                     <span style="color: #0000ff">using</span> (SqlDataAdapter ada = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlDataAdapter(cmd))
  128. </span><span style="color: #008080">128</span> <span style="color: #000000">                    {
  129. </span><span style="color: #008080">129</span>                         <span style="color: #0000ff">try</span>
  130. <span style="color: #008080">130</span> <span style="color: #000000">                        {
  131. </span><span style="color: #008080">131</span> <span style="color: #000000">                            conn.Open();
  132. </span><span style="color: #008080">132</span>                             cmd.Connection =<span style="color: #000000"> conn;
  133. </span><span style="color: #008080">133</span>                             cmd.CommandType =<span style="color: #000000"> CommandType.StoredProcedure;
  134. </span><span style="color: #008080">134</span>                             cmd.CommandText =<span style="color: #000000"> procName;
  135. </span><span style="color: #008080">135</span> <span style="color: #000000">                            cmd.Parameters.AddRange(cmdParams);
  136. </span><span style="color: #008080">136</span> 
  137. <span style="color: #008080">137</span>                             DataSet ds = <span style="color: #0000ff">new</span><span style="color: #000000"> DataSet();
  138. </span><span style="color: #008080">138</span> <span style="color: #000000">                            ada.Fill(ds);
  139. </span><span style="color: #008080">139</span>                             <span style="color: #0000ff">return</span><span style="color: #000000"> ds;
  140. </span><span style="color: #008080">140</span> <span style="color: #000000">                        }
  141. </span><span style="color: #008080">141</span>                         <span style="color: #0000ff">catch</span><span style="color: #000000">(SqlException e)
  142. </span><span style="color: #008080">142</span> <span style="color: #000000">                        {
  143. </span><span style="color: #008080">143</span>                             <span style="color: #0000ff">throw</span><span style="color: #000000"> e;
  144. </span><span style="color: #008080">144</span> <span style="color: #000000">                        }
  145. </span><span style="color: #008080">145</span>                         <span style="color: #0000ff">finally</span>
  146. <span style="color: #008080">146</span> <span style="color: #000000">                        {
  147. </span><span style="color: #008080">147</span> <span style="color: #000000">                            conn.Close();
  148. </span><span style="color: #008080">148</span> <span style="color: #000000">                        }
  149. </span><span style="color: #008080">149</span> <span style="color: #000000">                    }
  150. </span><span style="color: #008080">150</span> <span style="color: #000000">                }
  151. </span><span style="color: #008080">151</span> <span style="color: #000000">            }
  152. </span><span style="color: #008080">152</span> <span style="color: #000000">        }
  153. </span><span style="color: #008080">153</span>         <span style="color: #0000ff">#endregion</span>
  154. <span style="color: #008080">154</span> 
  155. <span style="color: #008080">155</span>         <span style="color: #0000ff">#region</span> 单表查询        
  156. <span style="color: #008080">156</span>         <span style="color: #0000ff">public</span> DataTable GetQueryData(<span style="color: #0000ff">string</span><span style="color: #000000"> sqlStr)
  157. </span><span style="color: #008080">157</span> <span style="color: #000000">        {
  158. </span><span style="color: #008080">158</span>             DataSet ds =<span style="color: #000000"> Query(sqlStr);
  159. </span><span style="color: #008080">159</span>             <span style="color: #0000ff">if</span> (ds != <span style="color: #0000ff">null</span> && ds.Tables.Count > <span style="color: #800080">0</span><span style="color: #000000">)
  160. </span><span style="color: #008080">160</span>                 <span style="color: #0000ff">return</span> ds.Tables[<span style="color: #800080">0</span><span style="color: #000000">];
  161. </span><span style="color: #008080">161</span>             <span style="color: #0000ff">return</span> <span style="color: #0000ff">null</span><span style="color: #000000">; 
  162. </span><span style="color: #008080">162</span> <span style="color: #000000">        }
  163. </span><span style="color: #008080">163</span>         <span style="color: #0000ff">public</span> DataTable GetQueryData(<span style="color: #0000ff">string</span><span style="color: #000000"> sqlStr ,SqlParameter[] cmdParams)
  164. </span><span style="color: #008080">164</span> <span style="color: #000000">        {
  165. </span><span style="color: #008080">165</span>             DataSet ds =<span style="color: #000000"> Query(sqlStr, cmdParams);
  166. </span><span style="color: #008080">166</span>             <span style="color: #0000ff">if</span> (ds != <span style="color: #0000ff">null</span> && ds.Tables.Count > <span style="color: #800080">0</span><span style="color: #000000">)
  167. </span><span style="color: #008080">167</span>                 <span style="color: #0000ff">return</span> ds.Tables[<span style="color: #800080">0</span><span style="color: #000000">];
  168. </span><span style="color: #008080">168</span>             <span style="color: #0000ff">return</span> <span style="color: #0000ff">null</span><span style="color: #000000">;
  169. </span><span style="color: #008080">169</span> <span style="color: #000000">        }
  170. </span><span style="color: #008080">170</span>         <span style="color: #0000ff">public</span> DataTable GetProcData(<span style="color: #0000ff">string</span><span style="color: #000000"> procName,SqlParameter[] cmdParams)
  171. </span><span style="color: #008080">171</span> <span style="color: #000000">        {
  172. </span><span style="color: #008080">172</span>             DataSet ds =<span style="color: #000000"> RunProcedure(procName, cmdParams);
  173. </span><span style="color: #008080">173</span>             <span style="color: #0000ff">if</span> (ds != <span style="color: #0000ff">null</span> && ds.Tables.Count > <span style="color: #800080">0</span><span style="color: #000000">)
  174. </span><span style="color: #008080">174</span>                 <span style="color: #0000ff">return</span> ds.Tables[<span style="color: #800080">0</span><span style="color: #000000">];
  175. </span><span style="color: #008080">175</span>             <span style="color: #0000ff">return</span> <span style="color: #0000ff">null</span><span style="color: #000000">;
  176. </span><span style="color: #008080">176</span> <span style="color: #000000">        }
  177. </span><span style="color: #008080">177</span>         <span style="color: #0000ff">#endregion</span>
  178. <span style="color: #008080">178</span> 
  179. <span style="color: #008080">179</span>         <span style="color: #0000ff">#region</span> 单行查询       
  180. <span style="color: #008080">180</span>         <span style="color: #0000ff">public</span> DataRow GetQueryRecord(<span style="color: #0000ff">string</span><span style="color: #000000"> sqlStr)
  181. </span><span style="color: #008080">181</span> <span style="color: #000000">        {
  182. </span><span style="color: #008080">182</span>             DataTable dt =<span style="color: #000000"> GetQueryData(sqlStr);
  183. </span><span style="color: #008080">183</span>             <span style="color: #0000ff">if</span> (dt != <span style="color: #0000ff">null</span> && dt.Rows.Count > <span style="color: #800080">0</span><span style="color: #000000">)
  184. </span><span style="color: #008080">184</span>                 <span style="color: #0000ff">return</span> dt.Rows[<span style="color: #800080">0</span><span style="color: #000000">];
  185. </span><span style="color: #008080">185</span>             <span style="color: #0000ff">return</span> <span style="color: #0000ff">null</span><span style="color: #000000">;
  186. </span><span style="color: #008080">186</span> <span style="color: #000000">        }
  187. </span><span style="color: #008080">187</span>         <span style="color: #0000ff">public</span> DataRow GetQueryRecord(<span style="color: #0000ff">string</span><span style="color: #000000"> sqlStr,SqlParameter[] cmdParams)
  188. </span><span style="color: #008080">188</span> <span style="color: #000000">        {
  189. </span><span style="color: #008080">189</span>             DataTable dt =<span style="color: #000000"> GetQueryData(sqlStr, cmdParams);
  190. </span><span style="color: #008080">190</span>             <span style="color: #0000ff">if</span> (dt != <span style="color: #0000ff">null</span> && dt.Rows.Count > <span style="color: #800080">0</span><span style="color: #000000">)
  191. </span><span style="color: #008080">191</span>                 <span style="color: #0000ff">return</span> dt.Rows[<span style="color: #800080">0</span><span style="color: #000000">];
  192. </span><span style="color: #008080">192</span>             <span style="color: #0000ff">return</span> <span style="color: #0000ff">null</span><span style="color: #000000">;
  193. </span><span style="color: #008080">193</span> <span style="color: #000000">        }
  194. </span><span style="color: #008080">194</span>         <span style="color: #0000ff">public</span> DataRow GetProcRecord(<span style="color: #0000ff">string</span><span style="color: #000000"> procName,SqlParameter[] cmdParams)
  195. </span><span style="color: #008080">195</span> <span style="color: #000000">        {
  196. </span><span style="color: #008080">196</span>             DataTable dt =<span style="color: #000000"> GetProcData(procName, cmdParams);
  197. </span><span style="color: #008080">197</span>             <span style="color: #0000ff">if</span> (dt != <span style="color: #0000ff">null</span> && dt.Rows.Count > <span style="color: #800080">0</span><span style="color: #000000">)
  198. </span><span style="color: #008080">198</span>                 <span style="color: #0000ff">return</span> dt.Rows[<span style="color: #800080">0</span><span style="color: #000000">];
  199. </span><span style="color: #008080">199</span>             <span style="color: #0000ff">return</span> <span style="color: #0000ff">null</span><span style="color: #000000">;
  200. </span><span style="color: #008080">200</span> <span style="color: #000000">        }
  201. </span><span style="color: #008080">201</span>         <span style="color: #0000ff">#endregion</span>
  202. <span style="color: #008080">202</span> 
  203. <span style="color: #008080">203</span>         <span style="color: #0000ff">#region</span> 使用完应关闭Reader
  204. <span style="color: #008080">204</span>         <span style="color: #0000ff">public</span> SqlDataReader ExecuteReader(<span style="color: #0000ff">string</span><span style="color: #000000"> sqlStr)
  205. </span><span style="color: #008080">205</span> <span style="color: #000000">        {
  206. </span><span style="color: #008080">206</span>             SqlConnection conn = <span style="color: #0000ff">new</span> SqlConnection(<span style="color: #0000ff">this</span><span style="color: #000000">._SqlConnectionStr);
  207. </span><span style="color: #008080">207</span>             SqlCommand cmd = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlCommand(sqlStr, conn);
  208. </span><span style="color: #008080">208</span>             <span style="color: #0000ff">try</span>
  209. <span style="color: #008080">209</span> <span style="color: #000000">            {
  210. </span><span style="color: #008080">210</span> <span style="color: #000000">                conn.Open();
  211. </span><span style="color: #008080">211</span>                 <span style="color: #0000ff">return</span><span style="color: #000000"> cmd.ExecuteReader(CommandBehavior.CloseConnection);
  212. </span><span style="color: #008080">212</span> <span style="color: #000000">            }
  213. </span><span style="color: #008080">213</span>             <span style="color: #0000ff">catch</span><span style="color: #000000">(SqlException e)
  214. </span><span style="color: #008080">214</span> <span style="color: #000000">            {
  215. </span><span style="color: #008080">215</span>                 <span style="color: #0000ff">throw</span><span style="color: #000000"> e;
  216. </span><span style="color: #008080">216</span> <span style="color: #000000">            }
  217. </span><span style="color: #008080">217</span> <span style="color: #000000">        }
  218. </span><span style="color: #008080">218</span>         <span style="color: #0000ff">public</span> SqlDataReader ExecuteReeder(<span style="color: #0000ff">string</span><span style="color: #000000"> sqlStr,SqlParameter[] cmdParams)
  219. </span><span style="color: #008080">219</span> <span style="color: #000000">        {
  220. </span><span style="color: #008080">220</span>             SqlConnection conn = <span style="color: #0000ff">new</span> SqlConnection(<span style="color: #0000ff">this</span><span style="color: #000000">._SqlConnectionStr);
  221. </span><span style="color: #008080">221</span>             SqlCommand cmd = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlCommand();
  222. </span><span style="color: #008080">222</span>             <span style="color: #0000ff">try</span>
  223. <span style="color: #008080">223</span> <span style="color: #000000">            {
  224. </span><span style="color: #008080">224</span> <span style="color: #000000">                conn.Open();
  225. </span><span style="color: #008080">225</span>                 cmd.Connection =<span style="color: #000000"> conn;
  226. </span><span style="color: #008080">226</span>                 cmd.CommandType =<span style="color: #000000"> CommandType.Text;
  227. </span><span style="color: #008080">227</span>                 cmd.CommandText =<span style="color: #000000"> sqlStr;
  228. </span><span style="color: #008080">228</span> <span style="color: #000000">                cmd.Parameters.AddRange(cmdParams);
  229. </span><span style="color: #008080">229</span>                 <span style="color: #0000ff">return</span><span style="color: #000000"> cmd.ExecuteReader(CommandBehavior.CloseConnection);
  230. </span><span style="color: #008080">230</span> <span style="color: #000000">            }
  231. </span><span style="color: #008080">231</span>             <span style="color: #0000ff">catch</span><span style="color: #000000">(SqlException e)
  232. </span><span style="color: #008080">232</span> <span style="color: #000000">            {
  233. </span><span style="color: #008080">233</span>                 <span style="color: #0000ff">throw</span><span style="color: #000000"> e;
  234. </span><span style="color: #008080">234</span> <span style="color: #000000">            }
  235. </span><span style="color: #008080">235</span> <span style="color: #000000">        }
  236. </span><span style="color: #008080">236</span>         <span style="color: #0000ff">#endregion</span>
  237. <span style="color: #008080">237</span> 
  238. <span style="color: #008080">238</span>         <span style="color: #0000ff">#region</span> 执行sql语句        
  239. <span style="color: #008080">239</span>         <span style="color: #0000ff">public</span> <span style="color: #0000ff">int</span> ExecuteSql(<span style="color: #0000ff">string</span><span style="color: #000000"> sqlStr)
  240. </span><span style="color: #008080">240</span> <span style="color: #000000">        {
  241. </span><span style="color: #008080">241</span>             <span style="color: #0000ff">using</span> (SqlConnection conn = <span style="color: #0000ff">new</span> SqlConnection(<span style="color: #0000ff">this</span><span style="color: #000000">._SqlConnectionStr))
  242. </span><span style="color: #008080">242</span> <span style="color: #000000">            {
  243. </span><span style="color: #008080">243</span>                 <span style="color: #0000ff">using</span> (SqlCommand cmd = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlCommand(sqlStr, conn))
  244. </span><span style="color: #008080">244</span> <span style="color: #000000">                {
  245. </span><span style="color: #008080">245</span>                     <span style="color: #0000ff">try</span>
  246. <span style="color: #008080">246</span> <span style="color: #000000">                    {
  247. </span><span style="color: #008080">247</span> <span style="color: #000000">                        conn.Open();
  248. </span><span style="color: #008080">248</span>                         <span style="color: #0000ff">return</span><span style="color: #000000"> cmd.ExecuteNonQuery();
  249. </span><span style="color: #008080">249</span> <span style="color: #000000">                    }
  250. </span><span style="color: #008080">250</span>                     <span style="color: #0000ff">catch</span><span style="color: #000000">(SqlException e)
  251. </span><span style="color: #008080">251</span> <span style="color: #000000">                    {
  252. </span><span style="color: #008080">252</span>                         <span style="color: #0000ff">throw</span><span style="color: #000000"> e;
  253. </span><span style="color: #008080">253</span> <span style="color: #000000">                    }
  254. </span><span style="color: #008080">254</span>                     <span style="color: #0000ff">finally</span>
  255. <span style="color: #008080">255</span> <span style="color: #000000">                    {
  256. </span><span style="color: #008080">256</span> <span style="color: #000000">                        conn.Close();
  257. </span><span style="color: #008080">257</span> <span style="color: #000000">                    }
  258. </span><span style="color: #008080">258</span> <span style="color: #000000">                }
  259. </span><span style="color: #008080">259</span> <span style="color: #000000">            }
  260. </span><span style="color: #008080">260</span> <span style="color: #000000">        }
  261. </span><span style="color: #008080">261</span>         <span style="color: #0000ff">public</span> <span style="color: #0000ff">int</span> ExecuteSql(<span style="color: #0000ff">string</span><span style="color: #000000"> sqlStr,SqlParameter[] cmdParams)
  262. </span><span style="color: #008080">262</span> <span style="color: #000000">        {
  263. </span><span style="color: #008080">263</span>             <span style="color: #0000ff">using</span> (SqlConnection conn = <span style="color: #0000ff">new</span> SqlConnection(<span style="color: #0000ff">this</span><span style="color: #000000">._SqlConnectionStr))
  264. </span><span style="color: #008080">264</span> <span style="color: #000000">            {
  265. </span><span style="color: #008080">265</span>                 <span style="color: #0000ff">using</span> (SqlCommand cmd = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlCommand())
  266. </span><span style="color: #008080">266</span> <span style="color: #000000">                {
  267. </span><span style="color: #008080">267</span>                     <span style="color: #0000ff">try</span>
  268. <span style="color: #008080">268</span> <span style="color: #000000">                    {
  269. </span><span style="color: #008080">269</span> <span style="color: #000000">                        conn.Open();
  270. </span><span style="color: #008080">270</span>                         cmd.Connection =<span style="color: #000000"> conn;
  271. </span><span style="color: #008080">271</span>                         cmd.CommandType =<span style="color: #000000"> CommandType.Text;
  272. </span><span style="color: #008080">272</span>                         cmd.CommandText =<span style="color: #000000"> sqlStr;
  273. </span><span style="color: #008080">273</span> <span style="color: #000000">                        cmd.Parameters.AddRange(cmdParams);
  274. </span><span style="color: #008080">274</span>                         <span style="color: #0000ff">return</span><span style="color: #000000"> cmd.ExecuteNonQuery();
  275. </span><span style="color: #008080">275</span> <span style="color: #000000">                    }
  276. </span><span style="color: #008080">276</span>                     <span style="color: #0000ff">catch</span><span style="color: #000000">(SqlException e)
  277. </span><span style="color: #008080">277</span> <span style="color: #000000">                    {
  278. </span><span style="color: #008080">278</span>                         <span style="color: #0000ff">throw</span><span style="color: #000000"> e;
  279. </span><span style="color: #008080">279</span> <span style="color: #000000">                    }
  280. </span><span style="color: #008080">280</span>                     <span style="color: #0000ff">finally</span>
  281. <span style="color: #008080">281</span> <span style="color: #000000">                    {
  282. </span><span style="color: #008080">282</span> <span style="color: #000000">                        conn.Close();
  283. </span><span style="color: #008080">283</span> <span style="color: #000000">                    }
  284. </span><span style="color: #008080">284</span> <span style="color: #000000">                }
  285. </span><span style="color: #008080">285</span> <span style="color: #000000">            }
  286. </span><span style="color: #008080">286</span> <span style="color: #000000">        }
  287. </span><span style="color: #008080">287</span>         <span style="color: #0000ff">#endregion</span>
  288. <span style="color: #008080">288</span> 
  289. <span style="color: #008080">289</span>         <span style="color: #0000ff">#region</span> 执行事务        
  290. <span style="color: #008080">290</span>         <span style="color: #0000ff">public</span> <span style="color: #0000ff">int</span> ExecuteSqlTran(List<<span style="color: #0000ff">string</span>><span style="color: #000000"> sqlStrList)
  291. </span><span style="color: #008080">291</span> <span style="color: #000000">        {
  292. </span><span style="color: #008080">292</span>             <span style="color: #0000ff">using</span> (SqlConnection conn = <span style="color: #0000ff">new</span> SqlConnection(<span style="color: #0000ff">this</span><span style="color: #000000">._SqlConnectionStr))
  293. </span><span style="color: #008080">293</span> <span style="color: #000000">            {
  294. </span><span style="color: #008080">294</span>                 <span style="color: #0000ff">using</span> (SqlCommand cmd = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlCommand())
  295. </span><span style="color: #008080">295</span> <span style="color: #000000">                {
  296. </span><span style="color: #008080">296</span>                     <span style="color: #0000ff">using</span> (SqlTransaction tran =<span style="color: #000000"> conn.BeginTransaction())
  297. </span><span style="color: #008080">297</span> <span style="color: #000000">                    {
  298. </span><span style="color: #008080">298</span>                         <span style="color: #0000ff">try</span>
  299. <span style="color: #008080">299</span> <span style="color: #000000">                        {
  300. </span><span style="color: #008080">300</span>                             cmd.Connection =<span style="color: #000000"> conn;
  301. </span><span style="color: #008080">301</span>                             cmd.CommandType =<span style="color: #000000"> CommandType.Text;                        
  302. </span><span style="color: #008080">302</span>                             cmd.Transaction =<span style="color: #000000"> tran;
  303. </span><span style="color: #008080">303</span> <span style="color: #000000">                            conn.Open();
  304. </span><span style="color: #008080">304</span>                             <span style="color: #0000ff">int</span> count = <span style="color: #800080">0</span><span style="color: #000000">;
  305. </span><span style="color: #008080">305</span>                             <span style="color: #0000ff">foreach</span>(<span style="color: #0000ff">string</span> sql <span style="color: #0000ff">in</span><span style="color: #000000"> sqlStrList)
  306. </span><span style="color: #008080">306</span> <span style="color: #000000">                            {
  307. </span><span style="color: #008080">307</span>                                 cmd.CommandText =<span style="color: #000000"> sql;
  308. </span><span style="color: #008080">308</span>                                 count +=<span style="color: #000000"> cmd.ExecuteNonQuery();
  309. </span><span style="color: #008080">309</span> <span style="color: #000000">                            }
  310. </span><span style="color: #008080">310</span> <span style="color: #000000">                            tran.Commit();
  311. </span><span style="color: #008080">311</span>                             <span style="color: #0000ff">return</span><span style="color: #000000"> count;
  312. </span><span style="color: #008080">312</span> <span style="color: #000000">                        }
  313. </span><span style="color: #008080">313</span>                         <span style="color: #0000ff">catch</span><span style="color: #000000">(SqlException e)
  314. </span><span style="color: #008080">314</span> <span style="color: #000000">                        {
  315. </span><span style="color: #008080">315</span> <span style="color: #000000">                            tran.Rollback();
  316. </span><span style="color: #008080">316</span>                             <span style="color: #0000ff">throw</span><span style="color: #000000"> e;
  317. </span><span style="color: #008080">317</span> <span style="color: #000000">                        }
  318. </span><span style="color: #008080">318</span>                         <span style="color: #0000ff">finally</span>
  319. <span style="color: #008080">319</span> <span style="color: #000000">                        {
  320. </span><span style="color: #008080">320</span> <span style="color: #000000">                            conn.Close();
  321. </span><span style="color: #008080">321</span> <span style="color: #000000">                        }
  322. </span><span style="color: #008080">322</span> <span style="color: #000000">                    }
  323. </span><span style="color: #008080">323</span> <span style="color: #000000">                }
  324. </span><span style="color: #008080">324</span> <span style="color: #000000">            }
  325. </span><span style="color: #008080">325</span> <span style="color: #000000">        }
  326. </span><span style="color: #008080">326</span>         <span style="color: #0000ff">public</span> <span style="color: #0000ff">int</span> ExecuteSqlTran(List<KeyValuePair<<span style="color: #0000ff">string</span>,SqlParameter[]>><span style="color: #000000"> sqlStrList)
  327. </span><span style="color: #008080">327</span> <span style="color: #000000">        {
  328. </span><span style="color: #008080">328</span>             <span style="color: #0000ff">using</span> (SqlConnection conn = <span style="color: #0000ff">new</span> SqlConnection(<span style="color: #0000ff">this</span><span style="color: #000000">._SqlConnectionStr))
  329. </span><span style="color: #008080">329</span> <span style="color: #000000">            {
  330. </span><span style="color: #008080">330</span>                 <span style="color: #0000ff">using</span> (SqlCommand cmd = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlCommand())
  331. </span><span style="color: #008080">331</span> <span style="color: #000000">                {
  332. </span><span style="color: #008080">332</span>                     <span style="color: #0000ff">using</span> (SqlTransaction tran =<span style="color: #000000"> conn.BeginTransaction())
  333. </span><span style="color: #008080">333</span> <span style="color: #000000">                    {
  334. </span><span style="color: #008080">334</span>                         <span style="color: #0000ff">try</span>
  335. <span style="color: #008080">335</span> <span style="color: #000000">                        {
  336. </span><span style="color: #008080">336</span>                             cmd.Connection =<span style="color: #000000"> conn;
  337. </span><span style="color: #008080">337</span>                             cmd.CommandType =<span style="color: #000000"> CommandType.Text;
  338. </span><span style="color: #008080">338</span>                             cmd.Transaction =<span style="color: #000000"> tran;
  339. </span><span style="color: #008080">339</span> <span style="color: #000000">                            conn.Open();
  340. </span><span style="color: #008080">340</span>                             <span style="color: #0000ff">int</span> count = <span style="color: #800080">0</span><span style="color: #000000">;
  341. </span><span style="color: #008080">341</span>                             <span style="color: #0000ff">foreach</span>(<span style="color: #0000ff">var</span> item <span style="color: #0000ff">in</span><span style="color: #000000"> sqlStrList)
  342. </span><span style="color: #008080">342</span> <span style="color: #000000">                            {
  343. </span><span style="color: #008080">343</span>                                 cmd.CommandText =<span style="color: #000000"> item.Key;
  344. </span><span style="color: #008080">344</span> <span style="color: #000000">                                cmd.Parameters.Clear();
  345. </span><span style="color: #008080">345</span> <span style="color: #000000">                                cmd.Parameters.AddRange(item.Value);
  346. </span><span style="color: #008080">346</span>                                 count +=<span style="color: #000000"> cmd.ExecuteNonQuery();
  347. </span><span style="color: #008080">347</span> <span style="color: #000000">                            }
  348. </span><span style="color: #008080">348</span> <span style="color: #000000">                            tran.Commit();
  349. </span><span style="color: #008080">349</span>                             <span style="color: #0000ff">return</span><span style="color: #000000"> count;
  350. </span><span style="color: #008080">350</span> <span style="color: #000000">                        }
  351. </span><span style="color: #008080">351</span>                         <span style="color: #0000ff">catch</span><span style="color: #000000">(SqlException e)
  352. </span><span style="color: #008080">352</span> <span style="color: #000000">                        {
  353. </span><span style="color: #008080">353</span> <span style="color: #000000">                            tran.Rollback();
  354. </span><span style="color: #008080">354</span>                             <span style="color: #0000ff">throw</span><span style="color: #000000"> e;
  355. </span><span style="color: #008080">355</span> <span style="color: #000000">                        }
  356. </span><span style="color: #008080">356</span>                         <span style="color: #0000ff">finally</span>
  357. <span style="color: #008080">357</span> <span style="color: #000000">                        {
  358. </span><span style="color: #008080">358</span> <span style="color: #000000">                            conn.Close();
  359. </span><span style="color: #008080">359</span> <span style="color: #000000">                        }
  360. </span><span style="color: #008080">360</span> <span style="color: #000000">                    }
  361. </span><span style="color: #008080">361</span> <span style="color: #000000">                }
  362. </span><span style="color: #008080">362</span> <span style="color: #000000">            }
  363. </span><span style="color: #008080">363</span> <span style="color: #000000">        }
  364. </span><span style="color: #008080">364</span>         <span style="color: #0000ff">public</span> <span style="color: #0000ff">int</span> ExecuteProc(<span style="color: #0000ff">string</span><span style="color: #000000"> procName,SqlParameter[] cmdParams)
  365. </span><span style="color: #008080">365</span> <span style="color: #000000">        {
  366. </span><span style="color: #008080">366</span>             <span style="color: #0000ff">using</span> (SqlConnection conn = <span style="color: #0000ff">new</span> SqlConnection(<span style="color: #0000ff">this</span><span style="color: #000000">._SqlConnectionStr))
  367. </span><span style="color: #008080">367</span> <span style="color: #000000">            {
  368. </span><span style="color: #008080">368</span>                 <span style="color: #0000ff">using</span> (SqlCommand cmd = <span style="color: #0000ff">new</span><span style="color: #000000"> SqlCommand())
  369. </span><span style="color: #008080">369</span> <span style="color: #000000">                {
  370. </span><span style="color: #008080">370</span>                     <span style="color: #0000ff">try</span>
  371. <span style="color: #008080">371</span> <span style="color: #000000">                    {
  372. </span><span style="color: #008080">372</span> <span style="color: #000000">                        conn.Open();
  373. </span><span style="color: #008080">373</span>                         cmd.Connection =<span style="color: #000000"> conn;
  374. </span><span style="color: #008080">374</span>                         cmd.CommandType =<span style="color: #000000"> CommandType.StoredProcedure;
  375. </span><span style="color: #008080">375</span>                         cmd.CommandText =<span style="color: #000000"> procName;
  376. </span><span style="color: #008080">376</span> <span style="color: #000000">                        cmd.Parameters.AddRange(cmdParams);
  377. </span><span style="color: #008080">377</span>                         <span style="color: #0000ff">return</span><span style="color: #000000"> cmd.ExecuteNonQuery();
  378. </span><span style="color: #008080">378</span> <span style="color: #000000">                    }
  379. </span><span style="color: #008080">379</span>                     <span style="color: #0000ff">catch</span><span style="color: #000000">(SqlException e)
  380. </span><span style="color: #008080">380</span> <span style="color: #000000">                    {
  381. </span><span style="color: #008080">381</span>                         <span style="color: #0000ff">throw</span><span style="color: #000000"> e;
  382. </span><span style="color: #008080">382</span> <span style="color: #000000">                    }
  383. </span><span style="color: #008080">383</span>                     <span style="color: #0000ff">finally</span>
  384. <span style="color: #008080">384</span> <span style="color: #000000">                    {
  385. </span><span style="color: #008080">385</span> <span style="color: #000000">                        conn.Close();
  386. </span><span style="color: #008080">386</span> <span style="color: #000000">                    }
  387. </span><span style="color: #008080">387</span> <span style="color: #000000">                }
  388. </span><span style="color: #008080">388</span> <span style="color: #000000">            }     
  389. </span><span style="color: #008080">389</span> <span style="color: #000000">        }
  390. </span><span style="color: #008080">390</span>         <span style="color: #0000ff">#endregion</span>
  391. <span style="color: #008080">391</span>     }

二、工厂模式

  1. <span style="color: #008080"> 1</span>     <span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> DbProvider
  2. </span><span style="color: #008080"> 2</span> <span style="color: #000000">    {
  3. </span><span style="color: #008080"> 3</span>         <span style="color: #0000ff">private</span> <span style="color: #0000ff">static</span> <span style="color: #0000ff">string</span> _SqlConnectionStr = <span style="color: #0000ff">null</span><span style="color: #000000">;
  4. </span><span style="color: #008080"> 4</span>         <span style="color: #0000ff">public</span> <span style="color: #0000ff">static</span> <span style="color: #0000ff">string</span><span style="color: #000000"> SqlConnectionStr
  5. </span><span style="color: #008080"> 5</span> <span style="color: #000000">        {
  6. </span><span style="color: #008080"> 6</span>             <span style="color: #0000ff">get</span>
  7. <span style="color: #008080"> 7</span> <span style="color: #000000">            {
  8. </span><span style="color: #008080"> 8</span>                 <span style="color: #0000ff">string</span> connStr =<span style="color: #000000"> _SqlConnectionStr;
  9. </span><span style="color: #008080"> 9</span>                 <span style="color: #0000ff">if</span> (connStr == <span style="color: #0000ff">null</span><span style="color: #000000">)
  10. </span><span style="color: #008080">10</span>                     connStr = <span style="color: #800000">"</span><span style="color: #800000">Data Source=(local);Initial Catalog=testDB;Persist Security Info=True;User ID=sa;Password=123456</span><span style="color: #800000">"</span><span style="color: #000000">; //一般这里是读取项目配置文件里的数据库参数来生成连接字符串
  11. </span><span style="color: #008080">11</span>                 <span style="color: #0000ff">return</span><span style="color: #000000"> connStr;
  12. </span><span style="color: #008080">12</span> <span style="color: #000000">            }
  13. </span><span style="color: #008080">13</span> <span style="color: #000000">        }
  14. </span><span style="color: #008080">14</span>         <span style="color: #0000ff">public</span> <span style="color: #0000ff">static</span><span style="color: #000000"> SqlHelper SqlServer
  15. </span><span style="color: #008080">15</span> <span style="color: #000000">        {
  16. </span><span style="color: #008080">16</span>             <span style="color: #0000ff">get</span>
  17. <span style="color: #008080">17</span> <span style="color: #000000">            {
  18. </span><span style="color: #008080">18</span>                 <span style="color: #0000ff">return</span> <span style="color: #0000ff">new</span><span style="color: #000000"> SqlHelper(SqlConnectionStr);
  19. </span><span style="color: #008080">19</span> <span style="color: #000000">            }
  20. </span><span style="color: #008080">20</span> <span style="color: #000000">        }
  21. </span><span style="color: #008080">21</span>     }

三、实例使用

 

  1. <span style="color: #008080">1</span>     <span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span><span style="color: #000000"> Demo
  2. </span><span style="color: #008080">2</span> <span style="color: #000000">    {
  3. </span><span style="color: #008080">3</span>         <span style="color: #0000ff">public</span> DataTable QueryOrderInfo(<span style="color: #0000ff">string</span><span style="color: #000000"> id)
  4. </span><span style="color: #008080">4</span> <span style="color: #000000">        {
  5. </span><span style="color: #008080">5</span>             <span style="color: #0000ff">string</span> sql = <span style="color: #800000">"</span><span style="color: #800000">select * from order where id=@id</span><span style="color: #800000">"</span><span style="color: #000000">;
  6. </span><span style="color: #008080">6</span>             SqlParameter[] cmdParams = <span style="color: #0000ff">new</span> SqlParameter[] { <span style="color: #0000ff">new</span> SqlParameter(<span style="color: #800000">"</span><span style="color: #800000">@id</span><span style="color: #800000">"</span><span style="color: #000000">, id) };
  7. </span><span style="color: #008080">7</span>             <span style="color: #0000ff">return</span><span style="color: #000000"> DbProvider.SqlServer.GetQueryData(sql, cmdParams);
  8. </span><span style="color: #008080">8</span> <span style="color: #000000">        }
  9. </span><span style="color: #008080">9</span>     }

 

C#：SqlHelper

标签：connect   on()   数据   ret   数据库   oca   工厂模式   man   data   

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！