数据库操作的时候，模式很固定。于是把这些操作都封装起来。 达到提供sql语句或参数，得到结果的目的。 我们把这个类库叫SqlHelper SqlHelper using System; using System.Configuration; using System.Data; using System.Data.SqlClient;namespace YZLibra

数据库操作的时候，模式很固定。于是把这些操作都封装起来。
达到提供sql语句或参数，得到结果的目的。
我们把这个类库叫SqlHelper

SqlHelper

<code class=" hljs cs"><span class="hljs-keyword">using</span> System;<span class="hljs-keyword">using</span> System.Configuration;<span class="hljs-keyword">using</span> System.Data;<span class="hljs-keyword">using</span> System.Data.SqlClient;namespace YZLibrary{    class SqlHelper    {        <span class="hljs-keyword">private</span> <span class="hljs-keyword">static</span> <span class="hljs-keyword">readonly</span> <span class="hljs-keyword">string</span> connStr = ConfigurationManager.ConnectionStrings[<span class="hljs-string">"sql"</span>].ConnectionString;        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"><summary></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> 执行非查询语句并返回受影响行数</span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></summary></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></span><span class="hljs-xmlDocTag"></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></span><span class="hljs-xmlDocTag"></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></span><span class="hljs-xmlDocTag"></span></span>        <span class="hljs-keyword">public</span> <span class="hljs-keyword">static</span> <span class="hljs-keyword">int</span> <span class="hljs-title">ExecuteNonQuery</span>(<span class="hljs-keyword">string</span> sql, <span class="hljs-keyword">params</span> SqlParameter[] pms)        {            <span class="hljs-keyword">using</span> (SqlConnection conn = <span class="hljs-keyword">new</span> SqlConnection(connStr))            {                <span class="hljs-keyword">using</span> (SqlCommand cmd = <span class="hljs-keyword">new</span> SqlCommand(sql, conn))                {                    cmd.Parameters.AddRange(pms);                    conn.Open();                    <span class="hljs-keyword">return</span> cmd.ExecuteNonQuery();                }            }        }         <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"><summary></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> 执行查询，并返回查询的结果集中的第一行第一列</span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></summary></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></span><span class="hljs-xmlDocTag"></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></span><span class="hljs-xmlDocTag"></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></span><span class="hljs-xmlDocTag"></span></span>        <span class="hljs-keyword">public</span> <span class="hljs-keyword">static</span> <span class="hljs-keyword">object</span> <span class="hljs-title">ExecuteScalar</span>(<span class="hljs-keyword">string</span> sql,  <span class="hljs-keyword">params</span> SqlParameter[] pms)        {            <span class="hljs-keyword">using</span> (SqlConnection conn = <span class="hljs-keyword">new</span> SqlConnection(connStr))            {                <span class="hljs-keyword">using</span> (SqlCommand cmd = <span class="hljs-keyword">new</span> SqlCommand(sql, conn))                {                    cmd.Parameters.AddRange(pms);                    conn.Open();                    <span class="hljs-keyword">return</span> cmd.ExecuteScalar();                }            }        }        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"><summary></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> 执行查询，并返回SqlDataReader。</span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></summary></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></span><span class="hljs-xmlDocTag"></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></span><span class="hljs-xmlDocTag"></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></span><span class="hljs-xmlDocTag"></span></span>        <span class="hljs-keyword">public</span> <span class="hljs-keyword">static</span> SqlDataReader <span class="hljs-title">ExecuteReader</span>(<span class="hljs-keyword">string</span> sql, <span class="hljs-keyword">params</span> SqlParameter[] pms)        {            SqlConnection conn = <span class="hljs-keyword">new</span> SqlConnection(connStr);            <span class="hljs-keyword">try</span>            {                <span class="hljs-keyword">using</span> (SqlCommand cmd = <span class="hljs-keyword">new</span> SqlCommand(sql, conn))                {                    cmd.Parameters.AddRange(pms);                    conn.Open();                    <span class="hljs-keyword">re<p>本文来源gao!%daima.com搞$代*!码$网9</p>turn</span> cmd.ExecuteReader(CommandBehavior.CloseConnection);                }            }            <span class="hljs-keyword">catch</span> (Exception ex)            {                conn.Dispose();                <span class="hljs-keyword">throw</span> ex;            }        }        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"><summary></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> 执行查询，返回DataTable</span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></summary></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></span><span class="hljs-xmlDocTag"></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></span><span class="hljs-xmlDocTag"></span></span>        <span class="hljs-comment"><span class="hljs-xmlDocTag">///</span> <span class="hljs-xmlDocTag"></span><span class="hljs-xmlDocTag"></span></span>        <span class="hljs-keyword">public</span> <span class="hljs-keyword">static</span> DataTable <span class="hljs-title">ExecuteDataTable</span>(<span class="hljs-keyword">string</span> sql,<span class="hljs-keyword">params</span> SqlParameter[] pms)        {            DataTable dt = <span class="hljs-keyword">new</span> DataTable();            <span class="hljs-keyword">using</span> (SqlDataAdapter adapter = <span class="hljs-keyword">new</span> SqlDataAdapter(sql, connStr))            {                adapter.SelectCommand.Parameters.AddRange(pms);                adapter.Fill(dt);            }            <span class="hljs-keyword">return</span> dt;        }     }}</code>

ExecuteReader

喜欢 (0)赏

[搞代码]

分享 (0)