Examples with Time java.sql.Time used on opensource projects

Example 1 with Time

use of java.sql.Time in project storm by apache.

the class SimpleJdbcMapper method getColumns.

@Override
public List<Column> getColumns(ITuple tuple) {
    List<Column> columns = new ArrayList<Column>();
    for (Column column : schemaColumns) {
        String columnName = column.getColumnName();
        Integer columnSqlType = column.getSqlType();
        if (Util.getJavaType(columnSqlType).equals(String.class)) {
            String value = tuple.getStringByField(columnName);
            columns.add(new Column(columnName, value, columnSqlType));
        } else if (Util.getJavaType(columnSqlType).equals(Short.class)) {
            Short value = tuple.getShortByField(columnName);
            columns.add(new Column(columnName, value, columnSqlType));
        } else if (Util.getJavaType(columnSqlType).equals(Integer.class)) {
            Integer value = tuple.getIntegerByField(columnName);
            columns.add(new Column(columnName, value, columnSqlType));
        } else if (Util.getJavaType(columnSqlType).equals(Long.class)) {
            Long value = tuple.getLongByField(columnName);
            columns.add(new Column(columnName, value, columnSqlType));
        } else if (Util.getJavaType(columnSqlType).equals(Double.class)) {
            Double value = tuple.getDoubleByField(columnName);
            columns.add(new Column(columnName, value, columnSqlType));
        } else if (Util.getJavaType(columnSqlType).equals(Float.class)) {
            Float value = tuple.getFloatByField(columnName);
            columns.add(new Column(columnName, value, columnSqlType));
        } else if (Util.getJavaType(columnSqlType).equals(Boolean.class)) {
            Boolean value = tuple.getBooleanByField(columnName);
            columns.add(new Column(columnName, value, columnSqlType));
        } else if (Util.getJavaType(columnSqlType).equals(byte[].class)) {
            byte[] value = tuple.getBinaryByField(columnName);
            columns.add(new Column(columnName, value, columnSqlType));
        } else if (Util.getJavaType(columnSqlType).equals(Date.class)) {
            Long value = tuple.getLongByField(columnName);
            columns.add(new Column(columnName, new Date(value), columnSqlType));
        } else if (Util.getJavaType(columnSqlType).equals(Time.class)) {
            Long value = tuple.getLongByField(columnName);
            columns.add(new Column(columnName, new Time(value), columnSqlType));
        } else if (Util.getJavaType(columnSqlType).equals(Timestamp.class)) {
            Long value = tuple.getLongByField(columnName);
            columns.add(new Column(columnName, new Timestamp(value), columnSqlType));
        } else {
            throw new RuntimeException("Unsupported java type in tuple " + Util.getJavaType(columnSqlType));
        }
    }
    return columns;
}

Example 2 with Time

use of java.sql.Time in project sharding-jdbc by dangdangdotcom.

the class PreparedStatementAdapterTest method assertSetTime.

@Test
public void assertSetTime() throws SQLException {
    Time now = new Time(0L);
    actual.setTime(1, now);
    actual.setTime(2, now, Calendar.getInstance());
    assertParameter(actual, 1, now);
    assertParameter(actual, 2, now);
}

Example 3 with Time

use of java.sql.Time in project DataX by alibaba.

the class ColumnCastTest method test_date.

@Test
public void test_date() throws IOException {
    Assert.assertTrue(DateCast.asString(new DateColumn(System.currentTimeMillis())).startsWith("201"));
    Configuration configuration = this.produce();
    configuration.set("common.column.datetimeFormat", "MM/dd/yyyy HH:mm:ss");
    DateCast.init(configuration);
    System.out.println(DateCast.asString(new DateColumn(System.currentTimeMillis())));
    Assert.assertTrue(!DateCast.asString(new DateColumn(System.currentTimeMillis())).startsWith("2014"));
    DateColumn dateColumn = new DateColumn(new Time(0L));
    System.out.println(dateColumn.asString());
    Assert.assertTrue(dateColumn.asString().equals("08:00:00"));
    configuration.set("common.column.timeZone", "GMT");
    DateCast.init(configuration);
    System.err.println(DateCast.asString(dateColumn));
    Assert.assertTrue(dateColumn.asString().equals("00:00:00"));
    configuration.set("common.column.timeZone", "GMT+8");
    DateCast.init(configuration);
    System.out.println(dateColumn.asString());
    Assert.assertTrue(dateColumn.asString().equals("08:00:00"));
    dateColumn = new DateColumn(new Date(0L));
    System.out.println(dateColumn.asString());
    Assert.assertTrue(dateColumn.asString().equals("1970-01-01"));
    dateColumn = new DateColumn(new java.util.Date(0L));
    System.out.println(dateColumn.asString());
    Assert.assertTrue(dateColumn.asString().equals("01/01/1970 08:00:00"));
}

Example 4 with Time

use of java.sql.Time in project druid by alibaba.

the class ResultSetProxyImpl method getTime.

@Override
public Time getTime(int columnIndex, Calendar cal) throws SQLException {
    FilterChainImpl chain = createChain();
    Time value = chain.resultSet_getTime(this, columnIndex, cal);
    recycleFilterChain(chain);
    return value;
}

Example 5 with Time

use of java.sql.Time in project druid by alibaba.

the class ResultSetProxyImpl method getTime.

@Override
public Time getTime(int columnIndex) throws SQLException {
    FilterChainImpl chain = createChain();
    Time value = chain.resultSet_getTime(this, columnIndex);
    recycleFilterChain(chain);
    return value;
}