databaseoperate.cs

互联网程序设计的课程

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>
/// DateBaseOperate 的摘要说明
/// 封装对数据库的各种操作
/// </summary>
public class DataBaseOperate
{
    private static SqlConnection myConnection;
    //初使化myConnection
    public static SqlConnection myInit()
    {
        string connStr= System.Configuration.ConfigurationSettings.AppSettings["connString"];
        myConnection = new SqlConnection(connStr);
        return myConnection;
    }

    //无返回记录的查询，一般用于插入，更新，删除等操作
    public static bool myExecuteNonQuery(string strSQL)
    {
        bool result = true;
        myInit();
        myConnection.Open();
        SqlCommand myCommand = new SqlCommand(strSQL, myConnection);
        try
        {
            myCommand.ExecuteNonQuery();
        }
        catch
        {
            result = false;
        }
        myConnection.Close();
        return result;
    }

    //查询记录的数目
    public static Object myExecuteScalar(string strSQL)
    {
        Object o;
        myInit();
        myConnection.Open();
        SqlCommand myCommand = new SqlCommand(strSQL, myConnection);
        o = myCommand.ExecuteScalar();
        myConnection.Close();
        return o;
    }

    //查询记录，返回DataTable
    public static DataTable myExecuteQuery(string strSQL)
    {
        myInit();
        myConnection.Open();     
        SqlDataAdapter myDataAdapter = new SqlDataAdapter(strSQL, myConnection);
        DataSet myDataSet = new DataSet();
        myDataAdapter.Fill(myDataSet,"myDataTable");
        myConnection.Close();
        return myDataSet.Tables["myDataTable"];
    }

    //读出数据，返回DataReader
    public static SqlDataReader myExecuteReader(string strSQL)
    {
        myInit();
        myConnection.Open();
        SqlCommand myCommand = new SqlCommand(strSQL, myConnection);
        SqlDataReader myDataReader = myCommand.ExecuteReader();
        return myDataReader;
    }
}