# spring-learn **Repository Path**: hrbu2024/spring-learn ## Basic Information - **Project Name**: spring-learn - **Description**: No description available - **Primary Language**: Unknown - **License**: Not specified - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2026-11-02 - **Last Updated**: 2026-11-17 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # 框架的迭代 Spring SpringMVC MyBaits ( SSM ) SSH: Struts1.x(MVC) Spring(解耦) Hibernate( 持久层 JBDC封装) SSH: Struts2.x(MVC) Spring(解耦) Hibernate( 持久层 JBDC封装) SSI: Struts2.x (MVC) Spring (解耦) IBatis (1.x 2.x)( 持久层 JBDC封装) SSI: SpringMVC(MVC) Spring (解耦) IBatis (1.x 2.x)( 持久层 JBDC封装) SSM: SpringMVC(MVC) Spring (解耦) MBatis (3.X)( 持久层 JBDC封装) # Spring 介绍 [Spring | Home](https://spring.io/) [Spring Framework Documentation :: Spring Framework](https://docs.spring.io/spring-framework/reference/6.2/index.html) Spring是一个基于java的轻量级的、一站式框架。 虽然Spring是一个轻量级框架,但并不表示它的功能少。实际上,spring是一个庞然大物,包罗万象。 时至今日,Spring已经成为java世界中事实上的标准。 Spring之父:Rod Johnson(罗德.约翰逊) 他是悉尼大学音乐学博士,而计算机仅仅是学士学位。 由于Rod对JAVAEE笨重、臃肿的现状深恶痛绝,以至于他将他在JAVAEE实战中的经历称为噩梦般的经历。他决定改变这种现状,于是就有了Spring。 ![image-20261102084608773](assets/image-20261102084608773.png) ![img](assets/1604979623542-f6978c97-76d9-4158-8051-ce4f898bbcc4.png) Spring 总共大约有 20 个模块,由 1300 多个不同的文件构成。而这些组件被分别整合在6 个模块中: 1. 核心容器(Core Container) 2. AOP(Aspect Oriented Programming) 3. 设备支持(Instrmentation) 4. 数据访问及集成(Data Access/Integeration) 5. Web报文发送(Messaging) 6. Test测试 ## 两大核心 - IOC/DI - IOC:控制反转(Inversion of Control):它是一种控制权的转移。即组件与组件之间的依赖由主动变为被动。也就是说:应用程序本身不再负责组件的创建、维护等,而是将控制权移交出去。从这一点来说,几乎所有的框架都是IOC框架。 - ​ DI:依赖注入(Dependency Injection):依赖其他容器(比如spring)来创建和维护所需要的组件,并将其注入到应用程序中。 - IOC 控制翻转, Service 依赖Dao,原来需要在serice 中new Dao,使用IOC容器 - DI 将dao 放到Service 过程 依赖注入 - AOP: 面相切面变成 # 上手Helloworld 聚合项目 - spring-learn - 01-spring-helloword-xml - 02-spring-helloword-xml - 03-spring-helloword-xml - 04-spring-helloword-xml - 05-spring-helloword-xml - 06-spring-helloword-xml - 依赖 - 父项目定义版本 - 子项目使用依赖(无需再重复编写版本号) ## 创建项目 ![image-20261102085815374](assets/image-20261102085815374.png) ![image-20261102085915252](assets/image-20261102085915252.png) ## 编写依赖 父项目pom.xml ```xml 4.0.0 com.neuedu.spring spring-learn 1.0 pom spring-learn http://maven.apache.org 01-spring-helloword-xml UTF-8 6.2.19 org.springframework spring-core ${spring.version} compile org.springframework spring-beans ${spring.version} compile org.springframework spring-context ${spring.version} compile org.springframework spring-expression ${spring.version} compile ``` 子项目 pom.xml ```xml 4.0.0 com.neuedu.spring spring-learn 1.0 01-spring-helloword-xml jar 01-spring-helloword-xml http://maven.apache.org UTF-8 org.springframework spring-core org.springframework spring-beans org.springframework spring-context org.springframework spring-expression ``` ## 使用Qualifier注解区分多个同名的类型 ![image-20261102142945966](assets/image-20261102142945966.png) # 使用配置类代替配置文件(spring-beans.xml) 04-spring-javaconfig ```java package com.neuedu.spring; import org.springframework.context.annotation.ComponentScan; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.spring * 类描述: 使用Java类代替配置文件 * 创建人:金山老师 * 创建时间:2026/11/02 14:49 * 版本:1.0 * */ // @ComponentScan("com.neuedu.spring") public class SpringApp { } ``` ![image-20261102145523237](assets/image-20261102145523237.png) junit的报错 可以不用管 ![image-20261102145452432](assets/image-20261102145452432.png) D:\app\Java\jdk-21\bin\java.exe -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:D:\app\JetBrains\IntelliJ IDEA 2024.3.1.1\lib\idea_rt.jar=54401:D:\app\JetBrains\IntelliJ IDEA 2024.3.1.1\bin" -javaagent:C:\Users\Administrator\AppData\Local\JetBrains\IntelliJIdea2024.3\captureAgent\debugger-agent.jar -Dkotlinx.coroutines.debug.enable.creation.stack.trace=false -Ddebugger.agent.enable.coroutines=true -Dkotlinx.coroutines.debug.enable.flows.stack.trace=true -Dkotlinx.coroutines.debug.enable.mutable.state.flows.stack.trace=true -Dfile.encoding=UTF-8 -Dsun.stdout.encoding=UTF-8 -Dsun.stderr.encoding=UTF-8 -classpath "C:\Users\Administrator\.m2\repository\org\junit\platform\junit-platform-launcher\1.14.4\junit-platform-launcher-1.14.4.jar;C:\Users\Administrator\.m2\repository\org\junit\platform\junit-platform-engine\1.14.4\junit-platform-engine-1.14.4.jar;C:\Users\Administrator\.m2\repository\org\opentest4j\opentest4j\1.3.0\opentest4j-1.3.0.jar;C:\Users\Administrator\.m2\repository\org\junit\platform\junit-platform-commons\1.14.4\junit-platform-commons-1.14.4.jar;C:\Users\Administrator\.m2\repository\org\apiguardian\apiguardian-api\1.1.2\apiguardian-api-1.1.2.jar;C:\Users\Administrator\.m2\repository\org\junit\jupiter\junit-jupiter-engine\5.14.4\junit-jupiter-engine-5.14.4.jar;C:\Users\Administrator\.m2\repository\org\junit\jupiter\junit-jupiter-api\5.14.4\junit-jupiter-api-5.14.4.jar;D:\app\JetBrains\IntelliJ IDEA 2024.3.1.1\lib\idea_rt.jar;D:\app\JetBrains\IntelliJ IDEA 2024.3.1.1\plugins\junit\lib\junit5-rt.jar;D:\app\JetBrains\IntelliJ IDEA 2024.3.1.1\plugins\junit\lib\junit-rt.jar;D:\workspace\spring-learn\04-spring-javaconfig\target\test-classes;D:\workspace\spring-learn\04-spring-javaconfig\target\classes;D:\app\apache-maven-3.9.9\jarrepository\org\springframework\spring-context\6.2.19\spring-context-6.2.19.jar;D:\app\apache-maven-3.9.9\jarrepository\org\springframework\spring-aop\6.2.19\spring-aop-6.2.19.jar;D:\app\apache-maven-3.9.9\jarrepository\org\springframework\spring-beans\6.2.19\spring-beans-6.2.19.jar;D:\app\apache-maven-3.9.9\jarrepository\org\springframework\spring-core\6.2.19\spring-core-6.2.19.jar;D:\app\apache-maven-3.9.9\jarrepository\org\springframework\spring-jcl\6.2.19\spring-jcl-6.2.19.jar;D:\app\apache-maven-3.9.9\jarrepository\org\springframework\spring-expression\6.2.19\spring-expression-6.2.19.jar;D:\app\apache-maven-3.9.9\jarrepository\io\micrometer\micrometer-observation\1.15.12\micrometer-observation-1.15.12.jar;D:\app\apache-maven-3.9.9\jarrepository\io\micrometer\micrometer-commons\1.15.12\micrometer-commons-1.15.12.jar;D:\app\apache-maven-3.9.9\jarrepository\org\springframework\spring-test\6.2.19\spring-test-6.2.19.jar;D:\app\apache-maven-3.9.9\jarrepository\org\junit\jupiter\junit-jupiter-api\5.14.4\junit-jupiter-api-5.14.4.jar;D:\app\apache-maven-3.9.9\jarrepository\org\opentest4j\opentest4j\1.3.0\opentest4j-1.3.0.jar;D:\app\apache-maven-3.9.9\jarrepository\org\junit\platform\junit-platform-commons\1.14.4\junit-platform-commons-1.14.4.jar;D:\app\apache-maven-3.9.9\jarrepository\org\apiguardian\apiguardian-api\1.1.2\apiguardian-api-1.1.2.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit5 com.neuedu.spring.service.UserServiceTest,queryUser org.junit.platform.launcher.core.DiscoveryIssueException: TestEngine with ID 'junit-jupiter' encountered a critical issue during test discovery: (1) [ERROR] MethodSelector [className = 'com.neuedu.spring.service.UserServiceTest', methodName = 'queryUser', parameterTypes = '', classLoader = null] resolution failed Source: MethodSource [className = 'com.neuedu.spring.service.UserServiceTest', methodName = 'queryUser', methodParameterTypes = ''] at com.neuedu.spring.service.UserServiceTest.queryUser(SourceFile:0) Cause: java.lang.ClassCircularityError: java/lang/WeakPairMap$Pair$Weak at java.base/java.lang.WeakPairMap$Pair.weak(WeakPairMap.java:201) at java.base/java.lang.WeakPairMap.putIfAbsent(WeakPairMap.java:123) at java.base/java.lang.Module.implAddReads(Module.java:551) at java.base/java.lang.Module.implAddReads(Module.java:512) at java.base/java.lang.System$2.addReads(System.java:2422) at java.base/jdk.internal.module.Modules.addReads(Modules.java:90) at java.base/java.lang.reflect.Proxy$ProxyBuilder.lambda$getDynamicModule$1(Proxy.java:915) at java.base/jdk.internal.loader.AbstractClassLoaderValue$Memoizer.get(AbstractClassLoaderValue.java:329) at java.base/jdk.internal.loader.AbstractClassLoaderValue.computeIfAbsent(AbstractClassLoaderValue.java:205) at java.base/java.lang.reflect.Proxy$ProxyBuilder.getDynamicModule(Proxy.java:905) at java.base/java.lang.reflect.Proxy$ProxyBuilder.proxyClassContext(Proxy.java:840) at java.base/java.lang.reflect.Proxy$ProxyBuilder.(Proxy.java:638) at java.base/java.lang.reflect.Proxy$ProxyBuilder.(Proxy.java:643) at java.base/java.lang.reflect.Proxy.lambda$getProxyConstructor$0(Proxy.java:429) at java.base/jdk.internal.loader.AbstractClassLoaderValue$Memoizer.get(AbstractClassLoaderValue.java:329) at java.base/jdk.internal.loader.AbstractClassLoaderValue.computeIfAbsent(AbstractClassLoaderValue.java:205) at java.base/java.lang.reflect.Proxy.getProxyConstructor(Proxy.java:427) at java.base/java.lang.reflect.Proxy.newProxyInstance(Proxy.java:1034) at java.base/sun.reflect.annotation.AnnotationParser$1.run(AnnotationParser.java:301) at java.base/sun.reflect.annotation.AnnotationParser$1.run(AnnotationParser.java:299) at java.base/java.security.AccessController.doPrivileged(AccessController.java:319) at java.base/sun.reflect.annotation.AnnotationParser.annotationForMap(AnnotationParser.java:299) at java.base/sun.reflect.annotation.AnnotationParser.parseAnnotation2(AnnotationParser.java:288) at java.base/sun.reflect.annotation.AnnotationParser.parseAnnotations2(AnnotationParser.java:121) at java.base/sun.reflect.annotation.AnnotationParser.parseSelectAnnotations(AnnotationParser.java:102) at java.base/sun.reflect.annotation.AnnotationType.(AnnotationType.java:146) at java.base/sun.reflect.annotation.AnnotationType.getInstance(AnnotationType.java:85) at java.base/sun.reflect.annotation.AnnotationParser.parseAnnotation2(AnnotationParser.java:262) at java.base/sun.reflect.annotation.AnnotationParser.parseAnnotations2(AnnotationParser.java:121) at java.base/sun.reflect.annotation.AnnotationParser.parseAnnotations(AnnotationParser.java:73) at java.base/java.lang.Class.createAnnotationData(Class.java:4246) at java.base/java.lang.Class.annotationData(Class.java:4235) at java.base/java.lang.Class.getAnnotation(Class.java:4118) at java.base/java.lang.reflect.AnnotatedElement.isAnnotationPresent(AnnotatedElement.java:292) at java.base/java.lang.Class.isAnnotationPresent(Class.java:4128) at org.junit.platform.commons.util.AnnotationUtils.findAnnotation(AnnotationUtils.java:136) at org.junit.platform.commons.util.AnnotationUtils.isAnnotated(AnnotationUtils.java:105) at org.junit.platform.commons.support.AnnotationSupport.isAnnotated(AnnotationSupport.java:97) at org.junit.jupiter.engine.discovery.predicates.TestClassPredicates.isAnnotatedButNotComposed(TestClassPredicates.java:168) at org.junit.jupiter.engine.discovery.predicates.TestClassPredicates.lambda$new$0(TestClassPredicates.java:47) at org.junit.jupiter.engine.discovery.predicates.TestClassPredicates.lambda$new$3(TestClassPredicates.java:54) at org.junit.jupiter.engine.discovery.MethodSelectorResolver.resolve(MethodSelectorResolver.java:105) at org.junit.jupiter.engine.discovery.MethodSelectorResolver.resolve(MethodSelectorResolver.java:78) at org.junit.platform.engine.support.discovery.EngineDiscoveryRequestResolution.lambda$resolve$2(EngineDiscoveryRequestResolution.java:150) at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) at java.base/java.util.ArrayList$ArrayListSpliterator.tryAdvance(ArrayList.java:1685) at java.base/java.util.stream.ReferencePipeline.forEachWithCancel(ReferencePipeline.java:129) at java.base/java.util.stream.AbstractPipeline.copyIntoWithCancel(AbstractPipeline.java:527) at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:513) at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) at java.base/java.util.stream.FindOps$FindOp.evaluateSequential(FindOps.java:150) at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) at java.base/java.util.stream.ReferencePipeline.findFirst(ReferencePipeline.java:647) at org.junit.platform.engine.support.discovery.EngineDiscoveryRequestResolution.resolve(EngineDiscoveryRequestResolution.java:189) at org.junit.platform.engine.support.discovery.EngineDiscoveryRequestResolution.resolve(EngineDiscoveryRequestResolution.java:126) at org.junit.platform.engine.support.discovery.EngineDiscoveryRequestResolution.resolveCompletely(EngineDiscoveryRequestResolution.java:92) at org.junit.platform.engine.support.discovery.EngineDiscoveryRequestResolution.run(EngineDiscoveryRequestResolution.java:83) at org.junit.platform.engine.support.discovery.EngineDiscoveryRequestResolver.resolve(EngineDiscoveryRequestResolver.java:149) at org.junit.jupiter.engine.discovery.DiscoverySelectorResolver.resolveSelectors(DiscoverySelectorResolver.java:63) at org.junit.jupiter.engine.JupiterTestEngine.discover(JupiterTestEngine.java:70) at org.junit.platform.launcher.core.EngineDiscoveryOrchestrator.discoverEngineRoot(EngineDiscoveryOrchestrator.java:195) at org.junit.platform.launcher.core.EngineDiscoveryOrchestrator.discoverSafely(EngineDiscoveryOrchestrator.java:174) at org.junit.platform.launcher.core.EngineDiscoveryOrchestrator.discover(EngineDiscoveryOrchestrator.java:119) at org.junit.platform.launcher.core.EngineDiscoveryOrchestrator.discover(EngineDiscoveryOrchestrator.java:84) at org.junit.platform.launcher.core.DefaultLauncher.discover(DefaultLauncher.java:104) at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:91) at org.junit.platform.launcher.core.DelegatingLauncher.execute(DelegatingLauncher.java:47) at org.junit.platform.launcher.core.InterceptingLauncher.lambda$execute$1(InterceptingLauncher.java:39) at org.junit.platform.launcher.core.ClasspathAlignmentCheckingLauncherInterceptor.intercept(ClasspathAlignmentCheckingLauncherInterceptor.java:25) at org.junit.platform.launcher.core.InterceptingLauncher.execute(InterceptingLauncher.java:38) at org.junit.platform.launcher.core.DelegatingLauncher.execute(DelegatingLauncher.java:47) at org.junit.platform.launcher.core.SessionPerRequestLauncher.execute(SessionPerRequestLauncher.java:66) at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:57) at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38) at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11) at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35) at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:232) at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:55) Process finished with exit code -1 # 使用包扫描的形式注册 ![image-20261103083917987](assets/image-20261103083917987.png) ![image-20261103083946742](assets/image-20261103083946742.png) - Controller ( 目前可以随便写 后面使用Spirngmvc的时候有特殊要求) - @RestController - Repository - Service - Component 除了@Component这个泛指组件的注解外,Spring还提供了与@Component功能相同的三个语义化注解。 1. @Service 业务层组件 2. @Controller 控制层组件 3. @Repository 数据层组件 修改上面代码,使用@Repository 和 @Service 替换 dao 与 service 组件上的注解。 # BeanFactory与ApplicationContext 获取Spring容器也可以使用BeanFactory接口。BeanFactory与ApplicationContext的区别是: 1. BeanFactory Bean工厂(org.springframework.beans.factory.BeanFactory)是Spring框架最核心的接口,提供了IoC的配置机制,使管理不同类型的Java对象成为可能。特点是:采用延迟加载Bean,直到第一次使用Bean实例时才会创建Bean。 2. ApplicationContext 应用上下文(org.springframework.context.ApplicationContext),继承自BeanFactory,提供了更多面向应用的功能,比如国际化支持、框架事件体系,更易于创建实际应用。 应用时,我们一般称BeanFactory为IoC容器,ApplicationContext为应用上下文: 1. BeanFactory是Spring框架的基础设施,面向Spring本身; 2. ApplicationContext面向使用Spring框架的开发者; 3. 几乎所有的应用场合都可以直接使用ApplicationContext而非底层的BeanFactory; ![image-20261102160353886](assets/image-20261102160353886.png) # AOP 面向切面编程 AOP:全称是 Aspect Oriented Programming 即:面向切面编程。 简单的说它就是把我们程序重复的代码抽取出来,在需要执行的时候,使用动态代理的技术,在不修改源码的基础上,对我们的已有方法进行增强。 即当需要扩展功能时,传统方式采用纵向继承方式实现。但这种方式有很多缺点。 比如:父类方法名称改变时,子类也要修改。给多个方法扩展功能时,子类也需要修改。 因此,spring的AOP,实际上是采用横向抽取机制,取代传统的纵向继承体系。 实现AOP示意图: 1. 先将方面代码抽取出来 ![img](assets/1604979623887-9e3b1c96-0dcf-46e2-ad14-238af06d56dd.png) 2. 运行时将业务代码和方面代码编织在一起 ![img](assets/1604979623883-6aaf0e7d-d06c-45ca-928c-3d9cdb5aca49.png) ![image-20261102163712850](assets/image-20261102163712850.png) ![image-20261102163725449](assets/image-20261102163725449.png) ​ 通知 Around ### 切面(Aspect) 切面是切点和通知组成,通知和切点共同定义了切面的全部内容即:它是什么,在何时何处完成其功能; 举例:将pointcut和Advice配置整合的过程切面 ### 连接点(Joinpoint) 连接点是在应用执行过程中能够插入切面的一个点,Spring仅支持方法的连接点,即仅能在方法调用前,方法调用后,方法抛出异常时及方法调用前后插入切面代码。 . 举例:如果在insert之前执行扩展(增强、通知),简单理解insert这个方法可以称之为连接点。 连接点: 1 Com.neuedu.service.StuServiceImpl.insert() 连接点: 2 Com.neuedu.service.UserServiceImpl.insert() ### 切点(Pointcut) ``` Com.neuedu.service.*Impl.insert() ``` ### 通知(Advice)、增强 切面的工作被成为通知,定义了切面是什么及何时使用。除了描述切面要完成的工作,通知还解决了何时执行这个工作的问题,它应该在某个方法被调用之前?之后?等。 举例:额外定义一个方法想要在连接点上进行扩展的功能 #### Spring切面可以应用5种类型的通知: 前置通知(Before)在目标方法被调用之前调用通知功能; 后置通知(After)在目标方法被完成之后调用通知功能,不关心方法的输出是什么; 环绕通知(Around advice)通知包裹了目标方法,在目标方法调用之前和之后执行自定义的行为; 异常通知(After-throwing)在目标方法抛出异常后调用通知; 返回通知(After-returning)在目标方法成功执行之后调用通知; ### 目标对象(Target) 通知逻辑的织入目标类。如果没有AOP,那么目标业务类需要自己实现所有的逻辑,在AOP的帮助下,目标类只需要实现那些非横切逻辑的程序逻辑,而比如事务管理等这些横切逻辑就可以使用AOP动态织入特定的连接点上。 举例:两个Service即是目标对象 ### 引入(Introduction) 引介是一种特殊的通知,为类添加一些属性和方法。这样,即使一个业务类原本没有实现某个接口,通过AOP的引介功能,也可以动态地为该业务类添加接口的实现逻辑,使业务类成为这个接口的实现类。 几乎由框架完成,我们可以暂时透明 ### 代理(Proxy) 一个类被AOP织入通知后,就产生一个结果类,它是融合了原类和通知逻辑的代理类。根据不同的代理方式,代理类既可能是和原类具有相同接口的类,也可能就是原类的子类,所以可以采用与调用原类相同的方式调用代理类。 举例:IOC容器创建的两个Service类型对象 ### 织入(Weaving) 织入是将通知添加到目标类的具体连接点上的过程.AOP就像一台织布机,将目标类,通知或引介编织到一起。 AOP有三种织入方式: ①编译期织入:切面在目标类编译时被织入,需要特殊的编译器; ②类装载期织入:切面在目标类加载到JVM时被织入,需要特殊的类装载器; ③动态代理织入:切面在应用运行的某个时刻呗织入,AOP容器会为目标对象动态创建一个代理对象; - 编写Service - 增强的代码(通知) - 配置前面 05-aop-xml ![image-20261102163937295](assets/image-20261102163937295.png) ![image-20261102165237243](assets/image-20261102165237243.png) # Spring整合Mybatis - Spring的项目(xml、javaconfig) - 添加依赖 - spring-context - spring-aop - aspectjweaver - spring-test - junit - spring-jdbc - mysql驱动 - mybatis - mybatis-spring - 数据源:druid - lombok - 编写service - 编写配置文件 spring-mybatis.xml - 包扫描 - 编写MyBatis - 核心配置文件 SqlMapConfig.xml - 编写实体类 Emp - 编写EmpMapper.xml - 编写EmpMapper.java - 就的SqlSessionFactory测试 - 整合 - 数据源 druid - 把SqlSessionFactory放到IOC容器中 - 在容器中管理Mapper的代理对象 - 整合测试 使用@Autowired从容器中获取Mapper ## 创建项目 ![image-20261103114719625](assets/image-20261103114719625.png) ## 添加依赖 ### 父项目 ```xml 4.0.0 com.neuedu.spring spring-learn 1.0 pom spring-learn http://maven.apache.org 01-spring-helloword-xml 02-spring-package-scan 03-spring-qualifier 04-spring-javaconfig 05-aop-xml 06-aop-xml-annotation 07-aop-javaconfig-annotation 08-spring-mybatis-xml UTF-8 6.2.19 5.14.4 1.8.7 8.4.0 3.5.6 1.18.48 1.2.28 4.0.0 org.springframework spring-core ${spring.version} compile org.springframework spring-aop ${spring.version} compile org.aspectj aspectjweaver ${aspectj.version} org.springframework spring-beans ${spring.version} compile org.springframework spring-context ${spring.version} compile org.springframework spring-expression ${spring.version} compile org.springframework spring-test ${spring.version} compile org.springframework spring-jdbc ${spring.version} compile org.junit.jupiter junit-jupiter-api ${junit.version} test com.mysql mysql-connector-j ${mysql.version} compile org.mybatis mybatis ${mybatis.version} org.projectlombok lombok ${lombok.version} provided com.alibaba druid ${druid.version} compile org.mybatis mybatis-spring ${mybatis.spring.version} compile ``` ### 子项目 ```xml 4.0.0 com.neuedu.spring spring-learn 1.0 08-spring-mybatis-xml jar 08-spring-mybatis-xml http://maven.apache.org UTF-8 org.springframework spring-context org.springframework spring-aop org.aspectj aspectjweaver org.springframework spring-test org.springframework spring-jdbc org.junit.jupiter junit-jupiter-api com.mysql mysql-connector-j org.mybatis mybatis org.projectlombok lombok com.alibaba druid org.mybatis mybatis-spring ``` ![image-20261103133249356](assets/image-20261103133249356.png) ## 搭建spring ### 编写Service ```java package com.neuedu.spring.service; import com.neuedu.spring.po.Emp; import org.springframework.stereotype.Service; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.spring.service * 类描述: * 创建人:金山老师 * 创建时间:2026/11/03 13:36 * 版本:1.0 * */ @Service public class EmpService { public Emp queryById(int id){ System.out.println("根据id查询数据库"); return new Emp(); //根据id查询数据库 } } ``` ### 配置文件 spring-mybaits.xml ```xml ``` ### 单元测试 ```java package com.neuedu.spring.service; import com.neuedu.spring.po.Emp; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.test.context.junit.jupiter.SpringJUnitConfig; import static org.junit.jupiter.api.Assertions.*; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.spring.service * 类描述: * 创建人:金山老师 * 创建时间:2026/11/03 13:39 * 版本:1.0 * */ @SpringJUnitConfig(locations = "classpath:spring-mybaits.xml") class EmpServiceTest { @Autowired private EmpService empService; @Test void queryById1() { System.out.println(empService); Emp emp = empService.queryById(10); } } ``` ## 在spring中管理数据源 获取连接对象Connection Druid [Apache Druid | Apache® Druid](https://druid.apache.org/) ![image-20261103140409522](assets/image-20261103140409522.png) ### 单元测试 ```java package com.neuedu.spring.service; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.test.context.junit.jupiter.SpringJUnitConfig; import javax.sql.DataSource; import java.sql.Connection; import java.sql.SQLException; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.spring.service * 类描述: * 创建人:金山老师 * 创建时间:2026/11/03 14:01 * 版本:1.0 * * * * spring-mybatis.xml * spring-mybatis.xml * * */ @SpringJUnitConfig(locations = "classpath:spring-mybatis.xml") public class DataSourceTest { @Autowired private DataSource dataSource; @Test public void testConnection(){ try { Connection connection = dataSource.getConnection(); System.out.println("connection = " + connection); } catch (SQLException e) { throw new RuntimeException(e); } } } ``` ## 整合MyBaits ### 编写SqlMapconfig.xml ```xml ``` ### 实体类 ```java package com.neuedu.spring.po; import lombok.Data; import java.util.Date; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.spring.po * 类描述: * 创建人:金山老师 * 创建时间:2026/11/03 13:37 * 版本:1.0 * */ @Data public class Emp { private Integer empno ; private String ename ; private String job ; private Integer mgr ; private Date hiredate ; private Double sal ; private String comm ; private Double deptno ; } ``` ### Mapper.java ![image-20261103144801181](assets/image-20261103144801181.png) ```java package com.neuedu.spring.mapper; import com.neuedu.spring.po.Emp; import java.util.List; /*** * * 项目名称: mybatis-app * 类名称:com.neuedu.mybatis.mapper * 类描述: * 创建人:金山老师 * 创建时间:2026/10/26 10:40 * 版本:1.0 * */ public interface EmpMapper { public List selectList(); public Emp selectById( int id ); public long total( ); public int updateById(Emp emp); public int insert(Emp emp); public int deleteById (int id ); } ``` ### Mapper.xml ```xml `empno`, `ename`, `job`, `mgr`, `hiredate`, `sal`, `comm`, `deptno` UPDATE `emp` `ename` = #{ename}, `job` = #{job}, `mgr` = #{mgr}, `hiredate` = #{hiredate}, `sal` = #{sal}, `comm` = #{comm}, `deptno` = #{deptno}, WHERE `empno` = #{empno} ; INSERT INTO `emp` `empno` , `ename` , `job` , `mgr` , `hiredate` , `sal` , `comm` , `deptno` , VALUES #{empno}, #{ename}, #{job}, #{mgr}, #{hiredate}, #{sal}, #{comm}, #{deptno}, delete from emp where empno = #{empno} ``` ## 使用spring管理 SqlSessionFactory 在spring-mybaits.xml中配置 ```xml ``` ## 在容器中声明一个Mapper ![image-20261103144724500](assets/image-20261103144724500.png) ## 批量注册Mapper到Spring容器 ```xml ``` ![image-20261103150346080](assets/image-20261103150346080.png) # 事务管理器 使用AOP 在 需要添加事务的 service方法上 增加额外的代码( 通知、增强 ) 只需要配置事务管理器 ``` ``` 在serice 中编写了一个需要事务的方法 ```java /** * sal 字段暂时当做 账户余额 * @param success * @return */ public boolean transfer(boolean success){ int id1 = 7369; //SMITH 7369 800.00 + 500 = 1300 int id2 = 7788; //SCOTT 7788 3000.00 - 500 = 2500 Emp smith = empMapper.selectById(id1); Emp scott = empMapper.selectById(id2); //内存中修改了下数据 smith.setSal(smith.getSal() + 500); scott.setSal(smith.getSal() - 500); int count1 = empMapper.updateById(smith); //中间过程还有一些代码逻辑,可能产生错误 if(!success){ throw new RuntimeException("保存smith的余额之后报错了 "); } int count2 = empMapper.updateById(scott); return count1 + count2 == 2; } ``` ## 单元测试 ```java @Test void transfer() { //success 模拟代码是否成功、出错 boolean success = false; boolean result = empService.transfer(success); System.out.println("result = " + result); } ``` ## 添加事务 在容器中声明事务管理器 ```xml ``` ## 传播特性 ![image-20261104113820438](assets/image-20261104113820438.png) ## 使用@Transactional待提xml切面 ![image-20261104133253867](assets/image-20261104133253867.png) # 纯注解的方式实现spring-mybais整合 ![image-20261104133409008](assets/image-20261104133409008.png) # SpringMVC [SpringMVC 官网文档](https://docs.spring.io/spring-framework/reference/6.2/web.html) ![image-20261104162214713](assets/image-20261104162214713.png) ![img](assets/1604979789045-b6ac3995-e979-4b22-a2e6-41e1b4ae1383.png) - web项目 - 配置tomcat - 添加依赖 - Handler(Controller)自定义 - 编写-spring-web.xml 容器的配置文件 - web.xml - 配置前端控制器(DispatcherServlet) - 读取spring-web.xml - 发布到Tomcat测试 ## HelloWorld ![image-20261104141236121](assets/image-20261104141236121.png) ### 添加依赖 需要父项目和子项目中都添加依赖 ```xml 4.0.0 com.neuedu.spring spring-learn 1.0 12-springmvc-helloworld war 12-springmvc-helloworld Maven Webapp jakarta.servlet jakarta.servlet-api org.springframework spring-webmvc ``` ![image-20261104141437701](assets/image-20261104141437701.png) ![image-20261104141503858](assets/image-20261104141503858.png) ### 编写Controller ```java package com.neuedu.his.controller; import jakarta.servlet.http.HttpServletRequest; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import java.sql.Array; import java.util.ArrayList; import java.util.List; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.his.controller * 类描述: * 创建人:金山老师 * 创建时间:2026/11/04 14:22 * 版本:1.0 * */ @Controller public class UserController { /*** * http://localhost:8080/web/user/index * @param request * @return */ @RequestMapping("/user/index") public String index(HttpServletRequest request){ //从数据库查询数据 List list = new ArrayList<>(); for (int i = 0; i < 10; i++) { list.add("张三"+i); } //设置数据 request.setAttribute("userList",list); return "/user/list.jsp"; } } ``` ```jsp <%@ page import="java.util.List" %><%-- Created by IntelliJ IDEA. User: Administrator Date: 2026/11/4 Time: 14:23 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> Title

