1500字范文,内容丰富有趣,写作好帮手!
1500字范文 > SSM三大框架整合(Spring+SpringMVC+MyBatis)

SSM三大框架整合(Spring+SpringMVC+MyBatis)

时间:2019-12-24 03:17:41

相关推荐

SSM三大框架整合(Spring+SpringMVC+MyBatis)

文章目录

SSM整合一、导入依赖1.1 Spring依赖1.2 SpringMVC依赖1.3 MyBatis依赖二、配置文件2.0 Web.xml 配置文件2.1 Spring的配置文件2.2 SpringMVC的配置文件2.3 MyBatis的配置文件2.4 其他的配置三、业务代码四、 遇到的问题总结

SSM整合

完整项目下载链接

Spring+SpringMVC+MyBatis

开发环境:

JDK:JDK8IDE:IntelliJ IDEA .3.3Maven:Apache Maven 3.6.3MyBatis:3.5.6Spring:5.2.11SpringMVC:5.2.11

一、导入依赖

1.1 Spring依赖

(1)ioc核心:

commons-loggingspring-aopspring-beansspring-contextspring-corespring-expression

(2)aop 核心:

spring-aspectscglibaopallianceaspectjweaver

(3)jdbc核心:

spring-jbdcspring-ormspring-tx

(4)测试:

spring-test

Maven依赖以下:

<dependency><groupId>org.springframework</groupId><artifactId>spring-aop</artifactId><version>5.2.11.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-aspects</artifactId><version>5.2.11.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-beans</artifactId><version>5.2.11.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>5.2.11.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-core</artifactId><version>5.2.11.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-expression</artifactId><version>5.2.11.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>5.2.11.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-orm</artifactId><version>5.2.11.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-test</artifactId><version>5.2.11.RELEASE</version><scope>test</scope></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId><version>5.2.11.RELEASE</version></dependency><!--日志--><dependency><groupId>commons-logging</groupId><artifactId>commons-logging</artifactId><version>1.2</version></dependency><!--以下三个是加强版的面向切面编程--><dependency><groupId>org.aspectj</groupId><artifactId>aspectjweaver</artifactId><version>1.9.5</version></dependency><dependency><groupId>aopalliance</groupId><artifactId>aopalliance</artifactId><version>1.0</version></dependency><dependency><groupId>cglib</groupId><artifactId>cglib</artifactId><version>3.3.0</version></dependency>

1.2 SpringMVC依赖

(1)【上传下载】

commons-fileuploadcommons-io

(2)【jstl-标准标签库】

javax.servlet.jsp.jstlstandard

(3)【SpringMVC核心】

spring-webspring-webmvc

(4)【数据校验】

hibernate-validator

(5)【支持AJAX】

jackson-annotationsjackson-corejackson-databind

<dependency><groupId>javax.servlet.jsp.jstl</groupId><artifactId>jstl-api</artifactId><version>1.2</version></dependency><!-- standard标签库 --><dependency><groupId>taglibs</groupId><artifactId>standard</artifactId><version>1.1.2</version></dependency><dependency><groupId>commons-fileupload</groupId><artifactId>commons-fileupload</artifactId><version>1.3.3</version></dependency><dependency><groupId>commons-io</groupId><artifactId>commons-io</artifactId><version>2.7</version></dependency><!--数据校验的依赖--><dependency><groupId>org.hibernate</groupId><artifactId>hibernate-validator</artifactId><version>6.1.5.Final</version></dependency><!--一下三个为SpringMVC支持AJAX的包--><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-annotations</artifactId><version>2.11.2</version></dependency><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-core</artifactId><version>2.11.2</version></dependency><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-databind</artifactId><version>2.11.2</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-web</artifactId><version>5.2.11.RELEASE</version></dependency><!--SpringMVC的依赖,它会将所有spring的依赖也都加进来--><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>5.2.11.RELEASE</version></dependency><!--Servlet的依赖--><dependency><groupId>javax.servlet</groupId><artifactId>javax.servlet-api</artifactId><version>3.1.0</version><scope>provided</scope></dependency>

1.3 MyBatis依赖

(1)【mybatis核心包】

mybatis

(2)【缓存包+缓存依赖的日志包】

ehcache-coremybatis-ehcachelog4jslf4j-log4j12slf4j-api

(3)【数据库驱动】

mysql-connector-java

