daocommand.cs

来自「一个用于两地间交通方案选择的小决策支持系统」· CS 代码 · 共 71 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;

namespace AIToSH
{
    class DAOCommand
    {
        private OleDbConnection myConn = null;
        private OleDbDataAdapter myODA = null;

        public DAOCommand()
        {
            this.myConn = new OleDbConnection();
            this.myConn.ConnectionString =
                "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= .//AccessToSH.mdb";
            try
            {
                this.myConn.Open();
            }
            catch (Exception e)
            {
                DigitalSupport.Log logger = new DigitalSupport.Log();
                logger.Module = "DAOCommand.DAOCommand()";
                logger.Description = e.Message;
                logger.WriteLog();
            }
        }

        public OleDbConnection MyConn
        { 
            get { return this.myConn; } 
        }

        public OleDbDataAdapter MyODA
        {
           get { return this.myODA; }
        }

        public bool releaseConnection()
        {
            try
            {
                if (myConn != null)
                {
                    myConn.Close();
                    myConn = null;
                }
                return true;
            }
            catch (Exception e)
            {
                DigitalSupport.Log logger = new DigitalSupport.Log();
                logger.Module = "DAOCommand.releaseConnection";
                logger.Description = e.Message;
                logger.WriteLog();
                return false;
            }
        }

           

        public void search(string strSql)
        {
            myODA = new OleDbDataAdapter(strSql, this.myConn);
        }
    }
}