SSI框架整合配置

applicationContext配置文件：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
 xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
 xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-2.5.xsd
           http://www.springframework.org/schema/aop
           http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
           http://www.springframework.org/schema/tx
           http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
 <context:annotation-config/>
  <context:component-scan base-package="com.tr"/>
 <bean id="ds" destroy-method="close"
  class="org.apache.commons.dbcp.BasicDataSource">
  <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
  <property name="url" value="jdbc:oracle:thin:@localhost:1521:ORCL" />
  <property name="username" value="system" />
  <property name="password" value="sa123456" />
  
 </bean>

 <bean id = "sqlMapClient" class = "org.springframework.orm.ibatis.SqlMapClientFactoryBean">
     <property name="configLocation">
       <value>classpath:com/tr/sqlMapClient/SqlMapConfig.xml</value>
     </property>
     <property name="useTransactionAwareDataSource">
       <value>true</value>
     </property>
     <property name="dataSource">
       <ref bean="ds"/>
     </property>
    
 </bean>
 <bean id = "sqlMapClientTemplate"
     class="org.springframework.orm.ibatis.SqlMapClientTemplate">
     <property name="sqlMapClient">
        <ref bean="sqlMapClient"/>
     </property>
 </bean>
</beans>

 

dao层的使用：

 

@Component
public class UserDao  implements Serializable {

 /**
  *
  */
 

 @Resource
 private SqlMapClient sqlMapClient ;
 
 

 private static final long serialVersionUID = 4895988913787447753L;

 public List<User> getAllUser() throws SQLException{
  
  return  sqlMapClient.queryForList("getAllUser");
 }
}