Example usage for java.sql Timestamp getMonth

List of usage examples for java.sql Timestamp getMonth

Introduction

In this page you can find the example usage for java.sql Timestamp getMonth.

Prototype

@Deprecated
public int getMonth() 

Source Link

Document

Returns a number representing the month that contains or begins with the instant in time represented by this Date object.

Usage

From source file:com.google.visualization.datasource.util.SqlDataSourceHelper.java

/**
 * Creates a table cell from the value in the current row of the given result
 * set and the given column index. The type of the value is determined by the
 * given value type./*  www.j  av a 2  s  .c om*/
 *
 * @param rs The result set holding the data from the sql table. The result
 *     points to the current row.
 * @param valueType The value type of the column that the cell belongs to.
 * @param column The column index. Indexes are 0-based.
 *
 * @return The table cell.
 *
 * @throws SQLException Thrown when the connection to the database failed.
 */
private static TableCell buildTableCell(ResultSet rs, ValueType valueType, int column) throws SQLException {
    Value value = null;

    // SQL indexes are 1- based.
    column = column + 1;

    switch (valueType) {
    case BOOLEAN:
        value = BooleanValue.getInstance(rs.getBoolean(column));
        break;
    case NUMBER:
        value = new NumberValue(rs.getDouble(column));
        break;
    case DATE:
        Date date = rs.getDate(column);
        // If date is null it is handled later.
        if (date != null) {
            GregorianCalendar gc = new GregorianCalendar(TimeZone.getTimeZone("GMT"));
            // Set the year, month and date in the gregorian calendar.
            // Use the 'set' method with those parameters, and not the 'setTime'
            // method with the date parameter, since the Date object contains the
            // current time zone and it's impossible to change it to 'GMT'.
            gc.set(date.getYear() + 1900, date.getMonth(), date.getDate());
            value = new DateValue(gc);
        }
        break;
    case DATETIME:
        Timestamp timestamp = rs.getTimestamp(column);
        // If timestamp is null it is handled later.
        if (timestamp != null) {
            GregorianCalendar gc = new GregorianCalendar(TimeZone.getTimeZone("GMT"));
            // Set the year, month, date, hours, minutes and seconds in the
            // gregorian calendar. Use the 'set' method with those parameters,
            // and not the 'setTime' method with the timestamp parameter, since
            // the Timestamp object contains the current time zone and it's
            // impossible to change it to 'GMT'.
            gc.set(timestamp.getYear() + 1900, timestamp.getMonth(), timestamp.getDate(), timestamp.getHours(),
                    timestamp.getMinutes(), timestamp.getSeconds());
            // Set the milliseconds explicitly, as they are not saved in the
            // underlying date.
            gc.set(Calendar.MILLISECOND, timestamp.getNanos() / 1000000);
            value = new DateTimeValue(gc);
        }
        break;
    case TIMEOFDAY:
        Time time = rs.getTime(column);
        // If time is null it is handled later.
        if (time != null) {
            GregorianCalendar gc = new GregorianCalendar(TimeZone.getTimeZone("GMT"));
            // Set the hours, minutes and seconds of the time in the gregorian
            // calendar. Set the year, month and date to be January 1 1970 like
            // in the Time object.
            // Use the 'set' method with those parameters,
            // and not the 'setTime' method with the time parameter, since
            // the Time object contains the current time zone and it's
            // impossible to change it to 'GMT'.
            gc.set(1970, Calendar.JANUARY, 1, time.getHours(), time.getMinutes(), time.getSeconds());
            // Set the milliseconds explicitly, otherwise the milliseconds from
            // the time the gc was initialized are used.
            gc.set(GregorianCalendar.MILLISECOND, 0);
            value = new TimeOfDayValue(gc);
        }
        break;
    default:
        String colValue = rs.getString(column);
        if (colValue == null) {
            value = TextValue.getNullValue();
        } else {
            value = new TextValue(rs.getString(column));
        }
        break;
    }
    // Handle null values.
    if (rs.wasNull()) {
        return new TableCell(Value.getNullValueFromValueType(valueType));
    } else {
        return new TableCell(value);
    }
}

From source file:business.security.control.OwmClient.java

