spring dao xml配置

深藏阁楼爱情的钟 2022-05-28 01:21 210阅读 0赞

##  ##

spring-dao.xml,spring整合mybatis和redis
    <?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"  
        xsi:schemaLocation="http://www.springframework.org/schema/beans  
        http://www.springframework.org/schema/beans/spring-beans.xsd  
        http://www.springframework.org/schema/context  
        http://www.springframework.org/schema/context/spring-context.xsd">  
          
          
        <context:property-placeholder location="classpath:jdbc.properties" />  
      
          
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">  
              
            <property name="driverClass" value="${jdbc.driver}" />  
            <property name="jdbcUrl" value="${jdbc.url}" />  
            <property name="user" value="${jdbc.username}" />  
            <property name="password" value="${jdbc.password}" />  
      
            
    	  
    	<property name="idleConnectionTestPeriod" value="60"/>
    	
    	<property name="initialPoolSize" value="5"/>
            <property name="maxPoolSize" value="30" />  
            <property name="minPoolSize" value="10" /> 
            
            <property name="maxIdleTime" value="60"/> 
            
            <property name="maxStatements" value="100"/>
            
            <property name="maxStatementsPerConnection" value="3"/>
            
            <property name="preferredTestQuery" value="select1"/>
              
            <property name="autoCommitOnClose" value="false" />  
              
            <property name="acquireRetryAttempts" value="3" /> 
            
            <property name="acquireRetryDelay" value="1000"/>
            
            <property name="checkoutTimeout" value="3000"/> 
        </bean>  
      
          
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
              
            <property name="dataSource" ref="dataSource" />  
              
            <property name="configLocation" value="classpath:mybatis-config.xml" />  
              
            <property name="typeAliasesPackage" value="org.seckill.entity" />  
              
            <property name="mapperLocations" value="classpath:mapper/*.xml" />  
        </bean>  
      
          
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
              
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />  
              
            <property name="basePackage" value="org.seckill.dao" />  
        </bean>  
      
          
        <bean id="redisDao" class="org.seckill.dao.cache.RedisDao">  
            <constructor-arg index="0" value="localhost" />  
            <constructor-arg index="1" value="6379" />  
        </bean>  
      
    </beans>