573503.xml

论坛精华帖子

<?xml version='1.0' encoding='GB2312'?>
<?xml:stylesheet type='text/xsl' href='../csdn.xsl'?>
<Topic>
<Issue>
<PostUserNickName>不贪</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>110</credit>
<TopicId>573503</TopicId>
<TopicName>如何按我需要的格式显示从数据库中抓出的时间</TopicName>
<PostUserId>196519</PostUserId>
<PostUserName>liangxuan1979</PostUserName>
<RoomName>JSP</RoomName>
<ReplyNum>8</ReplyNum>
<PostDateTime>2002-3-13 15:47:53</PostDateTime>
<Point>30</Point>
<ReadNum>0</ReadNum>
<RoomId>28</RoomId>
<EndState>2</EndState>
<Content>我在SQL&#32;SERVER数据库里设置一个Smalldatetime的“ComeDate”时间字段。在数据库中只有年月日。
但我在JSP页面中要显示此时间字段，如果以&lt;%=_rs("ComeDate")%&gt;的形式来显示，则会象下面这样：“2002-03-10&#32;00:00:00&#32;”，可是我不想要后面的“00:00:00&#32;”，只想显示年月日。我不知怎么在页面来做，请各位大虾帮忙！最好有代码！</Content>
</Issue>
<Replys>
<Reply>
<PostUserNickName>我无知,所以我有智慧.</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>103</credit>
<ReplyID>3814937</ReplyID>
<TopicID>573503</TopicID>
<PostUserId>10806</PostUserId>
<PostUserName>gzwrj</PostUserName>
<Point>2</Point>
<Content>public&#32;static&#32;String&#32;GetDateStr(java.sql.Timestamp&#32;rDate,&#32;String&#32;rDateFormat)&#32;{
&#32;&#32;&#32;&#32;&#32;&#32;&#32;&#32;SimpleDateFormat&#32;lFormat;
&#32;&#32;&#32;&#32;&#32;&#32;&#32;&#32;String&#32;lRtnStr&#32;=&#32;"";

&#32;&#32;&#32;&#32;&#32;&#32;&#32;&#32;lFormat&#32;=&#32;&#32;new&#32;SimpleDateFormat(rDateFormat);
&#32;&#32;&#32;&#32;&#32;&#32;&#32;&#32;lRtnStr&#32;=&#32;lFormat.format(rDate);
&#32;
&#32;&#32;&#32;&#32;&#32;&#32;&#32;&#32;return&#32;lRtnStr;
&#32;&#32;&#32;&#32;}</Content>
<PostDateTime>2002-3-13 16:25:28</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>zz</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>105</credit>
<ReplyID>3815509</ReplyID>
<TopicID>573503</TopicID>
<PostUserId>107094</PostUserId>
<PostUserName>zhu_liping</PostUserName>
<Point>0</Point>
<Content>SimpleDateFormat&#32;fmt&#32;=new&#32;SimpleDateFormat("yyyy-MM-dd&#32;hh24:mi",Locale.US);
out.print(fmt.format(rq));
你试试吧，成功了，别忘记给我分就行！
</Content>
<PostDateTime>2002-3-13 16:54:27</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>zz</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>105</credit>
<ReplyID>3815640</ReplyID>
<TopicID>573503</TopicID>
<PostUserId>107094</PostUserId>
<PostUserName>zhu_liping</PostUserName>
<Point>0</Point>
<Content>yyyy-MM-dd&#32;hh24:mi可以修改的
如:yyyy-MM-dd</Content>
<PostDateTime>2002-3-13 16:59:55</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>不贪</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>110</credit>
<ReplyID>3816449</ReplyID>
<TopicID>573503</TopicID>
<PostUserId>196519</PostUserId>
<PostUserName>liangxuan1979</PostUserName>
<Point>0</Point>
<Content>我数据库里NBDate的值是“2002-03-10”，但没有格式化时页面上显示“2002-03-10&#32;00:00:00&#32;”：
我安各位大虾的建议修改的程序是：
&lt;%@&#32;page&#32;contentType="text/html;charset=gb2312"%&gt;
&lt;%@&#32;page&#32;import="java.sql.*"%&gt;
&lt;%@&#32;page&#32;import="java.text.*"%&gt;
&lt;%
SimpleDateFormat&#32;fmt=new&#32;SimpleDateFormat("yyyy-.MM-dd");

String&#32;_driver="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(_driver).newInstance();
String&#32;_connectionURL="jdbc:odbc:FoxconnBar";
Connection&#32;_con=null;
_con=DriverManager.getConnection(_connectionURL);
Statement&#32;_stmt=null;
_stmt=_con.createStatement();

String&#32;_sqlstring="select&#32;*&#32;from&#32;NewsBoard&#32;order&#32;by&#32;NBDate&#32;Desc"&#32;;
ResultSet&#32;_rs=null;
_rs=_stmt.executeQuery(_sqlstring);
while(_rs.next()){
out.print(fmt.format(_rs.getString("NBDate")));
}
_rs.close();
_stmt.close();
_con.close();%&gt;
但出错了,出错为：
“
java.lang.IllegalArgumentException:&#32;Cannot&#32;format&#32;given&#32;Object&#32;as&#32;a&#32;Date
&#9;at&#32;java.text.DateFormat.format(DateFormat.java:279)
&#9;at&#32;java.text.Format.format(Format.java:133)
&#9;at&#32;org.apache.jsp.test$jsp._jspService(test$jsp.java:84)”

</Content>
<PostDateTime>2002-3-13 17:37:43</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>蓝鸟</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<ReplyID>3822709</ReplyID>
<TopicID>573503</TopicID>
<PostUserId>207417</PostUserId>
<PostUserName>lbluekey</PostUserName>
<Point>2</Point>
<Content>其实Format不过是塑sun写的一个功能类！
你可以写个函数实现呀！

public&#32;String&#32;getMyDate(Date&#32;date)
{
&#32;&#32;&#32;reutrn&#32;date.getYear()+"年"+(date.getMonth+1)+"月"；
}
是不是很简单亚</Content>
<PostDateTime>2002-3-14 10:29:18</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>不贪</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>110</credit>
<ReplyID>3823297</ReplyID>
<TopicID>573503</TopicID>
<PostUserId>196519</PostUserId>
<PostUserName>liangxuan1979</PostUserName>
<Point>0</Point>
<Content>我来试试！多谢各位！</Content>
<PostDateTime>2002-3-14 10:54:31</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>zz</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>105</credit>
<ReplyID>3823785</ReplyID>
<TopicID>573503</TopicID>
<PostUserId>107094</PostUserId>
<PostUserName>zhu_liping</PostUserName>
<Point>26</Point>
<Content>out.print(fmt.format(_rs.getString("NBDate")));&#32;
应该是
java.util.Date&#32;&#32;&#32;NBDate=_rs.getTimestamp("NBDate");
out.print(fmt.format(NBDate));
</Content>
<PostDateTime>2002-3-14 11:13:34</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>不贪</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>110</credit>
<ReplyID>3824338</ReplyID>
<TopicID>573503</TopicID>
<PostUserId>196519</PostUserId>
<PostUserName>liangxuan1979</PostUserName>
<Point>0</Point>
<Content>zhu_liping
非常谢谢你！
还谢谢gzwrj(redwing)，lbluekey(蓝鸟)&#32;两位朋友！</Content>
<PostDateTime>2002-3-14 11:35:44</PostDateTime>
</Reply>
</Replys>
</Topic>