字串轉換成Timestamp格式
package yku;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
public class DateUtils {
private static SimpleDateFormat datetimeformat = new SimpleDateFormat(
"yyyy/MM/dd HH:mm:ss");
private static SimpleDateFormat dateformat = new SimpleDateFormat(
"yyyy/MM/dd");
public static Timestamp convertDate(String str) {
if (str == null || str.length() == 0)
return null;
try {
return new Timestamp(dateformat.parse(str).getTime());
} catch (Exception e) {
//e.printStackTrace();
}
return null;
}
public static Timestamp convertDateTime(String str) {
if (str == null || str.length() == 0)
return null;
try {
return new Timestamp(datetimeformat.parse(str).getTime());
} catch (Exception e) {
//e.printStackTrace();
}
return null;
}
public static void main(String args[]) {
System.out.println("1."+DateUtils.convertDate("2014/01/01").toString());
System.out.println("2."+(DateUtils.convertDate("2014/0101")==null?"錯誤日期格式":"正確日期格式"));
System.out.println("這裡是分割線---------------------------------------------------");
System.out.println("3."+DateUtils.convertDateTime("2014/01/01 12:33:21").toString());
System.out.println("4."+(DateUtils.convertDate("2014/0101 123321")==null?"錯誤日期時間格式":"正確日期時間格式"));
}
}
Ans:
1.2014-01-01 00:00:00.0 2.錯誤日期格式 這裡是分割線--------------------------------------------------- 3.2014-01-01 12:33:21.0 4.錯誤日期時間格式
日期Date或Timestamp轉換成字串格式
package yku;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.sql.Date;
public class DateUtils {
private static SimpleDateFormat datetimeformat = new SimpleDateFormat(
"yyyy/MM/dd HH:mm:ss");
private static SimpleDateFormat dateformat = new SimpleDateFormat(
"yyyy/MM/dd");
public static String convertDateStr(java.sql.Date str) {
if (str == null)
return null;
try {
return dateformat.format(str);
} catch (Exception e) {
// e.printStackTrace();
}
return null;
}
public static String convertDateTimeStr(java.sql.Date str) {
if (str == null)
return null;
try {
return datetimeformat.format(str);
} catch (Exception e) {
// e.printStackTrace();
}
return null;
}
public static String convertDateStr(Timestamp str) {
if (str == null)
return null;
try {
return dateformat.format(str);
} catch (Exception e) {
// e.printStackTrace();
}
return null;
}
public static String convertDateTimeStr(Timestamp str) {
if (str == null)
return null;
try {
return datetimeformat.format(str);
} catch (Exception e) {
// e.printStackTrace();
}
return null;
}
public static void main(String args[]) {
Calendar cal = Calendar.getInstance();
cal.set(2014, 1, 31,22,33,11);
Date d = new Date(cal.getTimeInMillis());
System.out.println("1."+ DateUtils.convertDateStr(d));
System.out.println("2."+DateUtils.convertDateTimeStr(d));
System.out.println("這裡是分割線---------------------------------------------------");
Timestamp ts = new Timestamp(cal.getTimeInMillis());
System.out.println("3."+ DateUtils.convertDateStr(ts));
System.out.println("4."+ DateUtils.convertDateTimeStr(ts));
}
}
Ans:
1.2014/03/03 2.2014/03/03 22:33:11 這裡是分割線--------------------------------------------------- 3.2014/03/03 4.2014/03/03 22:33:11