(4)【数据源】

c3p0

(5)【MyBatis和Spring整合】

mybatis-spring

<dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.5.6</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.47</version></dependency><dependency><groupId>net.sf.ehcache</groupId><artifactId>ehcache-core</artifactId><version>2.6.11</version></dependency><dependency><groupId>org.slf4j</groupId><artifactId>slf4j-api</artifactId><version>1.7.26</version></dependency><dependency><groupId>org.slf4j</groupId><artifactId>slf4j-log4j12</artifactId><version>1.7.26</version></dependency><dependency><groupId>org.mybatis.caches</groupId><artifactId>mybatis-ehcache</artifactId><version>1.1.0</version></dependency><dependency><groupId>com.mchange</groupId><artifactId>c3p0</artifactId><version>0.9.5.5</version></dependency><!-- Mybatis-Spring--><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>2.0.5</version></dependency>

二、配置文件

2.0 Web.xml 配置文件

配置Spring容器,指定Spring的配置文件。Spring和SpringMVC分容器整合,Spring的容器作为父容器。SpringMVC的容器作为子容器。配置SpringMVC的前端控制器。DisPatchServlet。指定SpringMVC的配置文件。配置字符编码过滤器。配置支持REST风格的过滤器。

web.xml

<?xml version="1.0" encoding="UTF-8"?><web-app xmlns="/xml/ns/javaee"xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/xml/ns/javaee/xml/ns/javaee/web-app_4_0.xsd"version="4.0"><context-param><param-name>contextConfigLocation</param-name><!-- 指定Spring配置文件位置--><param-value>classpath:spring/applicationContext.xml</param-value></context-param><!-- 项目一启动,就启动ioc--><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><!-- 配置SpringMVC的前端控制器--><servlet><servlet-name>dispatcherServlet</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><init-param><param-name>contextConfigLocation</param-name><param-value>classpath:springmvc/applicationContext-mvc.xml</param-value></init-param><load-on-startup>1</load-on-startup></servlet><servlet-mapping><servlet-name>dispatcherServlet</servlet-name><url-pattern>/</url-pattern></servlet-mapping><!-- 字符编码--><filter><filter-name>encodingFilter</filter-name><filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class><init-param><param-name>encoding</param-name><param-value>UTF-8</param-value></init-param><init-param><param-name>forceEncoding</param-name><param-value>true</param-value></init-param></filter><filter-mapping><filter-name>encodingFilter</filter-name><url-pattern>/*</url-pattern></filter-mapping><!-- 支持REST风格的Filter--><filter><filter-name>methodFilter</filter-name><filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class></filter><filter-mapping><filter-name>methodFilter</filter-name><url-pattern>/*</url-pattern></filter-mapping></web-app>

2.1 Spring的配置文件

使用开启基于注解开发的标签,扫描处理Controller类之外的所有类。

导入外部配置文件:用来配置数据库连接的,username,password等。

