mybatis(五) --springmvc和mybatis整合

冷不防 2022-04-22 15:50 144阅读 0赞

**         spring和mybatis整合**

1.整合思路：

需要spring通过单例方式管理SqlSessionFactory。spring和mybatis整合生成代理对象，使用SqlSessionFactory创建SqlSession。（spring和mybatis整合自动完成）持久层的mapper都需要由spring进行管理。

2.整合环境：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTE2MTY1NjAw_size_16_color_FFFFFF_t_70][]

3.sqlSessionFactory配置

在applicationContext.xml配置sqlSessionFactory和数据源 sqlSessionFactory在mybatis和spring的整合包下。

<context:property-placeholder location="classpath:db.properties" />
    
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
    		destroy-method="close">
    		<property name="driverClassName" value="${jdbc.driver}" />
    		<property name="url" value="${jdbc.url}" />
    		<property name="username" value="${jdbc.username}" />
    		<property name="password" value="${jdbc.password}" />
    		<property name="maxActive" value="10" />
    		<property name="maxIdle" value="5" />
    	</bean>
    
    
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="configLocation" value="mybatis/SqlMapConfig.xml" />
    		
    		<property name="dataSource" ref="dataSource" />
    	</bean>

4.原始DAO开发(和spring整个后)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTE2MTY1NjAw_size_16_color_FFFFFF_t_70 1][]

![20190114134550548.png][]

5. DAO（实现类继承sqlSessionDaoSupport）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTE2MTY1NjAw_size_16_color_FFFFFF_t_70 2][]

6 配置DAO：

在applicationContext.xml中配置dao：

![20190114134700706.png][]

7.测试代码：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTE2MTY1NjAw_size_16_color_FFFFFF_t_70 3][]

9. mapper代理开发：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTE2MTY1NjAw_size_16_color_FFFFFF_t_70 4][]

通过MapperScannerConfigure进行mapper扫描（建议使用）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTE2MTY1NjAw_size_16_color_FFFFFF_t_70 5][]

测试代码：

![20190114134832483.png][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTE2MTY1NjAw_size_16_color_FFFFFF_t_70]: /images/20220327/55d9215e4c4a470aa3ac7f32726c7587.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTE2MTY1NjAw_size_16_color_FFFFFF_t_70 1]: /images/20220327/a9e07fd1bfbb48a88d86b13d5a953d9d.png
[20190114134550548.png]: /images/20220327/857b1d2c5a6b48c3ab6c1fbf0f1c3c59.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTE2MTY1NjAw_size_16_color_FFFFFF_t_70 2]: /images/20220327/61b53170825f40b7ac7e628b1768934d.png
[20190114134700706.png]: /images/20220327/2b782fda1a844da78e4e26353a9b49d7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTE2MTY1NjAw_size_16_color_FFFFFF_t_70 3]: /images/20220327/c0e7e178cf9e47188a960aee753f8678.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTE2MTY1NjAw_size_16_color_FFFFFF_t_70 4]: /images/20220327/67bfb83a0d204aecad0da0129ee8ba0c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxMTE2MTY1NjAw_size_16_color_FFFFFF_t_70 5]: /images/20220327/5302c982a1de489592febc44b7822fb0.png
[20190114134832483.png]: /images/20220327/5d4bb982671c40948f314efd91d7fc9c.png