*
     * @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) {

    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
     */

 * 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"));
    }

    /**

        super("ECL0072", asArray(getSql(cause), getRealMessage(cause), Integer.toString(cause.getErrorCode()), cause.getSQLState()), cause);
    }

    /**
     * Returns the <code>SQL</code>.
     *
     * @param cause the underlying exception
     * @return the <code>SQL</code>
     */
    protected static String getSql(final SQLException cause) {
        if (cause instanceof ClSQLException) {
            return ((ClSQLException) cause).getSql();

 */
package org.codelibs.core.sql;

import static org.codelibs.core.log.Logger.format;
import static org.codelibs.core.misc.AssertionUtil.assertArgumentNotEmpty;
import static org.codelibs.core.misc.AssertionUtil.assertArgumentNotNull;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.codelibs.core.exception.SQLRuntimeException;

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

    /**
     * @throws Exception
     */

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

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

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.codelibs.core.exception.SQLRuntimeException;

/**
 * Utility class for {@link PreparedStatement}.
 *

import org.codelibs.core.beans.Converter;
import org.codelibs.core.convert.DateConversionUtil;
import org.codelibs.core.convert.StringConversionUtil;
import org.codelibs.core.lang.StringUtil;

/**
 * Converter for SQL dates.
 *
 * @author higa
 */
public class SqlDateConverter implements Converter {

    /**
     * The date pattern.
     */
    protected String pattern;

    /**
     * Constructs an instance.