FAQ(60):java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
程序员文章站
2022-04-21 16:30:54
...
1、场景:springmvc+spring 实现功能
2、Log:
java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
com.mysql.jdbc.ResultSet.getDateFromString(ResultSet.java:1886)
com.mysql.jdbc.ResultSet.getDate(ResultSet.java:1822)
com.mysql.jdbc.ResultSet.getDate(ResultSet.java:1790)
com.User.Dao.UserDaoImpl.getUserList(UserDaoImpl.java:103)
com.User.Service.UserServiceImpl.getUserList(UserServiceImpl.java:24)
com.User.Controller.UserController.getUserList(UserController.java:118)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
解决:
今天在写代码的时候,在将字符串转换成时间的时候,出现了java.text.ParseException: Unparseable date: "2017-1-1 00:00:00" 这样的问题;
DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
Date start = df.parse(startTime);
Date stop = df.parse(stopTime);
long timeSpan = stop.getTime() - start.getTime();
long hours = timeSpan / (3600 * 1000);
我通过上面这些代码来计算传入的连个时间的时间差,可以在运行的时候却出现上面那个问题,百度了一下,在进行时间转换的时候,字符串的长度要一 一对应,也就是说和这个“yyyy-MM-dd“要长度一致,比如2013-1-1要转换成时间的话需要写成”2013-01-01“;然后就可以转换成功了!
上一篇: matplotlib之条形图
下一篇: Spring Data Jpa的详细介绍
推荐阅读
-
解决:java.sql.SQLException:Value ‘0000-00-00‘ can not be represented as java.sql.Date
-
java.sql.SQLException: Value ‘0000-00-00 00:00:00‘ can not be represented as java.sql.Timestamp异常
-
FAQ(60):java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
-
java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Tim 异常解决办法
-
FAQ(64):java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
-
java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date(已解决)
-
java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp at
-
java.sql.SQLException: Value ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp
-
java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
-
java.sql.SQLException: Value ‘0000-00-00 00:00:00‘ can not be represented as java.sql.Timestamp异常