ADO.Net 中 SQLHelper 的写法

18 篇文章 1 订阅
7 篇文章 1 订阅

ExecuteScalar() ExecuteNonQuery()ExecuteReader()

在编程中常用当中有以上三种:

 

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
//引用SQL数据
using System.Data;
using System.Data.SqlClient;
namespace ADO
{
    class SQLHelper
    {
        //连接字符串
        private static string connString = "Server=服务器名;DataBase=数据库名;Uid=用户名;Pwd=用户密码";  
        /// <summary>
        /// 获取单一结果
        /// </summary>
        /// <param name="sql_string">SQL语句</param>
        /// <returns>返回单一结果</returns>
        public static object ExecuteScalar的方法名(string sql_string)
        {
            SqlConnection myCon = new SqlConnection(connString);
            SqlCommand myCmd = new SqlCommand(sql_string, myCon);
            myCon.Open();
            string result = myCmd.ExecuteScalar();
            myCon.Close();
            return result;
        }
        /// <summary>
        /// 执行非查询操作
        /// </summary>
        /// <param name="sql_string">SQL语句</param>
        /// <returns>返回受影响的行</returns>
        public static int ExecuteNonQuery的方法名(string sql_string)
        {
            SqlConnection myCon = new SqlConnection(connString);
            SqlCommand myCmd = new SqlCommand(sql_string, myCon);
            myCon.Open();
            int result = myCmd.ExecuteNonQuery();
            myCon.Close();
            return result;
        }
        /// <summary>
        /// 获取只读数据集
         /// <param name="sql_string">SQL语句</param>
        /// <returns>返回只读取数据集</returns>
        /// </summary>
        public static SqlDataReader ExecuteReader的方法名(string sql_string)
        {
            SqlConnection myCon = new SqlConnection(connString);
            SqlCommand myCmd = new SqlCommand(sql_string, myCon);
            myCon.Open();
            string result = myCmd.ExecuteReader(CommandBehavior.CloseConnection);
            return result;
        }
    }
}


 

 

 在 Program 类中调用 SQLHelper

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace ADO
{
    class Program
    {
        static void Main(string[] args)
        {
            //string sqlString = "delete  from Student where studentNO='S110601'";
            //int myExcuteNonQuery = SQLHelper.myExecuteNonQuery(sqlString);
            //Console.WriteLine(myExcuteNonQuery);


//下面这个要特别注意:
            string sql = "select * from Student where gender='男'";
            sql += "select * from Student where gender='女'";
            SqlDataReader objRead = SQLHelper.ExecuteReader的方法名(sql);
            while (objRead.Read())
            {
                Console.WriteLine(objRead["StudentNO"].ToString() + " " + objRead["StudentName"].ToString() + " " + objRead["gender"].ToString());
            }
            Console.WriteLine("==========================================");
           if( objRead.NextResult())
           {
               while (objRead.Read())
               {
                   Console.WriteLine(objRead["StudentNO"].ToString() + " " + objRead["StudentName"].ToString() + " " + objRead["gender"].ToString());
               }
           }
            objRead.Close();
        }
    }
}


 

SQLHelper 另一种详细写法

 

using System;
using System.Collections.Generic;
using System.Text;
//引用SQL数据
using System.Data;
using System.Data.SqlClient;
namespace ConsoleApplication2
{
    class SQLHelper
    {
        //连接字符串
        private static string connString = "Server=.;DataBase=StudentManageDB;Uid=sa;Pwd=123";
        /// <summary>
        /// ExecuteScalar()
        /// </summary>
        /// <param name="sql_string">SQL语句</param>
        /// <returns>返回单个值的功能</returns>
        public static object ExecuteScalar的方法名(string sql_string)
        {
            using (SqlConnection myCon = new SqlConnection(connString))
            {
                using (SqlCommand myCmd = new SqlCommand(sql_string, myCon))
                {
                    try
                    {
                        myCon.Open();
                        return myCmd.ExecuteScalar();
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                    finally
                    {
                        myCon.Close();
                    }
                }
            }
        }
        /// <summary>
        /// ExecuteNonQuery()
        /// </summary>
        /// <param name="sql_string">SQL语句</param>
        /// <returns>返回受影响的行</returns>
        public static int myExecuteNonQuery(string sql_string)
        {
            using (SqlConnection myCon = new SqlConnection(connString))
            {
                using (SqlCommand myCmd = new SqlCommand(sql_string, myCon))
                {
                    try
                    {
                        myCon.Open();
                        return myCmd.ExecuteNonQuery();
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                    finally
                    {
                        myCon.Close();
                    }
                }
            }
        }
        /// <summary>
        /// ExecuteReader()
        /// </summary>
        /// <param name="sql_string">SQL语句</param>
        /// <returns>返回读取数据集</returns>
        public static SqlDataReader ExecuteReader的方法名(string sql_string)
        {
            using (SqlConnection myCon = new SqlConnection(connString))
            {
                using (SqlCommand myCmd = new SqlCommand(sql_string, myCon))
                {
                    try
                    {
                        myCon.Open();
                        return myCmd.ExecuteReader(CommandBehavior.CloseConnection);
                    }
                    catch (Exception ex)
                    {
                        throw ex;
                    }
                    finally
                    {
                        myCon.Close();
                    }
                }
            }
        }
    }
}


 

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值