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;
	}
	
}