dbaccess.cs

来自「3D游戏编程入门经典.」· CS 代码 · 共 70 行

using System;
using System.Collections.Generic;
using System.Text;

namespace CodeSW.DBA
{
    class DBAccess
    {
        #region 连接字符串
        private static string connectionString = System.Configuration.ConfigurationSettings.AppSettings["AccessConnectionString"];
        #endregion

        #region 创建SqlConnection的一个连接对象conn
        public static System.Data.OleDb.OleDbConnection GetOleDBconnObject(string _connString)
        {
            if (_connString == "")
            {
                _connString = connectionString;
            }
            try
            {
                System.Data.OleDb.OleDbConnection _conn = new System.Data.OleDb.OleDbConnection();
                _conn.ConnectionString = _connString;
                return _conn;
            }
            catch
            {
                return null;
            }
        }
        #endregion

        #region ExcuteReader()
        public static System.Data.OleDb.OleDbDataReader ExecuteReader(string SQLstring,System.Data.OleDb.OleDbConnection connection)
        {
            try
            {
                System.Data.OleDb.OleDbCommand Selectcommand = new System.Data.OleDb.OleDbCommand(SQLstring, connection);
                Selectcommand.CommandType = System.Data.CommandType.Text;
                return Selectcommand.ExecuteReader();
            }
            catch
            {
                return null;
            }
        }
        #endregion

        #region ExecuteNonQuery()
        public static int ExecuteNonQuery(string SQLstring)
        {
            try
            {
                System.Data.OleDb.OleDbConnection connection = DBAccess.GetOleDBconnObject("");
                connection.Open();
                System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(SQLstring, connection);
                cmd.CommandType = System.Data.CommandType.Text;
                int returnNum = cmd.ExecuteNonQuery();
                return returnNum;
            }
            catch
            {
                return 0;
            }
        }
        #endregion
    }

}