c#下各种数据库操作的封装2015.docVIP

c#下各种数据库操作的封装！(支持ACCESS,SQLSERVER,DB2,ORACLE,MYSQL)（一）收藏 首先定义数据库操作的标准接口IDBAccess,定义接口的基本功能； 通过基本的接口设置，完成数据访问的统一抽象。 public?interface?IDBAccess????...{????????void?Init(string?strServer,?string?strDataBase,?string?strUser,?string?strPwd);????????void?Open();????????void?Close();????????bool?TestConn();????????int?RunNoQuery(string?strCmd);????????DataTable?RunQuery(string?strCmd);????????DBType?DBType?...{?get;}????????int?GetFiledMax(string?strTable,?string?strField);????????DataTable?Tables?...{?get;?}????????DataTable?GetColumns();????????DataTable?GetColumns(string?strTable);????} c#下各种数据库操作的封装！(支持ACCESS,SQLSERVER,DB2,ORACLE,MYSQL)（二）收藏 使用静态工厂模式，通过传入枚举型参数?，动态创建访问实例 实现模式上采用基本实现接口，派生类继承基类的虚函数，从而实现代码的耦合较低，有很好的扩展性。 public?enum?DBType????...{????????Access,????????SQL,????????DB2,????????Oracle,????????MySQL????}?public?static?class?DBAccessFactory????...{????????public?static?IDBAccess?Create(DBType?type)????????...{????????????IDBAccess?IRet?=?null;????????????switch?(type)????????????...{????????????????case?DBType.Access:????????????????????IRet?=?new?Access(type);????????????????????break;????????????????case?DBType.SQL:????????????????????IRet?=?new?SQL(type);????????????????????break;????????????????default:????????????????????break;????????????}????????????return?IRet;????????}????????private?abstract?class?DBAccess?:?IDBAccess????????...{????????????protected?DbConnection?m_oConn?=?null;????????????protected?const?string?CON_strServer?=?Server;????????????protected?const?string?CON_strDataBase?=?Data?Source;????????????protected?const?string?CON_strUser?=?UID;????????????protected?const?string?CON_strPwd?=?PWD;????????????protected?const?string?CON_strConnTimeOut?=?Connect?Timeout?=?2;????????????private?DBType?m_eDBType?=?DBType.Access;????????????protected?DBAccess(DBType?type)????????????...{????????????????this.m_eDBType?=?type;????????????}????????????public?DBType?DBType????????????...{?????????