javaEE struts2中日期格式的用法.

//文本框

<s:textfield name="oqcIssueBean.oisDate" theme="simple" size="10" id="id_beginOisDate">
           <s:param name="value">
            <s:date name="oqcIssueBean.oisDate" format="yyyy-MM-dd"/>
           </s:param>
          </s:textfield>

//显示

<td><s:date name="oisDate" format="yyyy-MM-dd"/></td> 

===============查询两个日期之间的数据===============================

SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
  //出货日期 oisDate
  if(oqcIssueBean.getOisDate()!=null && !oqcIssueBean.getOisDate().toString().isEmpty()
  && oqcIssueBean.getEndOisDate()!=null && !oqcIssueBean.getEndOisDate().toString().isEmpty())
  {
   strWhere=strWhere+" AND OI.oisDate BETWEEN to_date('"+sdf.format(oqcIssueBean.getOisDate())+"','yyyy-MM-dd') AND to_date('"+sdf.format(oqcIssueBean.getEndOisDate())+"','yyyy-MM-dd')";
  }
  else if(oqcIssueBean.getOisDate()!=null && !oqcIssueBean.getOisDate().toString().isEmpty())
  {
   strWhere=strWhere+" AND OI.oisDate = to_date('"+sdf.format(oqcIssueBean.getOisDate())+"','yyyy-MM-dd')";
  }

posted @ 2010-03-26 14:26  wj-conquer  阅读(309)  评论(0编辑  收藏  举报