用户表格

<% List list = (List) request.getAttribute("userList"); %> <% for (int i = 0; i < list.size(); i++) { String name = list.get(i); %> <% } %>
序号 姓名
<%=i%> <%=name%>
``` 配置核心的配置文件 ### spring-mvc.xml ```xml ``` ### 配置前端控制器 web.xml中配置 ```xml DispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:spring-mvc.xml DispatcherServlet / ``` ![image-20261104144205116](assets/image-20261104144205116.png) ## 整合Spring、Mybaits 从11 复制代码 注意包 原来com.neuedu.spring 现在com.neuedu.his ![image-20261104153725346](assets/image-20261104153725346.png) ### 依赖 ```xml 4.0.0 com.neuedu.spring spring-learn 1.0 12-springmvc-helloworld war 12-springmvc-helloworld Maven Webapp jakarta.servlet jakarta.servlet-api org.springframework spring-webmvc org.aspectj aspectjweaver org.springframework spring-test org.springframework spring-jdbc org.junit.jupiter junit-jupiter-api com.mysql mysql-connector-j org.mybatis mybatis org.projectlombok lombok com.alibaba druid org.mybatis mybatis-spring ``` ![image-20261104155029369](assets/image-20261104155029369.png) # SpringMVC 的参数绑定 [Method Arguments :: Spring Framework](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/arguments.html) | Controller method argument | Description | | :----------------------------------------------------------- | :----------------------------------------------------------- | | `WebRequest`, `NativeWebRequest` | Generic access to request parameters and request and session attributes, without direct use of the Servlet API. | | `jakarta.servlet.ServletRequest`, `jakarta.servlet.ServletResponse` | Choose any specific request or response type — for example, `ServletRequest`, `HttpServletRequest`, or Spring’s `MultipartRequest`, `MultipartHttpServletRequest`. | | `jakarta.servlet.http.HttpSession` | Enforces the presence of a session. As a consequence, such an argument is never `null`. Note that session access is not thread-safe. Consider setting the `RequestMappingHandlerAdapter` instance’s `synchronizeOnSession` flag to `true` if multiple requests are allowed to concurrently access a session. | | `jakarta.servlet.http.PushBuilder` | Servlet 4.0 push builder API for programmatic HTTP/2 resource pushes. Note that, per the Servlet specification, the injected `PushBuilder` instance can be null if the client does not support that HTTP/2 feature. | | `java.security.Principal` | Currently authenticated user — possibly a specific `Principal` implementation class if known.Note that this argument is not resolved eagerly, if it is annotated in order to allow a custom resolver to resolve it before falling back on default resolution via `HttpServletRequest#getUserPrincipal`. For example, the Spring Security `Authentication` implements `Principal` and would be injected as such via `HttpServletRequest#getUserPrincipal`, unless it is also annotated with `@AuthenticationPrincipal` in which case it is resolved by a custom Spring Security resolver through `Authentication#getPrincipal`. | | `HttpMethod` | The HTTP method of the request. | | `java.util.Locale` | The current request locale, determined by the most specific `LocaleResolver` available (in effect, the configured `LocaleResolver` or `LocaleContextResolver`). | | `java.util.TimeZone` + `java.time.ZoneId` | The time zone associated with the current request, as determined by a `LocaleContextResolver`. | | `java.io.InputStream`, `java.io.Reader` | For access to the raw request body as exposed by the Servlet API. | | `java.io.OutputStream`, `java.io.Writer` | For access to the raw response body as exposed by the Servlet API. | | `@PathVariable` | For access to URI template variables. See [URI patterns](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-requestmapping.html#mvc-ann-requestmapping-uri-templates). | | `@MatrixVariable` | For access to name-value pairs in URI path segments. See [Matrix Variables](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/matrix-variables.html). | | `@RequestParam` | For access to the Servlet request parameters, including multipart files. Parameter values are converted to the declared method argument type. See [`@RequestParam`](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/requestparam.html) as well as [Multipart](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/multipart-forms.html).Note that use of `@RequestParam` is optional for simple parameter values. See “Any other argument”, at the end of this table. | | `@RequestHeader` | For access to request headers. Header values are converted to the declared method argument type. See [`@RequestHeader`](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/requestheader.html). | | `@CookieValue` | For access to cookies. Cookies values are converted to the declared method argument type. See [`@CookieValue`](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/cookievalue.html). | | `@RequestBody` | For access to the HTTP request body. Body content is converted to the declared method argument type by using `HttpMessageConverter` implementations. See [`@RequestBody`](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/requestbody.html). | | `HttpEntity` | For access to request headers and body. The body is converted with an `HttpMessageConverter`. See [HttpEntity](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/httpentity.html). | | `@RequestPart` | For access to a part in a `multipart/form-data` request, converting the part’s body with an `HttpMessageConverter`. See [Multipart](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/multipart-forms.html). | | `java.util.Map`, `org.springframework.ui.Model`, `org.springframework.ui.ModelMap` | For access to the model that is used in HTML controllers and exposed to templates as part of view rendering. | | `RedirectAttributes` | Specify attributes to use in case of a redirect (that is, to be appended to the query string) and flash attributes to be stored temporarily until the request after redirect. See [Redirect Attributes](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/redirecting-passing-data.html) and [Flash Attributes](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/flash-attributes.html). | | `@ModelAttribute` | For access to an existing attribute in the model (instantiated if not present) with data binding and validation applied. See [`@ModelAttribute`](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/modelattrib-method-args.html) as well as [Model](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-modelattrib-methods.html) and [`DataBinder`](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-initbinder.html).Note that use of `@ModelAttribute` is optional (for example, to set its attributes). See “Any other argument” at the end of this table. | | `Errors`, `BindingResult` | For access to errors from validation and data binding for a command object (that is, a `@ModelAttribute` argument) or errors from the validation of a `@RequestBody` or `@RequestPart` arguments. You must declare an `Errors`, or `BindingResult` argument immediately after the validated method argument. | | `SessionStatus` + class-level `@SessionAttributes` | For marking form processing complete, which triggers cleanup of session attributes declared through a class-level `@SessionAttributes` annotation. See [`@SessionAttributes`](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/sessionattributes.html) for more details. | | `UriComponentsBuilder` | For preparing a URL relative to the current request’s host, port, scheme, context path, and the literal part of the servlet mapping. See [URI Links](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-uri-building.html). | | `@SessionAttribute` | For access to any session attribute, in contrast to model attributes stored in the session as a result of a class-level `@SessionAttributes` declaration. See [`@SessionAttribute`](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/sessionattribute.html) for more details. | | `@RequestAttribute` | For access to request attributes. See [`@RequestAttribute`](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/requestattrib.html) for more details. | | Any other argument | If a method argument is not matched to any of the earlier values in this table and it is a simple type (as determined by [BeanUtils#isSimpleProperty](https://docs.spring.io/spring-framework/docs/6.2.19/javadoc-api/org/springframework/beans/BeanUtils.html#isSimpleProperty(java.lang.Class))), it is resolved as a `@RequestParam`. Otherwise, it is resolved as a `@ModelAttribute`. | ## @RequestParam 用于访问 Servlet 请求参数,包括多部分文件。参数值 转换为声明的方法参数类型。也请参见[`@RequestParam`](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/requestparam.html) 作为[多部分](https://docs.spring.io/spring-framework/reference/6.2/web/webmvc/mvc-controller/ann-methods/multipart-forms.html)。 注意,对于简单参数值,使用该值是可选的。 参见本表末尾的“其他论证”。`@RequestParam` ```java @ResponseBody //将返回结果转换成json @RequestMapping("/emp/getById") public String getById(@RequestParam("id") int id){ Emp emp = empService.queryById(id); String json = "{\"ename\": \""+ emp.getEname()+"\",\"empno\": \""+ emp.getEmpno()+"\"}"; return json; } ``` ## 绑定HttpServletRequest、HttpServletResponse ```java // @ResponseBody //将返回结果转换成json // @PostMapping("/save" ) // public Map save(HttpServletRequest request , HttpServletResponse response){ // // // HttpSession session = request.getSession(); // // String empno = request.getParameter("empno"); // String ename = request.getParameter("ename"); // // // System.out.println("empno = " + empno); // System.out.println("ename = " + ename); // System.out.println("session = " + session); // // // Map result = new HashMap(); // // result.put("success",true); // { success: true } // return result; // } @ResponseBody //将返回结果转换成json @PostMapping("/save" ) public Map save( @RequestParam("empno") String empno, @RequestParam("ename") String ename ){ System.out.println("empno = " + empno); System.out.println("ename = " + ename); Map result = new HashMap(); result.put("success",true); // { success: true } return result; } ``` ## 省略@RequestParam注解 需要配合 maven插件,让编译后的class 保留方法上的参数名称 ```xml org.apache.maven.plugins maven-compiler-plugin 3.8.1 21 21 true ``` # 输出JSON 上面的代码是自己转换json字符串,ResponseBody 输出给客户端,希望SpringMVC自动的将方法中返回的对象转成json字符串 发送给浏览器 ```java @ResponseBody //将返回结果转换成json @RequestMapping("/emp/getById") public Emp getById(@RequestParam("id") int id){ Emp emp = empService.queryById(id); return emp; } ``` 需要额外的支持:(GSON FastJSON FastJson2 Jackson ),springmvc 使用的是 Jackson , 添加类库 ```xml com.fasterxml.jackson.core jackson-databind 2.9.0 ``` ![image-20261109091257397](assets/image-20261109091257397.png) 启动Tomcat 发现 ![image-20261109091521628](assets/image-20261109091521628.png) 需要让mvc使用 消息转换对象 在spirng的配置文件中添加配置 ```xml ``` ```xml ``` ![image-20261109091958309](assets/image-20261109091958309.png) # @RequestMapping 除了可以在方法上添加Requestmapping 也可以在 类上声明 ```java package com.neuedu.his.controller; import com.neuedu.his.po.Emp; import com.neuedu.his.service.EmpService; import jakarta.servlet.http.HttpServletRequest; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import java.util.ArrayList; import java.util.List; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.his.controller * 类描述: * 创建人:金山老师 * 创建时间:2026/11/04 14:22 * 版本:1.0 * */ @Controller @RequestMapping("/emp") public class EmpController { @Autowired private EmpService empService; /*** * http://localhost:8080/web/emp/getById?id=7396 * http://localhost:8080/web/emp/getById?id=7788 * @param * * (int id){ spring 6.0.2 之前好使 * * @return */ // @ResponseBody //将返回结果转换成json // @RequestMapping("/emp/getById") // public String getById(@RequestParam("id") int id){ // // Emp emp = empService.queryById(id); // // //自己拼接jSON // String json = "{\"ename\": \""+ emp.getEname()+"\",\"empno\": \""+ emp.getEmpno()+"\"}"; // // return json; // } /** * * http://localhost:8080/web/emp/getById?id=7396 * * http://localhost:8080/web/emp/getById?id=7788 * @param id * @return */ @ResponseBody //将返回结果转换成json @RequestMapping("/getById") public Emp getById(@RequestParam("id") int id){ Emp emp = empService.queryById(id); return emp; } @ResponseBody //将返回结果转换成json @RequestMapping("/remove") public boolean delete(@RequestParam("id") int id){ return empService.remove(id); } } ``` 可以设置 接收固定的 Methods(get、post、delete、optoion、xxxxx) ``` public enum RequestMethod { GET, HEAD, POST, PUT, PATCH, DELETE, OPTIONS, TRACE; ``` ![image-20261109094312930](assets/image-20261109094312930.png) ``` @RequestMapping(value = "/getById", method = RequestMethod.GET) 可以简写成 @GetMapping( "/getById") ``` - GetMapping - Postmapping - DeleteMapping - PutMapping - PATCHmapping - OPTIONSmapping - TRACEMapping - GET, HEAD, POST, PUT, PATCH, DELETE, OPTIONS, TRACE; - ``` PostMapping ``` # Tomcat 解决中文乱码的问题 ![image-20261109100523095](assets/image-20261109100523095.png) # 整合Vue 拿到Vue 项目首先安装依赖 `npm install` 已经有管理系统的样子了 数据整合 修改数据库中emp表 主键自增 ```sql ALTER TABLE `test`.`emp` CHANGE `empno` `empno` INT NOT NULL AUTO_INCREMENT COMMENT '员工编号'; ``` ## 编写Service、Controller、Mapper ![image-20261109110948363](assets/image-20261109110948363.png) ### Service ```java package com.neuedu.his.service; import com.neuedu.his.mapper.EmpMapper; import com.neuedu.his.po.Emp; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Isolation; import org.springframework.transaction.annotation.Propagation; import org.springframework.transaction.annotation.Transactional; import java.util.List; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.spring.service * 类描述: * 创建人:金山老师 * 创建时间:2026/11/03 13:36 * 版本:1.0 * */ @Service public class EmpService { @Autowired private EmpMapper empMapper; public Emp queryById(int id){ return empMapper.selectById(id); } public List queryList(){ return empMapper.selectList(); } /** * 删除 * @param id * @return */ public boolean remove(int id){ return empMapper.deleteById(id)>0; } /** * 保存 * @return */ public boolean save(Emp emp){ return empMapper.insert(emp)>0; } /** * 更新 * @param emp * @return */ public boolean update(Emp emp){ return empMapper.updateById(emp)>0; } /** * 保存或者更新 * @param emp * @return */ public boolean saveOrUpdate(Emp emp){ if(emp.getEmpno() != null){ return empMapper.updateById(emp)>0; }else{ return empMapper.insert(emp)>0; } } } ``` ## 前端 - 配置菜单 vue-vite-ts/src/components/NavMenu.vue - 配置有路由 :vue-vite-ts/src/router/index.ts - vue-vite-ts/src/views/system/emp/index.vue - 封装API ```typescript import service from "@/utils/request.ts"; /** * api 接口 */ export function listData(){ return service.get("/emp/list") } /** * 根据用户ID 删除数据 * @param id */ export function removeData(id:number){ return service.get( "/emo/remove", { params: {id}, }) } /** * 新增或更新 * @param params */ export function saveOrUpdate(params:Record){ return service.get("/emo/saveOrUpdate",{ params, }) } /** * 根据主键 查询单条记录 * @param id */ export function getById(id:number){ return service.get("/emo/queryById",{ params: {id}, }) } ``` ### 列表页面 ```vue ``` ![image-20261109134857759](assets/image-20261109134857759.png) ## 解决跨域的问题 后台允许跨域 需要后端响应一个头信息 包含 access-control-allow-origin :域名 ![image-20261109135350654](assets/image-20261109135350654.png) ![image-20261109135320933](assets/image-20261109135320933.png) 清空缓存,解决历史router的问题BUG ![image-20261109144128184](assets/image-20261109144128184.png) ## 整合分页 Pagehelper ```xml com.github.pagehelper pagehelper 5.3.3 ``` ![image-20261109145455763](assets/image-20261109145455763.png) 给SqlSessionFatcory配置插件 ```xml helperDialect=mysql reasonable=true supportMethodsArguments=true params=count=countSql ``` ### 使用分页插件 ```java package com.neuedu.his.mapper; import com.github.pagehelper.PageHelper; import com.neuedu.his.po.Emp; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.test.context.junit.jupiter.SpringJUnitConfig; import java.util.List; import static org.junit.jupiter.api.Assertions.*; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.his.mapper * 类描述: * 创建人:金山老师 * 创建时间:2026/11/09 14:56 * 版本:1.0 * */ @SpringJUnitConfig(locations = "classpath:spring-mvc.xml") class EmpMapperTest { @Autowired EmpMapper empMapper; @Test void selectPage() { //开启分页 PageHelper.startPage(1,10); List emps = empMapper.selectList(); //使用分页插件 emps.forEach(System.out::println); System.out.println("--------------------------------------------------"); System.out.println("--------------------------------------------------"); System.out.println("--------------------------------------------------"); System.out.println("--------------------------------------------------"); //开启分页 PageHelper.startPage(2,10); emps = empMapper.selectList(); //使用分页插件 emps.forEach(System.out::println); } } ``` ### 在Controller中使用 ```java /*** * 查询所有 * @return */ @ResponseBody // 将返回结果转换成json @GetMapping("/page") public PageInfo page(@RequestParam(value = "pageNum", defaultValue = "1") int pageNum, @RequestParam(value = "pageSize", defaultValue = "10") int pageSize) { Page page = PageHelper.startPage(pageNum, pageSize); empService.queryList(); return page.toPageInfo(); } ``` ![image-20261109154203238](assets/image-20261109154203238.png) ## 接收日期类型的参数 前端传递日期类型hiredate 到后台是 Date - 2026-10-11 年-月-日 - 10-11-2026 月-日- 年 ![image-20261110113206169](assets/image-20261110113206169.png) ```java package com.neuedu.his.po; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.util.Date; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.spring.po * 类描述: * 创建人:金山老师 * 创建时间:2026/11/03 13:37 * 版本:1.0 * */ @Data public class Emp { private Integer empno ; private String ename ; private String job ; private Integer mgr ; //能接收什么样的日期 // @DateTimeFormat(iso= DateTimeFormat.ISO.DATE_TIME) @DateTimeFormat(pattern= "yyyy-MM-dd") private Date hiredate ; private Double sal ; private String comm ; private Double deptno ; } ``` # 文件上传 创建项目搭建Springmvc+mybaits+pageHelper+junit - 13-ssm-upload 对上传信息进行存储 设计一张表 ```sql CREATE TABLE `test`.`upload_file`( `file_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '文件id', `origin_name` VARCHAR(100) COMMENT '原始文件名称', `size` BIGINT COMMENT '大小(字节)', `ext` VARCHAR(100) COMMENT '扩展名', `file_name` VARCHAR(100) COMMENT '存储的文件名', `create_time` DATETIME DEFAULT NOW() COMMENT '创建时间', PRIMARY KEY (`file_id`) ) ENGINE=INNODB CHARSET=utf8mb4; ``` 编写CRUD Controller、Service、Mapper、Po ```java package com.neuedu.his.controller; import com.github.pagehelper.Page; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import com.neuedu.his.po.UploadFile; import com.neuedu.his.service.UploadFileService; import jakarta.servlet.http.HttpServletRequest; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.util.HashMap; import java.util.List; import java.util.Map; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.his.controller * 类描述: * 创建人:金山老师 * 创建时间:2026/11/04 14:22 * 版本:1.0 * */ // @Controller @RestController @RequestMapping("/upload_file") public class UploadFileController { @Autowired private UploadFileService uploadFileService; /*** * 查询所有 * @return */ @GetMapping("/page") public PageInfo page(@RequestParam(value = "pageNum", defaultValue = "1") int pageNum, @RequestParam(value = "pageSize", defaultValue = "10") int pageSize, UploadFile param ) { Page page = PageHelper.startPage(pageNum, pageSize); uploadFileService.queryList(param); return page.toPageInfo(); } /** * 根据id查询 * * @param id * @return */ @GetMapping("/getById") public UploadFile getById(@RequestParam("id") int id) { return uploadFileService.queryById(id); } @PostMapping("/saveOrUpdate") public Map saveOrUpdate( @RequestBody UploadFile saveData) { boolean success = uploadFileService.saveOrUpdate(saveData); Map result = new HashMap(); result.put("success", success); return result; } } ``` service ```java package com.neuedu.his.service; import com.neuedu.his.mapper.EmpMapper; import com.neuedu.his.mapper.UploadFileMapper; import com.neuedu.his.po.Emp; import com.neuedu.his.po.UploadFile; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.spring.service * 类描述: * 创建人:金山老师 * 创建时间:2026/11/03 13:36 * 版本:1.0 * */ @Service public class UploadFileService { @Autowired private UploadFileMapper uploadFileMapper; public UploadFile queryById(int id){ return uploadFileMapper.selectById(id); } public List queryList(UploadFile param){ return uploadFileMapper.selectList(param); } /** * 删除 * @param id * @return */ public boolean remove(int id){ return uploadFileMapper.deleteById(id)>0; } /** * 保存 * @return */ public boolean save(UploadFile param){ return uploadFileMapper.insert(param)>0; } /** * 更新 * @param param * @return */ public boolean update(UploadFile param){ return uploadFileMapper.updateById(param)>0; } /** * 保存或者更新 * @param param * @return */ public boolean saveOrUpdate(UploadFile param){ if(param.getFileId() != null){ return uploadFileMapper.updateById(param)>0; }else{ return uploadFileMapper.insert(param)>0; } } } ``` # 拦截器 ## 搭建一个springmvc的项目 ![image-20261116090106251](assets/image-20261116090106251.png) - 添加依赖 - 整合springmvc - web.xml - spring-intercrptor.xml - 包扫描 - 编写Controller ![image-20261116090738153](assets/image-20261116090738153.png) ## 测试Controller http://localhost:8080/web/emp/list ## 实现拦截器 编写一个实现类 HandlerInterceptor 重写 - preHandle - postHandle - afterCompletion ```` package com.neuedu.his.intecrptor; import jakarta.servlet.http.HttpServletRequest; import jakarta.servlet.http.HttpServletResponse; import org.springframework.web.servlet.HandlerInterceptor; import org.springframework.web.servlet.ModelAndView; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.his.intecrptor * 类描述: * 创建人:金山老师 * 创建时间:2026/11/16 09:22 * 版本:1.0 * */ public class LoginInteceptor implements HandlerInterceptor { @Override public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception { System.out.println("LoginInteceptor.preHandle"); return true; } @Override public void postHandle(HttpServletRequest request, HttpServletResponse response, Object handler, ModelAndView modelAndView) throws Exception { System.out.println("LoginInteceptor.postHandle"); } @Override public void afterCompletion(HttpServletRequest request, HttpServletResponse response, Object handler, Exception ex) throws Exception { System.out.println("LoginInteceptor.afterCompletion"); } } ```` ## 配置拦截器 - xml(spring的xml配置文件) | pre | Controller#list方法 | Post | After | | ----- | ------------------- | ---- | ----- | | true | 能执行 没有报错 | √ | √ | | false | 不执行 | x | x | | true | 能执行 报错了 | x | √ | # 异常处理 当Controller 报错, 错误 抛给 Tomcat 正常消息 ```json { code : 200 data: T } ``` 失败的消息 ```json { code : 403/500 msg: "/ by zero " } ``` ## 局部的异常处理 在Controller 中添加一个 @ExceptionHandler 方法 ```java /*** * 一旦出现异常,执行 exceptionHandler * @return */ @ExceptionHandler(exception=Exception.class) public String exceptionHandler(Exception ex){ System.out.println("EmpController.exceptionHandler==出现异常了 "); return "error: "+ex.getMessage(); } ``` ![image-20261116104233478](assets/image-20261116104233478.png) ## 全局的异常处理器 ```java package com.neuedu.his.common.ex; import jakarta.servlet.http.HttpServletResponse; import org.springframework.web.bind.annotation.ControllerAdvice; import org.springframework.web.bind.annotation.ExceptionHandler; import org.springframework.web.bind.annotation.RestControllerAdvice; import java.io.IOException; import java.io.PrintWriter; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.his.common.ex * 类描述: * 创建人:金山老师 * 创建时间:2026/11/16 10:44 * 版本:1.0 * */ // @ControllerAdvice @RestControllerAdvice public class MyExceptionHandler { /*** * 一旦出现异常,执行 exceptionHandler * @return */ // @ExceptionHandler(exception=Exception.class) // public void exceptionHandler(Exception ex, HttpServletResponse response) throws IOException { // // System.out.println("EmpController.exceptionHandler==出现异常了 "); // // // PrintWriter out = response.getWriter(); // out.write("error: "+ex.getMessage()); // out.flush(); // out.close(); // // return "error: "+ex.getMessage(); // } /*** * 一旦出现异常,执行 exceptionHandler * @return */ @ExceptionHandler(exception=Exception.class) public Ret exceptionHandler(Exception ex) throws IOException { System.out.println("EmpController.exceptionHandler==出现异常了 "); return Ret.error(500,"error: "+ex.getMessage()) ; } } ``` ## 通用的返回结果 Ret ```java package com.neuedu.his.common.ex; import lombok.Data; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.his.common.ex * 类描述: * 创建人:金山老师 * 创建时间:2026/11/16 10:49 * 版本:1.0 * */ @Data public class Ret { //状态吗 200 500 403 private Integer code; //提示信息 private String msg; //数据 private T data; public static Ret ok(T data){ Ret ret = new Ret<>(); ret.setCode(200); ret.setData(data); return ret; } public static Ret error(Integer code,String msg){ Ret ret = new Ret<>(); ret.setCode(code); ret.setMsg(msg); return ret; } } ``` ## 失败的消息 [localhost:8080/web/emp/zero?numa=0&numb=0](http://localhost:8080/web/emp/zero?numa=0&numb=0) ![image-20261116105647947](assets/image-20261116105647947.png) ## 成功的消息 [localhost:8080/web/emp/list](http://localhost:8080/web/emp/list) ![image-20261116105623803](assets/image-20261116105623803.png) # JWT JSON Web Token 明文: { header payload : zhangsan signature } ## 实现编解码 https://mvnrepository.com/artifact/com.auth0/java-jwt - **io.jsonwebtoken** - java-jwt: 简单的 ```xml com.auth0 java-jwt 4.6.2 compile ``` ### 编码: 将 username :admin 生成一个token ```java package com.neuedu.his; import com.auth0.jwt.JWT; import com.auth0.jwt.algorithms.Algorithm; import org.junit.jupiter.api.Test; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.his * 类描述: * 创建人:金山老师 * 创建时间:2026/11/16 11:33 * 版本:1.0 * */ public class JWTTest { private String secret ="写啥都行保密,不能给别人"; @Test public void encode(){ String username = "admin"; String token = JWT.create() //payload 负载,信息 .withClaim("username", username) .sign(Algorithm.HMAC256(secret)); System.out.println("token = " + token); } } ``` ![image-20261116113655377](assets/image-20261116113655377.png) ### 解码 将JSON按照Base64的格式转换了 ``` //eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6ImFkbWluIn0.-Bo_Hi-8TjfFpIGxyjlRkCooH9XoouC2A3KD2L0k8Ww eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9. header eyJ1c2VybmFtZSI6ImFkbWluIn0. payload -Bo_Hi-8TjfFpIGxyjlRkCooH9XoouC2A3KD2L0k8Ww singnature ``` ![image-20261116113844837](assets/image-20261116113844837.png) ```java package com.neuedu.his; import com.auth0.jwt.JWT; import com.auth0.jwt.JWTVerifier; import com.auth0.jwt.algorithms.Algorithm; import com.auth0.jwt.interfaces.Claim; import com.auth0.jwt.interfaces.DecodedJWT; import org.junit.jupiter.api.Test; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.his * 类描述: * 创建人:金山老师 * 创建时间:2026/11/16 11:33 * 版本:1.0 * */ public class JWTTest { private String secret ="写啥都行保密,不能给别人"; @Test public void encode(){ String username = "admin"; String nickname = "管理员"; String lastLogin = "2026-11-16 11:43:01"; String token = JWT.create() //payload 负载,信息 .withClaim("username", username) .withClaim("nickname", nickname) .withClaim("lastLogin", lastLogin) .sign(Algorithm.HMAC256(secret)); System.out.println("token = " + token); } //eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6ImFkbWluIn0.-Bo_Hi-8TjfFpIGxyjlRkCooH9XoouC2A3KD2L0k8Ww //eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6ImFkbWluIiwibmlja25hbWUiOiLnrqHnkIblkZgiLCJsYXN0TG9naW4iOiIyMDI2LTExLTE2IDExOjQzOjAxIn0.S7VOxMhAf4FrloyY5QFgOq3pyHLo4_gfFwDGiMiDuZk @Test public void decode(){ String token = "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6ImFkbWluIiwibmlja25hbWUiOiLnrqHnkIblkZgiLCJsYXN0TG9naW4iOiIyMDI2LTExLTE2IDExOjQzOjAxIn0.S7VOxMhAf4FrloyY5QFgOq3pyHLo4_gfFwDGiMiDuZk"; // String token = "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6ImFkbWluIiwibmlja25hbWUiOiLnrqHnkIblkZgiLCJsYXN0TG9naW4iOiIyMDI2LTExLTE2IDExOjQzOjAxIn0.S6VOxMhAf4FrloyY5QFgOq3pyHLo4_gfFwDGiMiDuZk"; //验证token 是否合法 JWTVerifier build = JWT.require(Algorithm.HMAC256(secret)).build(); //解析tpoken try{ DecodedJWT decodeJWT = build.verify(token); String username = decodeJWT.getClaim("username").asString(); String nickname = decodeJWT.getClaim("nickname").asString(); String lastLogin = decodeJWT.getClaim("lastLogin").asString(); System.out.println("username = " + username); System.out.println("nickname = " + nickname); System.out.println("lastLogin = " + lastLogin); System.out.println("token 是正常的"); }catch (Exception e){ System.out.println("无效Token 401 403 "); } } } ``` ![image-20261116114652159](assets/image-20261116114652159.png) # 基于SpringMVC+JWT登录 ![image-20261116134503322](assets/image-20261116134503322.png) ## 编写Token工具 ```java package com.neuedu.his.common.util; import com.auth0.jwt.JWT; import com.auth0.jwt.JWTVerifier; import com.auth0.jwt.algorithms.Algorithm; import com.auth0.jwt.interfaces.DecodedJWT; import com.neuedu.his.po.User; import java.util.Date; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.his.common.util * 类描述: * 创建人:金山老师 * 创建时间:2026/11/16 13:50 * 版本:1.0 * */ public class JWTUtil { //秘钥 private static String secret ="写啥都行保密,不能给别人"; //用于生成Token public static String encode(User user){ String token = JWT.create() //payload 负载,信息 .withClaim("userId", user.getUserId()) .withClaim("username", user.getUsername()) .withClaim("lastLogin", new Date()) .sign(Algorithm.HMAC256(secret)); return token; } //eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6ImFkbWluIn0.-Bo_Hi-8TjfFpIGxyjlRkCooH9XoouC2A3KD2L0k8Ww //eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6ImFkbWluIiwibmlja25hbWUiOiLnrqHnkIblkZgiLCJsYXN0TG9naW4iOiIyMDI2LTExLTE2IDExOjQzOjAxIn0.S7VOxMhAf4FrloyY5QFgOq3pyHLo4_gfFwDGiMiDuZk public static User decode(String token ){ if(token== null || "".equals(token)){ return null; } User user = null; //验证token 是否合法 JWTVerifier build = JWT.require(Algorithm.HMAC256(secret)).build(); //解析tpoken try{ DecodedJWT decodeJWT = build.verify(token); String username = decodeJWT.getClaim("username").asString(); int userId = decodeJWT.getClaim("userId").asInt(); Date lastLogin = decodeJWT.getClaim("lastLogin").asDate(); user = new User(); user.setUserId(userId); user.setNickname(username); user.setLastLogin(lastLogin); }catch (Exception e){ //token 不正确,或者 token 没穿 } return user; } } ``` ## LoginController ```java package com.neuedu.his.controller; import com.neuedu.his.common.Ret; import com.neuedu.his.common.util.JWTUtil; import com.neuedu.his.po.User; import org.springframework.web.bind.annotation.RestController; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.his.controller * 类描述: \ * 创建人:金山老师 * 创建时间:2026/11/16 13:45 * 版本:1.0 * */ @RestController public class LoginController { public Ret login(User user){ Ret ret = null; //判断数据库中是否存在 username、password maybaits UserSerice、UserMapper if("admin".equals(user.getUsername()) || "root".equals(user.getUsername())){ //登录成功 ret = Ret.ok(JWTUtil.encode(user)); }else{ ret = Ret.error(403,"用户名和密码不正确"); } return ret; } } ``` ### 登录成功的结果 ![image-20261116140911037](assets/image-20261116140911037.png) ### 失败的 ![image-20261116140933192](assets/image-20261116140933192.png) ## 添加登录拦截器 - LoginInteceptor # RESTFul /emp/getById/1 - Get : /emp/1 getById - Delete: /emp/1 removeById # 前后端开发框架搭建 基于若依的数据 ```sql /* SQLyog Ultimate v12.08 (64 bit) MySQL - 8.0.30 : Database - his ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`his` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `his`; /*Table structure for table `gen_table` */ DROP TABLE IF EXISTS `gen_table`; CREATE TABLE `gen_table` ( `table_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `table_name` varchar(200) DEFAULT '' COMMENT '表名称', `table_comment` varchar(500) DEFAULT '' COMMENT '表描述', `sub_table_name` varchar(64) DEFAULT NULL COMMENT '关联子表的表名', `sub_table_fk_name` varchar(64) DEFAULT NULL COMMENT '子表关联的外键名', `class_name` varchar(100) DEFAULT '' COMMENT '实体类名称', `tpl_category` varchar(200) DEFAULT 'crud' COMMENT '使用的模板(crud单表操作 tree树表操作)', `tpl_web_type` varchar(30) DEFAULT '' COMMENT '前端模板类型(element-ui模版 element-plus模版)', `package_name` varchar(100) DEFAULT NULL COMMENT '生成包路径', `module_name` varchar(30) DEFAULT NULL COMMENT '生成模块名', `business_name` varchar(30) DEFAULT NULL COMMENT '生成业务名', `function_name` varchar(50) DEFAULT NULL COMMENT '生成功能名', `function_author` varchar(50) DEFAULT NULL COMMENT '生成功能作者', `form_col_num` int DEFAULT '1' COMMENT '表单布局(单列 双列 三列)', `gen_type` char(1) DEFAULT '0' COMMENT '生成代码方式(0zip压缩包 1自定义路径)', `gen_path` varchar(200) DEFAULT '/' COMMENT '生成路径(不填默认项目路径)', `options` varchar(1000) DEFAULT NULL COMMENT '其它生成选项', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`table_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='代码生成业务表'; /*Data for the table `gen_table` */ /*Table structure for table `gen_table_column` */ DROP TABLE IF EXISTS `gen_table_column`; CREATE TABLE `gen_table_column` ( `column_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `table_id` bigint DEFAULT NULL COMMENT '归属表编号', `column_name` varchar(200) DEFAULT NULL COMMENT '列名称', `column_comment` varchar(500) DEFAULT NULL COMMENT '列描述', `column_type` varchar(100) DEFAULT NULL COMMENT '列类型', `java_type` varchar(500) DEFAULT NULL COMMENT 'JAVA类型', `java_field` varchar(200) DEFAULT NULL COMMENT 'JAVA字段名', `is_pk` char(1) DEFAULT NULL COMMENT '是否主键(1是)', `is_increment` char(1) DEFAULT NULL COMMENT '是否自增(1是)', `is_required` char(1) DEFAULT NULL COMMENT '是否必填(1是)', `is_insert` char(1) DEFAULT NULL COMMENT '是否为插入字段(1是)', `is_edit` char(1) DEFAULT NULL COMMENT '是否编辑字段(1是)', `is_list` char(1) DEFAULT NULL COMMENT '是否列表字段(1是)', `is_query` char(1) DEFAULT NULL COMMENT '是否查询字段(1是)', `query_type` varchar(200) DEFAULT 'EQ' COMMENT '查询方式(等于、不等于、大于、小于、范围)', `html_type` varchar(200) DEFAULT NULL COMMENT '显示类型(文本框、文本域、下拉框、复选框、单选框、日期控件)', `dict_type` varchar(200) DEFAULT '' COMMENT '字典类型', `sort` int DEFAULT NULL COMMENT '排序', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`column_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='代码生成业务表字段'; /*Data for the table `gen_table_column` */ /*Table structure for table `sys_config` */ DROP TABLE IF EXISTS `sys_config`; CREATE TABLE `sys_config` ( `config_id` int NOT NULL AUTO_INCREMENT COMMENT '参数主键', `config_name` varchar(100) DEFAULT '' COMMENT '参数名称', `config_key` varchar(100) DEFAULT '' COMMENT '参数键名', `config_value` varchar(500) DEFAULT '' COMMENT '参数键值', `config_type` char(1) DEFAULT 'N' COMMENT '系统内置(Y是 N否)', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`config_id`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='参数配置表'; /*Data for the table `sys_config` */ insert into `sys_config`(`config_id`,`config_name`,`config_key`,`config_value`,`config_type`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'主框架页-默认皮肤样式名称','sys.index.skinName','skin-blue','Y','admin','2026-10-20 11:20:32','',NULL,'蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow'),(2,'用户管理-账号初始密码','sys.user.initPassword','123456','Y','admin','2026-10-20 11:20:32','',NULL,'初始化密码 123456'),(3,'主框架页-侧边栏主题','sys.index.sideTheme','theme-dark','Y','admin','2026-10-20 11:20:32','',NULL,'深色主题theme-dark,浅色主题theme-light'),(4,'账号自助-验证码开关','sys.account.captchaEnabled','true','Y','admin','2026-10-20 11:20:32','',NULL,'是否开启验证码功能(true开启,false关闭)'),(5,'账号自助-是否开启用户注册功能','sys.account.registerUser','false','Y','admin','2026-10-20 11:20:32','',NULL,'是否开启注册用户功能(true开启,false关闭)'),(6,'用户登录-黑名单列表','sys.login.blackIPList','','Y','admin','2026-10-20 11:20:32','',NULL,'设置登录IP黑名单限制,多个匹配项以;分隔,支持匹配(*通配、网段)'),(7,'用户管理-初始密码修改策略','sys.account.initPasswordModify','1','Y','admin','2026-10-20 11:20:32','',NULL,'0:初始密码修改策略关闭,没有任何提示,1:提醒用户,如果未修改初始密码,则在登录时就会提醒修改密码对话框'),(8,'用户管理-账号密码更新周期','sys.account.passwordValidateDays','0','Y','admin','2026-10-20 11:20:32','',NULL,'密码更新周期(填写数字,数据初始化值为0不限制,若修改必须为大于0小于365的正整数),如果超过这个周期登录系统时,则在登录时就会提醒修改密码对话框'),(9,'用户管理-密码字符范围','sys.account.chrtype','0','Y','admin','2026-10-20 11:20:32','',NULL,'默认任意字符范围,0任意(密码可以输入任意字符),1数字(密码只能为0-9数字),2英文字母(密码只能为a-z和A-Z字母),3字母和数字(密码必须包含字母,数字),4字母数字和特殊字符(目前支持的特殊字符包括:~!@#$%^&*()-=_+)'); /*Table structure for table `sys_dept` */ DROP TABLE IF EXISTS `sys_dept`; CREATE TABLE `sys_dept` ( `dept_id` bigint NOT NULL AUTO_INCREMENT COMMENT '部门id', `parent_id` bigint DEFAULT '0' COMMENT '父部门id', `ancestors` varchar(50) DEFAULT '' COMMENT '祖级列表', `dept_name` varchar(30) DEFAULT '' COMMENT '部门名称', `order_num` int DEFAULT '0' COMMENT '显示顺序', `leader` varchar(20) DEFAULT NULL COMMENT '负责人', `phone` varchar(11) DEFAULT NULL COMMENT '联系电话', `email` varchar(50) DEFAULT NULL COMMENT '邮箱', `status` char(1) DEFAULT '0' COMMENT '部门状态(0正常 1停用)', `del_flag` char(1) DEFAULT '0' COMMENT '删除标志(0代表存在 2代表删除)', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`dept_id`) ) ENGINE=InnoDB AUTO_INCREMENT=200 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='部门表'; /*Data for the table `sys_dept` */ insert into `sys_dept`(`dept_id`,`parent_id`,`ancestors`,`dept_name`,`order_num`,`leader`,`phone`,`email`,`status`,`del_flag`,`create_by`,`create_time`,`update_by`,`update_time`) values (100,0,'0','若依科技',0,'若依','15888888888','ry@qq.com','0','0','admin','2026-10-20 11:19:57','',NULL),(101,100,'0,100','深圳总公司',1,'若依','15888888888','ry@qq.com','0','0','admin','2026-10-20 11:19:57','',NULL),(102,100,'0,100','长沙分公司',2,'若依','15888888888','ry@qq.com','0','0','admin','2026-10-20 11:19:57','',NULL),(103,101,'0,100,101','研发部门',1,'若依','15888888888','ry@qq.com','0','0','admin','2026-10-20 11:19:57','',NULL),(104,101,'0,100,101','市场部门',2,'若依','15888888888','ry@qq.com','0','0','admin','2026-10-20 11:19:57','',NULL),(105,101,'0,100,101','测试部门',3,'若依','15888888888','ry@qq.com','0','0','admin','2026-10-20 11:19:57','',NULL),(106,101,'0,100,101','财务部门',4,'若依','15888888888','ry@qq.com','0','0','admin','2026-10-20 11:19:57','',NULL),(107,101,'0,100,101','运维部门',5,'若依','15888888888','ry@qq.com','0','0','admin','2026-10-20 11:19:57','',NULL),(108,102,'0,100,102','市场部门',1,'若依','15888888888','ry@qq.com','0','0','admin','2026-10-20 11:19:57','',NULL),(109,102,'0,100,102','财务部门',2,'若依','15888888888','ry@qq.com','0','0','admin','2026-10-20 11:19:58','',NULL); /*Table structure for table `sys_dict_data` */ DROP TABLE IF EXISTS `sys_dict_data`; CREATE TABLE `sys_dict_data` ( `dict_code` bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码', `dict_sort` int DEFAULT '0' COMMENT '字典排序', `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签', `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值', `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型', `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性(其他样式扩展)', `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式', `is_default` char(1) DEFAULT 'N' COMMENT '是否默认(Y是 N否)', `status` char(1) DEFAULT '0' COMMENT '状态(0正常 1停用)', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`dict_code`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典数据表'; /*Data for the table `sys_dict_data` */ insert into `sys_dict_data`(`dict_code`,`dict_sort`,`dict_label`,`dict_value`,`dict_type`,`css_class`,`list_class`,`is_default`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,1,'男','0','sys_user_sex','','','Y','0','admin','2026-10-20 11:20:29','',NULL,'性别男'),(2,2,'女','1','sys_user_sex','','','N','0','admin','2026-10-20 11:20:29','',NULL,'性别女'),(3,3,'未知','2','sys_user_sex','','','N','0','admin','2026-10-20 11:20:29','',NULL,'性别未知'),(4,1,'显示','0','sys_show_hide','','primary','Y','0','admin','2026-10-20 11:20:29','',NULL,'显示菜单'),(5,2,'隐藏','1','sys_show_hide','','danger','N','0','admin','2026-10-20 11:20:29','',NULL,'隐藏菜单'),(6,1,'正常','0','sys_normal_disable','','primary','Y','0','admin','2026-10-20 11:20:29','',NULL,'正常状态'),(7,2,'停用','1','sys_normal_disable','','danger','N','0','admin','2026-10-20 11:20:29','',NULL,'停用状态'),(8,1,'正常','0','sys_job_status','','primary','Y','0','admin','2026-10-20 11:20:29','',NULL,'正常状态'),(9,2,'暂停','1','sys_job_status','','danger','N','0','admin','2026-10-20 11:20:29','',NULL,'停用状态'),(10,1,'默认','DEFAULT','sys_job_group','','','Y','0','admin','2026-10-20 11:20:29','',NULL,'默认分组'),(11,2,'系统','SYSTEM','sys_job_group','','','N','0','admin','2026-10-20 11:20:29','',NULL,'系统分组'),(12,1,'是','Y','sys_yes_no','','primary','Y','0','admin','2026-10-20 11:20:29','',NULL,'系统默认是'),(13,2,'否','N','sys_yes_no','','danger','N','0','admin','2026-10-20 11:20:29','',NULL,'系统默认否'),(14,1,'通知','1','sys_notice_type','','warning','Y','0','admin','2026-10-20 11:20:29','',NULL,'通知'),(15,2,'公告','2','sys_notice_type','','success','N','0','admin','2026-10-20 11:20:29','',NULL,'公告'),(16,1,'正常','0','sys_notice_status','','primary','Y','0','admin','2026-10-20 11:20:29','',NULL,'正常状态'),(17,2,'关闭','1','sys_notice_status','','danger','N','0','admin','2026-10-20 11:20:29','',NULL,'关闭状态'),(18,99,'其他','0','sys_oper_type','','info','N','0','admin','2026-10-20 11:20:29','',NULL,'其他操作'),(19,1,'新增','1','sys_oper_type','','info','N','0','admin','2026-10-20 11:20:29','',NULL,'新增操作'),(20,2,'修改','2','sys_oper_type','','info','N','0','admin','2026-10-20 11:20:29','',NULL,'修改操作'),(21,3,'删除','3','sys_oper_type','','danger','N','0','admin','2026-10-20 11:20:30','',NULL,'删除操作'),(22,4,'授权','4','sys_oper_type','','primary','N','0','admin','2026-10-20 11:20:30','',NULL,'授权操作'),(23,5,'导出','5','sys_oper_type','','warning','N','0','admin','2026-10-20 11:20:30','',NULL,'导出操作'),(24,6,'导入','6','sys_oper_type','','warning','N','0','admin','2026-10-20 11:20:30','',NULL,'导入操作'),(25,7,'强退','7','sys_oper_type','','danger','N','0','admin','2026-10-20 11:20:30','',NULL,'强退操作'),(26,8,'生成代码','8','sys_oper_type','','warning','N','0','admin','2026-10-20 11:20:30','',NULL,'生成操作'),(27,9,'清空数据','9','sys_oper_type','','danger','N','0','admin','2026-10-20 11:20:30','',NULL,'清空操作'),(28,1,'成功','0','sys_common_status','','primary','N','0','admin','2026-10-20 11:20:30','',NULL,'正常状态'),(29,2,'失败','1','sys_common_status','','danger','N','0','admin','2026-10-20 11:20:30','',NULL,'停用状态'); /*Table structure for table `sys_dict_type` */ DROP TABLE IF EXISTS `sys_dict_type`; CREATE TABLE `sys_dict_type` ( `dict_id` bigint NOT NULL AUTO_INCREMENT COMMENT '字典主键', `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称', `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型', `status` char(1) DEFAULT '0' COMMENT '状态(0正常 1停用)', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`dict_id`), UNIQUE KEY `dict_type` (`dict_type`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典类型表'; /*Data for the table `sys_dict_type` */ insert into `sys_dict_type`(`dict_id`,`dict_name`,`dict_type`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'用户性别','sys_user_sex','0','admin','2026-10-20 11:20:26','',NULL,'用户性别列表'),(2,'菜单状态','sys_show_hide','0','admin','2026-10-20 11:20:26','',NULL,'菜单状态列表'),(3,'系统开关','sys_normal_disable','0','admin','2026-10-20 11:20:26','',NULL,'系统开关列表'),(4,'任务状态','sys_job_status','0','admin','2026-10-20 11:20:26','',NULL,'任务状态列表'),(5,'任务分组','sys_job_group','0','admin','2026-10-20 11:20:26','',NULL,'任务分组列表'),(6,'系统是否','sys_yes_no','0','admin','2026-10-20 11:20:26','',NULL,'系统是否列表'),(7,'通知类型','sys_notice_type','0','admin','2026-10-20 11:20:26','',NULL,'通知类型列表'),(8,'通知状态','sys_notice_status','0','admin','2026-10-20 11:20:26','',NULL,'通知状态列表'),(9,'操作类型','sys_oper_type','0','admin','2026-10-20 11:20:26','',NULL,'操作类型列表'),(10,'系统状态','sys_common_status','0','admin','2026-10-20 11:20:26','',NULL,'登录状态列表'); /*Table structure for table `sys_job` */ DROP TABLE IF EXISTS `sys_job`; CREATE TABLE `sys_job` ( `job_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务ID', `job_name` varchar(64) NOT NULL DEFAULT '' COMMENT '任务名称', `job_group` varchar(64) NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名', `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串', `cron_expression` varchar(255) DEFAULT '' COMMENT 'cron执行表达式', `misfire_policy` varchar(20) DEFAULT '3' COMMENT '计划执行错误策略(1立即执行 2执行一次 3放弃执行)', `concurrent` char(1) DEFAULT '1' COMMENT '是否并发执行(0允许 1禁止)', `status` char(1) DEFAULT '0' COMMENT '状态(0正常 1暂停)', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT '' COMMENT '备注信息', PRIMARY KEY (`job_id`,`job_name`,`job_group`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='定时任务调度表'; /*Data for the table `sys_job` */ insert into `sys_job`(`job_id`,`job_name`,`job_group`,`invoke_target`,`cron_expression`,`misfire_policy`,`concurrent`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'系统默认(无参)','DEFAULT','ryTask.ryNoParams','0/10 * * * * ?','3','1','1','admin','2026-10-20 11:20:36','',NULL,''),(2,'系统默认(有参)','DEFAULT','ryTask.ryParams(\'ry\')','0/15 * * * * ?','3','1','1','admin','2026-10-20 11:20:36','',NULL,''),(3,'系统默认(多参)','DEFAULT','ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)','0/20 * * * * ?','3','1','1','admin','2026-10-20 11:20:36','',NULL,''); /*Table structure for table `sys_job_log` */ DROP TABLE IF EXISTS `sys_job_log`; CREATE TABLE `sys_job_log` ( `job_log_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务日志ID', `job_name` varchar(64) NOT NULL COMMENT '任务名称', `job_group` varchar(64) NOT NULL COMMENT '任务组名', `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串', `job_message` varchar(500) DEFAULT NULL COMMENT '日志信息', `status` char(1) DEFAULT '0' COMMENT '执行状态(0正常 1失败)', `exception_info` varchar(2000) DEFAULT '' COMMENT '异常信息', `start_time` datetime DEFAULT NULL COMMENT '执行开始时间', `end_time` datetime DEFAULT NULL COMMENT '执行结束时间', `create_time` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`job_log_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='定时任务调度日志表'; /*Data for the table `sys_job_log` */ /*Table structure for table `sys_logininfor` */ DROP TABLE IF EXISTS `sys_logininfor`; CREATE TABLE `sys_logininfor` ( `info_id` bigint NOT NULL AUTO_INCREMENT COMMENT '访问ID', `user_name` varchar(50) DEFAULT '' COMMENT '用户账号', `ipaddr` varchar(128) DEFAULT '' COMMENT '登录IP地址', `login_location` varchar(255) DEFAULT '' COMMENT '登录地点', `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型', `os` varchar(50) DEFAULT '' COMMENT '操作系统', `status` char(1) DEFAULT '0' COMMENT '登录状态(0成功 1失败)', `msg` varchar(255) DEFAULT '' COMMENT '提示消息', `login_time` datetime DEFAULT NULL COMMENT '访问时间', PRIMARY KEY (`info_id`), KEY `idx_sys_logininfor_s` (`status`), KEY `idx_sys_logininfor_lt` (`login_time`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统访问记录'; /*Data for the table `sys_logininfor` */ /*Table structure for table `sys_menu` */ DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `menu_id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID', `menu_name` varchar(50) NOT NULL COMMENT '菜单名称', `parent_id` bigint DEFAULT '0' COMMENT '父菜单ID', `order_num` int DEFAULT '0' COMMENT '显示顺序', `path` varchar(200) DEFAULT '' COMMENT '路由地址', `component` varchar(255) DEFAULT NULL COMMENT '组件路径', `query` varchar(255) DEFAULT NULL COMMENT '路由参数', `route_name` varchar(50) DEFAULT '' COMMENT '路由名称', `is_frame` int DEFAULT '1' COMMENT '是否为外链(0是 1否)', `is_cache` int DEFAULT '0' COMMENT '是否缓存(0缓存 1不缓存)', `menu_type` char(1) DEFAULT '' COMMENT '菜单类型(M目录 C菜单 F按钮)', `visible` char(1) DEFAULT '0' COMMENT '菜单状态(0显示 1隐藏)', `status` char(1) DEFAULT '0' COMMENT '菜单状态(0正常 1停用)', `perms` varchar(100) DEFAULT NULL COMMENT '权限标识', `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT '' COMMENT '备注', PRIMARY KEY (`menu_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2000 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单权限表'; /*Data for the table `sys_menu` */ insert into `sys_menu`(`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`route_name`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'系统管理',0,1,'system',NULL,'','',1,0,'M','0','0','','system','admin','2026-10-20 11:20:07','',NULL,'系统管理目录'),(2,'系统监控',0,2,'monitor',NULL,'','',1,0,'M','0','0','','monitor','admin','2026-10-20 11:20:07','',NULL,'系统监控目录'),(3,'系统工具',0,3,'tool',NULL,'','',1,0,'M','0','0','','tool','admin','2026-10-20 11:20:08','',NULL,'系统工具目录'),(4,'若依官网',0,4,'http://ruoyi.vip',NULL,'','',0,0,'M','0','0','','guide','admin','2026-10-20 11:20:08','',NULL,'若依官网地址'),(100,'用户管理',1,1,'user','system/user/index','','',1,0,'C','0','0','system:user:list','user','admin','2026-10-20 11:20:08','',NULL,'用户管理菜单'),(101,'角色管理',1,2,'role','system/role/index','','',1,0,'C','0','0','system:role:list','peoples','admin','2026-10-20 11:20:08','',NULL,'角色管理菜单'),(102,'菜单管理',1,3,'menu','system/menu/index','','',1,0,'C','0','0','system:menu:list','tree-table','admin','2026-10-20 11:20:08','',NULL,'菜单管理菜单'),(103,'部门管理',1,4,'dept','system/dept/index','','',1,0,'C','0','0','system:dept:list','tree','admin','2026-10-20 11:20:08','',NULL,'部门管理菜单'),(104,'岗位管理',1,5,'post','system/post/index','','',1,0,'C','0','0','system:post:list','post','admin','2026-10-20 11:20:08','',NULL,'岗位管理菜单'),(105,'字典管理',1,6,'dict','system/dict/index','','',1,0,'C','0','0','system:dict:list','dict','admin','2026-10-20 11:20:08','',NULL,'字典管理菜单'),(106,'参数设置',1,7,'config','system/config/index','','',1,0,'C','0','0','system:config:list','edit','admin','2026-10-20 11:20:08','',NULL,'参数设置菜单'),(107,'通知公告',1,8,'notice','system/notice/index','','',1,0,'C','0','0','system:notice:list','message','admin','2026-10-20 11:20:08','',NULL,'通知公告菜单'),(108,'日志管理',1,9,'log','','','',1,0,'M','0','0','','log','admin','2026-10-20 11:20:08','',NULL,'日志管理菜单'),(109,'在线用户',2,1,'online','monitor/online/index','','',1,0,'C','0','0','monitor:online:list','online','admin','2026-10-20 11:20:08','',NULL,'在线用户菜单'),(110,'定时任务',2,2,'job','monitor/job/index','','',1,0,'C','0','0','monitor:job:list','job','admin','2026-10-20 11:20:08','',NULL,'定时任务菜单'),(111,'数据监控',2,3,'druid','monitor/druid/index','','',1,0,'C','0','0','monitor:druid:list','druid','admin','2026-10-20 11:20:08','',NULL,'数据监控菜单'),(112,'服务监控',2,4,'server','monitor/server/index','','',1,0,'C','0','0','monitor:server:list','server','admin','2026-10-20 11:20:08','',NULL,'服务监控菜单'),(113,'缓存监控',2,5,'cache','monitor/cache/index','','',1,0,'C','0','0','monitor:cache:list','redis','admin','2026-10-20 11:20:08','',NULL,'缓存监控菜单'),(114,'缓存列表',2,6,'cacheList','monitor/cache/list','','',1,0,'C','0','0','monitor:cache:list','redis-list','admin','2026-10-20 11:20:08','',NULL,'缓存列表菜单'),(115,'表单构建',3,1,'build','tool/build/index','','',1,0,'C','0','0','tool:build:list','build','admin','2026-10-20 11:20:08','',NULL,'表单构建菜单'),(116,'代码生成',3,2,'gen','tool/gen/index','','',1,0,'C','0','0','tool:gen:list','code','admin','2026-10-20 11:20:08','',NULL,'代码生成菜单'),(117,'系统接口',3,3,'swagger','tool/swagger/index','','',1,0,'C','0','0','tool:swagger:list','swagger','admin','2026-10-20 11:20:08','',NULL,'系统接口菜单'),(500,'操作日志',108,1,'operlog','monitor/operlog/index','','',1,0,'C','0','0','monitor:operlog:list','form','admin','2026-10-20 11:20:08','',NULL,'操作日志菜单'),(501,'登录日志',108,2,'logininfor','monitor/logininfor/index','','',1,0,'C','0','0','monitor:logininfor:list','logininfor','admin','2026-10-20 11:20:08','',NULL,'登录日志菜单'),(1000,'用户查询',100,1,'','','','',1,0,'F','0','0','system:user:query','#','admin','2026-10-20 11:20:08','',NULL,''),(1001,'用户新增',100,2,'','','','',1,0,'F','0','0','system:user:add','#','admin','2026-10-20 11:20:08','',NULL,''),(1002,'用户修改',100,3,'','','','',1,0,'F','0','0','system:user:edit','#','admin','2026-10-20 11:20:08','',NULL,''),(1003,'用户删除',100,4,'','','','',1,0,'F','0','0','system:user:remove','#','admin','2026-10-20 11:20:08','',NULL,''),(1004,'用户导出',100,5,'','','','',1,0,'F','0','0','system:user:export','#','admin','2026-10-20 11:20:08','',NULL,''),(1005,'用户导入',100,6,'','','','',1,0,'F','0','0','system:user:import','#','admin','2026-10-20 11:20:08','',NULL,''),(1006,'重置密码',100,7,'','','','',1,0,'F','0','0','system:user:resetPwd','#','admin','2026-10-20 11:20:08','',NULL,''),(1007,'角色查询',101,1,'','','','',1,0,'F','0','0','system:role:query','#','admin','2026-10-20 11:20:08','',NULL,''),(1008,'角色新增',101,2,'','','','',1,0,'F','0','0','system:role:add','#','admin','2026-10-20 11:20:08','',NULL,''),(1009,'角色修改',101,3,'','','','',1,0,'F','0','0','system:role:edit','#','admin','2026-10-20 11:20:09','',NULL,''),(1010,'角色删除',101,4,'','','','',1,0,'F','0','0','system:role:remove','#','admin','2026-10-20 11:20:09','',NULL,''),(1011,'角色导出',101,5,'','','','',1,0,'F','0','0','system:role:export','#','admin','2026-10-20 11:20:09','',NULL,''),(1012,'菜单查询',102,1,'','','','',1,0,'F','0','0','system:menu:query','#','admin','2026-10-20 11:20:09','',NULL,''),(1013,'菜单新增',102,2,'','','','',1,0,'F','0','0','system:menu:add','#','admin','2026-10-20 11:20:09','',NULL,''),(1014,'菜单修改',102,3,'','','','',1,0,'F','0','0','system:menu:edit','#','admin','2026-10-20 11:20:09','',NULL,''),(1015,'菜单删除',102,4,'','','','',1,0,'F','0','0','system:menu:remove','#','admin','2026-10-20 11:20:09','',NULL,''),(1016,'部门查询',103,1,'','','','',1,0,'F','0','0','system:dept:query','#','admin','2026-10-20 11:20:09','',NULL,''),(1017,'部门新增',103,2,'','','','',1,0,'F','0','0','system:dept:add','#','admin','2026-10-20 11:20:09','',NULL,''),(1018,'部门修改',103,3,'','','','',1,0,'F','0','0','system:dept:edit','#','admin','2026-10-20 11:20:09','',NULL,''),(1019,'部门删除',103,4,'','','','',1,0,'F','0','0','system:dept:remove','#','admin','2026-10-20 11:20:09','',NULL,''),(1020,'岗位查询',104,1,'','','','',1,0,'F','0','0','system:post:query','#','admin','2026-10-20 11:20:09','',NULL,''),(1021,'岗位新增',104,2,'','','','',1,0,'F','0','0','system:post:add','#','admin','2026-10-20 11:20:09','',NULL,''),(1022,'岗位修改',104,3,'','','','',1,0,'F','0','0','system:post:edit','#','admin','2026-10-20 11:20:09','',NULL,''),(1023,'岗位删除',104,4,'','','','',1,0,'F','0','0','system:post:remove','#','admin','2026-10-20 11:20:09','',NULL,''),(1024,'岗位导出',104,5,'','','','',1,0,'F','0','0','system:post:export','#','admin','2026-10-20 11:20:09','',NULL,''),(1025,'字典查询',105,1,'#','','','',1,0,'F','0','0','system:dict:query','#','admin','2026-10-20 11:20:09','',NULL,''),(1026,'字典新增',105,2,'#','','','',1,0,'F','0','0','system:dict:add','#','admin','2026-10-20 11:20:09','',NULL,''),(1027,'字典修改',105,3,'#','','','',1,0,'F','0','0','system:dict:edit','#','admin','2026-10-20 11:20:09','',NULL,''),(1028,'字典删除',105,4,'#','','','',1,0,'F','0','0','system:dict:remove','#','admin','2026-10-20 11:20:09','',NULL,''),(1029,'字典导出',105,5,'#','','','',1,0,'F','0','0','system:dict:export','#','admin','2026-10-20 11:20:09','',NULL,''),(1030,'参数查询',106,1,'#','','','',1,0,'F','0','0','system:config:query','#','admin','2026-10-20 11:20:09','',NULL,''),(1031,'参数新增',106,2,'#','','','',1,0,'F','0','0','system:config:add','#','admin','2026-10-20 11:20:09','',NULL,''),(1032,'参数修改',106,3,'#','','','',1,0,'F','0','0','system:config:edit','#','admin','2026-10-20 11:20:09','',NULL,''),(1033,'参数删除',106,4,'#','','','',1,0,'F','0','0','system:config:remove','#','admin','2026-10-20 11:20:09','',NULL,''),(1034,'参数导出',106,5,'#','','','',1,0,'F','0','0','system:config:export','#','admin','2026-10-20 11:20:09','',NULL,''),(1035,'公告查询',107,1,'#','','','',1,0,'F','0','0','system:notice:query','#','admin','2026-10-20 11:20:09','',NULL,''),(1036,'公告新增',107,2,'#','','','',1,0,'F','0','0','system:notice:add','#','admin','2026-10-20 11:20:09','',NULL,''),(1037,'公告修改',107,3,'#','','','',1,0,'F','0','0','system:notice:edit','#','admin','2026-10-20 11:20:10','',NULL,''),(1038,'公告删除',107,4,'#','','','',1,0,'F','0','0','system:notice:remove','#','admin','2026-10-20 11:20:10','',NULL,''),(1039,'操作查询',500,1,'#','','','',1,0,'F','0','0','monitor:operlog:query','#','admin','2026-10-20 11:20:10','',NULL,''),(1040,'操作删除',500,2,'#','','','',1,0,'F','0','0','monitor:operlog:remove','#','admin','2026-10-20 11:20:10','',NULL,''),(1041,'日志导出',500,3,'#','','','',1,0,'F','0','0','monitor:operlog:export','#','admin','2026-10-20 11:20:10','',NULL,''),(1042,'登录查询',501,1,'#','','','',1,0,'F','0','0','monitor:logininfor:query','#','admin','2026-10-20 11:20:10','',NULL,''),(1043,'登录删除',501,2,'#','','','',1,0,'F','0','0','monitor:logininfor:remove','#','admin','2026-10-20 11:20:10','',NULL,''),(1044,'日志导出',501,3,'#','','','',1,0,'F','0','0','monitor:logininfor:export','#','admin','2026-10-20 11:20:10','',NULL,''),(1045,'账户解锁',501,4,'#','','','',1,0,'F','0','0','monitor:logininfor:unlock','#','admin','2026-10-20 11:20:10','',NULL,''),(1046,'在线查询',109,1,'#','','','',1,0,'F','0','0','monitor:online:query','#','admin','2026-10-20 11:20:10','',NULL,''),(1047,'批量强退',109,2,'#','','','',1,0,'F','0','0','monitor:online:batchLogout','#','admin','2026-10-20 11:20:10','',NULL,''),(1048,'单条强退',109,3,'#','','','',1,0,'F','0','0','monitor:online:forceLogout','#','admin','2026-10-20 11:20:10','',NULL,''),(1049,'任务查询',110,1,'#','','','',1,0,'F','0','0','monitor:job:query','#','admin','2026-10-20 11:20:10','',NULL,''),(1050,'任务新增',110,2,'#','','','',1,0,'F','0','0','monitor:job:add','#','admin','2026-10-20 11:20:10','',NULL,''),(1051,'任务修改',110,3,'#','','','',1,0,'F','0','0','monitor:job:edit','#','admin','2026-10-20 11:20:10','',NULL,''),(1052,'任务删除',110,4,'#','','','',1,0,'F','0','0','monitor:job:remove','#','admin','2026-10-20 11:20:10','',NULL,''),(1053,'状态修改',110,5,'#','','','',1,0,'F','0','0','monitor:job:changeStatus','#','admin','2026-10-20 11:20:10','',NULL,''),(1054,'任务导出',110,6,'#','','','',1,0,'F','0','0','monitor:job:export','#','admin','2026-10-20 11:20:10','',NULL,''),(1055,'生成查询',116,1,'#','','','',1,0,'F','0','0','tool:gen:query','#','admin','2026-10-20 11:20:10','',NULL,''),(1056,'生成修改',116,2,'#','','','',1,0,'F','0','0','tool:gen:edit','#','admin','2026-10-20 11:20:10','',NULL,''),(1057,'生成删除',116,3,'#','','','',1,0,'F','0','0','tool:gen:remove','#','admin','2026-10-20 11:20:10','',NULL,''),(1058,'导入代码',116,4,'#','','','',1,0,'F','0','0','tool:gen:import','#','admin','2026-10-20 11:20:10','',NULL,''),(1059,'预览代码',116,5,'#','','','',1,0,'F','0','0','tool:gen:preview','#','admin','2026-10-20 11:20:10','',NULL,''),(1060,'生成代码',116,6,'#','','','',1,0,'F','0','0','tool:gen:code','#','admin','2026-10-20 11:20:10','',NULL,''); /*Table structure for table `sys_notice` */ DROP TABLE IF EXISTS `sys_notice`; CREATE TABLE `sys_notice` ( `notice_id` int NOT NULL AUTO_INCREMENT COMMENT '公告ID', `notice_title` varchar(50) NOT NULL COMMENT '公告标题', `notice_type` char(1) NOT NULL COMMENT '公告类型(1通知 2公告)', `notice_content` longblob COMMENT '公告内容', `status` char(1) DEFAULT '0' COMMENT '公告状态(0正常 1关闭)', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(255) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`notice_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='通知公告表'; /*Data for the table `sys_notice` */ insert into `sys_notice`(`notice_id`,`notice_title`,`notice_type`,`notice_content`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'温馨提醒:2018-07-01 若依新版本发布啦','2','新版本内容','0','admin','2026-10-20 11:20:39','',NULL,'管理员'),(2,'维护通知:2018-07-01 若依系统凌晨维护','1','维护内容','0','admin','2026-10-20 11:20:40','',NULL,'管理员'),(3,'若依开源框架介绍','1','

