spring与ibatis结合

1： sql-map-config.xml? 中配置

?

<sqlMapConfig>
?<properties resource="db-dialect.properties" />
?<settings cacheModelsEnabled="true" enhancementEnabled="true"
??lazyLoadingEnabled="false" errorTracingEnabled="true" maxRequests="32"
??maxSessions="10" maxTransactions="5" useStatementNamespaces="true" />
??? <sqlMap resource="com/nstc/sql/${dialect}/HRInterface.xml" />
???
</sqlMapConfig>

?

（说明：db-dialect.properties 为编译后在classes目录下的文件，文件内容：dialect=oracle，目的：可配置性）

?

2：基类?? BaseDao

?

public class BaseDao extends SqlMapClientDaoSupport{

???
}

?

3：applicationContext.xml中如下配置

?

?<bean id="propertyConfigurer"
??????? />
??? </property>?
? </bean>

?

? <bean id="baseDao"
??????? />
??? </property>

?

<bean? id="hrDao"? parent="baseDao"></bean〉

?

?

4：在hrdao中使用

?

public class HRInterfaceDao extends BaseDao {

?

?public? String? getHRMessage(String vcEmployeeID){
??
??Integer?? count = (Integer)this.getSqlMapClientTemplate().queryForObject

?

? ("HRInter.getHRMessage",vcEmployeeID);
????
???? return? count+"";
?}

?

?public? void?? updateHRMessage(EmpMessageInfo? empMessageInfo){
??
??this.getSqlMapClientTemplate().update("HRInter.updateHRMessage",empMessageInfo);

?}

?

?public? void?? insertHRMessage(EmpMessageInfo? empMessageInfo){
??
??this.getSqlMapClientTemplate().insert("HRInter.insertHRMessage",empMessageInfo);
??
?}

?

?

?

}