jflute <******@****.***> 1437804256 +0900

Shinsuke Sugaya <******@****.***> 1436049991 +0900

     *
     * @param src the source object
     * @param pattern the pattern string
     * @param locale the locale
     * @return the converted {@link java.sql.Date}
     */
    protected static java.sql.Date toSqlDate(final Object src, final String pattern, final Locale locale) {
        if (src == null) {
            return null;
        }
        if (src instanceof java.sql.Date) {

    #  The package of SQL file for outsideSql.
    #  This is basically for narrowing SQL-searching target,
    #  for example, when the project has SQL files for other framework.
    #  So basically you don't need this.
    #
    #  You can use variable '$$PACKAGE_BASE$$' that means 'packageBase'.
    #  But you need to make SQL files at 'exbhv' under the set package

    #   [true]
    #     Table names on SQL executed by condition-bean or behavior
    #     are forcedly treated as upper case. (except outside-SQL)
    #
    #; isTableSqlNameUpperCase = false
    # - - - - - - - - - -/

    # /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    # o isColumnSqlNameUpperCase: (NotRequired - Default false)
    #   [true]
    #     Column names on SQL executed by condition-bean or behavior

    public void testToSqlDate_ShortStyle() throws Exception {
        final java.sql.Date date = toSqlDate("10/9/7");
        assertThat(new SimpleDateFormat("yyyy/MM/dd").format(date), is("2010/09/07"));
    }

    /**
     * @throws Exception
     */
    @Test
    public void testToSqlDate_MediumStyle() throws Exception {
        final java.sql.Date date = toSqlDate("2010/9/7");

     * @throws Exception
     */
    @Test
    public void testGetAsObjectAndGetAsString() throws Exception {
        final SqlDateConverter converter = new SqlDateConverter("yyyy/MM/dd");
        final java.sql.Date result = (java.sql.Date) converter.getAsObject("2008/01/16");
        System.out.println(result);
        assertThat(converter.getAsString(result), is("2008/01/16"));
    }

    /**
     * @throws Exception
     */

    # o isLoggingReplaceSql: (NotRequired - Default true)
    #  Does it show replace-SQL on log?
    #
    #; isLoggingReplaceSql = true
    # - - - - - - - - - -/

    # /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    # o isErrorSqlContinue: (NotRequired - Default false)
    #  Does it continue the task when error SQL exists?
    #
    #; isErrorSqlContinue = false
    # - - - - - - - - - -/

 * governing permissions and limitations under the License.
 */
package org.codelibs.core.sql;

import static org.codelibs.core.misc.AssertionUtil.assertArgumentNotEmpty;
import static org.codelibs.core.misc.AssertionUtil.assertArgumentNotNull;

import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Enumeration;

import org.codelibs.core.exception.SQLRuntimeException;

     */
    @Test
    public void testGetAsObjectAndGetAsString() throws Exception {
        final TimestampConverter converter = new TimestampConverter("yyyy/MM/dd HH:mm:ss");
        final java.sql.Timestamp result = (java.sql.Timestamp) converter.getAsObject("2008/12/31 12:34:56");
        System.out.println(result);
        assertThat(converter.getAsString(result), is("2008/12/31 12:34:56"));
    }

    /**