database.cs

电脑用户登录注册系统

using System;
using System.Data;
using System.Configuration;
using System.Data.OleDb;
using System.Web;
using System.Collections;


namespace DataBaseLayer
{ 
    public class DataBase:System.Web.UI.Page
    {
        
        private OleDbConnection con=null;
       
        private string accString;
	    public DataBase()
	    {
		    
            accString = "Provider=Microsoft.Jet.OleDb.4.0;";
            accString += "Data Source=" + System.Web.HttpContext.Current.Server.MapPath("user.mdb;");
            
        }

        
        public void open()
        {
            if (con == null)
            {
                con = new OleDbConnection(accString);
            }
            if (con.State.Equals(ConnectionState.Closed))
            {
                con.Open();
            }
        }

     
        public void close()
        {
            if (con.State.Equals(ConnectionState.Open))
            {
                con.Close();
                con.Dispose();
            }
            else
            {
                con.Dispose();
            }
        }

    
        public int ExecuteSQL(string sqlStr)
        {
            try
            {
               
                this.open();
                OleDbCommand cmd = new OleDbCommand(sqlStr, con);
                return cmd.ExecuteNonQuery();
            }
            catch
            {
                return -1;
            }
            finally
            {
                close();
            }
        }

        
        public DataTable GetDataTable(string sqlStr)
        {
            DataTable dt;
            DataSet ds;
            try
            {
                open();
                OleDbDataAdapter oda = new OleDbDataAdapter(sqlStr, con);
                ds = new DataSet();
                oda.Fill(ds);
                dt = ds.Tables[0];
            }
            catch(Exception ex)
            {
               dt=null;
            }
            finally
            {
                close();
            }
            return dt;
        }

        
        public DataSet GetDataSet(string sqlStr)
        {
            DataSet ds;
            try
            {
                open();
                OleDbDataAdapter oda = new OleDbDataAdapter(sqlStr, con);
                ds = new DataSet();
                oda.Fill(ds);
            }
            catch
            {
                return null;
            }
            finally
            {
                close();
            }
            return ds;
        }

       
        public DataRow GetDataRow(string sqlStr)
        {
            DataRow dr;
            try
            {
               
                dr = GetDataTable(sqlStr).Rows[0];
            }
            catch
            {
                dr = null;
            }
            finally
            {
                close();
            }
            return dr;
        }
        
       
        public bool ExecuteTransaction(ArrayList sqlStrings)
        {
            bool success = true;
            OleDbTransaction tran = con.BeginTransaction();
            OleDbCommand cmd = new OleDbCommand();
            cmd.Connection = con;
            cmd.Transaction = tran;
            try
            {
                foreach (string sqlStr in sqlStrings)
                {
                    cmd.CommandText = sqlStr;
                    cmd.ExecuteNonQuery();
                }
                tran.Commit();
                success = true;
            }
            catch
            {
                tran.Rollback();
                success = false;
            }
            finally
            {
                close();
            }
            return success;
        }
    }
}