maven项目导入出现spring-core.xml找不到的问题

本文介绍了解决Maven项目在Tomcat部署时资源文件未被正确导入的问题。通过调整项目的配置设置,确保Java和Resources文件夹被正确识别,从而使Tomcat能够正常加载所有必要的资源。

这是由于在maven项目导入的时候本来会自动导入java文件中的code和resources中的资源文件,但是有的tomcat的配置会使得resources中的资源文件没有导入,是的tomcat的容器中缺失东西,做法如下

右击项目点击properties 点击下面图片中的Add Folder,然后选中java和resources,点击ok,项目就可以正常启动了。




E:\JDK-22\bin\java.exe "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2024.1\lib\idea_rt.jar=59593:C:\Program Files\JetBrains\IntelliJ IDEA 2024.1\bin" -Dfile.encoding=UTF-8 -Dsun.stdout.encoding=UTF-8 -Dsun.stderr.encoding=UTF-8 -classpath E:\cangqiong\ziliao\资料\day01\后端初始工程\sky-take-out\sky-server\target\test-classes;E:\cangqiong\ziliao\资料\day01\后端初始工程\sky-take-out\sky-server\target\classes;E:\cangqiong\ziliao\资料\day01\后端初始工程\sky-take-out\sky-common\target\classes;E:\Maven\apache-maven-3.9.9\maven_repository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot-starter-json\2.7.3\spring-boot-starter-json-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.13.3\jackson-datatype-jdk8-2.13.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.13.3\jackson-datatype-jsr310-2.13.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.13.3\jackson-module-parameter-names-2.13.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\jsonwebtoken\jjwt\0.9.1\jjwt-0.9.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\aliyun\oss\aliyun-sdk-oss\3.10.2\aliyun-sdk-oss-3.10.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\httpcomponents\httpclient\4.5.13\httpclient-4.5.13.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\httpcomponents\httpcore\4.4.15\httpcore-4.4.15.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\jdom\jdom2\2.0.6.1\jdom2-2.0.6.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\codehaus\jettison\jettison\1.1\jettison-1.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\stax\stax-api\1.0.1\stax-api-1.0.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\aliyun\aliyun-java-sdk-core\3.4.0\aliyun-java-sdk-core-3.4.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\aliyun\aliyun-java-sdk-ram\3.0.0\aliyun-java-sdk-ram-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\aliyun\aliyun-java-sdk-sts\3.0.0\aliyun-java-sdk-sts-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\aliyun\aliyun-java-sdk-ecs\4.2.0\aliyun-java-sdk-ecs-4.2.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\aliyun\aliyun-java-sdk-kms\2.7.0\aliyun-java-sdk-kms-2.7.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\google\code\gson\gson\2.9.1\gson-2.9.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\github\wechatpay-apiv3\wechatpay-apache-httpclient\0.4.8\wechatpay-apache-httpclient-0.4.8.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\httpcomponents\httpmime\4.5.13\httpmime-4.5.13.jar;E:\cangqiong\ziliao\资料\day01\后端初始工程\sky-take-out\sky-pojo\target\classes;E:\Maven\apache-maven-3.9.9\maven_repository\com\fasterxml\jackson\core\jackson-databind\2.13.3\jackson-databind-2.13.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\fasterxml\jackson\core\jackson-annotations\2.13.3\jackson-annotations-2.13.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\fasterxml\jackson\core\jackson-core\2.13.3\jackson-core-2.13.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot-starter\2.7.3\spring-boot-starter-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot\2.7.3\spring-boot-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-context\5.3.22\spring-context-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot-autoconfigure\2.7.3\spring-boot-autoconfigure-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot-starter-logging\2.7.3\spring-boot-starter-logging-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\ch\qos\logback\logback-classic\1.2.11\logback-classic-1.2.11.jar;E:\Maven\apache-maven-3.9.9\maven_repository\ch\qos\logback\logback-core\1.2.11\logback-core-1.2.11.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\logging\log4j\log4j-to-slf4j\2.17.2\log4j-to-slf4j-2.17.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\logging\log4j\log4j-api\2.17.2\log4j-api-2.17.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\slf4j\jul-to-slf4j\1.7.36\jul-to-slf4j-1.7.36.jar;E:\Maven\apache-maven-3.9.9\maven_repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-core\5.3.22\spring-core-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-jcl\5.3.22\spring-jcl-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\yaml\snakeyaml\1.30\snakeyaml-1.30.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot-starter-test\2.7.3\spring-boot-starter-test-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot-test\2.7.3\spring-boot-test-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot-test-autoconfigure\2.7.3\spring-boot-test-autoconfigure-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\jayway\jsonpath\json-path\2.7.0\json-path-2.7.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\net\minidev\json-smart\2.4.8\json-smart-2.4.8.jar;E:\Maven\apache-maven-3.9.9\maven_repository\net\minidev\accessors-smart\2.4.8\accessors-smart-2.4.8.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\ow2\asm\asm\9.1\asm-9.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\jakarta\xml\bind\jakarta.xml.bind-api\2.3.3\jakarta.xml.bind-api-2.3.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\jakarta\activation\jakarta.activation-api\1.2.2\jakarta.activation-api-1.2.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\assertj\assertj-core\3.22.0\assertj-core-3.22.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\hamcrest\hamcrest\2.2\hamcrest-2.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\junit\jupiter\junit-jupiter\5.8.2\junit-jupiter-5.8.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\junit\jupiter\junit-jupiter-api\5.8.2\junit-jupiter-api-5.8.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\opentest4j\opentest4j\1.2.0\opentest4j-1.2.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\junit\platform\junit-platform-commons\1.8.2\junit-platform-commons-1.8.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apiguardian\apiguardian-api\1.1.2\apiguardian-api-1.1.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\junit\jupiter\junit-jupiter-params\5.8.2\junit-jupiter-params-5.8.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\junit\jupiter\junit-jupiter-engine\5.8.2\junit-jupiter-engine-5.8.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\junit\platform\junit-platform-engine\1.8.2\junit-platform-engine-1.8.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\mockito\mockito-core\4.5.1\mockito-core-4.5.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\net\bytebuddy\byte-buddy\1.12.13\byte-buddy-1.12.13.jar;E:\Maven\apache-maven-3.9.9\maven_repository\net\bytebuddy\byte-buddy-agent\1.12.13\byte-buddy-agent-1.12.13.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\objenesis\objenesis\3.2\objenesis-3.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\mockito\mockito-junit-jupiter\4.5.1\mockito-junit-jupiter-4.5.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\skyscreamer\jsonassert\1.5.1\jsonassert-1.5.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\vaadin\external\google\android-json\0.0.20131108.vaadin1\android-json-0.0.20131108.vaadin1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-test\5.3.22\spring-test-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\xmlunit\xmlunit-core\2.9.0\xmlunit-core-2.9.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot-starter-web\2.7.3\spring-boot-starter-web-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot-starter-tomcat\2.7.3\spring-boot-starter-tomcat-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.65\tomcat-embed-core-9.0.65.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\tomcat\embed\tomcat-embed-el\9.0.65\tomcat-embed-el-9.0.65.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.65\tomcat-embed-websocket-9.0.65.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-web\5.3.22\spring-web-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-beans\5.3.22\spring-beans-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-webmvc\5.3.22\spring-webmvc-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-aop\5.3.22\spring-aop-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-expression\5.3.22\spring-expression-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\mysql\mysql-connector-java\8.0.30\mysql-connector-java-8.0.30.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\mybatis\spring\boot\mybatis-spring-boot-starter\2.2.0\mybatis-spring-boot-starter-2.2.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot-starter-jdbc\2.7.3\spring-boot-starter-jdbc-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\zaxxer\HikariCP\4.0.3\HikariCP-4.0.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-jdbc\5.3.22\spring-jdbc-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\mybatis\spring\boot\mybatis-spring-boot-autoconfigure\2.2.0\mybatis-spring-boot-autoconfigure-2.2.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\mybatis\mybatis\3.5.7\mybatis-3.5.7.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\mybatis\mybatis-spring\2.0.6\mybatis-spring-2.0.6.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\projectlombok\lombok\1.18.32\lombok-1.18.32.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\alibaba\fastjson\1.2.76\fastjson-1.2.76.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\alibaba\druid-spring-boot-starter\1.2.1\druid-spring-boot-starter-1.2.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\alibaba\druid\1.2.1\druid-1.2.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\slf4j\slf4j-api\1.7.36\slf4j-api-1.7.36.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\github\pagehelper\pagehelper-spring-boot-starter\1.3.0\pagehelper-spring-boot-starter-1.3.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\github\pagehelper\pagehelper-spring-boot-autoconfigure\1.3.0\pagehelper-spring-boot-autoconfigure-1.3.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\github\pagehelper\pagehelper\5.2.0\pagehelper-5.2.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\github\jsqlparser\jsqlparser\3.2\jsqlparser-3.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\aspectj\aspectjrt\1.9.4\aspectjrt-1.9.4.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\aspectj\aspectjweaver\1.9.4\aspectjweaver-1.9.4.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\github\xiaoymin\knife4j-spring-boot-starter\3.0.2\knife4j-spring-boot-starter-3.0.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\github\xiaoymin\knife4j-spring-boot-autoconfigure\3.0.2\knife4j-spring-boot-autoconfigure-3.0.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\github\xiaoymin\knife4j-spring\3.0.2\knife4j-spring-3.0.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\github\xiaoymin\knife4j-annotations\3.0.2\knife4j-annotations-3.0.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\swagger\swagger-annotations\1.5.22\swagger-annotations-1.5.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\swagger\core\v3\swagger-annotations\2.1.2\swagger-annotations-2.1.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\github\xiaoymin\knife4j-core\3.0.2\knife4j-core-3.0.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\javassist\javassist\3.25.0-GA\javassist-3.25.0-GA.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\springfox\springfox-swagger2\3.0.0\springfox-swagger2-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\springfox\springfox-spi\3.0.0\springfox-spi-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\springfox\springfox-schema\3.0.0\springfox-schema-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\springfox\springfox-swagger-common\3.0.0\springfox-swagger-common-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\springfox\springfox-spring-web\3.0.0\springfox-spring-web-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\github\classgraph\classgraph\4.8.83\classgraph-4.8.83.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\springfox\springfox-spring-webflux\3.0.0\springfox-spring-webflux-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\mapstruct\mapstruct\1.3.1.Final\mapstruct-1.3.1.Final.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\springfox\springfox-spring-webmvc\3.0.0\springfox-spring-webmvc-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\springfox\springfox-core\3.0.0\springfox-core-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\springfox\springfox-oas\3.0.0\springfox-oas-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\swagger\core\v3\swagger-models\2.1.2\swagger-models-2.1.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\springfox\springfox-bean-validators\3.0.0\springfox-bean-validators-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\swagger\swagger-models\1.5.22\swagger-models-1.5.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\swagger\swagger-core\1.5.22\swagger-core-1.5.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\commons\commons-lang3\3.12.0\commons-lang3-3.12.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\fasterxml\jackson\dataformat\jackson-dataformat-yaml\2.13.3\jackson-dataformat-yaml-2.13.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\google\guava\guava\27.0.1-android\guava-27.0.1-android.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\google\guava\failureaccess\1.0.1\failureaccess-1.0.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\google\guava\listenablefuture\9999.0-empty-to-avoid-conflict-with-guava\listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\google\code\findbugs\jsr305\3.0.2\jsr305-3.0.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\checkerframework\checker-compat-qual\2.5.2\checker-compat-qual-2.5.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\google\errorprone\error_prone_annotations\2.2.0\error_prone_annotations-2.2.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\google\j2objc\j2objc-annotations\1.1\j2objc-annotations-1.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\codehaus\mojo\animal-sniffer-annotations\1.17\animal-sniffer-annotations-1.17.jar;E:\Maven\apache-maven-3.9.9\maven_repository\javax\validation\validation-api\2.0.1.Final\validation-api-2.0.1.Final.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\springfox\springfox-boot-starter\3.0.0\springfox-boot-starter-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\springfox\springfox-data-rest\3.0.0\springfox-data-rest-3.0.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\fasterxml\classmate\1.5.1\classmate-1.5.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\plugin\spring-plugin-core\2.0.0.RELEASE\spring-plugin-core-2.0.0.RELEASE.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\plugin\spring-plugin-metadata\2.0.0.RELEASE\spring-plugin-metadata-2.0.0.RELEASE.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\github\xiaoymin\knife4j-spring-ui\3.0.2\knife4j-spring-ui-3.0.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot-starter-data-redis\2.7.3\spring-boot-starter-data-redis-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\data\spring-data-redis\2.7.2\spring-data-redis-2.7.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\data\spring-data-keyvalue\2.7.2\spring-data-keyvalue-2.7.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\data\spring-data-commons\2.7.2\spring-data-commons-2.7.2.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-tx\5.3.22\spring-tx-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-oxm\5.3.22\spring-oxm-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\lettuce\lettuce-core\6.1.9.RELEASE\lettuce-core-6.1.9.RELEASE.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\netty\netty-common\4.1.79.Final\netty-common-4.1.79.Final.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\netty\netty-handler\4.1.79.Final\netty-handler-4.1.79.Final.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\netty\netty-resolver\4.1.79.Final\netty-resolver-4.1.79.Final.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\netty\netty-buffer\4.1.79.Final\netty-buffer-4.1.79.Final.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\netty\netty-transport-native-unix-common\4.1.79.Final\netty-transport-native-unix-common-4.1.79.Final.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\netty\netty-codec\4.1.79.Final\netty-codec-4.1.79.Final.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\netty\netty-transport\4.1.79.Final\netty-transport-4.1.79.Final.jar;E:\Maven\apache-maven-3.9.9\maven_repository\io\projectreactor\reactor-core\3.4.22\reactor-core-3.4.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\reactivestreams\reactive-streams\1.0.4\reactive-streams-1.0.4.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot-starter-cache\2.7.3\spring-boot-starter-cache-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-context-support\5.3.22\spring-context-support-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\boot\spring-boot-starter-websocket\2.7.3\spring-boot-starter-websocket-2.7.3.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-messaging\5.3.22\spring-messaging-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\springframework\spring-websocket\5.3.22\spring-websocket-5.3.22.jar;E:\Maven\apache-maven-3.9.9\maven_repository\javax\xml\bind\jaxb-api\2.3.1\jaxb-api-2.3.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\javax\activation\javax.activation-api\1.2.0\javax.activation-api-1.2.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\poi\poi\3.16\poi-3.16.jar;E:\Maven\apache-maven-3.9.9\maven_repository\commons-codec\commons-codec\1.15\commons-codec-1.15.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\commons\commons-collections4\4.1\commons-collections4-4.1.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\poi\poi-ooxml\3.16\poi-ooxml-3.16.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\poi\poi-ooxml-schemas\3.16\poi-ooxml-schemas-3.16.jar;E:\Maven\apache-maven-3.9.9\maven_repository\org\apache\xmlbeans\xmlbeans\2.6.0\xmlbeans-2.6.0.jar;E:\Maven\apache-maven-3.9.9\maven_repository\com\github\virtuald\curvesapi\1.04\curvesapi-1.04.jar DbConnection java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:682) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:230) at DbConnection.getCon(DbConnection.java:11) at DbConnection.main(DbConnection.java:18) 数据库连接失败!
最新发布
11-27
当Java使用JDBC连接MySQL出现 `Access denied for user 'root'@'localhost' (using password: YES)` 错误时,可以尝试以下解决办法: ### 检查密码 使用命令提示符或Navicat等软件连接MySQL,确保输入的密码正确。若忘记密码,可以通过百度搜索MySQL密码修改教程来进行修改。若能正常登录,但IDEA仍然报错,则需进一步排查其他原因[^3]。 ### 检查权限 在MySQL中,确保用户 `root` 拥有足够的权限。可以通过以下SQL语句为 `root` 用户授予所有权限: ```sql GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'your_password' WITH GRANT OPTION; FLUSH PRIVILEGES; ``` 其中,`your_password` 是 `root` 用户的密码。执行上述语句后,再次尝试连接数据库。 ### 重启MySQL服务 可以通过以下步骤重启MySQL服务:此电脑——右键管理——服务——到MySQL——右键停止、启动。重启后,再运行程序,看是否能成功连接数据库[^3]。 ### 检查URL参数 在JDBC连接URL中,确保参数配置正确。例如,可以添加一些常用的参数,如 `allowMultiQueries=true`、`useUnicode=true`、`characterEncoding=UTF-8`、`useSSL=false` 等: ```java String url = "jdbc:mysql://localhost:3306/your_database?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false"; ``` 其中,`your_database` 是要连接的数据库名称。 ### 检查MySQL版本与JDBC驱动兼容性 确保使用的JDBC驱动与MySQL版本兼容。不同版本的MySQL可能需要不同版本的JDBC驱动。可以从MySQL官方网站下载与MySQL版本对应的JDBC驱动,并在项目中正确配置。 ### 防火墙或安全组设置 检查防火墙或安全组设置,确保MySQL服务的端口(默认是3306)是开放的,允许外部连接。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值