Question

我在更新数据库的一个日期方面遇到困难。亚洲开发银行的外地类型是日期/时间。

现在,我正试图更新“R_Date”的实地名称。

Currently, I am using the SQL Expression in my jsp" UPDATE request SET request_date = "+Request_Date+" "; , But it is not accepting.

在选择发言中,我使用正常选择,试图用_或date,但不接受“DD-MMM-YYYY”格式。

因此,请你帮助我重新定位/更新/更新实地,以“DD-MMM-YYYYY”为形式。

Answer 1

通常的做法是在亚洲开发银行储存一个时间序列(原文,<代码>javautil)。日期: in Javaside and java.sql.timestamp in JDBCside is to use PreparedStatement#timestamp(。

Date requestDate = getItSomehow();
Timestamp timestamp = new Timestamp(requestDate.getTime());
preparedStatement = connection.prepareStatement("UPDATE request SET request_date = ?");
preparedStatement.setTimestamp(1, timestamp);

从亚洲开发银行获得一个时间序列的通常做法是使用 ResultSet#gettimestamp()<>>>>>>>。

Timestamp timestamp = resultSet.getTimestamp("request_date");
Date requestDate = timestamp; // You can just upcast.

在<代码>java.util.Date 和java.lang.String之间转换,通常使用 >>>> 编码:SimpleDateFormat ::

// Convert from String to Date.
String requestDateAsString = "09-Aug-2010";
SimpleDateFormat sdf = new SimpleDateFormat("dd-MMM-yyyy", Locale.ENGLISH);
Date requestDate = sdf.parse(requestDateAsString);

// Convert from Date to String.
String anotherDateAsString = sdf.format(someDate);

    MM  Numeric month (e.g., 07)
    MON Abbreviated month name (e.g., JUL)
    MONTH   Full month name (e.g., JULY)
    DD  Day of month (e.g., 24)
    DY  Abbreviated name of day (e.g., FRI)
    YYYY    4-digit year (e.g., 1998)
    YY  Last 2 digits of the year (e.g., 98)
    RR  Like YY, but the two digits are ``rounded   to a year in the range 1950 to 2049. Thus, 06 is considered 2006 instead of 1906
    AM (or PM)  Meridian indicator
    HH  Hour of day (1-12)
    HH24    Hour of day (0-23)
    MI  Minute (0-59)
    SS  Second (0-59)

See also:

友情链接