Tracy.Bai

Focus on Data analysis and Mining

导航

看实例学spring.net--使用Data Access

1. 配置web.config
<configSections>
    <sectionGroup name="common">
      <section name="logging" type="Common.Logging.ConfigurationSectionHandler, Common.Logging" />
    </sectionGroup>
    <sectionGroup name="spring">
      <section name="typeAliases" type="Spring.Context.Support.TypeAliasesSectionHandler, Spring.Core"/>
      <section name="parsers" type="Spring.Context.Support.NamespaceParsersSectionHandler, Spring.Core"/>
      <section name="context" type="Spring.Context.Support.WebContextHandler, Spring.Web"/>
      <section name="objects" type="Spring.Context.Support.DefaultSectionHandler, Spring.Core"/>
    </sectionGroup>
    <section name="databaseSettings" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
  </configSections>

 <spring>
    <parsers>
      <parser type="Spring.Data.Config.DatabaseNamespaceParser, Spring.Data" />
    </parsers>

<objects xmlns="http://www.springframework.net"
         xmlns:db="http://www.springframework.net/database">

  <description>
    The SpringAir object definitions for the Data Access Objects.
  </description>

  <!-- Property placeholder configurer for database settings -->
  <object type="Spring.Objects.Factory.Config.PropertyPlaceholderConfigurer, Spring.Core">
    <property name="ConfigSections" value="databaseSettings"/>
  
  </object>

  <!-- Production Data Access Objects -->
  <db:provider id="dbProvider"
                 provider="SqlServer-2.0"
                 connectionString="Server=${db.server};Integrated Security=no;User ID=${db.user};PWD=${db.password};initial catalog=${db.schema};"/>

  <object id="adoTemplate" type="Spring.Data.Generic.AdoTemplate, Spring.Data">
    <property name="DbProvider" ref="dbProvider"/>
  </object>

  <object id="commandcallbackdao" type="Spring.Net.DataAccess.ADO.CommandCallbackDao, Spring.Net.DataAccess.ADO">
    <property name="AdoTemplate" ref="adoTemplate"/>
  </object>
</objects><objects xmlns="http://www.springframework.net">
      <object type="Default.aspx">
        <property name="CmdDao" ref="commandcallbackdao"></property>
      </object>
</objects>
  </spring>
2. 在UI层调用
private CommandCallbackDao cmdDao;
protected void Page_Load(object sender, EventArgs e)
        {
            Response.Write(cmdDao.FindCountWithPostalCodeWithDelegate("12209"));
        }

posted on 2008-06-12 18:37  Love Fendi  阅读(1199)  评论(0编辑  收藏  举报