ToB企服应用市场:ToB评测及商务社交产业平台

标题: Spring整合Mybatis方式一 - 常规整合 - 注册映射器 [打印本页]
作者: 灌篮少年    时间: 2024-5-15 14:31
标题: Spring整合Mybatis方式一 - 常规整合 - 注册映射器
前置工作

编写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企服之家，中国第一个企服评测及商务社交产业平台。



欢迎光临 ToB企服应用市场:ToB评测及商务社交产业平台 (https://dis.qidao123.com/) Powered by Discuz! X3.4