网站建设有几块,wordpress图纸管理网站,动漫设计与制作属于计算机类吗,东莞网站包年优化0. 背景交代为了提高开发速度,我打算将公司原有Mybatis框架升级为FlunetMybatis。可是遇到了一系列问题#xff0c;下面开始爬坑工程结构示意如下#xff1a;src/
├── main
│ ├── java.com.demo
│ │ ├── Application.java //S…0. 背景交代为了提高开发速度,我打算将公司原有Mybatis框架升级为FlunetMybatis。可是遇到了一系列问题下面开始爬坑工程结构示意如下src/
├── main
│ ├── java.com.demo
│ │ ├── Application.java //SpringBoot启动类
│ │ ├── aop
│ │ │ └── GlobalExceptionHandler.java //全局异常处理
│ │ ├── config
│ │ │ └── FluentMybatisGenerator.java //FluentMybatis配置类
│ │ ├── controler
│ │ │ ├── CommodityController.java //新功能使用FluentMybatis
│ │ │ └── FeedbackController.java //老功能使用Mybatis
│ │ ├── enums
│ │ ├── mapper
│ │ │ └── FeedbackMapper.java //MybatisMapper
│ │ ├── mybatis //Mybatis拓展
│ │ │ ├── enums //枚举类
│ │ │ ├── fluent //FluentMybatis代码生成目录
│ │ │ │ ├── dao
│ │ │ │ │ ├── impl
│ │ │ │ │ │ └── CommodityDaoImpl.java //FluentMybatis生成的DAO实现
│ │ │ │ │ └── intf
│ │ │ │ │ └── CommodityDao.java //FluentMybatis生成的DAO接口
│ │ │ │ └── entity
│ │ │ │ └── CommodityEntity.java //FluentMybatis生成的数据模型
│ │ │ ├── handler
│ │ │ │ └── StringListHandler.java //自定义类型转换器VARCHAR 字符串列表
│ │ │ └── module
│ │ │ └── StringList.java //字符串列表
│ │ ├── plugins
│ │ │ ├── files
│ │ │ └── render
│ │ ├── pojo
│ │ │ └── Feedback.java //MyBatis数据模型
│ │ ├── service
│ │ │ ├── CommodityService.java //新功能Service接口
│ │ │ ├── FeedbackService.java //老功能Service接口
│ │ │ └── impl
│ │ │ ├── CommodityServiceImpl.java //新功能Service接口实现
│ │ │ └── FeedbackServiceImpl.java //老功能Service接口实现
│ │ ├── shiro
│ │ └── utils
│ └── resources
│ ├── application-dev.yml
│ ├── application-prod.yml
│ ├── application.yml
│ ├── logback.xml
│ └── mybatis
│ ├── mapper
│ │ └── FeedbackMapper.xml //Mybatis Mapper XML文件
│ └── mybatis-config.xml
└── test└── java主要涉及到的配置文件FluentMybatisGenerator内容package com.demo.config;import cn.org.atool.fluent.mybatis.spring.MapperFactory;
import cn.org.atool.generator.FileGenerator;
import cn.org.atool.generator.annotation.Column;
import cn.org.atool.generator.annotation.Table;
import cn.org.atool.generator.annotation.Tables;
import com.demo.mybatis.handler.StringListHandler;
import com.demo.mybatis.module.StringList;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.core.io.support.ResourcePatternResolver;import javax.annotation.Resource;
import javax.sql.DataSource;/*** FluentMybatisConfigurer** author adinlead* desc* create 2023/3/6 13:34 (星期一)*/
Configuration
MapperScan({com.demo.mapper})
public class FluentMybatisGenerator {/*** 定义fluent mybatis的MapperFactory*/Beanpublic MapperFactory mapperFactory() {return new MapperFactory();}/*** 生成代码类*/Tables(srcDir src/main/java,basePack com.demo.mybatis.fluent, //注意此处生成代码的路径与原生Mybatis不在同一个包下daoDir src/main/java,tablePrefix {tb_},tables {Table(value {tb_commodity}, columns {Column(value create_time, insert now()),Column(value update_time, insert now(), update now()),Column(value cover_images, javaType StringList.class, typeHandler StringListHandler.class)})})static class CodeGenerator {}
}问题以及解决1.1 FluentMybatis无法自动生成实体类现象在运行后没有在com.demo.mybatis.fluent中生成entity和dao解决方法在FluentMybatisGenerator.java中在返回自定义fluent mybatis的MapperFactory之前执行FileGenerator.build方法 Resourceprivate DataSource dataSource;/*** 定义fluent mybatis的MapperFactory*/Beanpublic MapperFactory mapperFactory() {FileGenerator.build(dataSource, CodeGenerator.class);// 引用配置类build方法允许有多个配置类return new MapperFactory();}mvn执行clean 后 再次运行项目即可效果如下1.2 自定义SqlSessionFactoryBean导致的一系列问题官方WIKI-环境部署-简单示例中看到了如下代码Configuration
MapperScan({你的Mapper package})
public class ApplicationConfig {Bean(dataSource)Beanpublic DataSource newDataSource() {// TODO}Beanpublic SqlSessionFactoryBean sqlSessionFactoryBean() throws Exception {SqlSessionFactoryBean bean new SqlSessionFactoryBean();bean.setDataSource(newDataSource());ResourcePatternResolver resolver new PathMatchingResourcePatternResolver();// 以下部分根据自己的实际情况配置// 如果有mybatis原生文件, 请在这里加载bean.setMapperLocations(resolver.getResources(classpath*:mapper/*.xml));org.apache.ibatis.session.Configuration configuration new org.apache.ibatis.session.Configuration();configuration.setLazyLoadingEnabled(true);configuration.setMapUnderscoreToCamelCase(true);bean.setConfiguration(configuration);return bean;}// 定义fluent mybatis的MapperFactoryBeanpublic MapperFactory mapperFactory() {return new MapperFactory();}
}在此示例中作者重定义了SqlSessionFactoryBean但是如果你没能正确配置那么这一行为也会导致一系列错误。1.2.1 Spring无法找到需要注入的对象错误如下
Error starting ApplicationContext. To display the conditions report re-run your application with debug enabled.
2023-03-08 13:17:02 [main] ERROR o.s.b.d.LoggingFailureAnalysisReporter - ***************************
APPLICATION FAILED TO START
***************************Description:A component required a bean of type com.demo.mybatis.fluent.mapper.CommodityMapper that could not be found.Action:Consider defining a bean of type com.demo.mybatis.fluent.mapper.CommodityMapper in your configuration.
这个一般是Spring 进行DI时找不到FluentMybatis的Mapper引起的错误原因在于官方文档中要求你在MapperScan中添加MybatisMapper包路径但是如果你的MybatisMapper和FluentMybatisMapper不在一个包中时也需要把FluentMybatis生成的Mapper路径也添加到扫描器中或者干脆放大扫描范围。添加FluentMybatisMapper包路径推荐Configuration
MapperScan({com.demo.mapper, com.demo.mybatis.fluent.mapper})
public class FluentMybatisGenerator {...
}扩大扫描范围Configuration
MapperScan({com.demo})
public class FluentMybatisGenerator {...
}1.2.2 原MybatisMapper报BindingException错误调用原生MybatisMapper中的方法时提示无法映射到方法错误信息如下org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.demo.mapper.FeedbackMapper.countManagerRecordsat org.apache.ibatis.binding.MapperMethod$SqlCommand.init(MapperMethod.java:235)at org.apache.ibatis.binding.MapperMethod.init(MapperMethod.java:53)at org.apache.ibatis.binding.MapperProxy.lambda$cachedInvoker$0(MapperProxy.java:115)at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660)at org.apache.ibatis.binding.MapperProxy.cachedInvoker(MapperProxy.java:102)at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85)at com.sun.proxy.$Proxy93.countManagerRecords(Unknown Source)at com.demo.service.impl.FeedbackServiceImpl.getManagerFeedbacks(FeedbackServiceImpl.java:77)at com.demo.controler.FeedbackController.getAdminRecords(FeedbackController.java:74)at com.demo.controler.FeedbackController$$FastClassBySpringCGLIB$$80abedc3.invoke(generated)这个错误一般是由于你没有正确配置MyBatis XML文件路径导致的需要在自定义SqlSessionFactoryBean方法中修改XML文件扫描路径 Beanpublic SqlSessionFactoryBean sqlSessionFactoryBean() throws Exception {SqlSessionFactoryBean bean new SqlSessionFactoryBean();bean.setDataSource(dataSource);ResourcePatternResolver resolver new PathMatchingResourcePatternResolver();/* 注意在这里需要将原生Mybatis的XML路径写到配置中 */bean.setMapperLocations(resolver.getResources(classpath*:mybatis/mapper/*.xml));org.apache.ibatis.session.Configuration configuration new org.apache.ibatis.session.Configuration();configuration.setLazyLoadingEnabled(true);configuration.setMapUnderscoreToCamelCase(true);bean.setConfiguration(configuration);return bean;}1.2.3 Mybatis别名解析错误在修改完1.2.2问题后你大概率会碰到这个问题具体表现为org.springframework.beans.factory.BeanCreationException: Error creating bean with name shiroFilter defined in class path resource [com/demo/shiro/ShiroConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.shiro.spring.web.ShiroFilterFactoryBean]: Factory method shiroFilterFactoryBean threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name securityManager defined in class path resource [com/demo/shiro/ShiroConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.shiro.web.mgt.DefaultWebSecurityManager]: Factory method securityManager threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name shiroRealm: Unsatisfied dependency expressed through field userService; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name userMapper defined in file [xxxx/DemoProject/target/classes/com/demo/mapper/UserMapper.class]: Unsatisfied dependency expressed through bean property sqlSessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name sqlSessionFactoryBean defined in class path resource [com/demo/config/FluentMybatisGenerator.class]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: file [xxxx/DemoProject/target/classes/mybatis/mapper/FeedbackMapper.xml]; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is file [xxxx/DemoProject/target/classes/mybatis/mapper/FeedbackMapper.xml]. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias Feedback. Cause: java.lang.ClassNotFoundException: Cannot find class: Feedbackat org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:658)at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:486)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:213)at org.springframework.context.support.PostProcessorRegistrationDelegate.registerBeanPostProcessors(PostProcessorRegistrationDelegate.java:270)at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:762)at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:567)at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145)at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754)at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:434)at org.springframework.boot.SpringApplication.run(SpringApplication.java:338)at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343)at org.springframework.boot.SpringApplication.run(SpringApplication.java:1332)at com.demo.Application.main(NewCommunity.java:27)根本原因在MyBatis中Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is file [xxxx/DemoProject/target/classes/mybatis/mapper/FeedbackMapper.xml]. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias Feedback. Cause: java.lang.ClassNotFoundException: Cannot find class: Feedbackat org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:123)at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:95)at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:611)... 92 common frames omitted
Caused by: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias Feedback. Cause: java.lang.ClassNotFoundException: Cannot find class: Feedbackat org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:118)at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:263)at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:254)at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElements(XMLMapperBuilder.java:246)at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:119)... 94 common frames omitted
Caused by: org.apache.ibatis.type.TypeException: Could not resolve type alias Feedback. Cause: java.lang.ClassNotFoundException: Cannot find class: Feedbackat org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:120)at org.apache.ibatis.builder.BaseBuilder.resolveAlias(BaseBuilder.java:149)at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:116)... 98 common frames omitted
Caused by: java.lang.ClassNotFoundException: Cannot find class: Feedbackat org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:196)at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:89)at org.apache.ibatis.io.Resources.classForName(Resources.java:261)at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:116)... 100 common frames omitted据我猜测其原因在于FluentMybatis没有夹在原生Mybatis的实体类解决方法很简单在自定义SqlSessionFactoryBean的方法中手动添加原生MyBatis实体类所在包即可 Beanpublic SqlSessionFactoryBean sqlSessionFactoryBean() throws Exception {SqlSessionFactoryBean bean new SqlSessionFactoryBean();bean.setDataSource(dataSource);ResourcePatternResolver resolver new PathMatchingResourcePatternResolver();/* 注意在这里需要将原生Mybatis的XML路径写到配置中 */bean.setMapperLocations(resolver.getResources(classpath*:mybatis/mapper/*.xml));org.apache.ibatis.session.Configuration configuration new org.apache.ibatis.session.Configuration();configuration.setLazyLoadingEnabled(true);configuration.setMapUnderscoreToCamelCase(true);/* 注意在这里需要将原生MyBatis的实体类包名添加到TypeAliasRegistry中 */configuration.getTypeAliasRegistry().registerAliases(com.demo.pojo);bean.setConfiguration(configuration);return bean;}1.2.0 一割解千愁经过测试其实不需要自定义SqlSessionFactoryBean也可以正常的将原生MyBatis和FluentMybatis二者结合使用所以如果上面的方法不能解决问题时可以尝试将自定义SqlSessionFactoryBean方法删除后再试。3. 完整的FluentMybatisGenerator.javapackage com.demo.config;import cn.org.atool.fluent.mybatis.spring.MapperFactory;
import cn.org.atool.generator.FileGenerator;
import cn.org.atool.generator.annotation.Column;
import cn.org.atool.generator.annotation.Table;
import cn.org.atool.generator.annotation.Tables;
import com.demo.mybatis.handler.StringListHandler;
import com.demo.mybatis.module.StringList;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.core.io.support.ResourcePatternResolver;import javax.annotation.Resource;
import javax.sql.DataSource;/*** FluentMybatisConfigurer** author adinlead* desc* create 2023/3/6 13:34 (星期一)*/
Configuration
public class FluentMybatisGenerator {/*** 从Spring中获取DataSource*/Resourceprivate DataSource dataSource;/*** 使用定义Fluent Mybatis的MapperFactory*/Beanpublic MapperFactory mapperFactory() {/* 引用配置类build方法允许有多个配置类 */FileGenerator.build(dataSource, CodeGenerator.class);return new MapperFactory();}/*** 使用自定义SqlSessionFactoryBean* return* throws Exception*/Beanpublic SqlSessionFactoryBean sqlSessionFactoryBean() throws Exception {SqlSessionFactoryBean bean new SqlSessionFactoryBean();bean.setDataSource(dataSource);ResourcePatternResolver resolver new PathMatchingResourcePatternResolver();/* 注意在这里需要将原生Mybatis的XML路径写到配置中 */bean.setMapperLocations(resolver.getResources(classpath*:mybatis/mapper/*.xml));org.apache.ibatis.session.Configuration configuration new org.apache.ibatis.session.Configuration();configuration.setLazyLoadingEnabled(true);configuration.setMapUnderscoreToCamelCase(true);/* 注意在这里需要将原生Mybatis的XML路径写到配置中 */configuration.getTypeAliasRegistry().registerAliases(com.demo.pojo);bean.setConfiguration(configuration);return bean;}/*** 生成代码类*/Tables(srcDir src/main/java,basePack com.demo.mybatis.fluent,daoDir src/main/java,tablePrefix {tb_},tables {Table(value {tb_commodity}, columns {Column(value create_time, insert now()),Column(value update_time, insert now(), update now()),Column(value cover_images, javaType StringList.class, typeHandler StringListHandler.class)})})static class CodeGenerator {}
}
