灵活配置数据源

小咪咪 2022-05-14 15:26 155阅读 0赞

spring配置文件里配置：mybatis-spring.xml
    第一种：
     
    
     <context:property-placeholder location="zscbbs.properties"/>
    
        <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
            <property name="driverClassName" value="${driver}"/>
            <property name="url" value="${url}"/>
            <property name="username" value="${user}"/>
            <property name="password" value="${password}"/>
        </bean>
    
    
    第二种：
    服务器配置文件context.xm文件里配置：
    <Resource name="jdbcMysql"
    		  auth="Container" type="javax.sql.DataSource" maxActive="100"
    		  maxIdle="30" maxWait="10000" username="root" password="root"
    		  driverClassName="com.mysql.jdbc.Driver"
    		  url="jdbc:mysql://localhost:3306/kgcnews?useUnicode=true&characterEncoding=utf8" />
    
    spring配置文件里配置：mybatis-spring.xml
    
        <bean id="dataSourceTwo"  class="org.springframework.jndi.JndiObjectFactoryBean" >
             <property name="jndiName" >
                
                <value>java:comp/env/jdbcMysql</value>
             </property>
    
        </bean>
    
    
        下面是mybais和spring整合运用数据源：
        spring配置文件配置：
        
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"></property>
            
            <property name="configLocation" value="classpath:mybatis-config.xml"></property>
            
            <property name="mapperLocations">
                <list>
                    <value>classpath:cn/kgc/mappers/detailMapper.xml</value>
                </list>
            </property>
        </bean>
        
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="cn.kgc.dao"/>
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        </bean>
    
        
        <context:component-scan base-package="cn.kgc.service"></context:component-scan>