IBatis配置sqlmap.config

DAL中读取时可采取以下方式传入文件路径:

 DomSqlMapBuilder builder = new DomSqlMapBuilder();

ISqlMapper  _mapper = builder.Configure(sqlMapPath);

 

文件名：SqlMap.config

<?xml version="1.0" encoding="UTF-8" ?>
<sqlMapConfig xmlns="http://ibatis.apache.org/dataMapper" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="SqlMapConfig.xsd">

  <!--
   resource：资源文件，为程序根目录开始的路径，
     相对路径用resource='Resources/a.xml',相对路径只能由程序根目录开始；
   url:绝对路径用, url='file:///f:/a.config' 表示；
   embedded:调用内嵌资源，embedded="Web.configs.IBatis.properties.config"
   
   <properties resource="properties/database.properties"/>
    可将SqlMap中的<property />内容写到配置文件中，从此处引用:
      <add key="userid" value="xiaoming" />
    SQL Map配置文件及其每个映射文件都可以使用占位符${key}:
      <sqlMap resource="${userid}/Resources/Order.xml"/>
-->

  <!--自定义属性配置-->
  <properties embedded="Web.configs.IBatis.properties.config" />

  <!--数据库驱动配置-->
  <providers resource="configs/IBatis/providers.config"/>
 
  <!--数据库配置-->
  <database>
    <provider name="sqlServer1.1"/>
    <!--
    <dataSource name="NPetshop" connectionString="server=(local);database=iBatisDemo;uid=sa;pwd=123123;"/>
    <dataSource name="NPetshop" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\db1.mdb;"/>
    -->
    <dataSource name="NPetshop1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=${dbFileName};Integrated Security=True;User Instance=True"/>
    <!--
    <dataSource name="NPetshop2" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Copy of iBatisDemo_Data.mdf;Integrated Security=True;User Instance=True"/>
    <provider name="oracle9.2"/>
    <dataSource name="ibatisDemo" connectionString="Data Source=GZRDKF;Persist Security Info=True;User ID=p_cashback;password=data"/>
    -->

  </database>

  <!--model对应sql处理配置-->
  <sqlMaps>
    <!--各个xml的别名配置不要重复alias="PagerItem"-->
      <sqlMap resource="configs/IBatis/Resources/Order.xml"/>
      <sqlMap resource="configs/IBatis/Resources/Custom.xml"/>
      <sqlMap resource="configs/IBatis/Resources/Product.xml"/>
   </sqlMaps>

  </sqlMapConfig>