Java SQL Time Create getTimeLong(ResultSet resultSet)

Description

get Time Long

License

Open Source License

Declaration

public static long getTimeLong(ResultSet resultSet) throws SQLException 

Method Source Code

//package com.java2s;
/*-/*from  w  w  w.ja v  a 2 s . com*/
 * #%L
 * Codenjoy - it's a dojo-like platform from developers to developers.
 * %%
 * Copyright (C) 2016 Codenjoy
 * %%
 * This program 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.
 * 
 * This program 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 this program.  If not, see
 * <http://www.gnu.org/licenses/gpl-3.0.html>.
 * #L%
 */

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Time;
import java.text.SimpleDateFormat;

public class Main {
    public static SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSZ");

    public static long getTimeLong(ResultSet resultSet) throws SQLException {
        try {
            // last version format
            String time = resultSet.getString("time");
            return formatter.parse(time).getTime();
        } catch (Exception e) {
            // TODO remove this block
            try {
                // for postgresql
                Time time = resultSet.getTime("time");
                return time.getTime();
            } catch (Exception e2) {
                // for sqlite
                return resultSet.getLong("time");
            }
        }
    }
}

Related

1. getTimeAndDateStamp(String line)
2. getTimeBy(int hour)
3. getTimeFormat()
4. getTimeFromCalendar(final Calendar calendar)
5. getTimeList(ResultSet resultSet, String columnName)
6. getTimeNumberFromSqlTime(Time time)
7. getTimesByStr(String dataStr)
8. getTimeStr(Time time)
9. getTimeZone(String id)