C#数据库操作类类DB_Class

来源：互联网发布：电视直播app源码编辑：程序博客网时间：2024/05/01 17:50

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

/// <summary>
/// Sql_Class 的摘要说明
/// </summary>
public class DB_Class
{
    public DB_Class()
{
   //
   // TODO: 在此处添加构造函数逻辑
   //
    }
    # region GetCon
    public static SqlConnection GetCon()
    {
        return new SqlConnection(ConfigurationManager.AppSettings[ "GetCon"]);
    }
    # endregion

    # region insert/del/update
    //~~~~~~~~~~~~~~~~~~~~~~根据传进来的ＳＱＬ语句执行插入/删除/更新等操作~~~~~~~~~~~~~~~~~~~~~~~~~
    public static bool doData(string que)
    {
        SqlConnection con = GetCon();
        con.Open();
        SqlCommand cmd = new SqlCommand(que, con);
        try
        {
            cmd.ExecuteNonQuery();
            return true;
        }
        catch
        {
            return false;
        }
        finally
        {
            cmd.Dispose();
            con.Dispose();
        }
    }
    #endregion

    # region return_single_data
    //~~~~~~~~~~~~~~~~~~~~~~~~~~~查询返回单个字段~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    public static String return_single_data(string cmdText)
    {

        SqlConnection con = GetCon();
        con.Open();
        SqlCommand cmd = new SqlCommand(cmdText, con);
        String cn = null;
        try
        {
            cn = cmd.ExecuteScalar().ToString();
            return cn;
        }
        catch
        {
            cn = "0";
            return cn;
        }
        finally
        {
            cmd.Dispose();
            con.Dispose();
        }
    }
#endregion

    # region return_multi_data
    //~~~~~~~~~~~~~~~~~~~~~~~~~~~查询返回多条记录~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    public SqlDataReader return_multi_data(string cmdText)
    {

        SqlConnection con = GetCon();
        ///打开链接
        con.Open();
        ///创建Command
        SqlCommand myCommand = new SqlCommand(cmdText, con);

        ///定义DataReader
        SqlDataReader dr = null;
        try
        {

            ///读取数据
            dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
            return dr;
        }
        catch (SqlException ex)
        {
            ///抛出异常
            throw new Exception(ex.Message, ex);
        }
        finally
        {
            ///返回DataReader

            con.Dispose();
        }
    }
    # endregion

    # region return_bool
    //~~~~~~~~~~~~~~~~~~~~~~~查询返回BOOL~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    public static bool check_name(string sql)
    {

string temp;

        SqlConnection con = GetCon();
        SqlCommand cmd = new SqlCommand(sql, con);
         con.Open();
        try
        {
            temp = cmd.ExecuteScalar().ToString();
        }
        catch
        {
            return false;
        }
        if ((temp != "") && (temp != null))
            return true;
        else
            return false;

     }
    #endregion

     # region get_dataset
     //~~~~~~~~~~~~~~~~~~~~~~~~~~~DataSet查询返回多条记录~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    public DataSet GetDataSet(string strSql, string TableName)
    {
        SqlConnection con = GetCon();//与数据库连接
        con.Open();
        DataSet ds = new DataSet();
        SqlDataAdapter adapt = new SqlDataAdapter(strSql, con); //实例化SqlDataAdapter类对象
        try
        {

            adapt.Fill(ds, TableName);//填充数据集
            return ds;//返回数据集DataSet的表的集合

        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);

        }
        finally
        {//断开连接，释放资源

            adapt.Dispose();
            ds.Dispose();
            con.Dispose();
            con.Close();
        }

}
#endregion
}