/*
 * Copyright 2004-2010 the Seasar Foundation and the Others.
 *
 * 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.
 */
package org.seasar.doma.jdbc.type;

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.sql.Types;
import java.text.SimpleDateFormat;
import java.util.Date;

/**
 * {@link Date} 用の {@link JdbcType} の実装です。
 * 
 * @author taedium
 * @since 1.9.0
 */
public class UtilDateType extends AbstractJdbcType<Date> {

    public UtilDateType() {
        super(Types.TIMESTAMP);
    }

    @Override
    public Date doGetValue(ResultSet resultSet, int index) throws SQLException {
        Timestamp timestamp = resultSet.getTimestamp(index);
        if (timestamp == null) {
            return null;
        }
        return new Date(timestamp.getTime());
    }

    @Override
    protected void doSetValue(PreparedStatement preparedStatement, int index,
            Date value) throws SQLException {
        preparedStatement.setTimestamp(index, new Timestamp(value.getTime()));
    }

    @Override
    protected Date doGetValue(CallableStatement callableStatement, int index)
            throws SQLException {
        Timestamp timestamp = callableStatement.getTimestamp(index);
        if (timestamp == null) {
            return null;
        }
        return new Date(timestamp.getTime());
    }

    @Override
    protected String doConvertToLogFormat(Date value) {
        SimpleDateFormat dateFormat = new SimpleDateFormat(
                "yyyy-MM-dd HH:mm:ss.SSS");
        return "'" + dateFormat.format(value) + "'";
    }

}
