JAvaデータベースへの具体的な時間の追加
1153 ワード
Oracle------dataタイプ
Mysql------Timestampタイプ
Date date=
new
Date();
//
SimpleDateFormat tempDate =
new
SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss"
);
String datetime = tempDate.format(date);
//
setDate(
new
java.sql.Date.valueOf(datetime ));
// Date 。
Mysql------Timestampタイプ
public static Timestamp dateTimeString2Date(String date_str) {
try {
Calendar cal = Calendar.getInstance();//
java.sql.Timestamp timestampnow = new java.sql.Timestamp(cal.getTimeInMillis());//
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
ParsePosition pos = new ParsePosition(0);
java.util.Date current = formatter.parse(date_str, pos);
timestampnow = new java.sql.Timestamp(current.getTime());
return timestampnow;
}
catch (NullPointerException e) {
return null;
}
}