using?System;
using?System.Collections;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Data;
using?System.Data.Common;
using?System.Data.SqlClient;
using?System.Data.OracleClient;
using?MySql.Data.MySqlClient;?

namespace?DBUtility
{
????public?class?DbFactory
????{
????????public?static?string?cnString?=?System.Configuration.ConfigurationSettings.AppSettings[“ConnString“];
????????public?static?string?dbFlag?=?System.Configuration.ConfigurationSettings.AppSettings[“DbFlag“];

????????public?static?DbConnection?CreateConnection（）
????????{
????????????DbConnection?cn?=?null;

????????????switch?（dbFlag）
????????????{
????????????????case?“1“:
????????????????????cn?=?new?SqlConnection（cnString）;
????????????????????break;
????????????????case?“2“:
????????????????????cn?=?new?OracleConnection（cnString）;
????????????????????break;
????????????????case?“3“:
????????????????????cn?=?new?MySqlConnection（cnString）;
????????????????????break;
????????????}

????????????return?cn;
????????}

????????public?static?DbCommand?CreateCommand（DbConnection?cn）
????????{
????????????DbCommand?cmd?=?null;
????????????switch?（dbFlag）
????????????{
????????????????case?“1“:
????????????????????cmd?=?new?SqlCommand（）;
????????????????????cmd.Connection?=?cn;
????????????????????break;
????????????????case?“2“:
????????????????????cmd?=?new?OracleCommand（）;
????????????????????cmd.Connection?=?cn;
????????????????????break;
????????????????case?“3“:
????????????????????cmd?=?new?MySqlCommand（）;
????????????????????cmd.Connection?=?cn;
????????????????????break;
????????????}

????????????return?cmd;
????????}

????????public?static?DbDataAdapter?CreateDataAdapter（）
????????{
????????????DbDataAdapter?dba?=?null;
????????????switch?（dbFlag）
????????????{
????????????????case?“1“:
????????????????????dba?=?new?SqlDataAdapter（）;
????????????????????break;
????????????????case?“2“:
????????????????????dba?=?new?OracleDataAdapter（）;
????????????????????break;
????????????????case?“3“:
????????????????????dba?=?new?MySqlDataAdapter（）;
????????????????????break;
????????????}

????????????return?dba;
????????}

????????public?static?DbParameter[]?CreateParameter（Dictionary?para）
????????{
????????????DbParameter[]?dbPara?=?null;
????????????int?i?=?0;

????????????switch?（dbFlag）
????????????{
????????????????case?“1“:
????????????????????dbPara?=?new?SqlParameter[para.Count];
????????????????????foreach?（KeyValuePair?dic?in?para）
????????????????????{
????????????????????????dbPara[i]?=?new?SqlParameter（“@“?+?dic.Key?dic.Value）;
????????????????????????i++;
????????????????????}
????????????????????break;
????????????????case?“2“:
????????????????????dbPara?=?new?OracleParameter[para.Count];
????????????????????foreach?（KeyValuePair?dic?in?para）
????????????????

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????5100??2013-10-17?11:28??簡(jiǎn)單三層+wcf\Applicationframe\Applicationframe.sln

????..A..H.????155648??2013-10-21?10:53??簡(jiǎn)單三層+wcf\Applicationframe\Applicationframe.v11.suo

?????文件???????9216??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\bin\Debug\DBUtility.dll

?????文件??????22016??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\bin\Debug\DBUtility.pdb

?????文件?????294912??2013-05-22?17:21??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\bin\Debug\MySql.Data.dll

?????文件???????5120??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\bin\Debug\ProjectModel.dll

?????文件??????15872??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\bin\Debug\ProjectModel.pdb

?????文件???????3575??2013-10-21?10:45??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\DbFactory.cs

?????文件???????5798??2013-10-16?16:40??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\DBHelper.cs

?????文件???????2911??2013-10-16?17:47??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\DBUtility.csproj

?????文件???????1639??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\obj\Debug\DBUtility.csproj.FileListAbsolute.txt

?????文件??????11229??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\obj\Debug\DBUtility.csprojResolveAssemblyReference.cache

?????文件???????9216??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\obj\Debug\DBUtility.dll

?????文件??????22016??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\obj\Debug\DBUtility.pdb

?????文件???????6853??2013-10-17?10:11??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件??????????0??2013-10-08?10:08??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

?????文件??????????0??2013-10-08?10:08??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

?????文件??????????0??2013-10-08?10:08??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

?????文件???????1338??2013-10-08?10:08??簡(jiǎn)單三層+wcf\Applicationframe\DBUtility\Properties\AssemblyInfo.cs

?????文件???????9216??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\ProjectAccess\bin\Debug\DBUtility.dll

?????文件??????22016??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\ProjectAccess\bin\Debug\DBUtility.pdb

?????文件?????294912??2013-05-22?17:21??簡(jiǎn)單三層+wcf\Applicationframe\ProjectAccess\bin\Debug\MySql.Data.dll

?????文件???????5632??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\ProjectAccess\bin\Debug\ProjectAccess.dll

?????文件??????11776??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\ProjectAccess\bin\Debug\ProjectAccess.pdb

?????文件???????5120??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\ProjectAccess\bin\Debug\ProjectModel.dll

?????文件??????15872??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\ProjectAccess\bin\Debug\ProjectModel.pdb

?????文件???????6818??2013-10-17?10:12??簡(jiǎn)單三層+wcf\Applicationframe\ProjectAccess\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????1824??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\ProjectAccess\obj\Debug\ProjectAccess.csproj.FileListAbsolute.txt

?????文件??????16227??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\ProjectAccess\obj\Debug\ProjectAccess.csprojResolveAssemblyReference.cache

?????文件???????5632??2013-10-21?10:46??簡(jiǎn)單三層+wcf\Applicationframe\ProjectAccess\obj\Debug\ProjectAccess.dll

............此處省略192個(gè)文件信息