关于servlet获取页面时间控件值的有关问题,获取后总提示格式转换异常
关于servlet获取页面时间控件值的问题,获取后总提示格式转换错误
我想获得控件值后,将二个时间段的值传到数据库查询,我用试着用SIMPLEDATAFORMAT转换,可还是不行
这是取值的servlet
response.setCharacterEncoding("gbk");
response.setContentType("text/html");
String starttime=request.getParameter("starttime");
String endtime=request.getParameter("endtime");
SimpleDateFormat format=new SimpleDateFormat("");
OperatorQuery query=new OperatorQuery();
List list=query.queryFeeList(starttime, endtime);
HttpSession session=request.getSession();
session.setAttribute("list", list);
// request.getRequestDispatcher("/projectdataquery/luhag.jsp").forward(request, response);
response.sendRedirect("/projectdataquery/luhag.jsp");
这是页面对应的html
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<!--
<link rel="stylesheet" type="text/css" href="styles.css"> -->
<script language="javascript" type="text/javascript" src="My97DatePicker/WdatePicker.js">
</script>
</head>
<body>
<form name="frmfee" action="./servlet/QueryServlet" method="post">
<table width="773" border="0" height="308" align="center">
<!--DWLayoutTable-->
<tr>
<td width="773" height="36" align="center" valign="center">增值服务收费统计系统</td>
</tr>
<tr><td><hr/></td></tr>
<tr>
<td height="28" valign="center">查看项目:
<select name="select">
<option selected>生肖姻缘</option>
<option>星座姻缘</option>
<option>血型姻缘</option>
</select></td>
</tr>
<tr>
<td>查询日期:<input class="Wdate" type="text" name="starttime" id="d15" onFocus="WdatePicker({isShowClear:false,readOnly:true})"/>到<input class="Wdate" type="text" name="endtime" id="d15" onFocus="WdatePicker({isShowClear:false,readOnly:true})"/></td>
</tr>
<tr>
<td height="180"><input type="submit" name="submit" value="提交"/></td>
</tr>
</table>
</form>
</body>
</html>
这是报的错误提示
2008-05-29 13:01:43 StandardWrapperValve[QueryServlet]: Servlet.service() for servlet QueryServlet threw exception
java.lang.IllegalArgumentException: Cannot format given Object as a Date
at java.text.DateFormat.format(DateFormat.java:281)
at java.text.Format.format(Format.java:140)
at iwit.sp.servlet.OperatorQuery.queryFeeList(OperatorQuery.java:69)
at iwit.sp.servlet.QueryServlet.doGet(QueryServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
我想获得控件值后,将二个时间段的值传到数据库查询,我用试着用SIMPLEDATAFORMAT转换,可还是不行
这是取值的servlet
response.setCharacterEncoding("gbk");
response.setContentType("text/html");
String starttime=request.getParameter("starttime");
String endtime=request.getParameter("endtime");
SimpleDateFormat format=new SimpleDateFormat("");
OperatorQuery query=new OperatorQuery();
List list=query.queryFeeList(starttime, endtime);
HttpSession session=request.getSession();
session.setAttribute("list", list);
// request.getRequestDispatcher("/projectdataquery/luhag.jsp").forward(request, response);
response.sendRedirect("/projectdataquery/luhag.jsp");
这是页面对应的html
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<!--
<link rel="stylesheet" type="text/css" href="styles.css"> -->
<script language="javascript" type="text/javascript" src="My97DatePicker/WdatePicker.js">
</script>
</head>
<body>
<form name="frmfee" action="./servlet/QueryServlet" method="post">
<table width="773" border="0" height="308" align="center">
<!--DWLayoutTable-->
<tr>
<td width="773" height="36" align="center" valign="center">增值服务收费统计系统</td>
</tr>
<tr><td><hr/></td></tr>
<tr>
<td height="28" valign="center">查看项目:
<select name="select">
<option selected>生肖姻缘</option>
<option>星座姻缘</option>
<option>血型姻缘</option>
</select></td>
</tr>
<tr>
<td>查询日期:<input class="Wdate" type="text" name="starttime" id="d15" onFocus="WdatePicker({isShowClear:false,readOnly:true})"/>到<input class="Wdate" type="text" name="endtime" id="d15" onFocus="WdatePicker({isShowClear:false,readOnly:true})"/></td>
</tr>
<tr>
<td height="180"><input type="submit" name="submit" value="提交"/></td>
</tr>
</table>
</form>
</body>
</html>
这是报的错误提示
2008-05-29 13:01:43 StandardWrapperValve[QueryServlet]: Servlet.service() for servlet QueryServlet threw exception
java.lang.IllegalArgumentException: Cannot format given Object as a Date
at java.text.DateFormat.format(DateFormat.java:281)
at java.text.Format.format(Format.java:140)
at iwit.sp.servlet.OperatorQuery.queryFeeList(OperatorQuery.java:69)
at iwit.sp.servlet.QueryServlet.doGet(QueryServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)