c#下各种数据库操作的封装！(支持ACCESS,SQLSERVER,DB2,ORACLE,MYSQL)（三）

各派生类的具体实现，此时只要实现DBAccess的各个虚函数即可。

privateclass Access : DBAccess
...{
public Access(DBType type)
               : base(type)
...{
           }

protectedoverridevoid InitConn(string strServer, string strDataBase, string strUser, string strPwd)
...{
string strConn = "Provider = ";
switch (strDataBase.Substring(strDataBase.LastIndexOf('.') + 1).ToLower())
...{
case "mdb":     // 2000, 2003
                       strConn += "Microsoft.Jet.OleDb.4.0;";
break;

case "accdb":   // 2007
                       strConn += "Microsoft.ACE.OLEDB.12.0;";
break;

default:
throw (new Exception("Unknown Access Version."));
//break;
               }
               strConn += CON_strDataBase + " = " + strDataBase;
//strConn += CON_strUser + " = " + strUser;
               //strConn += CON_strPwd + " = " + strPwd;
base.m_oConn = new OleDbConnection(strConn);
           }

protectedoverride DbCommand GetCmd(string strCmd)
...{
returnnew OleDbCommand(strCmd, (OleDbConnection)base.m_oConn);
           }

protectedoverride DbDataAdapter DbAdp
...{
get...{ returnnew OleDbDataAdapter(); }
           }

publicoverride DataTable Tables
...{
get
...{
return ((OleDbConnection)base.m_oConn).GetOleDbSchemaTable(OleDbSchemaGuid.Tables, newobject[] ...{ null, null, null, "Table" });
               }
           }

publicoverride DataTable GetColumns()
...{
               DataTable dt = new DataTable();
foreach (DataRow row inthis.Tables.Rows)
...{
                   dt.Merge(this.GetColumns(row["TABLE_NAME"].ToString()));
               }
return dt;
           }

publicoverride DataTable GetColumns(string strTable)
...{
return ((OleDbConnection)base.m_oConn).GetOleDbSchemaTable(OleDbSchemaGuid.Columns, newobject[] ...{ null, null, strTable, null });
           }
       }

privateclass SQL : DBAccess
...{
public SQL(DBType type)
               : base(type)
...{
           }

protectedoverridevoid InitConn(string strServer, string strDataBase, string strUser, string strPwd)
...{
string strConn = CON_strServer + " = " + strServer + ";";
               strConn += CON_strDataBase + " = " + strDataBase + ";";
               strConn += CON_strUser + " = " + strUser + ";";
               strConn += CON_strPwd + " = " + strPwd + ";";
               strConn += CON_strConnTimeOut;
base.m_oConn = new SqlConnection(strConn);
           }

protectedoverride DbCommand GetCmd(string strCmd)
...{
returnnew SqlCommand(strCmd, (SqlConnection)base.m_oConn);
           }

protectedoverride DbDataAdapter DbAdp
...{
get...{ returnnew SqlDataAdapter(); }
           }

publicoverride DataTable Tables
...{
get...{ return ((SqlConnection)base.m_oConn).GetSchema("Tables", null); }
           }

publicoverride DataTable GetColumns()
...{
return ((SqlConnection)base.m_oConn).GetSchema("Columns", null);
           }

publicoverride DataTable GetColumns(string strTable)
...{
return ((SqlConnection)base.m_oConn).GetSchema("Columns", newstring[] ...{ null, null, strTable, null });
           }
       }

转载于:https://blog.51cto.com/ciscoxia/1216324