spirng的使用（4）：spring整合mybatis

矫情吗；* 2022-05-19 06:48 78阅读 0赞

一、spring整合mybatis的思路

SqlSessionFactory对象应该放到spring容器中作为单例存在。

传统dao的开发方式中，应该从spring容器中获得sqlsession对象。

Mapper代理形式中，应该从spring容器中直接获得mapper的代理对象。

数据库的连接以及数据库连接池事务管理都交给spring容器来完成。

二、spring整合mybatis的流程

1）spring整合mybatis的jar包

除了各个框架和数据库、数据库连接池之外，spring整合mybatis还需要单独的一个spring整合mybatis的jar包

2）mybatis的主要配置文件SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
      PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
      "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    	
    </configuration>

3）spring整合mybatis的配置文件applicationContext.xml，其中这里可以单独的简历一个applicationContext-dao.xml的文件。

主spring的配置文件，其中主spring配置文件加载副配置文件applicationContext-dao.xml

<?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:mvc="http://www.springframework.org/schema/mvc"
        xsi:schemaLocation="
        http://www.springframework.org/schema/beans     http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
    
    
    	<context:component-scan base-package="com.weiwei.aqy.manager.controller"></context:component-scan>
    
    	
    	<bean id="mappingJackson2HttpMessageConverter"
    		class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
    		<property name="supportedMediaTypes">
    			<list>
    				<value>text/html;charset=UTF-8</value>
    			</list>
    		</property>
    	</bean>
    
    	
    	<bean id="stringHttpMessageConverter"
    		class="org.springframework.http.converter.StringHttpMessageConverter">
    		<constructor-arg value="UTF-8" index="0" />
    		<property name="supportedMediaTypes">
    			<list>
    				<value>text/plain;charset=UTF-8</value>
    			</list>
    		</property>
    	</bean>
    	
    	<bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping"/>
    	<bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter">
    		<property name="messageConverters">
    			<list>
    				<ref bean="stringHttpMessageConverter" />
    			</list>
    		</property>
    	</bean>
    	
    	
    	<mvc:annotation-driven />
    
    	
    	<bean
    		class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" />
    
    	
    	<bean
    		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    		<property name="viewClass"
    			value="org.springframework.web.servlet.view.JstlView" />
    		<property name="prefix" value="/WEB-INF/jsp/" />
    		<property name="suffix" value=".jsp" />
    	</bean>
    
    </beans>

关于在spring里面的mybatis配置文件applicationContext-dao.xml

<?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:tx="http://www.springframework.org/schema/tx"
        xsi:schemaLocation="
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
    
        
        <context:property-placeholder location="classpath:jdbc.properties" />
    
        
    	<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource"
    		destroy-method="close">
    		<property name="driverClassName" value="${jdbc.driver}" />
    		<property name="jdbcUrl" value="${jdbc.url}" />
    		<property name="username" value="${jdbc.username}" />
    		<property name="password" value="${jdbc.password}" />
    		<property name="readOnly" value="false" />
    		<property name="idleTimeout" value="1000000" />
    		<property name="maxLifetime" value="25200000" />
    		<property name="connectionTimeout" value="3000000" />
    		<property name="maximumPoolSize" value="10" />
    		<property name="connectionTestQuery" value="select 1" />
    		<property name="dataSourceProperties">
    			<props>
    				<prop key="cachePrepStmts">true</prop>
    				<prop key="prepStmtCacheSize">250</prop>
    				<prop key="prepStmtCacheSqlLimit">2048</prop>
    				<prop key="useServerPrepStmts">true</prop>
    				<prop key="useLocalSessionState">true</prop>
    				<prop key="useLocalTransactionState">true</prop>
    				<prop key="rewriteBatchedStatements">true</prop>
    				<prop key="cacheResultSetMetadata">true</prop>
    				<prop key="cacheServerConfiguration">true</prop>
    				<prop key="elideSetAutoCommits">true</prop>
    				<prop key="maintainTimeStats">false</prop>
    			</props>
    		</property>
    	</bean>
    
        
    
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		<property name="dataSource" ref="dataSource" />
    		
    
    		<property name="mapperLocations" value="classpath:com/qizhi/aqy/manager/mapper/*.xml" />
    		<property name="configLocation" value="classpath:mybatis/mybatis-conf.xml"></property>
    	</bean>
    
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		
    		<property name="basePackage" value="com.qizhi.aqy.manager.dao" />
    		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
    	</bean>
    	
    
    	
    	<tx:annotation-driven transaction-manager="transactionManager" />
    	
    	<bean id="transactionManager"
    		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    		<property name="dataSource" ref="dataSource" />
    	</bean>
    
    </beans>

4）数据库的配置jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://ip:port/databasename?useUnicode=true&characterEncoding=UTF-8
    jdbc.username=name
    jdbc.password=password
    
    jdbc.initialPoolSize = 5
    jdbc.maxPoolSize = 50
    jdbc.minPoolSize = 5
    jdbc.maxIdleTime = 1800
    jdbc.acquireIncrement = 5
    jdbc.maxStatements = 1000
    jdbc.idleConnectionTestPeriod = 30

5）Mapper代理形式开发