Java SQL Time Format formatDefaultValue(Object o)

Description

Converts the object into a DEFAULT clause value.

License

Apache License

Parameter

Parameter	Description
o	the default object

Return

the value formatted for a DEFAULT clause

Declaration

static String formatDefaultValue(Object o) 

Method Source Code

//package com.java2s;
/*//w w  w .  ja  va  2 s  .c om
 * Copyright 2004-2011 H2 Group.
 * Copyright 2011 James Moger.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

import java.text.MessageFormat;
import java.text.SimpleDateFormat;

import java.util.Date;

public class Main {
    /**
     * Converts the object into a DEFAULT clause value.
     * 
     * @param o
     *            the default object
     * @return the value formatted for a DEFAULT clause
     */
    static String formatDefaultValue(Object o) {
        Class<?> objectClass = o.getClass();
        String value = null;
        if (Number.class.isAssignableFrom(objectClass)) {
            // NUMBER
            return ((Number) o).toString();
        } else if (Boolean.class.isAssignableFrom(objectClass)) {
            // BOOLEAN
            return o.toString();
        } else if (java.sql.Date.class.isAssignableFrom(objectClass)) {
            // DATE
            value = new SimpleDateFormat("yyyy-MM-dd").format((Date) o);
        } else if (java.sql.Time.class.isAssignableFrom(objectClass)) {
            // TIME
            value = new SimpleDateFormat("HH:mm:ss").format((Date) o);
        } else if (Date.class.isAssignableFrom(objectClass)) {
            // DATETIME
            value = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format((Date) o);
        } else if (String.class.isAssignableFrom(objectClass)) {
            // STRING
            value = o.toString();
        }
        if (value == null) {
            return "''";
        }
        return MessageFormat.format("''{0}''", value);
    }
}

Related

1. formatCharDateYMDHMS(String str)
2. formatDate(String Format)
3. formatDateWithSlashes(java.sql.Date date)
4. formatDateYM(Date date, String datePtn)
5. formatDateYMD(String str, String datePtn)
6. formatExceptionForToolsWithLimitedCharacterSet(String exceptionLabel)
7. formatTime(Date date)
8. formatTime(final Time time)
9. formatTime(Time time, String format)