JAVAÊý¾Ý¿âʱ¼ä²éѯ
ʱ¼äΪStringÀàÐ͵Ä
´ó¼Ò°ï°ïСµÜ°É£¡£¡£¡
û¶®lzÒâ˼¡£to_char(date,'yyyy-mm-dd')
Èç¹ûÊý¾Ý¿âÊÇoracleµÄ»°£¬¿ÉÒÔÔËÐÐÒ»ÏÂÏÂÃæÓï¾äµÃµ½Êý¾Ý¿â·þÎñÆ÷µÄʱ¼ä¡£
SQL code:
select to_char(sysdate,'yyyy/MM/dd') from dual
SQL code:
mysql> select curdate();
+------------+
| curdate() |
+------------+
| 2009-12-07 |
+------------+
1 row in set (0.03 sec)
mysql>
ÄǾÍתΪÈÕÆÚÐÍÔٱȽÏ
String »¹²»ºÃ£¬ÔÚÍâÃæÏȸñʽ»¯Ò»°Ñ³ÉString£¬È»ºóÔÙ´«½øÈ¥°¡
СµÜµÄÒâ˼ÊÇÊý¾Ý¿â´«¹ýÀ´µÄÊý¾Ý¶¼ÊÇStringÀàÐ굀 µ«ÊÇJAVAÀïÎÒÒªµÄÊÇintÀàÐ͵Ä,È»ºóʱ¼ä¸ÄΪdate ÀàÐÍ
ʱ¼ä²»Ö»ÓÐÈÕÆÚ »¹ÓÐʱ·ÖÃëÄØ
ºÜÂé·³µÄ Íû´óϺÃǰïæ°¡£¡
public static void main(String[] args) {
String a = "2009-01-01 11:11:11";
try {
SimpleDateFormat dateFm = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); // ¸ñʽ»¯µ±Ç°ÏµÍ³ÈÕÆÚ
Date
Ïà¹ØÎÊ´ð£º
ÎÊÌâÃèÊö£ºÐ´ÈÕÖ¾¹¦ÄÜ£¬Ð´ºÃµÄдÈÕÖ¾·þÎñ£¬ÆäËûÓû§Í¨¹ýhttpµ÷Ó÷þÎñ£¬´«Èë²ÎÊý£¬È»ºó¼Ç¼ÈÕÖ¾£¬
ÎҵķþÎñ¸ÃÔõôд£¬ ±ðÈËÔõôͨ¹ýhttpµ÷ÓÃÎҵķþÎñ£¬ÎÒÓÃwebserviceдºÃÁËÒ»¸ö£¬¿ÉÊDz¢·¢ÓÐÉÏÏߣ¬Ïë¸ÄÓ ......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ÎÊÌâÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öÎļþnagiv.jsp ÁíÒ»¸öÎļþfailure.jsp°üº¬Ëû£¬Í¬Ê±nagivÎļþÖÐÓÐÒ»¸ö¿ÉÒÔÌø×ªµ½yy.jspµÄcommandButton£¬µ«ÊÇÎÒ½«failureÖеã»÷nagivÖеÄÄĸöcommandButton£¬Ò²Ãæ²»»áÌø×ª ......
ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
<part name="bstrPnrNO" type="s:string" />
<part name ......