项目介绍

RuoYi开源项目是为企业用户定制的后台脚手架框架,为企业打造的一站式解决方案,降低企业开发成本,提升开发效率。主要包括用户管理、角色管理、部门管理、菜单管理、参数管理、字典管理、岗位管理、定时任务、服务监控、登录日志、操作日志、代码生成等功能。其中,还支持多数据源、数据权限、国际化、Redis缓存、Docker部署、滑动验证码、第三方认证登录、分布式事务、分布式文件存储、分库分表处理等技术特点。


官网及演示

若依官网地址: http://ruoyi.vip

若依文档地址: http://doc.ruoyi.vip

演示地址【不分离版】: http://demo.ruoyi.vip

演示地址【分离版本】: http://vue.ruoyi.vip

演示地址【微服务版】: http://cloud.ruoyi.vip

演示地址【移动端版】: http://h5.ruoyi.vip


','0','admin','2026-10-20 11:20:40','',NULL,'管理员'); /*Table structure for table `sys_notice_read` */ DROP TABLE IF EXISTS `sys_notice_read`; CREATE TABLE `sys_notice_read` ( `read_id` bigint NOT NULL AUTO_INCREMENT COMMENT '已读主键', `notice_id` int NOT NULL COMMENT '公告id', `user_id` bigint NOT NULL COMMENT '用户id', `read_time` datetime NOT NULL COMMENT '阅读时间', PRIMARY KEY (`read_id`), UNIQUE KEY `uk_user_notice` (`user_id`,`notice_id`) COMMENT '同一用户同一公告只记录一次' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='公告已读记录表'; /*Data for the table `sys_notice_read` */ /*Table structure for table `sys_oper_log` */ DROP TABLE IF EXISTS `sys_oper_log`; CREATE TABLE `sys_oper_log` ( `oper_id` bigint NOT NULL AUTO_INCREMENT COMMENT '日志主键', `title` varchar(50) DEFAULT '' COMMENT '模块标题', `business_type` int DEFAULT '0' COMMENT '业务类型(0其它 1新增 2修改 3删除)', `method` varchar(200) DEFAULT '' COMMENT '方法名称', `request_method` varchar(10) DEFAULT '' COMMENT '请求方式', `operator_type` int DEFAULT '0' COMMENT '操作类别(0其它 1后台用户 2手机端用户)', `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员', `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称', `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL', `oper_ip` varchar(128) DEFAULT '' COMMENT '主机地址', `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点', `oper_param` varchar(2000) DEFAULT '' COMMENT '请求参数', `json_result` varchar(2000) DEFAULT '' COMMENT '返回参数', `status` int DEFAULT '0' COMMENT '操作状态(0正常 1异常)', `error_msg` varchar(2000) DEFAULT '' COMMENT '错误消息', `oper_time` datetime DEFAULT NULL COMMENT '操作时间', `cost_time` bigint DEFAULT '0' COMMENT '消耗时间', PRIMARY KEY (`oper_id`), KEY `idx_sys_oper_log_bt` (`business_type`), KEY `idx_sys_oper_log_s` (`status`), KEY `idx_sys_oper_log_ot` (`oper_time`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='操作日志记录'; /*Data for the table `sys_oper_log` */ /*Table structure for table `sys_post` */ DROP TABLE IF EXISTS `sys_post`; CREATE TABLE `sys_post` ( `post_id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID', `post_code` varchar(64) NOT NULL COMMENT '岗位编码', `post_name` varchar(50) NOT NULL COMMENT '岗位名称', `post_sort` int NOT NULL COMMENT '显示顺序', `status` char(1) NOT NULL COMMENT '状态(0正常 1停用)', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`post_id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='岗位信息表'; /*Data for the table `sys_post` */ insert into `sys_post`(`post_id`,`post_code`,`post_name`,`post_sort`,`status`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'ceo','董事长',1,'0','admin','2026-10-20 11:20:02','',NULL,''),(2,'se','项目经理',2,'0','admin','2026-10-20 11:20:02','',NULL,''),(3,'hr','人力资源',3,'0','admin','2026-10-20 11:20:02','',NULL,''),(4,'user','普通员工',4,'0','admin','2026-10-20 11:20:02','',NULL,''),(5,'se','项目经理',3,'0','',NULL,'',NULL,NULL),(6,'se','项目经理',3,'0','',NULL,'',NULL,NULL); /*Table structure for table `sys_role` */ DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `role_id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID', `role_name` varchar(30) NOT NULL COMMENT '角色名称', `role_key` varchar(100) NOT NULL COMMENT '角色权限字符串', `role_sort` int NOT NULL COMMENT '显示顺序', `data_scope` char(1) DEFAULT '1' COMMENT '数据范围(1:全部数据权限 2:自定数据权限 3:本部门数据权限 4:本部门及以下数据权限)', `menu_check_strictly` tinyint(1) DEFAULT '1' COMMENT '菜单树选择项是否关联显示', `dept_check_strictly` tinyint(1) DEFAULT '1' COMMENT '部门树选择项是否关联显示', `status` char(1) NOT NULL COMMENT '角色状态(0正常 1停用)', `del_flag` char(1) DEFAULT '0' COMMENT '删除标志(0代表存在 2代表删除)', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`role_id`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色信息表'; /*Data for the table `sys_role` */ insert into `sys_role`(`role_id`,`role_name`,`role_key`,`role_sort`,`data_scope`,`menu_check_strictly`,`dept_check_strictly`,`status`,`del_flag`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,'超级管理员','admin',1,'1',1,1,'0','0','admin','2026-10-20 11:20:05','',NULL,'超级管理员'),(2,'普通角色','common',2,'2',1,1,'0','0','admin','2026-10-20 11:20:05','',NULL,'普通角色'); /*Table structure for table `sys_role_dept` */ DROP TABLE IF EXISTS `sys_role_dept`; CREATE TABLE `sys_role_dept` ( `role_id` bigint NOT NULL COMMENT '角色ID', `dept_id` bigint NOT NULL COMMENT '部门ID', PRIMARY KEY (`role_id`,`dept_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色和部门关联表'; /*Data for the table `sys_role_dept` */ insert into `sys_role_dept`(`role_id`,`dept_id`) values (2,100),(2,101),(2,105); /*Table structure for table `sys_role_menu` */ DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `role_id` bigint NOT NULL COMMENT '角色ID', `menu_id` bigint NOT NULL COMMENT '菜单ID', PRIMARY KEY (`role_id`,`menu_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色和菜单关联表'; /*Data for the table `sys_role_menu` */ insert into `sys_role_menu`(`role_id`,`menu_id`) values (2,1),(2,2),(2,3),(2,4),(2,100),(2,101),(2,102),(2,103),(2,104),(2,105),(2,106),(2,107),(2,108),(2,109),(2,110),(2,111),(2,112),(2,113),(2,114),(2,115),(2,116),(2,117),(2,500),(2,501),(2,1000),(2,1001),(2,1002),(2,1003),(2,1004),(2,1005),(2,1006),(2,1007),(2,1008),(2,1009),(2,1010),(2,1011),(2,1012),(2,1013),(2,1014),(2,1015),(2,1016),(2,1017),(2,1018),(2,1019),(2,1020),(2,1021),(2,1022),(2,1023),(2,1024),(2,1025),(2,1026),(2,1027),(2,1028),(2,1029),(2,1030),(2,1031),(2,1032),(2,1033),(2,1034),(2,1035),(2,1036),(2,1037),(2,1038),(2,1039),(2,1040),(2,1041),(2,1042),(2,1043),(2,1044),(2,1045),(2,1046),(2,1047),(2,1048),(2,1049),(2,1050),(2,1051),(2,1052),(2,1053),(2,1054),(2,1055),(2,1056),(2,1057),(2,1058),(2,1059),(2,1060); /*Table structure for table `sys_user` */ DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `user_id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID', `dept_id` bigint DEFAULT NULL COMMENT '部门ID', `user_name` varchar(30) NOT NULL COMMENT '用户账号', `nick_name` varchar(30) NOT NULL COMMENT '用户昵称', `user_type` varchar(2) DEFAULT '00' COMMENT '用户类型(00系统用户)', `email` varchar(50) DEFAULT '' COMMENT '用户邮箱', `phonenumber` varchar(11) DEFAULT '' COMMENT '手机号码', `sex` char(1) DEFAULT '0' COMMENT '用户性别(0男 1女 2未知)', `avatar` varchar(100) DEFAULT '' COMMENT '头像地址', `password` varchar(100) DEFAULT '' COMMENT '密码', `status` char(1) DEFAULT '0' COMMENT '账号状态(0正常 1停用)', `del_flag` char(1) DEFAULT '0' COMMENT '删除标志(0代表存在 2代表删除)', `login_ip` varchar(128) DEFAULT '' COMMENT '最后登录IP', `login_date` datetime DEFAULT NULL COMMENT '最后登录时间', `pwd_update_date` datetime DEFAULT NULL COMMENT '密码最后更新时间', `create_by` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户信息表'; /*Data for the table `sys_user` */ insert into `sys_user`(`user_id`,`dept_id`,`user_name`,`nick_name`,`user_type`,`email`,`phonenumber`,`sex`,`avatar`,`password`,`status`,`del_flag`,`login_ip`,`login_date`,`pwd_update_date`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) values (1,103,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','127.0.0.1','2026-10-20 11:20:00','2026-10-20 11:20:00','admin','2026-10-20 11:20:00','',NULL,'管理员'),(2,105,'ry','孙尚香','00','jshan@neueedu.com','13888888888','2','','$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2','0','0','127.0.0.1','2026-10-20 11:20:00','2026-10-20 11:20:00','admin','2026-10-20 11:20:00','',NULL,'测试员'),(100,1,'1','张飞','00','3','2','1','3','1','0','0','',NULL,NULL,'','2026-10-20 14:59:42',NULL,NULL,'5'),(111,NULL,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','',NULL,NULL,'',NULL,'',NULL,NULL),(112,NULL,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','',NULL,NULL,'',NULL,'',NULL,NULL),(113,NULL,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','',NULL,NULL,'',NULL,'',NULL,NULL),(114,NULL,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','',NULL,NULL,'',NULL,'',NULL,NULL),(115,NULL,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','',NULL,NULL,'',NULL,'',NULL,NULL),(116,NULL,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','',NULL,NULL,'',NULL,'',NULL,NULL),(117,NULL,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','',NULL,NULL,'',NULL,'',NULL,NULL),(118,NULL,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','',NULL,NULL,'',NULL,'',NULL,NULL),(119,NULL,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','',NULL,NULL,'',NULL,'',NULL,NULL),(120,NULL,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','',NULL,NULL,'',NULL,'',NULL,NULL),(121,NULL,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','',NULL,NULL,'',NULL,'',NULL,NULL),(122,NULL,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','',NULL,NULL,'',NULL,'',NULL,NULL),(123,NULL,'zhangsan','张三','1','zhangsan@example.com','12345678901','1','avatar.jpg','123456','0','0','',NULL,NULL,'',NULL,'',NULL,NULL); /*Table structure for table `sys_user_post` */ DROP TABLE IF EXISTS `sys_user_post`; CREATE TABLE `sys_user_post` ( `user_id` bigint NOT NULL COMMENT '用户ID', `post_id` bigint NOT NULL COMMENT '岗位ID', PRIMARY KEY (`user_id`,`post_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户与岗位关联表'; /*Data for the table `sys_user_post` */ insert into `sys_user_post`(`user_id`,`post_id`) values (1,1),(2,2); /*Table structure for table `sys_user_role` */ DROP TABLE IF EXISTS `sys_user_role`; CREATE TABLE `sys_user_role` ( `user_id` bigint NOT NULL COMMENT '用户ID', `role_id` bigint NOT NULL COMMENT '角色ID', PRIMARY KEY (`user_id`,`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户和角色关联表'; /*Data for the table `sys_user_role` */ insert into `sys_user_role`(`user_id`,`role_id`) values (1,1),(2,2); /*Table structure for table `user` */ DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `username` varchar(50) NOT NULL COMMENT '用户名', `password` varchar(50) NOT NULL COMMENT '密码', `expire` datetime DEFAULT NULL COMMENT '过期时间', `last_login` datetime DEFAULT NULL COMMENT '最后一次登录时间', `create_by` varchar(50) DEFAULT NULL COMMENT '创建用户', `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` varchar(50) DEFAULT NULL COMMENT '更新用户', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `is_delete` varchar(5) DEFAULT '0' COMMENT '是否删除,0 正常,1删除', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*Data for the table `user` */ insert into `user`(`id`,`username`,`password`,`expire`,`last_login`,`create_by`,`create_time`,`update_by`,`update_time`,`is_delete`) values (1,'admin','123456','2026-10-10 09:06:10',NULL,'admin','2026-10-10 09:45:15',NULL,NULL,'0'),(2,'zhangsan1314','654321','2026-11-19 12:00:00','2026-11-19 00:00:00','admin','2026-10-10 09:45:18','admin','2026-10-20 08:44:31','0'),(3,'ry','123456','2026-10-10 09:06:10',NULL,'admin','2026-10-10 09:45:18',NULL,NULL,'0'),(4,'jashan','123456','2026-10-10 09:06:10',NULL,'admin','2026-10-10 09:45:18',NULL,NULL,'0'),(9,'root','!@#$%^&*()','2026-11-19 12:00:00',NULL,NULL,'2026-10-19 14:06:24',NULL,NULL,'0'),(10,'superadmin','!@#$%^&*()','2026-11-19 12:00:00',NULL,NULL,'2026-10-19 14:38:13',NULL,NULL,'0'),(11,'u1','123456','2026-11-19 12:00:00',NULL,NULL,'2026-10-19 15:38:00',NULL,NULL,'0'),(15,'u2','s2','2026-10-20 08:59:08',NULL,NULL,'2026-10-20 08:59:49',NULL,NULL,'0'),(17,'u3','s3','2026-10-20 10:03:51',NULL,NULL,'2026-10-20 10:04:03',NULL,NULL,'0'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; ``` - spring - mybaits - 事务管理器 - 数据源 - lombok - 分页 - SpringMVC - jackson JSON格式处理 - 通用的返回结果 - 全局的异常处理器 - 登录验证 - 拦截器 ## 搭建Springmvc - 依赖 - web.xml - spring-ssm.xml - UserController ![image-20261116153814042](assets/image-20261116153814042.png) ## 整合MyBaits - 容器中注册数据源 druid - SqlSessionFactory - 注册Mapper - SysUser - SysUserMapper.java - SysUserMapper.xml - 事务 - tx:autxxxxxxx - 在Service中使用@Tranxxxxl - 分页插件 - 测试从容器中获取Mapper 使用 ## 增删改查+Ret ## 登录拦截 ``` LoginInteceptor ``` 使用WebMVCConfigr配置先关的操作 使用Java类的形式配置拦截器 ```java package com.neuedu.his.common; import com.neuedu.his.common.interceptor.LoginInteceptor; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Configurable; import org.springframework.context.annotation.Configuration; import org.springframework.stereotype.Component; import org.springframework.web.servlet.config.annotation.EnableWebMvc; import org.springframework.web.servlet.config.annotation.InterceptorRegistry; import org.springframework.web.servlet.config.annotation.WebMvcConfigurer; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.his.common * 类描述: * 创建人:金山老师 * 创建时间:2026/11/16 16:32 * 版本:1.0 * */ @Component @EnableWebMvc public class HisWebMvcConfig implements WebMvcConfigurer { @Autowired LoginInteceptor loginInteceptor; @Override public void addInterceptors(InterceptorRegistry registry) { //添加拦截器 registry.addInterceptor(new LoginInteceptor()) //拦截所有路径 .addPathPatterns("/**") //忽略的地址 .excludePathPatterns("/login"); } } ``` ![image-20261116164925888](assets/image-20261116164925888.png) ## 配置跨域 ```java package com.neuedu.his.common; import com.neuedu.his.common.interceptor.LoginInteceptor; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Configurable; import org.springframework.context.annotation.Configuration; import org.springframework.stereotype.Component; import org.springframework.web.servlet.config.annotation.CorsRegistry; import org.springframework.web.servlet.config.annotation.EnableWebMvc; import org.springframework.web.servlet.config.annotation.InterceptorRegistry; import org.springframework.web.servlet.config.annotation.WebMvcConfigurer; /*** * * 项目名称: spring-learn * 类名称:com.neuedu.his.common * 类描述: * 创建人:金山老师 * 创建时间:2026/11/16 16:32 * 版本:1.0 * */ @Component @EnableWebMvc public class HisWebMvcConfig implements WebMvcConfigurer { @Autowired LoginInteceptor loginInteceptor; //配置拦截器 @Override public void addInterceptors(InterceptorRegistry registry) { //添加拦截器 registry.addInterceptor(new LoginInteceptor()) //拦截所有路径 .addPathPatterns("/**") //忽略的地址 .excludePathPatterns("/login"); } //配置跨域 /*** * * * response.setHeader("Access-Control-Allow-Origin","*"); * response.setHeader("Access-Control-Allow-Headers","*"); */ @Override public void addCorsMappings(CorsRegistry registry) { registry.addMapping("/**") .allowedHeaders("*") .allowedMethods("*") .allowedOrigins("*"); } } ``` 整合前端