数据访问层设计(多库操作)（3）

 5、数据库配置，可写在WEB》CONFIG或APP》CONFIG中

<?xml version="1.0" encoding="utf-8" ?>
<configuration>

 <configSections>
  <!-- 数据库配置节设置 -->
  <sectionGroup name="DBSettings">
   <section name="DBSetting" type="HKH.DataBase.Config.clsDbSettingSectionHandler,HKHDBAccess" />
  </sectionGroup>
 </configSections>

 <!-- 数据库配置，可配置多项 -->
 <DBSettings>
  <DBSetting name="sqlConn" daoBuilder="HKH.DataBase.Sql.clsSqlDAOBuilder,HKHDBAccess" dbAccess="HKH.DataBase.Sql.clsSqlDBAccess,HKHDBAccess"
   default="true">
   <connParam name="Data Source" value="lwt" />
   <connParam name="Initial Catalog" value="DBTest" />
   <connParam name="User ID" value="sa" />
   <connParam name="Password" value="sa" />
   <connParam name="Integrated Security" value="false" />
   <connParam name="Connect Timeout" value="60" />
  </DBSetting>
  <DBSetting name="odbcConn" daoBuilder="HKH.DataBase.Odbc.clsOdbcDAOBuilder,HKHDBAccess" dbAccess="HKH.DataBase.Odbc.clsOdbcDBAccess,HKHDBAccess">
   <connParam name="Provider" value="" />
   <connParam name="Data Source" value="lwt" />
   <connParam name="Initial Catalog" value="DBTest" />
   <connParam name="User ID" value="sa" />
   <connParam name="Password" value="sa" />
   <connParam name="Integrated Security" value="false" />
   <connParam name="Connect Timeout" value="60" />
  </DBSetting>
  <DBSetting name="oleDbConn" daoBuilder="HKH.DataBase.OleDb.clsOleDbDAOBuilder,HKHDBAccess"
   dbAccess="HKH.DataBase.OleDb.clsOleDbDBAccess,HKHDBAccess">
   <!-- Mode值 Read/ReadWrite/Share Deny None/Share Deny Read/Share Deny Write/Share Exclusive/Write-->
   <connParam name="Provider" value="Microsoft.Jet.OLEDB.4.0" />
   <connParam name="Data Source" value="lwt" />
   <connParam name="Initial Catalog" value="C:/Documents and Settings/Administrator/My Documents/oletest.mdb" />
   <connParam name="User ID" value="Admin" />
   <connParam name="Password" value="" />
   <connParam name="Integrated Security" value="false" />
   <connParam name="Connect Timeout" value="60" />
   <connParam name="Extended Properties" value="" />
   <connParam name="Mode" value="ReadWrite" />
  </DBSetting>
 </DBSettings>

 <appSettings>
 </appSettings>
</configuration>