取得服务器日期时间?

DataBase:
String str = "select sysdate from dual"
ResultSet rs = stmt.executeQuery(str);
if(rs.next())
java.util.Date date = rs.getDate(1);

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

日期可参考tomcat下的例子：date.jsp<html>
<%@ page session="false"%><body bgcolor="white">
<jsp:useBean id='clock' scope='page' class='dates.JspCalendar' type="dates.JspCalendar" /><font size=4>
<ul>
<li> Day of month: is  <jsp:getProperty name="clock" property="dayOfMonth"/>
<li> Year: is  <jsp:getProperty name="clock" property="year"/>
<li> Month: is  <jsp:getProperty name="clock" property="month"/>
<li> Time: is  <jsp:getProperty name="clock" property="time"/>
<li> Date: is  <jsp:getProperty name="clock" property="date"/>
<li> Day: is  <jsp:getProperty name="clock" property="day"/>
<li> Day Of Year: is  <jsp:getProperty name="clock" property="dayOfYear"/>
<li> Week Of Year: is  <jsp:getProperty name="clock" property="weekOfYear"/>
<li> era: is  <jsp:getProperty name="clock" property="era"/>
<li> DST Offset: is  <jsp:getProperty name="clock" property="DSTOffset"/>
<li> Zone Offset: is  <jsp:getProperty name="clock" property="zoneOffset"/>
</ul>
</font></body>
</html>
bean如下：JspCalendar.java
package dates;import java.text.DateFormat;
import java.util.*;public class JspCalendar {
    Calendar  calendar = null;    public JspCalendar() {
calendar = Calendar.getInstance();
Date trialTime = new Date();
calendar.setTime(trialTime);
    }    public int getYear() {
return calendar.get(Calendar.YEAR);
    }

    public String getMonth() {
int m = getMonthInt();
String[] months = new String [] { "January", "February", "March",
"April", "May", "June",
"July", "August", "September",
"October", "November", "December" };
if (m > 12)
    return "Unknown to Man";

return months[m - 1];    }    public String getDay() {
int x = getDayOfWeek();
String[] days = new String[] {"Sunday", "Monday", "Tuesday", "Wednesday",
      "Thursday", "Friday", "Saturday"}; if (x > 7)
    return "Unknown to Man"; return days[x - 1];    }

    public int getMonthInt() {
return 1 + calendar.get(Calendar.MONTH);
    }    public String getDate() {
return getMonthInt() + "/" + getDayOfMonth() + "/" +  getYear();    }    public String getTime() {
return getHour() + ":" + getMinute() + ":" + getSecond();
    }    public int getDayOfMonth() {
return calendar.get(Calendar.DAY_OF_MONTH);
    }    public int getDayOfYear() {
return calendar.get(Calendar.DAY_OF_YEAR);
    }    public int getWeekOfYear() {
return calendar.get(Calendar.WEEK_OF_YEAR);
    }    public int getWeekOfMonth() {
return calendar.get(Calendar.WEEK_OF_MONTH);
    }    public int getDayOfWeek() {
return calendar.get(Calendar.DAY_OF_WEEK);
    }

    public int getHour() {
return calendar.get(Calendar.HOUR_OF_DAY);
    }

    public int getMinute() {
return calendar.get(Calendar.MINUTE);
    }
    public int getSecond() {
return calendar.get(Calendar.SECOND);
    }    public static void main(String args[]) {
JspCalendar db = new JspCalendar();
p("date: " + db.getDayOfMonth());
p("year: " + db.getYear());
p("month: " + db.getMonth());
p("time: " + db.getTime());
p("date: " + db.getDate());
p("Day: " + db.getDay());
p("DayOfYear: " + db.getDayOfYear());
p("WeekOfYear: " + db.getWeekOfYear());
p("era: " + db.getEra());
p("ampm: " + db.getAMPM());
p("DST: " + db.getDSTOffset());
p("ZONE Offset: " + db.getZoneOffset());
p("TIMEZONE: " + db.getUSTimeZone());
    }    private static void p(String x) {
System.out.println(x);
    }
    public int getEra() {
return calendar.get(Calendar.ERA);
    }    public String getUSTimeZone() {
String[] zones = new String[] {"Hawaii", "Alaskan", "Pacific",
       "Mountain", "Central", "Eastern"};

return zones[10 + getZoneOffset()];
    }    public int getZoneOffset() {
return calendar.get(Calendar.ZONE_OFFSET)/(60*60*1000);
    }
    public int getDSTOffset() {
return calendar.get(Calendar.DST_OFFSET)/(60*60*1000);
    }
    public int getAMPM() {
return calendar.get(Calendar.AM_PM);
    }
}
Web Server:
java.util.Date date = new java.util.Date();
System.out.println(date);
1，你的jsp就是运行在服务器上的，你取时间就是服务器的，
2，mysql你可以用getdate()
3,客户端你可以用js脚本。
1、取得服务器时间(JSP)
DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
String SBRQ=sdf.format(new Date());
2、取得客户端时间(JS)
var d=new Date();
d.getYear()+'-'+(d.getMonth()+1)+'-'+d.getDate();
3、不至于吧
...
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeUpdate();
...
Client: use javascript:
<script>
var oneDate = new Date(yy,mm,dd,hh,mm,ss);
alert(oneDate);
</script>