Database abstract factory implemented with C # (2)
The following three classes are Factory for SQL Server private connections, the specific implementation of the OLEDB connection, and ODBC connections:
(3) SQLFActory.cs
Using system; using system.data.sqlclient; using system.configuration;
Namespace DBService {/// /// Dedicated to SQLServer dedicated plants /// public class sqlfactory: Abstractory: AbstractDdbFactory {/// /// Construction function /// public Sqlfactory () {}
/// /// Establish a default Connection object /// /// Connection object public idbconnection createconnection () {return new sqlConnection ();}
/// / / / Establish Connection object /// connection string /// /// Connection object < / returns> public idbconnection createConnection (String strconn) {return new sqlconnection (strconn);}
/// /// Establish a Command object /// /// Command object public idbcommand createcommand () {return new sqlcommand ();
/// /// Establish DataAdapter object /// /// DataAdapter object public idbdataadapter createDataAdapter () {Return New SqlDataAdapter ()
/// /// According to Connection Transaction /// /// Connection object /// Transaction object public IdbTransaction CreateTractions {Return MyDbConnection.begintransAction ();
/// // / Established DataReader /// DataReader Objects PUBLIC IDataReader CreateDataReader (idbcommand mydbcommand) {return mydbcommand.executeReader ();} /// /// get connection string /// /// connection string public String GetConnectionString () {string strServer = ConfigurationSettings.AppSettings [ "SqlServerServer"]; string strDatabase = ConfigurationSettings.AppSettings [ "SqlServerDatabase"]; string strUid = ConfigurationSettings.AppSettings [ "SqlServerUid"]; string strPwd = ConfigurationSettings.AppSettings [ "SqlServerPwd" ]; String strconnectionstring = "server =" strserver "; database =" strdatabase "; uid =" struid "; pwd =" strpwd ";" returnnectionstring;}
}
(4) OLEDBFActory.cs
Using system.data; using system.data.oledb; using system.configuration;
Namespace DBService {/// // / /// public class oledbfactory: abstractDbFactory {/// /// Constructor /// public oledbFactory: AbstractDbFactory {/// () {}
/// /// Establish a default Connection object /// /// Connection object public idbconnection createconnection () {return new oledbConnection ();}
/// / / / Establish Connection object /// connection string /// /// Connection object < / returns> public idbconnection createConnection (String strconn) {Return New OledbConnection (StrConn);} /// /// Establishing Command Object /// /// Command Object Public IDBCommand CreateCommand () {return new oledbcommand ();
/// /// Establish DataAdapter object /// /// DataAdapter object
/// /// According to Connection Transaction /// /// Connection object /// Transaction object public IdbTransaction CreateTractions {Return MyDbConnection.begintransAction ();
/// // / Established DataReader /// DataReader Objects PUBLIC IDataReader CreateDataReader (idbcommand mydbcommand) {return mydbcommand.executeReader ();}
/// /// Get a connection string /// Connection string public string getConnectionstring () {string strprovider = configurationSettings.appsettings ["OLEDBPROVIDER"] ; string strDataSource = ConfigurationSettings.AppSettings [ "OleDbDataSource"]; string strConnectionString = "Provider =" strProvider "; Data Source =" strDataSource ";"; return strConnectionString;}}}
(5) odbcfactory.cs
Using system; using system.data.odbc; using system.configuration;
Namespace dbservice {/// // //// public class odbcfactory: AbstractDbFactory {/// /// Public ODBCFACTory: () {}
/// /// Establish a default Connection object /// /// Connection object public idbconnection createconnection () {returnne odbcConnection ();}
/// / / / Establish Connection object /// connection string /// /// Connection object < / RETURNS> Public IDBConnection CreateConnection (String StrConn) {Return New OdbcConnection (STRCONN);
/// /// Establish Command Object /// /// Command Object Public IDBCommand CreateCommand () {Return New OdbcCommand ();
/// /// Establish DataAPter object /// /// DataAdapter object public idbdataadapter createDataAdapter () {Return new odbcdataadapter ()
/// /// According to Connection Transaction /// /// Connection object /// Transaction object public IDbTransaction CreateTransaction (IDbConnection myDbConnection) {return myDbConnection.BeginTransaction ();} /// /// established DataReader /// /// The Command Command Object /// DataReader object public iDataReader createDataReader (idbcommand mydbcommand) {return mydbcommand.executeReader ();}
/// /// Get a connection string /// public string getConnectionstring () {string striver = configurationSettings.appsettings ["odbcdriver"]; string strDbq = ConfigurationSettings.appsettings ["odbcdbq"]; string strconnectionstring = "driver = {" strider "}; dbq =" strdbq ";" returnnectionstring;}
}
to be continued......
