将日期格式化成YYYY年M月的格式

最新推荐文章于 2024-12-03 11:21:04 发布

w459110

最新推荐文章于 2024-12-03 11:21:04 发布

阅读量689

点赞数

CC 4.0 BY-SA版权

分类专栏：我的错误文章标签： Java Apache Servlet JSP J#

本文链接：https://blog.youkuaiyun.com/w459110/article/details/83841880

我的错误专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一个HTTP状态码500内部服务器错误的具体情况，详细分析了Apache Tomcat环境下JSP页面出现的日期格式化异常问题及其根本原因。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Cannot format given Object as a Date
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.IllegalArgumentException: Cannot format given Object as a Date
 java.text.DateFormat.format(Unknown Source)
 java.text.Format.format(Unknown Source)
 com.lyang.governmentbill.CCI.jsp.Bean.ReportManagerBean.reportManagerBean(ReportManagerBean.java:115)
 org.apache.jsp.reportList_jsp._jspService(reportList_jsp.java:141)
 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.


--------------------------------------------------------------------------------

代码如下：


try {
				while (rs.next()) {
					row = sheet.createRow(i + 1);
					 i++;
					for (int j = 1; j <= columns.length; j++) {
						cell = row.createCell((short) (j-1));
						cell.setEncoding((short) 1);
						boolean dataFlag=false;
						for(int k = 0;k<dealColumns.length;k++){
							if(dealColumns[k].equals(String.valueOf(j-1))){
								dataFlag=true;
								style1.setDataFormat((short)4);
							}
						}
						if(dataFlag){
							cell.setCellValue(rs.getDouble(j));
							cell.setCellStyle(style1);
						}else{
							if(j==7){
								SimpleDateFormat sdf = new SimpleDateFormat("yyyy年M月");
								String strDate =sdf.format(DateFormat.getDateInstance().parse(rs.getString(7)));
							cell.setCellValue(strDate);
							}else{
							cell.setCellValue(rs.getString(j));
							String date=rs.getString(7);
							cell.setCellStyle(style);
							}
						}

					}
				}
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		finally{
			try {
				rs.close();
				stat.close();
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}