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

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 或者是其它的。