Search in sources :

Example 16 with Time

use of java.sql.Time in project generator by mybatis.

the class MyTimeTypeHandler method getResult.

public Object getResult(ResultGetter resultGetter) throws SQLException {
    Time time = resultGetter.getTime();
    if (time == null) {
        return null;
    } else {
        MyTime answer = new MyTime();
        Calendar c = Calendar.getInstance();
        c.setTime(time);
        answer.setHours(c.get(Calendar.HOUR_OF_DAY));
        answer.setMinutes(c.get(Calendar.MINUTE));
        answer.setSeconds(c.get(Calendar.SECOND));
        return answer;
    }
}
Also used : Calendar(java.util.Calendar) MyTime(mbg.test.common.MyTime) Time(java.sql.Time) MyTime(mbg.test.common.MyTime)

Example 17 with Time

use of java.sql.Time in project generator by mybatis.

the class MyTimeTypeHandler method getResult.

public Object getResult(ResultGetter resultGetter) throws SQLException {
    Time time = resultGetter.getTime();
    if (time == null) {
        return null;
    } else {
        MyTime answer = new MyTime();
        Calendar c = Calendar.getInstance();
        c.setTime(time);
        answer.setHours(c.get(Calendar.HOUR_OF_DAY));
        answer.setMinutes(c.get(Calendar.MINUTE));
        answer.setSeconds(c.get(Calendar.SECOND));
        return answer;
    }
}
Also used : Calendar(java.util.Calendar) MyTime(mbg.test.common.MyTime) Time(java.sql.Time) MyTime(mbg.test.common.MyTime)

Example 18 with Time

use of java.sql.Time in project nutz by nutzam.

the class SupportedFieldTypeTest method check_for_sqlTime.

@Test
public void check_for_sqlTime() {
    Time time = Castors.me().castTo("07:09:12", Time.class);
    dao.insert(EntityTypes.class, Chain.make("name", "ABC").add("sqlTime", time));
    EntityTypes et = dao.fetch(EntityTypes.class);
    assertEquals(time.toString(), et.sqlTime.toString());
}
Also used : Time(java.sql.Time) Test(org.junit.Test)

Example 19 with Time

use of java.sql.Time in project jodd by oblac.

the class DateConverterTest method testSqlTime2Date.

@Test
public void testSqlTime2Date() {
    Time sqltime = new Time(time);
    Date date = dateConverter.convert(sqltime);
    assertEquals(time, date.getTime());
}
Also used : JDateTime(jodd.datetime.JDateTime) Time(java.sql.Time) Date(java.util.Date) Test(org.junit.Test)

Example 20 with Time

use of java.sql.Time in project jodd by oblac.

the class SqlTimeConverterTest method testConversion.

@Test
public void testConversion() {
    assertNull(sqlTimeConverter.convert(null));
    assertEquals(Time.valueOf("00:01:02"), sqlTimeConverter.convert(Time.valueOf("00:01:02")));
    assertEquals(new Time(60), sqlTimeConverter.convert(Integer.valueOf(60)));
    assertEquals(Time.valueOf("00:01:02"), sqlTimeConverter.convert("00:01:02"));
    assertEquals(Time.valueOf("00:01:02"), sqlTimeConverter.convert("       00:01:02    "));
    try {
        sqlTimeConverter.convert("00:01");
        fail();
    } catch (TypeConversionException ignore) {
    }
    try {
        sqlTimeConverter.convert("a");
        fail();
    } catch (TypeConversionException ignore) {
    }
}
Also used : JDateTime(jodd.datetime.JDateTime) Time(java.sql.Time) Test(org.junit.Test)

Aggregations

Time (java.sql.Time)182 Test (org.junit.Test)58 Timestamp (java.sql.Timestamp)50 Date (java.sql.Date)43 ResultSet (java.sql.ResultSet)32 LocalTime (java.time.LocalTime)32 Test (org.testng.annotations.Test)30 SQLException (java.sql.SQLException)26 Calendar (java.util.Calendar)25 BaseTest (util.BaseTest)25 BigDecimal (java.math.BigDecimal)21 Connection (java.sql.Connection)21 PreparedStatement (java.sql.PreparedStatement)21 Date (java.util.Date)19 JDateTime (jodd.datetime.JDateTime)11 ArrayList (java.util.ArrayList)10 GregorianCalendar (java.util.GregorianCalendar)10 Statement (java.sql.Statement)8 SimpleDateFormat (java.text.SimpleDateFormat)8 MyTime (mbg.test.common.MyTime)8