@Schedule(second = "0", minute = "0", hour = "*", persistent = false)
public void checkWeather() {

    System.out.println("Inizio check");

    List<Place> listPlaceInDb;
    List<Forecast> listForecastInDb = new ArrayList<Forecast>();

    listPlaceInDb = placeManager.getAllPlaces();

    List<Forecast> tmp = new ArrayList<Forecast>();

    for (Place p : listPlaceInDb) {
        tmp = forecastManager.getForecastInPlace(p);
        for (Forecast f : tmp) {
            listForecastInDb.add(f);//from  w  w w.  j av  a  2s  .c o m
        }
    }

    //Adesso ho nella mia lista tutti i forecast del mio db
    //Devo pulire quelli con la data vecchia
    Timestamp now = new Timestamp(new java.util.Date().getTime());

    for (Forecast f : listForecastInDb) {
        if ((f.getDate().getYear() < now.getYear()) || (f.getDate().getMonth() < now.getMonth())
                || (f.getDate().getDate() < now.getDate())) {
            System.out
                    .println("Sto rimuovendo il forecast: " + f.getPlace().getCity() + " " + f.getDate() + now);
            entityManager.remove(entityManager.find(Forecast.class, f.getId()));
        }
    }

    listForecastInDb = new ArrayList<Forecast>();

    for (Place p : listPlaceInDb) {
        for (Forecast f : forecastManager.getForecastInPlace(p)) {
            listForecastInDb.add(f);
        }
    }

    //Qui nel mio database dovrei avere solo forecast aggiornati
    for (Place p : listPlaceInDb) {
        try {
            WeatherForecastResponse risposta;
            risposta = this.tenForecastWeatherAtCity(p.getCity());
            List<ForecastWeatherData> list = risposta.getForecasts();
            for (ForecastWeatherData fwd : list) {
                if (!alreadyIn(fwd, p.getCity())) {
                    Timestamp t = new Timestamp(fwd.getCalcDateTime());
                    System.out.println("Sto aggiungendo/aggiornando il forecast : " + p.getCity() + " " + t);
                    Forecast f = new Forecast();
                    //Recupero nel database la main condition associata
                    MainCondition mc = new MainCondition();
                    mc.setCondition(fwd.getWeatherConditions().get(0).getMain());
                    entityManager.merge(mc);

                    //Ho preparato tutti i parametri necessari
                    f.setPlace(p);
                    f.setMainCondition(mc);
                    f.setDate(new Timestamp(fwd.getCalcDateTime()));

                    entityManager.persist(f);
                }

            }
        } catch (JSONException ex) {
            Logger.getLogger(EventBean.class.getName()).log(Level.WARNING, null,
                    "Too much requests to the ForecastServer");
        } catch (IOException ex) {
            Logger.getLogger(EventBean.class.getName()).log(Level.SEVERE, null, ex);
        }

    }
    System.out.println("Check Weather Completed!");

}

From source file:business.security.control.OwmClient.java

private boolean alreadyIn(ForecastWeatherData fwd, String city) {

    ArrayList<Forecast> listForecastInDb = new ArrayList<Forecast>();
    Iterable<Place> listPlaceInDb;

    Timestamp date = new Timestamp(fwd.getCalcDateTime());

    listPlaceInDb = placeManager.getAllPlaces();

    for (Place p : listPlaceInDb) {

        for (Forecast f : forecastManager.getForecastInPlace(p)) {
            listForecastInDb.add(f);//from   ww w .  ja  v  a  2  s  . co  m
        }
    }

    for (Forecast f : listForecastInDb) {
        if (f.getPlace().getCity().equals(city) && f.getDate().getYear() == date.getYear()
                && f.getDate().getMonth() == date.getMonth() && f.getDate().getDate() == date.getDate()) {
            if (!(f.getMainCondition().getCondition().equals(fwd.getWeatherConditions().get(0).getMain()))) {
                entityManager.remove(entityManager.find(Forecast.class, f.getId()));
                return false;
            }

            return true;
        }
    }

    return false;

}

From source file:org.apache.openjpa.persistence.kernel.TestProxies2.java

public void testTimestamp() {
    OpenJPAEntityManager pm = getPM(true, true);
    startTx(pm);/*w  ww .j a va  2 s.  c om*/
    ProxiesPC pc = pm.find(ProxiesPC.class, _oid);
    java.sql.Timestamp tstamp = pc.getTimestamp();
    assertNotNull(tstamp);

    // dates can lose precision, but make sure same day
    assertEquals(_timestamp.getYear(), tstamp.getYear());
    assertEquals(_timestamp.getMonth(), tstamp.getMonth());
    assertEquals(_timestamp.getDate(), tstamp.getDate());

    // make sure proxied
    assertTrue(!pm.isDirty(pc));
    tstamp.setNanos(100);
    assertTrue(pm.isDirty(pc));

    endTx(pm);
    assertEquals(tstamp, pc.getTimestamp());
    endEm(pm);
}