配置数据源,这里使用C3P0,使用“$”符号(EL表达式取外部配置文件中的值。

配置MyBatis。class为SqlSessionFactoryBean。这个类在MyBatis和spring的整合包里。这个类的作用是,能根据MyBatis的配置文件来创建出一个SqlSessionFactory。

指定MyBatis配置文件。指定MyBatis使用的数据源。指定Mapper.xml映射文件的位置。其实,MyBatis的配置文件都可以不要,配置文件中配置的东西,这个标签中都可以配置,只不过没有配置文件方便。

配置基于XML的事务控制。(基于xml事务控制太过复杂,可以用基于注解的事务控制替换)

写切入点表达式。事务建议指向我们下面写的事务管理器。配置事务管理器。 配置事务属性。即:哪些方法是事务方法。

把每一个Dao接口的实现注册的ioc容器中(非必需)。

如果忽略此步骤,则可以在service层的代码里直接注入SqlSessionFactory,然后使用SqlSessionFactory获取sqlsession,再用sqlsession得到Dao接口的实现。

代码如下:

@Autowiredprivate SqlSessionFactory sqlSessionFactory;public Teacher test(Integer id){SqlSession sqlSession = sqlSessionFactory.openSession();TeacherDao teacherDao = sqlSession.getMapper(TeacherDao.class);Teacher teacher= teacherDao.getTeacherById(id);System.out.println(teacher);return teacher;}

执行此步骤之后,就可以在service类中直接注入Dao类。

application.xml

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xmlns:context="/schema/context"xmlns:aop="/schema/aop" xmlns:tx="/schema/tx"xsi:schemaLocation="/schema/beans /schema/beans/spring-beans.xsd /schema/context /schema/context/spring-context.xsd /schema/aop /schema/aop/spring-aop.xsd /schema/tx /schema/tx/spring-tx.xsd"><!-- Spring 处理控制器不扫描,其他的都扫描,排除的话,不用写禁用默认过滤--><context:component-scan base-package="nuc"><context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/></context:component-scan><!-- 1. 导入外部配置文件--><context:property-placeholder location="classpath:other/dbconfig.properties"></context:property-placeholder><!-- 2. 配置数据源c3p0,使用$符号取值--><bean id="dataSource" class="com.mchange.boPooledDataSource"><property name="user" value="${username}"/><property name="driverClass" value="${driverclass}"/><property name="password" value="${password}"/><property name="jdbcUrl" value="${jdbcurl}"/><property name="maxPoolSize" value="${maxPoolSize}"/><property name="minPoolSize" value="${minPoolSize}"/></bean><!-- 3. 配置MyBatis操作数据库--><!--可以根据配置文件得到sqlSessionFactory--><bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean"><!-- 指定MyBatis配置文件位置--><property name="configLocation" value="classpath:mybatis/mybatis-config.xml"/><!-- 指定数据源--><property name="dataSource" ref="dataSource"/><!-- 指定xml映射文件位置--><property name="mapperLocations" value="classpath:nuc/dao/*.xml"/></bean><!-- 我们要把每一个Dao接口的实现加入到ioc容器中--><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><!--指定到接口所在的包 --><property name="basePackage" value="nuc.dao"/></bean><!-- 4. 配置事务控制:配置事务管理器,让它控制数据源中的连接--><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"/></bean><!-- 5. 基于xml配置的事务配置。哪些方法切入事务还要写切入点表达式--><aop:config><!-- 配置切入点表达式--><aop:pointcut id="txPointcut" expression="execution(* nuc.service.*.*(..))"/><aop:advisor advice-ref="myTX" pointcut-ref="txPointcut"/></aop:config><!-- transaction-manager="transactionManager" :指定要配置的事务管理器的id--><!-- 配置事务增强、事务属性、事务建议--><tx:advice id="myTX" transaction-manager="transactionManager"><!-- 配置事务属性--><tx:attributes><tx:method name="*" rollback-for="java.lang.Exception"/></tx:attributes></tx:advice></beans>

2.2 SpringMVC的配置文件

开启包扫描,只扫描Controller类,这里需要禁用到默认的扫描规则。配置视图解析器。InternalResourceViewResolver扫描静态资源和动态资源。

application-mvc.xml

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xmlns:context="/schema/context"xmlns:mvc="/schema/mvc"xsi:schemaLocation="/schema/beans /schema/beans/spring-beans.xsd /schema/context /schema/context/spring-context.xsd /schema/tool /schema/tool/spring-tool.xsd /schema/cache /schema/cache/spring-cache.xsd /schema/mvc /schema/mvc/spring-mvc.xsd"><!-- SpringMVC只扫描控制器,禁用掉默认的扫描规则--><context:component-scan base-package="nuc" use-default-filters="false"><context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/></context:component-scan><bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/WEB-INF/pages/"/><property name="suffix" value=".jsp"/></bean><!-- 配置文件上传解析器--><bean class="org.springframework.monsMultipartResolver" id="multipartResolver"><property name="defaultEncoding" value="UTF-8"/><property name="maxUploadSize" value="#{1024*1024*1024}"/></bean><!-- 扫描静态资源--><mvc:default-servlet-handler/><!-- 扫描动态资源--><mvc:annotation-driven/></beans>

2.3 MyBatis的配置文件

整合步骤:

导入整合包(能将dao的实现加入到容器中)。 导入MyBatis和spring的整合包。

<!-- Mybatis--><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>2.0.5</version></dependency>

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-////DTD Config 3.0//EN""/dtd/mybatis-3-config.dtd"><configuration><settings><!-- 开启延迟加载功能--><setting name="lazyLoadingEnabled" value="true"/><!-- 开启属性按需加载--><setting name="aggressiveLazyLoading" value="false"/><!--开启二级缓存,并告诉MyBatis哪个Dao查询的时候需要用到二级缓存--><setting name="cacheEnabled" value="true"/></settings></configuration>

2.4 其他的配置

(1)dbconfig.properties

jdbc.username=rootpassword=*********jdbcurl=jdbc:mysql://localhost:3306/mybatis_test?serverTimezone=UTC&amp;rewriteBatchedStatements=truedriverclass=com.mysql.jdbc.DrivermaxPoolSize=20minPoolSize=10

(2)ehcache.xml

<?xml version="1.0" encoding="UTF-8"?><ehcache xmlns:xsi="/2001/XMLSchema-instance"xsi:noNamespaceSchemaLocation="../config/ehcache.xsd"><!-- 磁盘保存路径 --><diskStore path="E:\ehcache" /><defaultCache maxElementsInMemory="1" maxElementsOnDisk="10000000"eternal="false" overflowToDisk="true" timeToIdleSeconds="120"timeToLiveSeconds="120" diskExpiryThreadIntervalSeconds="120"memoryStoreEvictionPolicy="LRU"></defaultCache></ehcache><!-- 属性说明:l diskStore:指定数据在磁盘中的存储位置。l defaultCache:当借助CacheManager.add("demoCache")创建Cache时,EhCache便会采用<defalutCache/>指定的的管理策略以下属性是必须的:l maxElementsInMemory - 在内存中缓存的element的最大数目 l maxElementsOnDisk - 在磁盘上缓存的element的最大数目,若是0表示无穷大l eternal - 设定缓存的elements是否永远不过期。如果为true,则缓存的数据始终有效,如果为false那么还要根据timeToIdleSeconds,timeToLiveSeconds判断l overflowToDisk - 设定当内存缓存溢出的时候是否将过期的element缓存到磁盘上以下属性是可选的:l timeToIdleSeconds - 当缓存在EhCache中的数据前后两次访问的时间超过timeToIdleSeconds的属性取值时,这些数据便会删除,默认值是0,也就是可闲置时间无穷大l timeToLiveSeconds - 缓存element的有效生命期,默认是0.,也就是element存活时间无穷大diskSpoolBufferSizeMB 这个参数设置DiskStore(磁盘缓存)的缓存区大小.默认是30MB.每个Cache都应该有自己的一个缓冲区.l diskPersistent - 在VM重启的时候是否启用磁盘保存EhCache中的数据,默认是false。l diskExpiryThreadIntervalSeconds - 磁盘缓存的清理线程运行间隔,默认是120秒。每个120s,相应的线程会进行一次EhCache中数据的清理工作l memoryStoreEvictionPolicy - 当内存缓存达到最大,有新的element加入的时候, 移除缓存中element的策略。默认是LRU(最近最少使用),可选的有LFU(最不常使用)和FIFO(先进先出)-->

(3)Log4j.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"><log4j:configuration xmlns:log4j="/log4j/"><appender name="STDOUT" class="org.apache.log4j.ConsoleAppender"><param name="Encoding" value="UTF-8" /><layout class="org.apache.log4j.PatternLayout"><param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS} %m (%F:%L) \n" /></layout></appender><logger name="java.sql"><level value="debug" /></logger><logger name="org.apache.ibatis"><level value="info" /></logger><root><level value="debug" /><appender-ref ref="STDOUT" /></root></log4j:configuration>

三、业务代码

先看一下项目整体

(1)Dao层

TeacherDao.java

package nuc.dao;import nuc.pojo.Teacher;/*** @author 满眼星河* @create -12-02-22:44*/public interface TeacherDao {Teacher getTeacherById(Integer id);}

TeacherDao.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapperPUBLIC "-////DTD Mapper 3.0//EN""/dtd/mybatis-3-mapper.dtd"><mapper namespace="nuc.dao.TeacherDao"><!-- 使用的是MyBatis的默认二级缓存,type:指定相应的自定义缓存类--><cache type="org.mybatis.caches.ehcache.EhcacheCache"></cache><select id="getTeacherById" resultMap="myTeacher">select * from t_teacher where id=#{id}</select><resultMap id="myTeacher" type="nuc.pojo.Teacher"><id property="id" column="id"/><result property="teacherName" column="teachername"/><result property="className" column="class_name"/><result property="address" column="address"/><result property="birth" column="birth_date"/></resultMap></mapper>

(2)service层

TeacherService.java

package nuc.service;import nuc.dao.TeacherDao;import nuc.pojo.Teacher;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.stereotype.Service;/*** @author 满眼星河* @create -12-02-22:34*/@Servicepublic class TeacherService {@Autowiredprivate TeacherDao teacherDao;public Teacher getTeacherById(Integer id){Teacher teacher= teacherDao.getTeacherById(id);System.out.println(teacher);return teacher;}}

(3)controller层

MyController.java

package nuc.controller;import nuc.pojo.Teacher;import nuc.service.TeacherService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.ui.Model;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestParam;/*** @author 满眼星河* @create -12-02-23:46*/@Controllerpublic class MyController {@Autowiredprivate TeacherService teacherService;@RequestMapping(value = "/test")public String test01(@RequestParam("id") Integer id, Model model){Teacher teacher = teacherService.getTeacherById(id);model.addAttribute("teacher",teacher);return "success";}}

(4)bean

Teacher.java

package nuc.pojo;import java.util.Date;/*** @author 满眼星河* @create -11-30-21:11*/public class Teacher {private Integer id;private String teacherName;private String className;private String address;private Date birth;public Teacher(){}public Teacher(Integer id, String teacherName, String className, String address, Date birth){this.id = id;this.teacherName = teacherName;this.className = className;this.address = address;this.birth = birth;}//省略setter、getter、toString方法

四、 遇到的问题总结

问题一:Mapper.xml文件无法导入的问题。

报错如下:

Invalid bound statement (not found): nuc.dao.TeacherDao.getTeacherById] with root causeorg.apache.ibatis.binding.BindingException: Invalid bound statement (not found): nuc.dao.TeacherDao.getTeacherByIdat org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235)at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:53)at org.apache.ibatis.binding.MapperProxy.lambda$cachedInvoker$0(MapperProxy.java:115)at java.util.puteIfAbsent(ConcurrentHashMap.java:1660)at org.apache.ibatis.binding.MapperProxy.cachedInvoker(MapperProxy.java:102)at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85)at com.sun.proxy.$Proxy18.getTeacherById(Unknown Source)at nuc.service.TeacherService.getTeacherById(TeacherService.java:36)at nuc.service.TeacherService$$FastClassBySpringCGLIB$$db4fbf9e.invoke(<generated>)at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

