Spring整合Mybatis方式一 - 常规整合 - 注册映射器

前置工作

• 导包（mybatis-spring、mysql-connector-java、mybatis、spring-webmvc等）
  
• 实体类
  
• DAO层两个文件（接口、xml文件）；Service层的接口
  

编写Spring管理mybatis的xml-spring-dao.xml

核心代码（两种方式实现）

第一种：xml

1. <bean id="sqlSessionFactory" >
2.   <property name="dataSource" ref="dataSource" />
3.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
4. </bean>
7. <bean id="userMapper" >
8.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
9.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
10. </bean>

复制代码

第二种：annotation方式
点击查看代码

1. @Bean
2. public SqlSessionFactory sqlSessionFactory() throws Exception {
3.   SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
4.   factoryBean.setDataSource(dataSource());
5.   return factoryBean.getObject();
6. }
8. @Bean
9. public MapperFactoryBean<UserMapper> userMapper() throws Exception {
10. <mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
13.     MapperFactoryBean<UserMapper> factoryBean = new MapperFactoryBean<>(UserMapper.class);
14. <mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
17.     factoryBean.setSqlSessionFactory(sqlSessionFactory());
18. <mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
21.     return factoryBean;
22. }

复制代码

完整xml文件

1. <bean id="sqlSessionFactory" >
2.   <property name="dataSource" ref="dataSource" />
3.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
4. </bean>
7. <bean id="userMapper" >
8.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
9.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
10. </bean><bean id="sqlSessionFactory" >
11.   <property name="dataSource" ref="dataSource" />
12.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
13. </bean>
16. <bean id="userMapper" >
17.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
18.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
19. </bean><bean id="sqlSessionFactory" >
20.   <property name="dataSource" ref="dataSource" />
21.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
22. </bean>
25. <bean id="userMapper" >
26.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
27.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
28. </bean><bean id="sqlSessionFactory" >
29.   <property name="dataSource" ref="dataSource" />
30.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
31. </bean>
34. <bean id="userMapper" >
35.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
36.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
37. </bean><bean id="sqlSessionFactory" >
38.   <property name="dataSource" ref="dataSource" />
39.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
40. </bean>
43. <bean id="userMapper" >
44.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
45.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
46. </bean><bean id="sqlSessionFactory" >
47.   <property name="dataSource" ref="dataSource" />
48.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
49. </bean>
52. <bean id="userMapper" >
53.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
54.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
55. </bean><bean id="sqlSessionFactory" >
56.   <property name="dataSource" ref="dataSource" />
57.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
58. </bean>
61. <bean id="userMapper" >
62.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
63.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
64. </bean><bean id="sqlSessionFactory" >
65.   <property name="dataSource" ref="dataSource" />
66.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
67. </bean>
70. <bean id="userMapper" >
71.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
72.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
73. </bean><bean id="sqlSessionFactory" >
74.   <property name="dataSource" ref="dataSource" />
75.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
76. </bean>
79. <bean id="userMapper" >
80.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
81.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
82. </bean><bean id="sqlSessionFactory" >
83.   <property name="dataSource" ref="dataSource" />
84.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
85. </bean>
88. <bean id="userMapper" >
89.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
90.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
91. </bean><bean id="sqlSessionFactory" >
92.   <property name="dataSource" ref="dataSource" />
93.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
94. </bean>
97. <bean id="userMapper" >
98.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
99.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
100. </bean><bean id="sqlSessionFactory" >
101.   <property name="dataSource" ref="dataSource" />
102.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
103. </bean>
106. <bean id="userMapper" >
107.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
108.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
109. </bean>

复制代码

重新编写Service实现类

1. public class BookServiceImpl implements BookService{<mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
4.     private BookMapper bookMapper;<mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
7.     @Autowired //需要spring-aop包<mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
10.     public BookServiceImpl(BookMapper bookMapper) {<bean id="sqlSessionFactory" >
11.   <property name="dataSource" ref="dataSource" />
12.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
13. </bean>
16. <bean id="userMapper" >
17.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
18.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
19. </bean>this.bookMapper = bookMapper;<mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
22.     }<mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
25.     @Override<mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
28.     public Book getBookById(Integer bookID) {<bean id="sqlSessionFactory" >
29.   <property name="dataSource" ref="dataSource" />
30.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
31. </bean>
34. <bean id="userMapper" >
35.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
36.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
37. </bean>return bookMapper.getBookById(bookID);<mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
40.     }}

复制代码

测试

1. ApplicationContext context=new ClassPathXmlApplicationContext("applicationContext.xml");
2. BookService bookServiceImpl = context.getBean("BookServiceImpl", BookService.class);
3. Book book = bookServiceImpl.getBookById(2);
4. System.out.println(book);

复制代码

改进注册映射器方式：使用发现映射器方式

MapperFactoryBean注册映射器的最大题目，就是需要一个个注册所有的映射器，而现实上mybatis-spring提供了扫描包下所有映射器接口的方法。
注意：以下两种设置方法，均可替换上述MapperFactoryBean设置，而其余代码与设置不变
方式一：设置扫描器标签

1.与上面设置MapperFactoryBean差异，该设置无需注入SqlSessionFactory，它会自动匹配已有的会话工厂bean
2.假如设置了多个DataSource，也就是多个sqlSessionFactory时，可以使用factory-ref参数指定需要的会话工厂

1. <mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
4.    

复制代码

方式二:MapperScannerConfigurer类

1.与上面标签的功能差不多，同样是扫描基准包，自动注入会话工厂
2.假如要更换注入的会话工厂，差异于常用的ref引入bean，而是使用value指定bean名，且属性是sqlSessionFactoryBeanName

1. <bean id="sqlSessionFactory" >
2.   <property name="dataSource" ref="dataSource" />
3.   <property name="mapperLocations" value="classpath:com/ylzl/mapper/BookMapper.xml"/>
4. </bean>
7. <bean id="userMapper" >
8.   <property name="sqlSessionFactory" ref="sqlSessionFactory" />
9.   <property name="mapperInterface" value="com.ylzl.mapper.UserMapper" />
10. </bean>  

复制代码

annotation方式

1. @Beanpublic MapperScannerConfigurer mapperScannerConfigurer() {<mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
4.     MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();<mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
7.     mapperScannerConfigurer.setBasePackage("com.ylzl.dao");<mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
10.     mapperScannerConfigurer.setSqlSessionFactoryBeanName("sqlSessionFactory");<mybatis:scan base-package="com.ylzl.dao" factory-ref="sqlSessionFactory" />
13.     return mapperScannerConfigurer;}

复制代码

图片：

转载请注明原文链接：https://www.cnblogs.com/yulingzhiling/p/18099455若标题中有“转载”字样，则本文版权归原作者所有。若无转载字样，本文版权归作者和博客园共有，接待转载，但未经作者同意必须保留此段声明，且在文章页面显着位置给出原文毗连，否则保留追究法律责任的权利.
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。