Java SQL Date Get getDate(ResultSet rs, String columnName)

Description

get a java.util.Date object from a result set column with sql type TIMESTAMP and given name

License

Open Source License

Parameter

Parameter	Description
rs	a parameter
columnName	a parameter

Exception

Parameter	Description
SQLException	an exception

Return

the value, which may be null

Declaration

public static Date getDate(ResultSet rs, String columnName) throws SQLException 

Method Source Code

//package com.java2s;
/*//from   w w  w  .  ja  va  2s  . co m
 * Copyright 2010 Research Studios Austria Forschungsgesellschaft mBH
 *
 * This file is part of easyrec.
 *
 * easyrec is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * easyrec is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with easyrec.  If not, see <http://www.gnu.org/licenses/>.
 */

import java.sql.*;

public class Main {
    /**
     * get a java.util.Date object from a result set column with sql type TIMESTAMP and given name
     *
     * @param rs
     * @param columnName
     * @return the value, which may be <code>null</code>
     * @throws SQLException
     */
    public static Date getDate(ResultSet rs, String columnName) throws SQLException {
        Timestamp ts = rs.getTimestamp(columnName);
        if (ts == null) {
            return null;
        }
        return new Date(ts.getTime());
    }
}

Related

1. getDate(ResultSet rs, int columnIndex)
2. getDate(ResultSet rs, int index)
3. getDate(ResultSet rs, String colName)
4. getDate(ResultSet rs, String column)
5. getDate(ResultSet rs, String columnLabel)
6. getDate(String aDate, int dif)
7. getDate(String date)
8. getDate(String date)
9. getDate(String format)