原因:Dao的映射文件无法导出解决:在项目的pom.xml文件中的<build>标签中加上如下,资源就可以成功导出了。

<resources><resource><directory>src/main/java</directory><includes><include>**/*.properties</include><include>**/*.xml</include></includes><filtering>false</filtering></resource></resources>

问题二:slf4j日志无法使用。

报错如下:

SLF4J: No SLF4J providers were found.SLF4J: Defaulting to no-operation (NOP) logger implementationSLF4J: See /codes.html#noProviders for further details.

原因:slf4j的版本太高。解决:换成低版本的slf4j即可。

<dependency><groupId>org.slf4j</groupId><artifactId>slf4j-api</artifactId><version>1.7.26</version></dependency><dependency><groupId>org.slf4j</groupId><artifactId>slf4j-log4j12</artifactId><version>1.7.26</version></dependency>

问题三:数据库连接异常

报错如下:

Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!] with root causejava.sql.SQLException: Access denied for user 'lu'@'localhost' (using password: YES)

原因:在 dbconfig.properties 配置数据库连接参数时使用了username,导致连接数据库时拿到的用户名是电脑的用户名,并不是数据库用户的用户名。

/codes.html#noProviders for further details.

- 原因:slf4j的版本太高。- 解决:换成低版本的slf4j即可。```xml<dependency><groupId>org.slf4j</groupId><artifactId>slf4j-api</artifactId><version>1.7.26</version></dependency><dependency><groupId>org.slf4j</groupId><artifactId>slf4j-log4j12</artifactId><version>1.7.26</version></dependency>

问题三:数据库连接异常

报错如下:

Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!] with root causejava.sql.SQLException: Access denied for user 'lu'@'localhost' (using password: YES)

原因:在 dbconfig.properties 配置数据库连接参数时使用了username,导致连接数据库时拿到的用户名是电脑的用户名,并不是数据库用户的用户名。解决:不是要username作key即可。

完整项目下载链接

关注一波呗🤞🤞🤞

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。