database.cs

welcome administrator use

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
//该源码下载自www.51aspx.com(５1ａｓｐｘ．ｃｏｍ)

/// <summary>
///数据操作类
/// </summary>
public class DataBase
{
    private SqlConnection Conn = null;
    private SqlCommand Cmd;
    private SqlDataAdapter Da;
    private DataSet Ds;
    private DataTable Dt;
    private String strConn;

	public DataBase()
	{
		//
		//在这里构造你妈的函数!
		//
        strConn = ConfigurationManager.AppSettings["ConnStr"];
	}


    /// <summary>
    /// 打开Conn连接
    /// </summary>
    public void Open()
    {
        if (Conn == null)
        {
            Conn = new SqlConnection(strConn);
        }
        if (Conn.State.Equals(ConnectionState.Closed))
        {
            Conn.Open();
        }
    }


    /// <summary>
    /// 关闭Conn连接并释放....
    /// </summary>
    public void Close()
    {
        if (Conn.State.Equals(ConnectionState.Open))
        {
            Conn.Close();
            //释放他老母占用的资源
            Conn.Dispose();
        }
        else
            Conn.Dispose();
    }


    /// <summary>
    /// 执行CMD操作类
    /// </summary>
    /// <param name="sql">sql语句</param>
    /// <returns>Cmd</returns>
    public int ExecuteCmd(string sql)
    {
        try
        {
            Open();
            Cmd = new SqlCommand(sql, Conn);
            return Cmd.ExecuteNonQuery();
        }
        catch
        {
            return -1;
        }
        finally
        {
            Close();
        }
    }

    /// <summary>
    /// DataSet类
    /// </summary>
    /// <param name="sql">sql语句</param>
    /// <returns>返回你老母的DataSet</returns>
    public DataSet GetDataSet(string sql)
    {
        try
        {
            Open();
            Da = new SqlDataAdapter(sql, Conn);
            Ds = new DataSet();
            Da.Fill(Ds);
        }
        catch (Exception e)
        {
            throw new Exception(e.Message, e);
        }
        finally
        {
            Close();
        }
        return Ds;
    }

    /// <summary>
    /// 验证类
    /// </summary>
    /// <param name="sql">sql语句</param>
    /// <returns>返回Cmd</returns>
    public int ExecuteRead(string sql)
    {
        try
        {
            Open();
            Cmd = new SqlCommand(sql, Conn);
            return (int)Cmd.ExecuteScalar();
        }
        catch
        {
            return -1;
        }
        finally
        {
            Close();
        }
    }


    public DataTable getDataTable(string sql)
    {
        try
        {
            Open();
            Da = new SqlDataAdapter(sql, Conn);
            Dt = new DataTable();
            Da.Fill(Dt);
        }
        catch (Exception e)
        {
            throw new Exception(e.Message, e);
        }
        finally
        {
            Close();
        }
        return Dt;
    }
}