Spring与Mybatis的整合之Mapper代理的整合方式

ゞ浴缸里的玫瑰 2022-07-13 01:50 155阅读 0赞

1.项目的目录

![20161120161210341][]

2.将Mapper和Mapper.xml放在同一个目录

![20161120161340836][]          ![20161120161350732][]

3.applicationContext.xml的配置文件

**\[html\]**  [view plain][]   [copy][view plain]

[print][view plain] [?][view plain] [![在CODE上查看代码片][CODE]][CODE_CODE] [![派生到我的代码片][ico_fork.svg]][ico_fork.svg 1]

1.  **<****beans** xmlns="http://www.springframework.org/schema/beans"  
2.      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"  
3.      xmlns:context="http://www.springframework.org/schema/context"  
4.      xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"  
5.      xsi:schemaLocation="http://www.springframework.org/schema/beans   
6.          http://www.springframework.org/schema/beans/spring-beans-3.2.xsd   
7.          http://www.springframework.org/schema/mvc   
8.          http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd   
9.          http://www.springframework.org/schema/context   
10.         http://www.springframework.org/schema/context/spring-context-3.2.xsd   
11.         http://www.springframework.org/schema/aop   
12.         http://www.springframework.org/schema/aop/spring-aop-3.2.xsd   
13.         http://www.springframework.org/schema/tx   
14.         http://www.springframework.org/schema/tx/spring-tx-3.2.xsd "**>**  
15.   
16.       
17.     **<****context:property-placeholder** location="classpath:db.properties" **/>**  
18.       
19.     **<****bean** id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"  
20.         destroy-method="close"**>**  
21.         **<****property** name="driverClassName" value="$\{jdbc.driver\}" **/>**  
22.         **<****property** name="url" value="$\{jdbc.url\}" **/>**  
23.         **<****property** name="username" value="$\{jdbc.username\}" **/>**  
24.         **<****property** name="password" value="$\{jdbc.password\}" **/>**  
25.         **<****property** name="maxActive" value="10" **/>**  
26.         **<****property** name="maxIdle" value="5" **/>**  
27.     **</****bean****>**  
28.   
29.   
30.       
31.     **<****bean** id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"**>**  
32.           
33.         **<****property** name="dataSource" ref="dataSource" **/>**  
34.           
35.         **<****property** name="configLocation" value="classpath:SqlMapConfig.xml" **/>**  
36.     **</****bean****>**  
37.   
38.   
39.       
40.       
41.     **<****bean** class="org.mybatis.spring.mapper.MapperScannerConfigurer"**>**  
42.           
43.         **<****property** name="basePackage" value="com.mybatis.mapper" **/>**  
44.           
45.         **<****property** name="sqlSessionFactoryBeanName" value="sqlSessionFactory" **/>**  
46.     **</****bean****>**  
47.   
48.       
49.     **<****bean** id="userService" class="com.mybatis.service.UserService"**>**  
50.         **<****property** name="userMapper" ref="userMapper" **/>**  
51.     **</****bean****>**  
52.   
53.       
54.       
55.       
56.     **<****bean** id="txManager"  
57.         class="org.springframework.jdbc.datasource.DataSourceTransactionManager"**>**  
58.         **<****property** name="dataSource" ref="dataSource"**>****</****property****>**  
59.     **</****bean****>**  
60.   
61.       
62.     **<****tx:advice** id="txAdvice" transaction-manager="txManager"**>**  
63.         **<****tx:attributes****>**  
64.             **<****tx:method** name="find\*" read-only="true" **/>**  
65.             **<****tx:method** name="insert\*" propagation="REQUIRED"  **/>**  
66.             **<****tx:method** name="delete\*" propagation="REQUIRED" **/>**  
67.             **<****tx:method** name="update\*" propagation="REQUIRED" **/>**  
68.             **<****tx:method** name="\*" read-only="true" **/>**  
69.         **</****tx:attributes****>**  
70.     **</****tx:advice****>**  
71.   
72.       
73.     **<****aop:config****>**  
74.         **<****aop:pointcut** expression="execution(\* com.mybatis.service.\*.\*(..))"  
75.             id="pt" **/>**  
76.         **<****aop:advisor** advice-ref="txAdvice" pointcut-ref="pt" **/>**  
77.     **</****aop:config****>**  
78.   
79. **</****beans****>**

4.db.properties

**\[javascript\]**  [view plain][]   [copy][view plain]

[print][view plain] [?][view plain] [![在CODE上查看代码片][CODE]][CODE_CODE] [![派生到我的代码片][ico_fork.svg]][ico_fork.svg 1]

1.  jdbc.driver=com.mysql.jdbc.Driver  
2.  jdbc.url=jdbc:mysql://localhost:3306/mybatistest  
3.  jdbc.username=root  
4.  jdbc.password=1234

[5.源码下载][5.]

[20161120161210341]: /images/20220713/210d97eec0cd4dbf861c5e2b9e468d0b.png
[20161120161340836]: https://img-blog.csdn.net/20161120161340836
[20161120161350732]: /images/20220713/103de98d4369451da3e0847a6fefe88a.png
[view plain]: http://blog.csdn.net/zbw18297786698/article/details/53241383#
[CODE]: https://code.csdn.net/assets/CODE_ico.png
[CODE_CODE]: https://code.csdn.net/snippets/1995677
[ico_fork.svg]: https://code.csdn.net/assets/ico_fork.svg
[ico_fork.svg 1]: https://code.csdn.net/snippets/1995677/fork
[5.]: http://download.csdn.net/detail/zbw18297786698/9687986