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();
}
}
原因:SimpleDateFormat 的format方法是:public final java.lang.String format(java.util,Date org0); format方法应该传一个Date类型的参数,而不是String 或者是其它的。