SpringMVC-12-(ssm集成其它数据源的配置)

╰+攻爆jí腚メ 2022-03-07 00:58 89阅读 0赞

# 12【掌握】ssm集成其它数据源的配置 #

## 1.创建db.properties ##

driverClassName=com.mysql.jdbc.Driver
    url=jdbc:mysql://127.0.0.1:3306/test
    username=root
    password=123456

## 2.使用springjdbc ##

org.springframework.jdbc.datasource.DriverManagerDataSource

<context:property-placeholder location="classpath:db.properties" 
         system-properties-mode="FALLBACK"/>
            
    	
    	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    		
    		<property name="driverClassName" value="${driverClassName}"></property>
    		<property name="url" value="${url}"></property>
    		<property name="username" value="${username}"></property>
    		<property name="password" value="${password}"></property>
    	</bean>

## 3.使用c3p0 \[基本不能使用了\] ##

**导包**  
c3p0-0.9.2.1.jar mchange-commons-java-0.2.3.4.jar  
**配置application-dao.xml**

<bean id="dataSource2" class="com.mchange.v2.c3p0.DriverManagerDataSource">
    		<property name="driverClass" value="${driverClassName}"></property>
    		<property name="jdbcUrl" value="${url}"></property>
    		<property name="user" value="${username}"></property>
    		<property name="password" value="${password}"></property>
    	</bean>

## 4.使用dbcp2 ##

**导包**  
![在这里插入图片描述][20190315212121155.png]  
**配置application-dao.xml**

<bean id="dataSource3" class="org.apache.commons.dbcp.BasicDataSource">
    		
    		<property name="driverClassName" value="${driverClassName}"></property>
    		<property name="url" value="${url}"></property>
    		<property name="username" value="${username}"></property>
    		<property name="password" value="${password}"></property>
    	</bean>

## 5.使用druid ##

在开发中很的非常多  
阿里巴巴提供的  
fastjson  
druid  
zk  
db  
**导包**  
![在这里插入图片描述][20190315212143466.png]  
**配置application-dao.xml**

<bean id="dataSource4" class="com.alibaba.druid.pool.DruidDataSource">
    		
    		<property name="driverClassName" value="${driverClassName}"></property>
    		<property name="url" value="${url}"></property>
    		<property name="username" value="${username}"></property>
    		<property name="password" value="${password}"></property>
    		
    		<property name="initialSize" value="5"></property>
    		
    		<property name="maxActive" value="20"></property>
    	</bean>

**配置druid的监控页面**

<servlet>
    		<servlet-name>StatViewServlet</servlet-name>
    		<servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
    		
    		<init-param>
    			<param-name>loginUsername</param-name>
    			<param-value>root</param-value>
    		</init-param>
    		<init-param>
    			<param-name>loginPassword</param-name>
    			<param-value>123456</param-value>
    		</init-param>
    		<init-param>
    			
    			<param-name>allow</param-name>
    			<param-value></param-value>
    		</init-param>
    		<init-param>
    			
    			<param-name>deny</param-name>
    			<param-value>192.169.2.111</param-value>
    		</init-param>
    	</servlet>
    	
    	<servlet-mapping>
    		<servlet-name>StatViewServlet</servlet-name>
    		<url-pattern>/druid/*</url-pattern>
    	</servlet-mapping>
    	
    	<filter>
    		<filter-name>WebStatFilter</filter-name>
    		<filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class>
    		<init-param>
                <param-name>exclusions</param-name>
                
                <param-value>*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*</param-value>
            </init-param>
    	</filter>
    	<filter-mapping>
    		<filter-name>WebStatFilter</filter-name>
            <url-pattern>/*</url-pattern>
    	</filter-mapping>

**修改application-dao.xml**  
![在这里插入图片描述][20190315212228353.png]

[20190315212121155.png]: /images/20220307/292f908f602645b99bfd7d6604b21951.png
[20190315212143466.png]: /images/20220307/2fc697e2abce4b4ea1fe7c3e68697554.png
[20190315212228353.png]: /images/20220307/e776c79c47b4497691db1d3ef1c8a1c0.png