java出现报错QAQ 完全无头绪 注册页面点击注册后显示如下错误:

Question

严重: Servlet.service() for servlet [UserServlet] in context with path [/goods] threw exception
java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
at cn.itcast.servlet.BaseServlet.service(BaseServlet.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at cn.itcast.filter.EncodingFilter.doFilter(EncodingFilter.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1434)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at cn.itcast.servlet.BaseServlet.service(BaseServlet.java:44)
... 26 more
Caused by: java.lang.RuntimeException: java.sql.SQLException: Data truncation: Data too long for column 'loginname' at row 1 Query: insert into t_user values (?,?,?,?,?,?) Parameters: [73819349617543F5B35F175489731F6F, 8E84EB7B41B14C22832B10625AADD601332DC8C364D6489A9AA8B87C7AF89962, aaaaaa, [e-mail], false, 8E84EB7B41B14C22832B10625AADD601332DC8C364D6489A9AA8B87C7AF89962]
at cn.itcast.goods.user.service.UserService.regist(UserService.java:72)
at cn.itcast.goods.user.web.servlet.UserServlet.regist(UserServlet.java:131)
... 31 more
Caused by: java.sql.SQLException: Data truncation: Data too long for column 'loginname' at row 1 Query: insert into t_user values (?,?,?,?,?,?) Parameters: [73819349617543F5B35F175489731F6F, 8E84EB7B41B14C22832B10625AADD601332DC8C364D6489A9AA8B87C7AF89962, aaaaaa, [e-mail], false, 8E84EB7B41B14C22832B10625AADD601332DC8C364D6489A9AA8B87C7AF89962]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:320)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:489)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:402)
at cn.itcast.jdbc.TxQueryRunner.update(TxQueryRunner.java:55)
at cn.itcast.goods.user.dao.UserDao.add(UserDao.java:52)
at cn.itcast.goods.user.service.UserService.regist(UserService.java:70)
... 32 more

求问如何结局,我是照着一个学习视频学习的..

Answer 1

你的数据库字段设置不合理 插入的数据长度超过了你设置的最大长度，Data too long for column 'loginname' at row 1 Query: insert into t_user values (?,?,?,?,?,?) 你可以看看 至少这是个错误 也或许还有配置的错误 web.xml