package frame.persist;
|
|
import java.text.DateFormat;
|
import java.text.SimpleDateFormat;
|
import java.util.Date;
|
|
public class DBDate {
|
|
private static DataBaseType dbType;
|
private Date date;
|
|
static {
|
dbType = DataBaseType.MySQL;
|
}
|
|
public DBDate() {
|
date = new Date();
|
}
|
|
public DBDate(Date date) {
|
this.date = date;
|
}
|
|
public String toSQLString() throws Exception {
|
String result = null;
|
|
DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
|
String value = dateFormat.format(date);
|
|
if (DataBaseType.Oracle == dbType) {
|
result = "to_date('" + value + "','YYYY-MM-DD')";
|
}
|
else if (DataBaseType.SQLServer == dbType) {
|
result = "('" + value + "')";
|
}
|
else if (DataBaseType.MySQL == dbType) {
|
result = "('" + value + "')";
|
}
|
else {
|
throw new Exception("unknown database type");
|
}
|
|
return result;
|
}
|
|
}
|
