utf8mb4和utf8的不同、若依框架,代码生成器,gitee,前端vue的下载、修复和启动(寻求大佬帮助若依框架三、2.3)
理想还很年轻! 2024-07-18 09:03:14 阅读 79
2024.7.9
一、数据库的排序和统一问题。utf8mb4和utf8的不同1.1 发现问题1.2 解决问题-在idea中用sql生成器,生成sql语句,然后在里面修改1.3 utf8和utf8mb4的区别
二、若依前后端框架。代码生成器(还没研究懂,但有三个方案)2.1 若依框架的优缺点(十分片面)2.2 若依框架的下载,安装和运行:2.3 遇到的问题(希望有人能帮到我)2.3.1 pom2.3.2 mapper.xml能和mapper用mybatis连接上跳转。2.3.3 报的错误
2.4 解决了的问题2.4.1 xml中 type=、parameterType=报错,见图(这是修改过的了)2.4.2 在我们的实体类上面增加一个注解@Alias("TmsTb01"):2.4.3 @Alias(我的理解是别名)
2.5 使用mybatis-generator (没咋看懂,还有git上的代码生成器,和若依差不多。)
三、gitee1 为什么使用到gitee了2 gitee的登录和创建仓库以及邀请组员2.1 gitee官网:[https://gitee.com/](https://gitee.com/)2.2 然后创建仓库:2.3 邀请组员2.4 推拉数据
四、前端vue的下载修复和启动1 运行和下载npm run dev、npm install2 下载完进行修复npm audit fix(好习惯!)3 npm audit和npm audit fix的不同:
一、数据库的排序和统一问题。utf8mb4和utf8的不同
1.1 发现问题
在我们小组的分工合作完,建好数据库表之后,合并的时候,发现有冲突。因为三个组员使用的Navicat,没有utf8,用的是默认的utf8mb4和utf8mb4_general_ci这两个字符集和排序规则。导致我们总和数据库的时候,发现问题。
1.2 解决问题-在idea中用sql生成器,生成sql语句,然后在里面修改
把每个表最后的utf8mb4修改为utf8后,保存,重新执行。
1.3 utf8和utf8mb4的区别
utf8 是 Mysql 中的一种字符集,只支持最长三个字节的 UTF-8字符,也就是 Unicode 中的基本多文本平面。要在 Mysql 中保存 4 字节长度的 UTF-8 字符,需要使用 utf8mb4 字符集,但只有 5.5.3 版本以后的才支持。
如果遇到 4 字节的字符就会出现错误了。三个字节的 UTF-8 最大能编码的 Unicode 字符是 0xFFFF,也就是 Unicode 中的基本多文平面(BMP)。也就是说,任何不在基本多文平面的 Unicode字符,都无法使用MySQL原有的 utf8 字符集存储。这些不在BMP中的字符包括哪些呢?最常见的就是Emoji 表情(Emoji 是一种特殊的 Unicode 编码,常见于 ios 和 android 手机上),和一些不常用的汉字,以及任何新增的 Unicode 字符等等。
二、若依前后端框架。代码生成器(还没研究懂,但有三个方案)
2.1 若依框架的优缺点(十分片面)
对于我来说,这是一个没有深入研究过的东西,是小组成员商讨然后使用。对于若依的前后端分离框架:
优点是:数据库的字段超级多,我们也需要相应的元素,和一些重复的代码开发,使用若依可以直接专注于代码的开发,前后端都已经是较为完善的了。
缺点是:对于刚接触若依框架的我们来说,很多模块,功能有点找不清,而且我们需要开发的话,固定在rouyi-system里面来写,需要花大量时间去继续研究代码的含义,以及如何去重新开一个模块,写自己的代码。(我知道,还是我业务能力低,大佬早就解决了,接触时间太少了,后续多接触,再回来改)。
2.2 若依框架的下载,安装和运行:
直接看大佬的吧:https://blog.csdn.net/moran_3346/article/details/131803190
2.3 遇到的问题(希望有人能帮到我)
我想独立出一个模块来写自己的代码,所以我创建了一个空模块,然后去重新写所有的配置
代码太多了,我只粘出部分重要的代码:
2.3.1 pom
<?xml version="1.0" encoding="UTF-8"?>code>
<project xmlns="http://maven.apache.org/POM/4.0.0"code>
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"code>
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">code>
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>com.ruoyi</groupId>
<artifactId>ruoyi</artifactId>
<version>3.8.8</version>
</parent>
<groupId>com.fst</groupId>
<version>3.8.8</version>
<artifactId>Shipping_lists</artifactId>
<properties>
<maven.compiler.source>17</maven.compiler.source>
<maven.compiler.target>17</maven.compiler.target>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
</properties>
<dependencies>
<!-- 通用工具-->
<dependency>
<groupId>com.ruoyi</groupId>
<artifactId>ruoyi-common</artifactId>
</dependency>
</dependencies>
</project>
2.3.2 mapper.xml能和mapper用mybatis连接上跳转。
<?xml version="1.0" encoding="UTF-8" ?>code>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.fst.mapper.ShipInfoChangeMapper">code>
<resultMap type="TmsTb01" id="ShipInfoChangeResult">code>
<result property="omTermInfoId" column="om_term_info_id" />code>
<result property="newOutRegionId" column="new_out_region_id" />code>
<result property="oldOutRegionId" column="old_out_region_id" />code>
<result property="newTakeAddress" column="new_take_address" />code>
<result property="oldTakeAddress" column="old_take_address" />code>
<result property="newBranchName" column="new_branch_name" />code>
<result property="oldBranchName" column="old_branch_name" />code>
<result property="newBankContacts" column="new_bank_contacts" />code>
<result property="oldBankContacts" column="old_bank_contacts" />code>
<result property="newBankTel" column="new_bank_tel" />code>
<result property="oldBankTel" column="old_bank_tel" />code>
<result property="newOutLogisticsProviderInfoId" column="new_out_logistics_provider_info_id" />code>
<result property="oldOutLogisticsProviderInfoId" column="old_out_logistics_provider_info_id" />code>
</resultMap>
<sql id="selectShipInfoChangeVo">code>
select om_term_info_id, new_out_region_id, old_out_region_id, new_take_address, old_take_address, new_branch_name, old_branch_name, new_bank_contacts, old_bank_contacts, new_bank_tel, old_bank_tel, new_out_logistics_provider_info_id, old_out_logistics_provider_info_id from ship_info_change
</sql>
<select id="selectShipInfoChangeList" parameterType="TmsTb01" resultMap="ShipInfoChangeResult">code>
<include refid="selectShipInfoChangeVo"/>code>
<where>
<if test="newOutRegionId != null "> and new_out_region_id = #{ newOutRegionId}</if>code>
<if test="oldOutRegionId != null "> and old_out_region_id = #{ oldOutRegionId}</if>code>
<if test="newTakeAddress != null and newTakeAddress != ''"> and new_take_address = #{ newTakeAddress}</if>code>
<if test="oldTakeAddress != null and oldTakeAddress != ''"> and old_take_address = #{ oldTakeAddress}</if>code>
<if test="newBranchName != null and newBranchName != ''"> and new_branch_name like concat('%', #{ newBranchName}, '%')</if>code>
<if test="oldBranchName != null and oldBranchName != ''"> and old_branch_name like concat('%', #{ oldBranchName}, '%')</if>code>
<if test="newBankContacts != null and newBankContacts != ''"> and new_bank_contacts = #{ newBankContacts}</if>code>
<if test="oldBankContacts != null and oldBankContacts != ''"> and old_bank_contacts = #{ oldBankContacts}</if>code>
<if test="newBankTel != null and newBankTel != ''"> and new_bank_tel = #{ newBankTel}</if>code>
<if test="oldBankTel != null and oldBankTel != ''"> and old_bank_tel = #{ oldBankTel}</if>code>
<if test="newOutLogisticsProviderInfoId != null "> and new_out_logistics_provider_info_id = #{ newOutLogisticsProviderInfoId}</if>code>
<if test="oldOutLogisticsProviderInfoId != null "> and old_out_logistics_provider_info_id = #{ oldOutLogisticsProviderInfoId}</if>code>
</where>
</select>
<select id="selectShipInfoChangeByOmTermInfoId" parameterType="Long" resultMap="ShipInfoChangeResult">code>
<include refid="selectShipInfoChangeVo"/>code>
where om_term_info_id = #{ omTermInfoId}
</select>
<insert id="insertShipInfoChange" parameterType="TmsTb01">code>
insert into ship_info_change
<trim prefix="(" suffix=")" suffixOverrides=",">code>
<if test="omTermInfoId != null">om_term_info_id,</if>code>
<if test="newOutRegionId != null">new_out_region_id,</if>code>
<if test="oldOutRegionId != null">old_out_region_id,</if>code>
<if test="newTakeAddress != null">new_take_address,</if>code>
<if test="oldTakeAddress != null">old_take_address,</if>code>
<if test="newBranchName != null">new_branch_name,</if>code>
<if test="oldBranchName != null">old_branch_name,</if>code>
<if test="newBankContacts != null">new_bank_contacts,</if>code>
<if test="oldBankContacts != null">old_bank_contacts,</if>code>
<if test="newBankTel != null">new_bank_tel,</if>code>
<if test="oldBankTel != null">old_bank_tel,</if>code>
<if test="newOutLogisticsProviderInfoId != null">new_out_logistics_provider_info_id,</if>code>
<if test="oldOutLogisticsProviderInfoId != null">old_out_logistics_provider_info_id,</if>code>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">code>
<if test="omTermInfoId != null">#{ omTermInfoId},</if>code>
<if test="newOutRegionId != null">#{ newOutRegionId},</if>code>
<if test="oldOutRegionId != null">#{ oldOutRegionId},</if>code>
<if test="newTakeAddress != null">#{ newTakeAddress},</if>code>
<if test="oldTakeAddress != null">#{ oldTakeAddress},</if>code>
<if test="newBranchName != null">#{ newBranchName},</if>code>
<if test="oldBranchName != null">#{ oldBranchName},</if>code>
<if test="newBankContacts != null">#{ newBankContacts},</if>code>
<if test="oldBankContacts != null">#{ oldBankContacts},</if>code>
<if test="newBankTel != null">#{ newBankTel},</if>code>
<if test="oldBankTel != null">#{ oldBankTel},</if>code>
<if test="newOutLogisticsProviderInfoId != null">#{ newOutLogisticsProviderInfoId},</if>code>
<if test="oldOutLogisticsProviderInfoId != null">#{ oldOutLogisticsProviderInfoId},</if>code>
</trim>
</insert>
<update id="updateShipInfoChange" parameterType="TmsTb01">code>
update ship_info_change
<trim prefix="SET" suffixOverrides=",">code>
<if test="newOutRegionId != null">new_out_region_id = #{ newOutRegionId},</if>code>
<if test="oldOutRegionId != null">old_out_region_id = #{ oldOutRegionId},</if>code>
<if test="newTakeAddress != null">new_take_address = #{ newTakeAddress},</if>code>
<if test="oldTakeAddress != null">old_take_address = #{ oldTakeAddress},</if>code>
<if test="newBranchName != null">new_branch_name = #{ newBranchName},</if>code>
<if test="oldBranchName != null">old_branch_name = #{ oldBranchName},</if>code>
<if test="newBankContacts != null">new_bank_contacts = #{ newBankContacts},</if>code>
<if test="oldBankContacts != null">old_bank_contacts = #{ oldBankContacts},</if>code>
<if test="newBankTel != null">new_bank_tel = #{ newBankTel},</if>code>
<if test="oldBankTel != null">old_bank_tel = #{ oldBankTel},</if>code>
<if test="newOutLogisticsProviderInfoId != null">new_out_logistics_provider_info_id = #{ newOutLogisticsProviderInfoId},</if>code>
<if test="oldOutLogisticsProviderInfoId != null">old_out_logistics_provider_info_id = #{ oldOutLogisticsProviderInfoId},</if>code>
</trim>
where om_term_info_id = #{ omTermInfoId}
</update>
<delete id="deleteShipInfoChangeByOmTermInfoId" parameterType="Long">code>
delete from ship_info_change where om_term_info_id = #{ omTermInfoId}
</delete>
<delete id="deleteShipInfoChangeByOmTermInfoIds" parameterType="String">code>
delete from ship_info_change where om_term_info_id in
<foreach item="omTermInfoId" collection="array" open="(" separator="," close=")">code>
#{omTermInfoId}
</foreach>
</delete>
</mapper>
2.3.3 报的错误
19:38:33.049 [restartedMain] INFO c.r.RuoYiApplication - [logStarting,55] - Starting RuoYiApplication using Java 21.0.1 on fst with PID 1456 (E:\project1\mybatis-generator-gui-master\production-system\production-system-master\ruoyi-admin\target\classes started by feng in E:\project1\mybatis-generator-gui-master\production-system)
19:38:33.052 [restartedMain] DEBUG c.r.RuoYiApplication - [logStarting,56] - Running with Spring Boot v2.5.15, Spring v5.3.33
19:38:33.052 [restartedMain] INFO c.r.RuoYiApplication - [logStartupProfileInfo,686] - The following 1 profile is active: "druid"
19:38:33.053 [background-preinit] INFO o.h.v.i.util.Version - [<clinit>,21] - HV000001: Hibernate Validator 6.2.5.Final
19:38:35.560 [restartedMain] INFO o.a.c.c.AprLifecycleListener - [log,173] - Loaded Apache Tomcat Native library [1.2.39] using APR version [1.7.4].
19:38:35.561 [restartedMain] INFO o.a.c.c.AprLifecycleListener - [log,173] - APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true], UDS [true].
19:38:35.561 [restartedMain] INFO o.a.c.c.AprLifecycleListener - [log,173] - APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
19:38:35.582 [restartedMain] INFO o.a.c.c.AprLifecycleListener - [log,173] - OpenSSL successfully initialized [OpenSSL 3.0.11 19 Sep 2023]
19:38:35.595 [restartedMain] INFO o.a.c.h.Http11NioProtocol - [log,173] - Initializing ProtocolHandler ["http-nio-8080"]
19:38:35.595 [restartedMain] INFO o.a.c.c.StandardService - [log,173] - Starting service [Tomcat]
19:38:35.596 [restartedMain] INFO o.a.c.c.StandardEngine - [log,173] - Starting Servlet engine: [Apache Tomcat/9.0.75]
19:38:35.779 [restartedMain] INFO o.a.c.c.C.[.[.[/] - [log,173] - Initializing Spring embedded WebApplicationContext
19:38:36.364 [restartedMain] DEBUG c.r.f.s.f.JwtAuthenticationTokenFilter - [init,242] - Filter 'jwtAuthenticationTokenFilter' configured for use
19:38:38.517 [restartedMain] INFO c.a.d.p.DruidDataSource - [init,1002] - { dataSource-1} inited
19:38:39.011 [restartedMain] WARN o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext - [refresh,599] - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'captchaController': Unsatisfied dependency expressed through field 'configService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sysConfigServiceImpl': Unsatisfied dependency expressed through field 'configMapper'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sysConfigMapper' defined in file [E:\project1\mybatis-generator-gui-master\production-system\production-system-master\ruoyi-system\target\classes\com\ruoyi\system\mapper\SysConfigMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/ruoyi/framework/config/MyBatisConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is java.io.IOException: Failed to parse mapping resource: 'file [E:\project1\mybatis-generator-gui-master\production-system\production-system-master\Shipping_lists\target\classes\mapper\list\ShipInfoChangeMapper.xml]'
19:38:39.011 [restartedMain] INFO c.a.d.p.DruidDataSource - [close,2204] - { dataSource-1} closing ...
19:38:39.015 [restartedMain] INFO c.a.d.p.DruidDataSource - [close,2277] - { dataSource-1} closed
19:38:39.033 [restartedMain] INFO o.a.c.c.StandardService - [log,173] - Stopping service [Tomcat]
19:38:39.066 [restartedMain] ERROR o.s.b.SpringApplication - [reportFailure,870] - Application run failed
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'captchaController': Unsatisfied dependency expressed through field 'configService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sysConfigServiceImpl': Unsatisfied dependency expressed through field 'configMapper'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sysConfigMapper' defined in file [E:\project1\mybatis-generator-gui-master\production-system\production-system-master\ruoyi-system\target\classes\com\ruoyi\system\mapper\SysConfigMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/ruoyi/framework/config/MyBatisConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is java.io.IOException: Failed to parse mapping resource: 'file [E:\project1\mybatis-generator-gui-master\production-system\production-system-master\Shipping_lists\target\classes\mapper\list\ShipInfoChangeMapper.xml]'
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:713)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:693)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:408)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:591)
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:780)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:453)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:343)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1370)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1359)
at com.ruoyi.RuoYiApplication.main(RuoYiApplication.java:18)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49)
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sysConfigServiceImpl': Unsatisfied dependency expressed through field 'configMapper'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sysConfigMapper' defined in file [E:\project1\mybatis-generator-gui-master\production-system\production-system-master\ruoyi-system\target\classes\com\ruoyi\system\mapper\SysConfigMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/ruoyi/framework/config/MyBatisConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is java.io.IOException: Failed to parse mapping resource: 'file [E:\project1\mybatis-generator-gui-master\production-system\production-system-master\Shipping_lists\target\classes\mapper\list\ShipInfoChangeMapper.xml]'
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:713)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:693)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:408)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209)
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:710)
... 23 common frames omitted
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sysConfigMapper' defined in file [E:\project1\mybatis-generator-gui-master\production-system\production-system-master\ruoyi-system\target\classes\com\ruoyi\system\mapper\SysConfigMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/ruoyi/framework/config/MyBatisConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is java.io.IOException: Failed to parse mapping resource: 'file [E:\project1\mybatis-generator-gui-master\production-system\production-system-master\Shipping_lists\target\classes\mapper\list\ShipInfoChangeMapper.xml]'
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1534)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1417)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209)
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:710)
... 37 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/ruoyi/framework/config/MyBatisConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is java.io.IOException: Failed to parse mapping resource: 'file [E:\project1\mybatis-generator-gui-master\production-system\production-system-master\Shipping_lists\target\classes\mapper\list\ShipInfoChangeMapper.xml]'
at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:646)
at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:626)
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:336)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209)
at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1519)
... 48 common frames omitted
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is java.io.IOException: Failed to parse mapping resource: 'file [E:\project1\mybatis-generator-gui-master\production-system\production-system-master\Shipping_lists\target\classes\mapper\list\ShipInfoChangeMapper.xml]'
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185)
at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:641)
... 61 common frames omitted
Caused by: java.io.IOException: Failed to parse mapping resource: 'file [E:\project1\mybatis-generator-gui-master\production-system\production-system-master\Shipping_lists\target\classes\mapper\list\ShipInfoChangeMapper.xml]'
at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:700)
at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:577)
at org.mybatis.spring.SqlSessionFactoryBean.getObject(SqlSessionFactoryBean.java:720)
at com.ruoyi.framework.config.MyBatisConfig.sqlSessionFactory(MyBatisConfig.java:130)
at com.ruoyi.framework.config.MyBatisConfig$$EnhancerBySpringCGLIB$$ebba123a.CGLIB$sqlSessionFactory$0(<generated>)
at com.ruoyi.framework.config.MyBatisConfig$$EnhancerBySpringCGLIB$$ebba123a$$FastClassBySpringCGLIB$$74fc26c.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)
at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331)
at com.ruoyi.framework.config.MyBatisConfig$$EnhancerBySpringCGLIB$$ebba123a.sqlSessionFactory(<generated>)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)
... 62 common frames omitted
Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [E:\project1\mybatis-generator-gui-master\production-system\production-system-master\Shipping_lists\target\classes\mapper\list\ShipInfoChangeMapper.xml]'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'TmsTb01'. Cause: java.lang.ClassNotFoundException: Cannot find class: TmsTb01
at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:128)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:100)
at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:698)
... 73 common frames omitted
Caused by: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'TmsTb01'. Cause: java.lang.ClassNotFoundException: Cannot find class: TmsTb01
at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:118)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:270)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:262)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElements(XMLMapperBuilder.java:254)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:124)
... 75 common frames omitted
Caused by: org.apache.ibatis.type.TypeException: Could not resolve type alias 'TmsTb01'. Cause: java.lang.ClassNotFoundException: Cannot find class: TmsTb01
at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:128)
at org.apache.ibatis.builder.BaseBuilder.resolveAlias(BaseBuilder.java:150)
at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:116)
... 79 common frames omitted
Caused by: java.lang.ClassNotFoundException: Cannot find class: TmsTb01
at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:226)
at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:103)
at org.apache.ibatis.io.Resources.classForName(Resources.java:322)
at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:124)
... 81 common frames omitted
进程已结束,退出代码为 1
2.4 解决了的问题
2.4.1 xml中 type=、parameterType=报错,见图(这是修改过的了)
2.4.2 在我们的实体类上面增加一个注解@Alias(“TmsTb01”):
2.4.3 @Alias(我的理解是别名)
使用前提
在配置文件中配置 type-aliases-package 告诉spring boot (项目)你改别名的包是哪里
如:type-aliases-package: com.ye.test.pojo
实体类使用方法
<code>@Alias("oppo")
public class Teacher {
private Integer id;
private String name;
mapper.xml 使用方法
mapper.xml 文件中可以直接使用 oppo,代替 com.ye.test.pojo.Teacher
如:javaType=“oppo” resultType=“oppo” parameterType=“oppo”
注意:使用@Alias 起别名之后,mapper.xml 文件 不能再使用 Teacher/teacher,但可以使用全类名 com.ye.test.pojo.Teacher
2.5 使用mybatis-generator (没咋看懂,还有git上的代码生成器,和若依差不多。)
大佬的:
https://blog.csdn.net/qq_43813351/article/details/119913372
https://developer.aliyun.com/article/1463287
三、gitee
1 为什么使用到gitee了
因为我们小组开发,还使用到了gitee来进行代码的整理和下放,很久之前在黑马的视频里面使用过gitee对自己的代码进行推,拉,合并,今天重温一下。主要的使用场景还是在idea里面。
2 gitee的登录和创建仓库以及邀请组员
2.1 gitee官网:https://gitee.com/
2.2 然后创建仓库:
根据需求进行创建
2.3 邀请组员
打开自己的仓库,点击管理,然后仓库成员管理
然后就可以根据链接和二维码进行分享和邀请了!!!
2.4 推拉数据
推数据:
拉数据
从头拉项目
四、前端vue的下载修复和启动
被组员吐槽了,是一点前端不会啊哈哈哈
1 运行和下载npm run dev、npm install
2 下载完进行修复npm audit fix(好习惯!)
3 npm audit和npm audit fix的不同:
npm audit安全漏洞的扫描器
npm audit fix:自动修复漏洞的利器
npm audit fix要慎重使用,这个命令可能会引发依赖问题,比如A包依赖B包,结果B包强制更新后,A包的依赖找不到了。
所以,搭配使用:
我们来看一个具体的例子。假设你的项目中有一个名为“express”的依赖包,但是这个包存在一个已知的安全漏洞。当你运行npm audit时,它会报告这个漏洞并给出相应的警告信息。接下来,你就可以查看升级之后,是否会造成其他冲突,然后尝试运行npm audit fix来自动修复这个问题。系统会自动更新“express”依赖包的版本,将其升级到一个没有安全漏洞的版本。
上一篇: Web漏洞扫描工具AppScan与AWVS测评及使用体验
下一篇: CTF题目合集
本文标签
代码生成器 前端vue的下载、修复和启动(寻求大佬帮助若依框架三、2.3) utf8mb4和utf8的不同、若依框架 gitee
声明
本文内容仅代表作者观点,或转载于其他网站,本站不以此文作为商业用途
如有涉及侵权,请联系本站进行删除
转载本站原创文章,请注明来源及作者。