SpringMVC项目连接数据库配置

缺乏、安全感 2022-12-23 11:09 156阅读 0赞

### 1、applicationContext.xml（其中有些配置项不需要的可以不配置） ###

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:context="http://www.springframework.org/schema/context"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
        xmlns:tx="http://www.springframework.org/schema/tx" xmlns:p="http://www.springframework.org/schema/p"
        xmlns:util="http://www.springframework.org/schema/util" xmlns:jdbc="http://www.springframework.org/schema/jdbc"
        xmlns:cache="http://www.springframework.org/schema/cache"
        xsi:schemaLocation="
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/jdbc
        http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd
        http://www.springframework.org/schema/cache
        http://www.springframework.org/schema/cache/spring-cache-3.1.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/util
        http://www.springframework.org/schema/util/spring-util.xsd">
    
        
        <context:component-scan base-package="com.99bill.*"></context:component-scan>
    
        
        <bean id="propertyConfigurer"
            class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
            <property name="locations">
                <list>
                    <value>classpath*:jdbc.properties</value>
                </list>
            </property>
        </bean>
        
        
        <import resource="spring-dao.xml"/>
        <import resource="spring-aop.xml"/>
    
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
            init-method="init" destroy-method="close">
            
            <property name="driverClassName" value="${jdbc.driverClassName}" />
            <property name="url" value="${jdbc.url}" />
            <property name="username" value="${jdbc.username}" />
            <property name="password" value="${jdbc.password}" />
    
            
            <property name="initialSize" value="1" />
            <property name="minIdle" value="1" />
            <property name="maxActive" value="20" />
    
            
            <property name="maxWait" value="60000" />
    
            
            <property name="timeBetweenEvictionRunsMillis" value="60000" />
    
            
            <property name="minEvictableIdleTimeMillis" value="300000" />
    
            
            
    
            
            <property name="validationQuery" value="SELECT 1 FROM DUAL" />
    
            <property name="testWhileIdle" value="true" />
            <property name="testOnBorrow" value="false" />
            <property name="testOnReturn" value="false" />
    
            
            <property name="poolPreparedStatements" value="false" />
            <property name="maxPoolPreparedStatementPerConnectionSize"
                value="20" />
    
            
            <property name="filters" value="stat" />
        </bean>
    
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"
            p:dataSource-ref="dataSource" p:configLocation="classpath:mybatis-config.xml"
            p:mapperLocations="classpath:com/99bill/**/resource/mybaits/*.xml" />
    
        
        
        <bean id="sqlSessionFactory"         class="com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"/>
            
            <property name="mapperLocations" value="classpath:conf/mybatis/*mapper.xml"/>
            <property name="configLocation" value="classpath:conf/mybatis/mybatis-config.xml"/>
            <property name="plugins">
                <array>
                    <bean id="paginationInterceptor" class="com.baomidou.mybatisplus.plugins.PaginationInterceptor"/>
                </array>
            </property>
            <property name="globalConfig" ref="globalConfig"/>
        </bean>
        
        <bean id="globalConfig" class="com.baomidou.mybatisplus.entity.GlobalConfiguration">
            <property name="idType" value="3"/>
        </bean>
    
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="basePackage" value="com.byzk.dao"/>
            
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        </bean>
    
        
        <bean id="transactionManager"
            class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
            p:dataSource-ref="dataSource" />
    
        
        <aop:aspectj-autoproxy proxy-target-class="true" />
    
         
        <tx:annotation-driven transaction-manager="transactionManager" />
    
        
        <context:annotation-config/>
        
      　　
        <cache:annotation-driven cache-manager="cacheManager" />
        <bean id="ehCacheManagerFactory"
            class="org.springframework.cache.ehcache.EhCacheManagerFactoryBean"
            p:configLocation="classpath:ehcache.xml" />
        <bean id="cacheManager" class="org.springframework.cache.ehcache.EhCacheCacheManager"
            p:cacheManager-ref="ehCacheManagerFactory" />
    
    </beans>

### 2、jdbc.propertiest ###

#基本属性 driverClassName、url、user、password
    #Mysql配置
    #jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
    
    #Oracle配置
    jdbc.driverClassName=oracle.jdbc.OracleDriver
    
    jdbc.url=jdbc:oracle:thin:@192.168.100.17:1521:orcl
    jdbc.username=kangpeng
    jdbc.password=123456

### 3、mybatis-config.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD SQL Map Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    
    <configuration>
        
        <settings>
            
            <setting name="cacheEnabled" value="true"/>
            
            <setting name="lazyLoadingEnabled" value="true"/>
            <setting name="multipleResultSetsEnabled" value="true"/>
            <setting name="useColumnLabel" value="true"/>
            <setting name="defaultExecutorType" value="REUSE"/>
            <setting name="defaultStatementTimeout" value="25000"/>
        </settings>
    
    </configuration>

### 注意：使用之前要导入相应的数据库和连接池jar包。 ###