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>