看报错是HashMap不能转为User，所以首先应该查看一下Mapper.xml文件中接口对应的返回类型是不是有问题呢，很可能是mapper文件返回结果跟你Mapper接口中的方法返回类型不同导致的。
Java中用mysql-connector-java-8.0.20驱动连接MySQL时，Java已经可以不加载MySQL驱动直接连接MySQL了？_course
2020-06-21Java里常规连接MySQL数据库第一步是Class.forName来加载驱动， 心血来潮想试试不加载驱动会怎样，发现居然也能不报错。。。。？？？ what？这是为啥嘞？ 环境：idea编辑器，jdk14.0，项目结构内已经导入mysql-connector-java-8.0.20.jar包 尝试：不导入com.mysql.*包，也不通过Class.forName()来加载驱动，直接通过url连接。 代码如图：  注意那个被注释掉的代码。 我傻了，难道是mysql驱动的新特性？或者是jdk14的特性？还是getConnection方法会自动查找？还是什么其他原因。 当然如果不导入驱动jar包如果不加载驱动还是会正常报错。
intellij idea项目已成功部署到服务器，但是没有看到程序执行输出_course
2018-09-15public class UserDaoImple { public boolean addUser(User user){ System.out.print("没有输出"); try { Class.forName("com.mysql.jdbc.Driver"); String sql="insert into user values(?,?,?,?,?,?)"; String url="jdbc:mysql://localhost:3306/clothing_samplehh?useSSL=true"; Connection connection = DriverManager.getConnection(url,"root","root"); PreparedStatement ps=connection.prepareStatement(sql); ps.setString(1,user.getUserId()); ps.setString(2,user.getUserName()); ps.setString(3,user.getUserTel()); ps.setString(4,user.getUserEmail()); ps.setString(5,user.getUserPassword()); ps.setString(6,user.getUserRegisterDate()); connection.close(); ps.close(); } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } System.out.print("还是没有输出"); return true; } } 后台输出内容： "C:\Program Files\JetBrains\IntelliJ IDEA 2017.3.1\apache-tomcat-8.5.24\bin\catalina.bat" run [2018-09-15 12:35:51,994] Artifact Q7:war exploded: Waiting for server connection to start artifact deployment... Using CATALINA_BASE: "C:\Users\Administrator\.IntelliJIdea2017.3\system\tomcat\未命名_Q7" Using CATALINA_HOME: "C:\Program Files\JetBrains\IntelliJ IDEA 2017.3.1\apache-tomcat-8.5.24" Using CATALINA_TMPDIR: "C:\Program Files\JetBrains\IntelliJ IDEA 2017.3.1\apache-tomcat-8.5.24\temp" Using JRE_HOME: "C:\Program Files\jdk\jdk1.8\jdk1.8.0_151" Using CLASSPATH: "C:\Program Files\JetBrains\IntelliJ IDEA 2017.3.1\apache-tomcat-8.5.24\bin\bootstrap.jar;C:\Program Files\JetBrains\IntelliJ IDEA 2017.3.1\apache-tomcat-8.5.24\bin\tomcat-juli.jar" 15-Sep-2018 12:35:53.136 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.24 15-Sep-2018 12:35:53.138 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Nov 27 2017 13:05:30 UTC 15-Sep-2018 12:35:53.138 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.24.0 15-Sep-2018 12:35:53.138 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows 7 15-Sep-2018 12:35:53.138 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 6.1 15-Sep-2018 12:35:53.139 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64 15-Sep-2018 12:35:53.139 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:\Program Files\jdk\jdk1.8\jdk1.8.0_151\jre 15-Sep-2018 12:35:53.139 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_151-b12 15-Sep-2018 12:35:53.139 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation 15-Sep-2018 12:35:53.139 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Users\Administrator\.IntelliJIdea2017.3\system\tomcat\未命名_Q7 15-Sep-2018 12:35:53.139 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:\Program Files\JetBrains\IntelliJ IDEA 2017.3.1\apache-tomcat-8.5.24 15-Sep-2018 12:35:53.140 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Users\Administrator\.IntelliJIdea2017.3\system\tomcat\未命名_Q7\conf\logging.properties 15-Sep-2018 12:35:53.140 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 15-Sep-2018 12:35:53.140 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote= 15-Sep-2018 12:35:53.140 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.port=1099 15-Sep-2018 12:35:53.140 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.ssl=false 15-Sep-2018 12:35:53.140 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.authenticate=false 15-Sep-2018 12:35:53.140 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.rmi.server.hostname=127.0.0.1 15-Sep-2018 12:35:53.140 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048 15-Sep-2018 12:35:53.140 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 15-Sep-2018 12:35:53.140 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs= 15-Sep-2018 12:35:53.141 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Users\Administrator\.IntelliJIdea2017.3\system\tomcat\未命名_Q7 15-Sep-2018 12:35:53.141 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Program Files\JetBrains\IntelliJ IDEA 2017.3.1\apache-tomcat-8.5.24 15-Sep-2018 12:35:53.141 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Program Files\JetBrains\IntelliJ IDEA 2017.3.1\apache-tomcat-8.5.24\temp 15-Sep-2018 12:35:53.141 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library [1.2.16] using APR version [1.6.3]. 15-Sep-2018 12:35:53.141 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true]. 15-Sep-2018 12:35:53.142 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true] 15-Sep-2018 12:35:54.156 信息 [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.0.2m 2 Nov 2017] 15-Sep-2018 12:35:54.317 信息 [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"] 15-Sep-2018 12:35:54.339 信息 [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read 15-Sep-2018 12:35:54.348 信息 [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"] 15-Sep-2018 12:35:54.348 信息 [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read 15-Sep-2018 12:35:54.348 信息 [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1674 ms 15-Sep-2018 12:35:54.395 信息 [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina] 15-Sep-2018 12:35:54.395 信息 [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.24 15-Sep-2018 12:35:54.469 信息 [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"] 15-Sep-2018 12:35:54.479 信息 [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-nio-8009"] 15-Sep-2018 12:35:54.482 信息 [main] org.apache.catalina.startup.Catalina.start Server startup in 127 ms Connected to server [2018-09-15 12:35:54,678] Artifact Q7:war exploded: Artifact is being deployed, please wait... 15-Sep-2018 12:35:55.306 信息 [RMI TCP Connection(3)-127.0.0.1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time. [2018-09-15 12:35:55,361] Artifact Q7:war exploded: Artifact is deployed successfully [2018-09-15 12:35:55,362] Artifact Q7:war exploded: Deploy took 683 milliseconds 15-Sep-2018 12:36:04.470 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\JetBrains\IntelliJ IDEA 2017.3.1\apache-tomcat-8.5.24\webapps\manager] 15-Sep-2018 12:36:04.544 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\JetBrains\IntelliJ IDEA 2017.3.1\apache-tomcat-8.5.24\webapps\manager] has finished in [74] ms
IntelliJ IDEA 2020.1.1 (Ultimate Edition)tomcat启动不了_course
2020-05-21 tomcat启动不了也没有提示，idea版本：IntelliJ IDEA 2020.1.1 (Ultimate Edition)
Intellij idea配置database报错问题_course
2017-07-07   但是点击OK后，database窗口中只显示了数据库名，没有任何表格，控制台提示的是java.lang.AbstractMethodError: Method com/mysql/jdbc/ResultSet.isClosed()Z is abstract错误。
IntelliJ IDEA 连接数据库报错_course
2018-04-27 Connection to MySQL - docdb@localhost failed java.sql.SQLException: The connection property 'zeroDateTimeBehavior' acceptable values are: 'CONVERT_TO_NULL', 'EXCEPTION' or 'ROUND'. The value 'convertToNull' is not acceptable. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:127) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:87) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:61) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:71) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:85) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:440) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226) at com.intellij.database.remote.jdbc.impl.RemoteDriverImpl.connect(RemoteDriverImpl.java:27) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:323) at sun.rmi.transport.Transport$1.run(Transport.java:200) at sun.rmi.transport.Transport$1.run(Transport.java:197) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Transport.java:196) at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$254(TCPTransport.java:683) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler$$Lambda$1/16470434.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:276) at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:253) at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:162) at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:194) at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:148) at com.sun.proxy.$Proxy172.connect(Unknown Source) at sun.reflect.GeneratedMethodAccessor686.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.intellij.execution.rmi.RemoteUtil.invokeRemote(RemoteUtil.java:124) at com.intellij.execution.rmi.RemoteUtil.access$100(RemoteUtil.java:36) at com.intellij.execution.rmi.RemoteUtil$RemoteInvocationHandler.invoke(RemoteUtil.java:229) at com.sun.proxy.$Proxy173.connect(Unknown Source) at com.intellij.database.dataSource.LocalDataSource.getConnection(LocalDataSource.java:240) at com.intellij.database.dataSource.LocalDataSource.getConnection(LocalDataSource.java:208) at com.intellij.database.dataSource.DataSource.getConnection(DataSource.java:361) at com.intellij.database.dataSource.DataSource.performJdbcOperation(DataSource.java:405) at com.intellij.database.dataSource.AbstractDataSource.refreshMetaData(AbstractDataSource.java:32) at com.intellij.database.dataSource.DataSourceUiUtil$3.run(DataSourceUiUtil.java:180) at com.intellij.openapi.progress.impl.CoreProgressManager$TaskRunnable.run(CoreProgressManager.java:563) at com.intellij.openapi.progress.impl.CoreProgressManager$8.run(CoreProgressManager.java:367) at com.intellij.openapi.progress.impl.CoreProgressManager$2.run(CoreProgressManager.java:152) at com.intellij.openapi.progress.impl.CoreProgressManager.a(CoreProgressManager.java:452) at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:402) at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:54) at com.intellij.openapi.progress.impl.CoreProgressManager.runProcess(CoreProgressManager.java:137) at com.intellij.openapi.application.impl.ApplicationImpl$10$1.run(ApplicationImpl.java:617) at com.intellij.openapi.application.impl.ApplicationImpl$8.run(ApplicationImpl.java:400) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) at org.jetbrains.ide.PooledThreadExecutor$1$1.run(PooledThreadExecutor.java:56) Caused by: java.lang.RuntimeException: com.mysql.cj.exceptions.WrongArgumentException: The connection property 'zeroDateTimeBehavior' acceptable values are: 'CONVERT_TO_NULL', 'EXCEPTION' or 'ROUND'. The value 'convertToNull' is not acceptable. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:103) at com.mysql.cj.conf.DefaultPropertySet.initializeProperties(DefaultPropertySet.java:194) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:382) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226) at com.intellij.database.remote.jdbc.impl.RemoteDriverImpl.connect(RemoteDriverImpl.java:27) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:323) at sun.rmi.transport.Transport$1.run(Transport.java:200) at sun.rmi.transport.Transport$1.run(Transport.java:197) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Transport.java:196) at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$254(TCPTransport.java:683) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler$$Lambda$1/16470434.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.RuntimeException: com.mysql.cj.exceptions.CJException: The connection property 'zeroDateTimeBehavior' acceptable values are: 'CONVERT_TO_NULL', 'EXCEPTION' or 'ROUND'. The value 'convertToNull' is not acceptable. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:103) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:149) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:122) at com.mysql.cj.conf.EnumPropertyDefinition.parseObject(EnumPropertyDefinition.java:64) at com.mysql.cj.conf.EnumPropertyDefinition.parseObject(EnumPropertyDefinition.java:39) at com.mysql.cj.conf.AbstractRuntimeProperty.setFromString(AbstractRuntimeProperty.java:96) at com.mysql.cj.conf.AbstractRuntimeProperty.initializeFrom(AbstractRuntimeProperty.java:91) at com.mysql.cj.conf.AbstractRuntimeProperty.initializeFrom(AbstractRuntimeProperty.java:75) at com.mysql.cj.conf.DefaultPropertySet.initializeProperties(DefaultPropertySet.java:191) ... 22 more Caused by: java.lang.IllegalArgumentException: No enum constant com.mysql.cj.conf.PropertyDefinitions.ZeroDatetimeBehavior.CONVERTTONULL at java.lang.Enum.valueOf(Enum.java:238) at com.mysql.cj.conf.EnumPropertyDefinition.parseObject(EnumPropertyDefinition.java:62) ... 27 more
Intellij idea中创建java maven项目引用包出错_course
2017-11-09 如图所示 提示connot resolve symbol 'XXXX' 请各位帮忙指点
IntelliJ idea Web项目配置问题（JDBC驱动注册失败）_course
2017-07-07今天想要把开发工具从Eclipse换成Intellij idea。于是把一个在Eclipse中开发的项目导入到了idea。各种配置完之后，项目可以启动，可以打开主页，但是无法登陆系统。控制台打印JDBC驱动注册失败，如图。请问这个问题怎么解决啊！各位大哥帮帮忙，小弟谢过啦！    另外数据库连接是没问题的。在Eclipse中启动也没有问题
在IntelliJ IDEA中首次设置Postgres_course
2017-04-18<div class="post-text" itemprop="text"> <p>Ok so I am currently trying to set up a Postgres Database on IntelliJ and I'm running into an issue. I was going through the settings trying to understand the different configurations and get a better understanding of what was going on as I've never dealt with any kind of SQL related databases before. Not to my knowledge at least. When I click on the schema tab, this prompt shows up:</p> <p><code>The specified user/password combination is rejected: [08004] The server requested password-based authentication, but no password was provided.</code></p> <p>This is followed by a prompt asking for a username & password. I entered <code>root</code> (literally) in the username section, and a made up <code>password</code> in the password section, and I got this error message:</p> <p><code>The specified user/password combination is rejected: [28P01] FATAL: password authentication failed for user "root"</code>.</p> <p>I am not sure what I am supposed to do as I was never asked to set up a password. From what I get from the prompt, a username seems to have already been defined by IntelliJ. How do I find out what that <code>username</code> is and reset the <code>password</code>? And if that's not the way to go, how should I go about solving this issue?</p> <p>EDIT: I finally figured it out. The username had to be the same as the name of my database. From then I was able to set up my password, and everything worked fine. </p> </div>
intellij idea导入eclipse创建的maven web项目 jar包导入总是报错_course
2018-11-12** 软件环境**： spring+springMVC+mybatis+ mysql； tomcat服务器； maven项目 eclipse工具运行正常； **问题描述：** maven的jar包依赖没有导入成功，maven配置正常 沿用了阿里云的中心库eclipse可用； 报错截图1：  ``` nformation:java: Errors occurred while compiling module 'miaolanghzong' Information:Eclipse compiler 4.7.2 was used to compile java sources Information:2018/11/12 21:56 - Compilation completed with 133 errors and 418 warnings in 29 s 620 ms D:\career\workspaceTest2\erzhentang\src\main\java\com\app\totalController\MemberBusinessController.java Error:Error:line (1)java: Syntax error on token "Invalid Character", delete this token Error:Error:line (13)java: The import javax.servlet.http.HttpServletRequest cannot be resolved Error:Error:line (14)java: The import javax.servlet.http.HttpServletResponse cannot be resolved Error:Error:line (47)java: The import com.google.gson cannot be resolved Error:Error:line (659)java: HttpServletRequest cannot be resolved to a type Error:Error:line (659)java: HttpServletResponse cannot be resolved to a type Error:Error:line (623)java: HttpServletRequest cannot be resolved to a type Error:Error:line (623)java: HttpServletResponse cannot be resolved to a type Error:Error:line (894)java: HttpServletRequest cannot be resolved to a type Error:Error:line (894)java: HttpServletResponse cannot be resolved to a type Error:Error:line (806)java: HttpServletRequest cannot be resolved to a type Error:Error:line (806)java: HttpServletResponse cannot be resolved to a type Error:Error:line (198)java: HttpServletRequest cannot be resolved to a type Error:Error:line (198)java: HttpServletResponse cannot be resolved to a type Error:Error:line (277)java: HttpServletRequest cannot be resolved to a type Error:Error:line (277)java: HttpServletResponse cannot be resolved to a type Error:Error:line (134)java: HttpServletRequest cannot be resolved to a type Error:Error:line (134)java: HttpServletResponse cannot be resolved to a type Error:Error:line (460)java: HttpServletRequest cannot be resolved to a type Error:Error:line (460)java: HttpServletResponse cannot be resolved to a type Error:Error:line (540)java: HttpServletRequest cannot be resolved to a type Error:Error:line (540)java: HttpServletResponse cannot be resolved to a type Error:Error:line (109)java: HttpServletRequest cannot be resolved to a type Error:Error:line (109)java: HttpServletResponse cannot be resolved to a type Error:Error:line (411)java: HttpServletRequest cannot be resolved to a type Error:Error:line (411)java: HttpServletResponse cannot be resolved to a type Warning:Warning:line (114)java: The static method sendCode(java.lang.String) from the type com.app.util.Alidayu should be accessed in a static way Warning:Warning:line (154)java: The static method md5Encode(java.lang.String) from the type com.app.util.MD5Util should be accessed in a static way Warning:Warning:line (207)java: The static method md5Encode(java.lang.String) from the type com.app.util.MD5Util should be accessed in a static way Warning:Warning:line (286)java: The static method md5Encode(java.lang.String) from the type com.app.util.MD5Util should be accessed in a static way Warning:Warning:line (421)java: The static method md5Encode(java.lang.String) from the type com.app.util.MD5Util should be accessed in a static way Warning:Warning:line (469)java: The static method md5Encode(java.lang.String) from the type com.app.util.MD5Util should be accessed in a static way Warning:Warning:line (549)java: The static method md5Encode(java.lang.String) from the type com.app.util.MD5Util should be accessed in a static way D:\career\workspaceTest2\erzhentang\src\main\java\com\app\common\LoginFilter.java Error:Error:line (23)java: Filter cannot be resolved to a type Error:Error:line (37)java: ServletException cannot be resolved to a type Error:Error:line (36)java: ServletRequest cannot be resolved to a type Error:Error:line (36)java: ServletResponse cannot be resolved to a type Error:Error:line (37)java: FilterChain cannot be resolved to a type Error:Error:line (106)java: ServletException cannot be resolved to a type Error:Error:line (106)java: FilterConfig cannot be resolved to a type Error:Error:line (7)java: The import javax.servlet.Filter cannot be resolved Error:Error:line (8)java: The import javax.servlet.FilterChain cannot be resolved Error:Error:line (9)java: The import javax.servlet.FilterConfig cannot be resolved Error:Error:line (10)java: The import javax.servlet.ServletException cannot be resolved Error:Error:line (11)java: The import javax.servlet.ServletRequest cannot be resolved Error:Error:line (12)java: The import javax.servlet.ServletResponse cannot be resolved Error:Error:line (13)java: The import javax.servlet.http.HttpServletRequest cannot be resolved Error:Error:line (14)java: The import javax.servlet.http.HttpServletResponse cannot be resolved Error:Error:line (15)java: The import javax.servlet.http.HttpSession cannot be resolved Error:Error:line (24)java: FilterConfig cannot be resolved to a type Warning:Warning:line (26)java: java.util.List is a raw type. References to generic type java.util.List<E> should be parameterized Warning:Warning:line (28)java: java.util.List is a raw type. References to generic type java.util.List<E> should be parameterized Error:Error:line (33)java: FilterConfig cannot be resolved to a type Error:Error:line (39)java: HttpServletRequest cannot be resolved to a type Error:Error:line (39)java: HttpServletRequest cannot be resolved to a type Error:Error:line (40)java: HttpServletResponse cannot be resolved to a type Error:Error:line (40)java: HttpServletResponse cannot be resolved to a type Error:Error:line (41)java: HttpSession cannot be resolved to a type Error:Error:line (107)java: FilterConfig cannot be resolved to a type Error:Error:line (108)java: FilterConfig cannot be resolved to a type Error:Error:line (113)java: FilterConfig cannot be resolved to a type D:\career\workspaceTest2\erzhentang\src\main\java\com\app\dao\impl\MemberDaoImpl.java Warning:Warning:line (42)java: java.util.Map is a raw type. References to generic type java.util.Map<K,V> should be parameterized Warning:Warning:line (63)java: java.util.Map is a raw type. References to generic type java.util.Map<K,V> should be parameterized Warning:Warning:line (110)java: java.util.Map is a raw type. References to generic type java.util.Map<K,V> should be parameterized Warning:Warning:line (9)java: The import com.app.bean.Menu is never used D:\career\workspaceTest2\erzhentang\src\main\java\com\app\dao\impl\EarProblemDaoImpl.java Warning:Warning:line (18)java: java.util.Map is a raw type. References to generic type java.util.Map<K,V> should be parameterized Warning:Warning:line (48)java: java.util.Map is a raw type. References to generic type java.util.Map<K,V> should be parameterized D:\career\workspaceTest2\erzhentang\src\main\java\com\app\dao\impl\BodyConclusionDaoImpl.java Warning:Warning:line (25)java: java.util.Map is a raw type. References to generic type java.util.Map<K,V> should be parameterized Warning:Warning:line (11)java: The import com.app.bean.BodyConclusionWuxing is never used D:\career\workspaceTest2\erzhentang\src\main\java\com\app\dao\mapper\EarDisease100Mapper.java Warning:Warning:line (14)java: java.util.Map is a raw type. References to generic type java.util.Map<K,V> should be parameterized D:\career\workspaceTest2\erzhentang\src\main\java\com\app\dao\BlueToochMacDao.java Warning:Warning:line (12)java: java.util.Map is a raw type. References to generic type java.util.Map<K,V> should be parameterized Warning:Warning:line (14)java: java.util.Map is a raw type. References to generic type java.util.Map<K,V> should be parameterized D:\career\workspaceTest2\erzhentang\src\main\java\com\app\dao\EarScanC ```      
Java--Mybatis foreach 循环之 数组(array)取值 方法_course
2019-06-03 错误详情： ```### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '吕试听'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '吕试听') - ?, ?,?, ?,?,?,?) insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '3'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '3') - ?, ?,?, ?,?,?,?) ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ] - (28462 ms) - 2019-6-3 22:35:45[DEBUG](JakartaCommonsLoggingImpl.java:46) Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@23103ebd] - (28463 ms) - 2019-6-3 22:35:45[DEBUG](DataSourceUtils.java:327) Returning JDBC Connection to DataSource - (28468 ms) - 2019-6-3 22:35:45[DEBUG](AbstractHandlerExceptionResolver.java:132) Resolving exception from handler [public java.lang.String com.dms.controller.monthlyinfo.CourseInfoController.courseInfoSave(com.dms.pojo.Course,javax.servlet.http.HttpSession,javax.servlet.http.HttpServletRequest,java.lang.String)]: org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '吕试听'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '吕试听') - ?, ?,?, ?,?,?,?) insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '3'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '3') - ?, ?,?, ?,?,?,?) ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 - (28483 ms) - 2019-6-3 22:35:45[DEBUG](AbstractHandlerExceptionResolver.java:132) Resolving exception from handler [public java.lang.String com.dms.controller.monthlyinfo.CourseInfoController.courseInfoSave(com.dms.pojo.Course,javax.servlet.http.HttpSession,javax.servlet.http.HttpServletRequest,java.lang.String)]: org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '吕试听'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '吕试听') - ?, ?,?, ?,?,?,?) insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '3'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '3') - ?, ?,?, ?,?,?,?) ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 - (28484 ms) - 2019-6-3 22:35:45[DEBUG](AbstractHandlerExceptionResolver.java:132) Resolving exception from handler [public java.lang.String com.dms.controller.monthlyinfo.CourseInfoController.courseInfoSave(com.dms.pojo.Course,javax.servlet.http.HttpSession,javax.servlet.http.HttpServletRequest,java.lang.String)]: org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '吕试听'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '吕试听') - ?, ?,?, ?,?,?,?) insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '3'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '3') - ?, ?,?, ?,?,?,?) ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 - (28507 ms) - 2019-6-3 22:35:45[DEBUG](AbstractHandlerExceptionResolver.java:132) Resolving exception from handler [public java.lang.String com.dms.controller.monthlyinfo.CourseInfoController.courseInfoSave(com.dms.pojo.Course,javax.servlet.http.HttpSession,javax.servlet.http.HttpServletRequest,java.lang.String)]: org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '吕试听'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '吕试听') - ?, ?,?, ?,?,?,?) insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '3'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '3') - ?, ?,?, ?,?,?,?) ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 - (28507 ms) - 2019-6-3 22:35:45[DEBUG](AbstractHandlerExceptionResolver.java:132) Resolving exception from handler [public java.lang.String com.dms.controller.monthlyinfo.CourseInfoController.courseInfoSave(com.dms.pojo.Course,javax.servlet.http.HttpSession,javax.servlet.http.HttpServletRequest,java.lang.String)]: org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '吕试听'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '吕试听') - ?, ?,?, ?,?,?,?) insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '3'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '3') - ?, ?,?, ?,?,?,?) ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 - (28513 ms) - 2019-6-3 22:35:45[DEBUG](AbstractHandlerExceptionResolver.java:132) Resolving exception from handler [public java.lang.String com.dms.controller.monthlyinfo.CourseInfoController.courseInfoSave(com.dms.pojo.Course,javax.servlet.http.HttpSession,javax.servlet.http.HttpServletRequest,java.lang.String)]: org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '吕试听'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '吕试听') - ?, ?,?, ?,?,?,?) insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '3'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '3') - ?, ?,?, ?,?,?,?) ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 - (28514 ms) - 2019-6-3 22:35:45[DEBUG](FrameworkServlet.java:976) Could not complete request org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '吕试听'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '吕试听') - ?, ?,?, ?,?,?,?) insert into expense_info(cId,sId,expenseDate,expenseWeek,expenseSchoolTime,expenseCoach,createdName,expenseSurplusClassHour,expenseCoursesContent,expenseTeachResult,createdBy,creationDate,modifyBy,modifyDate) values( (select max(id) from course_info), (select s.id from student_info s where s.studentName = '3'), ?,?,?,?,? (select studentClassHourNum from student_info where studentName = '3') - ?, ?,?, ?,?,?,?) ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:364) at com.sun.proxy.$Proxy9.insert(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:236) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:46) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:43) at com.sun.proxy.$Proxy11.addExpenseInfo(Unknown Source) at com.dms.service.course.impl.CourseServiceImpl.addExpenseInfo(CourseServiceImpl.java:52) at com.dms.controller.monthlyinfo.CourseInfoController.courseInfoSave(CourseInfoController.java:375) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:855) at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select studentClassHourNum from student_info where studentName = '???è?????') -' at line 6 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:353) at com.mysql.jdbc.Util.getInstance(Util.java:336) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710) at com.mysql.jdbc.Connection.execSQL(Connection.java:2436) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1402) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:977) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:55) at com.sun.proxy.$Proxy25.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41) at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148) at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:137) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:354) ... 50 more 1. ``` 这种写法如何取到值？？
关于Idea怎么和MYSQL数据库建立连接_course
2017-10-04请请教下关于Idea开发工具怎么和MYSQL数据库建立连接，刚刚使用MYSQL和Idea 不是很熟悉，非常感谢回答
使用intellij idea 运行java web项目出下以下红色提示？_course
2016-10-29十月 29, 2016 3:12:26 下午 org.apache.catalina.startup.TldConfig execute 信息: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time. 十月 29, 2016 3:12:26 下午 org.apache.catalina.startup.TldConfig execute 信息: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time. 十月 29, 2016 3:12:27 下午 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deployment of web application directory D:\apache-tomcat-7.0.69\webapps\manager has finished in 8,501 ms
Intelliji Idea开发ssh项目部署到服务器上的tomcat无法运行。求教！_course
2017-09-20在本地tomcat环境是可以运行的。 struts2-convention-plugin-2.5.13.jar，这个jar包不知道发生什么错误。 错误日志提示如下： 20-Sep-2017 18:46:27.428 INFO [http-nio-8080-exec-23] org.apache.catalina.core.ApplicationContext.log HTMLManager: start: Starting web application '/myroom' 20-Sep-2017 18:46:28.548 INFO [http-nio-8080-exec-23] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time. 20-Sep-2017 18:46:28.552 INFO [http-nio-8080-exec-23] org.apache.catalina.core.ApplicationContext.log No Spring WebApplicationInitializer types detected on classpath 20-Sep-2017 18:46:28.644 INFO [http-nio-8080-exec-23] org.apache.catalina.core.ApplicationContext.log Initializing Spring root WebApplicationContext 20-Sep-2017 18:46:31.102 SEVERE [http-nio-8080-exec-23] org.apache.catalina.core.StandardContext.filterStart Exception starting filter [struts2] Unable to load configuration. - bean - jar:file:/usr/local/apache-tomcat-9.0.0.M26/webapps/myroom/WEB-INF/lib/struts2-convention-plugin-2.5.13.jar!/struts-plugin.xml:32:155 at org.apache.struts2.dispatcher.Dispatcher.init(Dispatcher.java:499) at org.apache.struts2.dispatcher.InitOperations.initDispatcher(InitOperations.java:75) at org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter.init(StrutsPrepareAndExecuteFilter.java:63) at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:283) at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:264) at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:108) at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4491) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5131) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1303) at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:665) at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:211) at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:136) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:592) at org.apache.catalina.valves.RequestFilterValve.process(RequestFilterValve.java:348) at org.apache.catalina.valves.RemoteAddrValve.invoke(RemoteAddrValve.java:52) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1374) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: Unable to load configuration. - bean - jar:file:/usr/local/apache-tomcat-9.0.0.M26/webapps/myroom/WEB-INF/lib/struts2-convention-plugin-2.5.13.jar!/struts-plugin.xml:32:155 at com.opensymphony.xwork2.config.ConfigurationManager.getConfiguration(ConfigurationManager.java:70) at org.apache.struts2.dispatcher.Dispatcher.getContainer(Dispatcher.java:906) at org.apache.struts2.dispatcher.Dispatcher.init_PreloadConfiguration(Dispatcher.java:445) at org.apache.struts2.dispatcher.Dispatcher.init(Dispatcher.java:486) ... 40 more Caused by: Unable to load bean: type:org.apache.struts2.convention.ActionConfigBuilder class:org.apache.struts2.convention.PackageBasedActionConfigBuilder - bean - jar:file:/usr/local/apache-tomcat-9.0.0.M26/webapps/myroom/WEB-INF/lib/struts2-convention-plugin-2.5.13.jar!/struts-plugin.xml:32:155 at com.opensymphony.xwork2.config.providers.XmlConfigurationProvider.register(XmlConfigurationProvider.java:247) at org.apache.struts2.config.StrutsXmlConfigurationProvider.register(StrutsXmlConfigurationProvider.java:98) at com.opensymphony.xwork2.config.impl.DefaultConfiguration.reloadContainer(DefaultConfiguration.java:240) at com.opensymphony.xwork2.config.ConfigurationManager.getConfiguration(ConfigurationManager.java:67) ... 43 more Caused by: java.lang.IncompatibleClassChangeError: Implementing class at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:763) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) at org.apache.catalina.loader.WebappClassLoaderBase.findClassInternal(WebappClassLoaderBase.java:2257) at org.apache.catalina.loader.WebappClassLoaderBase.findClass(WebappClassLoaderBase.java:799) at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1238) at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1104) at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:2671) at java.lang.Class.getDeclaredConstructors(Class.java:2020) at com.opensymphony.xwork2.config.providers.XmlConfigurationProvider.register(XmlConfigurationProvider.java:237) ... 46 more 20-Sep-2017 18:46:31.104 SEVERE [http-nio-8080-exec-23] org.apache.catalina.core.StandardContext.startInternal One or more Filters failed to start. Full details will be found in the appropriate container log file 20-Sep-2017 18:46:31.104 SEVERE [http-nio-8080-exec-23] org.apache.catalina.core.StandardContext.startInternal Context [/myroom] startup failed due to previous errors 20-Sep-2017 18:46:31.104 INFO [http-nio-8080-exec-23] org.apache.catalina.core.ApplicationContext.log Closing Spring root WebApplicationContext 20-Sep-2017 18:46:31.129 WARNING [http-nio-8080-exec-23] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [myroom] registered the JDBC driver [com.alibaba.druid.proxy.DruidDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. 20-Sep-2017 18:46:31.130 WARNING [http-nio-8080-exec-23] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [myroom] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. 20-Sep-2017 18:46:31.130 WARNING [http-nio-8080-exec-23] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [myroom] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: java.lang.Object.wait(Native Method) java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:143) com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:43) 20-Sep-2017 18:46:31.137 INFO [http-nio-8080-exec-23] org.apache.catalina.core.ApplicationContext.log HTMLManager: list: Listing contexts for virtual host '47.94.164.52'
Intellij Idea使用时报错，但项目中并不依赖此包_course
2016-09-01开发工具： Intellij Idean 使用命令gradle idea可以下载相应的jar包 但在相应的modules 下时使用 gradle jettyRun 报下列的错，但项目中并不依赖这个包， 不知道有熟悉的童鞋可以回答么？ 已经手动安装过这个包了，好奇怪的 Could not resolve all dependencies for configuration ':modules:creditspider:compile'. > Artifact 'jta.jar (javax.transaction:jta:1.0.1B)' not found. Searched in the following locations: https://repo1.maven.org/maven2/javax/transaction/jta/1.0.1B/jta-1.0.1B.jar
idea mysql连接池 NullPointerException_course
2020-04-21这三张图分别是报错的给定位置，连接池的配置以及报错的信息。既然是空指针异常，也就是说没有连接到数据库。我看了一下路径是正确的的，可以找到properties文件，但是在写入数据的时候总出现空指针错误，请各位大佬解惑。 
idea中pom.xml无法导入jdbc的jar包_course
2020-05-03----_这问题勉强已解决，我直接结贴吧_ ------ <br> ```xml <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.38</version> </dependency> ``` <br />  <br/> 查看本地仓库，发现只有下面这个文件：  <br/> lastupdate内容如下： <br/> ``` #NOTE: This is a Maven Resolver internal implementation file, its format can be changed without prior notice. #Sun May 03 14:48:53 CST 2020 http\://maven.aliyun.com/nexus/content/groups/public/.error=Could not transfer artifact mysql\:mysql-connector-java\:pom\:5.1.38 from/to alimaven (http\://maven.aliyun.com/nexus/content/groups/public/)\: sun.security.validator.ValidatorException\: PKIX path building failed\: sun.security.provider.certpath.SunCertPathBuilderException\: unable to find valid certification path to requested target @default-alimaven-http\://maven.aliyun.com/nexus/content/groups/public/.lastUpdated=1588488533478 ``` <br/> 还有其他几个版本我都无法导入， 已尝试：重新复制粘贴；关闭代理；重启idea；mvn clean/compile; <br/> --------------------------------------------- ---在这记一下解决经过以后留个印象--- 尝试重装了该版本的maven，又下了一个idea2020，仓库备份后清空，settings.xml去掉镜像。 一开始去掉阿里镜像，结果也不行，右侧包括pulgin在内全部飘红，mvn命令除了-v全部error，删掉本地项目后reimport又再次生成的也只有一个lastUpdated文件，报错信息看起来就像是说我少了证书，网上一查让加参数试了也不行，和证书好像没啥关系。 后来新建了一个新maven项目，reimport终于有反应了，然后回到老项目里重新剪切粘贴reimport，这次终于可以从中央仓库下载依赖了，虽然速度慢，但加上[阿里镜像](https://help.aliyun.com/document_detail/102512.html?spm=a2c4e.11153940.0.0.213c7bdePMchQS)就不行了，应该是镜像问题，也不知道今天怎么突然就这样了。我意识到两点： - 网速不行确实会造成mvn命令执行失败，但不会像这样一直失败，重新执行一次即可； - 如果中途加了settings.xml文件的mirror，再次reimport，结果失败pom文件飘红，造成即使立刻注释掉mirror点刷新也没有反应，重启一下idea。
Java能同时连mysql数据库和sqlserver数据库吗_course
2019-06-04比如说我现在的数据库是sqlserver，我要做一些增删改查，但是增加的数据保存在mysql数据库中，查询在sqlserver数据库中查。大概意思就是慢慢用mysql数据库替换掉sqlserver数据库，这个能实现吗？跪求大佬解答
idea配置mybits generate时报错，请问是哪配错了吗？_course
2019-11-11报错说找不到driver-class-name核对了很多次都没问题啊 报错： ``` D:\jdk1.8.0_121\bin\java.exe -Dmaven.multiModuleProjectDirectory=D:\mycode\demo_mybits\demo "-Dmaven.home=D:\software\idea\IntelliJ IDEA 2018.2.6\plugins\maven\lib\maven3" "-Dclassworlds.conf=D:\software\idea\IntelliJ IDEA 2018.2.6\plugins\maven\lib\maven3\bin\m2.conf" "-javaagent:D:\software\idea\IntelliJ IDEA 2018.2.6\lib\idea_rt.jar=7115:D:\software\idea\IntelliJ IDEA 2018.2.6\bin" -Dfile.encoding=UTF-8 -classpath "D:\software\idea\IntelliJ IDEA 2018.2.6\plugins\maven\lib\maven3\boot\plexus-classworlds-2.5.2.jar" org.codehaus.classworlds.Launcher -Didea.version=2018.2.6 mybatis-generator:generate -e [INFO] Error stacktraces are turned on. [INFO] Scanning for projects... [INFO] [INFO] ------------------------------------------------------------------------ [INFO] Building demo 0.0.1-SNAPSHOT [INFO] ------------------------------------------------------------------------ [INFO] [INFO] --- mybatis-generator-maven-plugin:1.3.2:generate (default-cli) @ demo --- [INFO] Connecting to the Database [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 1.637 s [INFO] Finished at: 2019-11-11T09:52:35+08:00 [INFO] Final Memory: 14M/245M [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2:generate (default-cli) on project demo: Execution default-cli of goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2:generate failed: Exception getting JDBC Driver: {spring.datasource.driver-class-name} -> [Help 1] org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2:generate (default-cli) on project demo: Execution default-cli of goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2:generate failed: Exception getting JDBC Driver at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:212) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80) at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51) at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106) at org.apache.maven.cli.MavenCli.execute(MavenCli.java:863) at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288) at org.apache.maven.cli.MavenCli.main(MavenCli.java:199) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356) at org.codehaus.classworlds.Launcher.main(Launcher.java:47) Caused by: org.apache.maven.plugin.PluginExecutionException: Execution default-cli of goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.2:generate failed: Exception getting JDBC Driver at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:145) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:207) ... 21 more Caused by: java.lang.RuntimeException: Exception getting JDBC Driver at org.mybatis.generator.internal.db.ConnectionFactory.getDriver(ConnectionFactory.java:85) at org.mybatis.generator.internal.db.ConnectionFactory.getConnection(ConnectionFactory.java:54) at org.mybatis.generator.config.Context.getConnection(Context.java:526) at org.mybatis.generator.config.Context.introspectTables(Context.java:436) at org.mybatis.generator.api.MyBatisGenerator.generate(MyBatisGenerator.java:222) at org.mybatis.generator.maven.MyBatisGeneratorMojo.execute(MyBatisGeneratorMojo.java:203) at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:134) ... 22 more Caused by: java.lang.ClassNotFoundException: {spring.datasource.driver-class-name} at org.codehaus.plexus.classworlds.strategy.SelfFirstStrategy.loadClass(SelfFirstStrategy.java:50) at org.codehaus.plexus.classworlds.realm.ClassRealm.unsynchronizedLoadClass(ClassRealm.java:271) at org.codehaus.plexus.classworlds.realm.ClassRealm.loadClass(ClassRealm.java:247) at org.codehaus.plexus.classworlds.realm.ClassRealm.loadClass(ClassRealm.java:239) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:348) at org.mybatis.generator.internal.ObjectFactory.internalClassForName(ObjectFactory.java:150) at org.mybatis.generator.internal.ObjectFactory.externalClassForName(ObjectFactory.java:121) at org.mybatis.generator.internal.db.ConnectionFactory.getDriver(ConnectionFactory.java:82) ... 28 more [ERROR] [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/PluginExecutionException Process finished with exit code 1 ``` application.properties ``` ## 服务器端口，如果不配置默认是8080端口 server.port=9090 ## 数据库设置 spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://localhost:3306/boot_demo?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8 spring.datasource.username=root spring.datasource.password=x5 ## mybatis配置 # 参数类型的包别名设置 mybatis.typeAliasesPackage=com.example.demo.model # 指向映射xml文件目录 mybatis.mapperLocations=classpath:mapper/*.xml pagehelper.helperDialect=mysql pagehelper.reasonable=true pagehelper.supportMethodsArguments=true pagehelper.params=count=countSql ``` pom.xml ``` <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.2.0.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.example</groupId> <artifactId>demo</artifactId> <version>0.0.1-SNAPSHOT</version> <name>demo</name> <description>Demo project for Spring Boot</description> <properties> <java.version>1.8</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.2</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.10</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> <plugin> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.7</version> <configuration> <verbose>true</verbose> <overwrite>true</overwrite> </configuration> <dependencies> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.18</version> <scope>runtime</scope> </dependency> </dependencies> </plugin> </plugins> </build> </project> ``` generatorConfig.xml ``` <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"> <generatorConfiguration> <!--导入配置文件--> <properties resource="application.properties"></properties> <!-- 一个数据库一个context --> <context id="default"> <!-- 注释生成设置 --> <commentGenerator> <!-- 是否生成注释代时间戳--> <property name="suppressDate" value="true" /> <!-- 是否取消注释 --> <property name="suppressAllComments" value="true" /> </commentGenerator> <!--jdbc的数据库连接--> <jdbcConnection driverClass="{spring.datasource.driver-class-name}" connectionURL="{spring.datasource.url}" userId="{spring.datasource.username}" password="{spring.datasource.password}"> <property name="nullCatalogMeansCurrent" value="true" /> </jdbcConnection> <!-- 类型转换 --> <javaTypeResolver> <!-- 是否使用bigDecimal， false可自动转化以下类型（Long, Integer, Short, etc.） --> <property name="forceBigDecimals" value="false" /> </javaTypeResolver> <!-- targetPackage：生成的实体类所在的包 --> <!-- targetProject：生成的实体类所在的硬盘位置 --> <javaModelGenerator targetPackage="com.example.demo.model" targetProject="src/main/java"> <!-- 是否允许子包 --> <property name="enableSubPackages" value="false" /> <!-- 是否对modal添加构造函数 --> <property name="constructorBased" value="true" /> <!-- 是否清理从数据库中查询出的字符串左右两边的空白字符 --> <property name="trimStrings" value="true" /> <!-- 建立modal对象是否不可改变 即生成的modal对象不会有setter方法，只有构造方法 --> <property name="immutable" value="false" /> </javaModelGenerator> <!-- targetPackage 和 targetProject：生成的 mapper xml 文件的包和位置 --> <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"> <!-- 是否在当前路径下新加一层schema,ex：false路径com.qikegu.demo.model， com.qikegu.demo.model.[schemaName] --> <property name="enableSubPackages" value="false" /> <!-- 是否针对string类型的字段在set的时候进行trim调用 --> <property name="trimStrings" value="true"/> </sqlMapGenerator> <!-- targetPackage 和 targetProject：生成的 java interface 文件的包和位置 --> <javaClientGenerator type="XMLMAPPER" targetPackage="com.example.demo.repository" targetProject="src/main/java"> <!-- 是否在当前路径下新加一层schema,ex：false路径com.qikegu.demo.model， com.qikegu.demo.model.[schemaName] --> <property name="enableSubPackages" value="false" /> </javaClientGenerator> <!-- 配置表信息 --> <!-- schema即为数据库名 tableName为对应的数据库表 domainObjectName是要生成的实体类 enable*ByExample, 是否生成 example类 --> <!-- 不同的表，修改tableName和domainObjectName就可以 --> <table tableName="user" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"> </table> </context> </generatorConfiguration> ```
为什么我用springboot连接mysql始终不成功？_course
2019-01-14之前按照教程写不能成功，现在直接复制别人完整的代码还是不行 一些配置 application.properties ``` spring.mvc.view.prefix=/WEB-INF/jsp/ spring.mvc.view.suffix=.jsp spring.datasource.url=jdbc:mysql://localhost:3306/test?useSSL=false&useUnicode=true&characterEncoding=UTF-8 spring.datasource.username=root spring.datasource.password=123456 spring.datasource.driver-class-name=com.mysql.jdbc.Driver ``` UserMapper.java ``` @Mapper public interface UserMapper { @Select("select * from user") List<User> findAll(); @Insert("insert into user(username,password)values(#{username},#{password}") public int add(User user); } ``` UserSrevice.java ``` @Service public class UserService { @Autowired private UserMapper userMapper; public List<User> findAll(){ return userMapper.findAll(); } public int add(User user){ return userMapper.add(user); } } ``` 每次刷新页面  错误提示 ``` 2019-01-14 11:51:15.363 ERROR 752 --- [nio-8080-exec-1] o.a.tomcat.jdbc.pool.ConnectionPool : Unable to create initial connections of pool. java.sql.SQLException: Unknown character set index for field '255' received from server. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) ~[mysql-connector-java-5.0.3.jar:na] at com.mysql.jdbc.Connection.getCharsetNameForIndex(Connection.java:3396) ~[mysql-connector-java-5.0.3.jar:na] at com.mysql.jdbc.Field.<init>(Field.java:191) ~[mysql-connector-java-5.0.3.jar:na] ERROR 752 --- [nio-8080-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unknown character set index for field '255' received from server. ### The error may exist in com/polaris/springboot_mybatis_jsp/mapper/UserMapper.java (best guess) ### The error may involve com.polaris.springboot_mybatis_jsp.mapper.UserMapper.findAll ### The error occurred while executing a query ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unknown character set index for field '255' received from server.] with root cause ``` 其中会指向这两行 ``` (UserService.java:18) return userMapper.findAll(); (UserController.java:24) List<User> list = userService.findAll(); ``` 求大神解答
idea 2019 database 连接Mysql 报错 lower_case_table_names 显示不出表_course
2020-03-07### MySql是5.2 连接的jar包换了各种版本，还是不行， > -能连接上但是database不显示表名<br> <br> <br> -用idea连接就会报错!<br>[图片说明](https://img-ask.csdn.net/upload/202003/07/1583559616_707277.jpg)<br> -database下也无法加载表名<br> <br> -但是在控制台能查表内容，表名是红色的提示未找到 <br> -我该怎么做才能让database显示出表，求帮助
- 博客 ORA-01031: insufficient privileges解决办法
- 学院 微信小程序快速入门课程（仿豆瓣评分）
- 博客 PAT 甲级 1083 PAT Ranking 个人错误总结
- 下载 高频领域中的电容器
- 博客 SpringBoot定时任务和异步操作
- 学院 从底层决胜LoRa
- 学院 Java全栈工程师-Maven基础
- 博客 C中main函数作参数
- 学院 信息系统项目管理师-通关教程-第3阶段-选择题2013上
- 下载 MPAndroid中文文档.zip
- 下载 kinect驱动安装.zip
- 博客 点云数据集和论文
- 学院 嵌入式系统启动流程基础概念、uboot工作流程、kernel启动流程、文件系统特性分析.
- 博客 java网络编程UDP应用
- 博客 Katacoda Kubernetes系列场景一：Launch Single Node Kubernetes Cluster
- 博客 剑指 Offer 28. 对称的二叉树C++
- 下载 MATLAB疲劳检测专注度识别GUI用户界面.zip
- 学院 Java全栈工程师-Apache Shiro
- 博客 jQuery的each和原生的forEach
- 博客 笔试题记录
- 博客 字符串分割
- 博客 斐波那契数列
- 学院 Java SE基础
- 学院 【SpringBoot项目实战】超市销售管理系统
- 博客 身为Android开发的你还在用万年不变的过时框架吗？
- 下载 ssm牛肉溯源系统毕业设计程序
- 学院 Python基础入门（纯面授课程）
- 下载 winform利用ffmpeg给视频添加背景乐
- 博客 数据结构和算法 快速排序
- 下载 ssm无人药店系统毕业设计程序