Example usage for org.apache.ibatis.type JdbcType TIMESTAMP

List of usage examples for org.apache.ibatis.type JdbcType TIMESTAMP

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.type.*
  5. JdbcType
  6. TIMESTAMP

Introduction

In this page you can find the example usage for org.apache.ibatis.type JdbcType TIMESTAMP.

Prototype

JdbcType TIMESTAMP

To view the source code for org.apache.ibatis.type JdbcType TIMESTAMP.

Click Source Link

Usage

From source file:cherry.foundation.type.db.mapper.ConversionTestMapper.java

License:Apache License

@Select({ "SELECT",
        "id, joda_date, joda_time, joda_datetime, sec_str, sec_int, sec_long, sec_bigint, sec_bigdec, flag_code, deleted_flg",
        "FROM conversion_test" })
@Results({ @Result(column = "id", property = "id", jdbcType = JdbcType.INTEGER, id = true),
        @Result(column = "joda_date", property = "jodaDate", jdbcType = JdbcType.DATE),
        @Result(column = "joda_time", property = "jodaTime", jdbcType = JdbcType.TIME),
        @Result(column = "joda_datetime", property = "jodaDatetime", jdbcType = JdbcType.TIMESTAMP),
        @Result(column = "sec_str", property = "secStr", jdbcType = JdbcType.VARCHAR),
        @Result(column = "sec_int", property = "secInt", jdbcType = JdbcType.VARCHAR),
        @Result(column = "sec_long", property = "secLong", jdbcType = JdbcType.VARCHAR),
        @Result(column = "sec_bigint", property = "secBigint", jdbcType = JdbcType.VARCHAR),
        @Result(column = "sec_bigdec", property = "secBigdec", jdbcType = JdbcType.VARCHAR),
        @Result(column = "flag_code", property = "flagCode", jdbcType = JdbcType.INTEGER),
        @Result(column = "deleted_flg", property = "deletedFlg", jdbcType = JdbcType.INTEGER) })
List<ConversionTest> selectAll();

From source file:com.baifendian.swordfish.dao.mapper.AdHocMapper.java

License:Apache License

/**
 * ? id ?/*from   w  w w .j a  va 2  s.co  m*/
 *
 * @param execId
 * @return
 */
@Results(value = {
        @Result(property = "id", column = "id", id = true, javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "name", column = "name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "desc", column = "desc", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "createTime", column = "create_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "modifyTime", column = "modify_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "ownerId", column = "owner", javaType = int.class, jdbcType = JdbcType.INTEGER), })
@SelectProvider(type = AdHocMapperProvider.class, method = "selectProjectByExecId")
Project queryProjectByExecId(@Param("execId") int execId);

From source file:com.baifendian.swordfish.dao.mapper.AdHocMapper.java

License:Apache License

/**
 * ? id //from ww w  .  j  a  va  2 s .c om
 *
 * @param id
 * @return
 */
@Results(value = {
        @Result(property = "id", column = "id", id = true, javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "projectId", column = "project_id", id = true, javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "name", column = "name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "proxyUser", column = "proxy_user", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "queue", column = "queue", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "type", column = "type", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "status", column = "status", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "owner", column = "owner", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "parameter", column = "parameter", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "createTime", column = "create_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "startTime", column = "start_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "endTime", column = "end_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "jobId", column = "job_id", javaType = String.class, jdbcType = JdbcType.VARCHAR) })
@SelectProvider(type = AdHocMapperProvider.class, method = "selectById")
AdHoc selectById(@Param("id") int id);

From source file:com.baifendian.swordfish.dao.mapper.AdHocMapper.java

License:Apache License

/**
 * ? id //from w w w  . j a v a  2  s  . c o  m
 *
 * @param execId
 * @return
 */
@Results(value = {
        @Result(property = "execId", column = "exec_id", id = true, javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "index", column = "index", id = true, javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "stm", column = "stm", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "result", column = "result", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "status", column = "status", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "createTime", column = "create_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "startTime", column = "start_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "endTime", column = "end_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP) })
@SelectProvider(type = AdHocMapperProvider.class, method = "selectResultById")
List<AdHocResult> selectResultById(@Param("execId") int execId);

From source file:com.baifendian.swordfish.dao.mapper.AdHocMapper.java

License:Apache License

/**
 * search by exec id and index/*  ww  w.  j  a  v  a  2  s .  c  o m*/
 *
 * @param execId
 * @param index
 * @return
 */
@Results(value = {
        @Result(property = "execId", column = "exec_id", id = true, javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "index", column = "index", id = true, javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "name", column = "name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "stm", column = "stm", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "result", column = "result", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "status", column = "status", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "createTime", column = "create_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "startTime", column = "start_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "endTime", column = "end_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP) })
@SelectProvider(type = AdHocMapperProvider.class, method = "selectResultByIdAndIndex")
AdHocResult selectResultByIdAndIndex(@Param("execId") int execId, @Param("index") int index);

From source file:com.baifendian.swordfish.dao.mapper.AdHocMapper.java

License:Apache License

/**
 * ? id //w  w w . ja v  a  2s.  c o  m
 *
 * @param
 * @return
 */
@Results(value = {
        @Result(property = "id", column = "id", id = true, javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "projectId", column = "project_id", id = true, javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "name", column = "name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "proxyUser", column = "proxy_user", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "queue", column = "queue", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "status", column = "status", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "type", column = "type", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "owner", column = "owner", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "parameter", column = "parameter", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "createTime", column = "create_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "startTime", column = "start_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "endTime", column = "end_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "jobId", column = "job_id", javaType = String.class, jdbcType = JdbcType.VARCHAR) })
@SelectProvider(type = AdHocMapperProvider.class, method = "selectAdhocByName")
List<AdHoc> selectAdhocByName(@Param("projectId") int projectId, @Param("name") String name);

From source file:com.baifendian.swordfish.dao.mapper.ExecutionFlowMapper.java

License:Apache License

/**
 * ? id /*  w ww. j ava  2 s.  c  o m*/
 */
@Results(value = {
        @Result(property = "id", column = "id", id = true, javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "flowId", column = "flow_id", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "worker", column = "worker", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "projectId", column = "project_id", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "projectName", column = "project_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "status", column = "status", typeHandler = EnumOrdinalTypeHandler.class, javaType = FlowStatus.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "submitUserId", column = "submit_user", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "submitUser", column = "submit_user_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "owner", column = "owner_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "proxyUser", column = "proxy_user", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "submitTime", column = "submit_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "startTime", column = "start_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "scheduleTime", column = "schedule_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "endTime", column = "end_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "workflowData", column = "workflow_data", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "workflowDataSub", column = "workflow_data_sub", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "type", column = "type", typeHandler = EnumOrdinalTypeHandler.class, javaType = ExecType.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "failurePolicy", column = "failure_policy", typeHandler = EnumOrdinalTypeHandler.class, javaType = FailurePolicyType.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "workflowName", column = "flow_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "queue", column = "queue", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "userDefinedParams", column = "user_defined_params", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "extras", column = "extras", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "maxTryTimes", column = "max_try_times", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "timeout", column = "timeout", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "notifyType", column = "notify_type", typeHandler = EnumOrdinalTypeHandler.class, javaType = NotifyType.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "notifyMails", column = "notify_mails", javaType = String.class, jdbcType = JdbcType.VARCHAR) })
@SelectProvider(type = ExecutionFlowMapperProvider.class, method = "selectByExecId")
ExecutionFlow selectByExecId(@Param("execId") Integer execId);

From source file:com.baifendian.swordfish.dao.mapper.ExecutionFlowMapper.java

License:Apache License

/**
 * ??// ww  w .  j  ava2  s  .c o  m
 */
@Results(value = {
        @Result(property = "id", column = "id", id = true, javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "flowId", column = "flow_id", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "workflowName", column = "flow_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "projectName", column = "project_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "status", column = "status", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "worker", column = "worker", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "status", column = "status", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "scheduleTime", column = "schedule_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "submitTime", column = "submit_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "startTime", column = "start_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "endTime", column = "end_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "submitUserId", column = "schedule_user", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "submitUser", column = "submit_user_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "proxyUser", column = "proxy_user", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "type", column = "type", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT) })
@SelectProvider(type = ExecutionFlowMapperProvider.class, method = "selectByFlowIdAndTimesAndStatusLimit")
List<ExecutionFlow> selectByFlowIdAndTimesAndStatusLimit(@Param("projectName") String projectName,
        @Param("workflowList") List<String> workflowList, @Param("startDate") Date startDate,
        @Param("endDate") Date endDate, @Param("start") int start, @Param("limit") int limit,
        @Param("status") List<FlowStatus> statuses);

From source file:com.baifendian.swordfish.dao.mapper.ExecutionFlowMapper.java

License:Apache License

/**
 * ? flow id ?//from  w w w  . jav a2  s.  com
 */
@Results(value = {
        @Result(property = "id", column = "id", id = true, javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "flowId", column = "flow_id", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "worker", column = "worker", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "status", column = "status", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "scheduleTime", column = "schedule_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "type", column = "type", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT) })
@SelectProvider(type = ExecutionFlowMapperProvider.class, method = "selectByFlowIdAndTime")
List<ExecutionFlow> selectByFlowIdAndTime(@Param("flowId") Integer flowId,
        @Param("scheduleTime") Date scheduleTime);

From source file:com.baifendian.swordfish.dao.mapper.ExecutionFlowMapper.java

License:Apache License

/**
 * ??TOP//  w w  w .  j a  v  a2s.com
 */
@Results(value = {
        @Result(property = "id", column = "id", id = true, javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "flowId", column = "flow_id", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "workflowName", column = "flow_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "projectName", column = "project_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "status", column = "status", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "worker", column = "worker", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "status", column = "status", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "scheduleTime", column = "schedule_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "submitTime", column = "submit_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "startTime", column = "start_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "endTime", column = "end_time", javaType = Date.class, jdbcType = JdbcType.TIMESTAMP),
        @Result(property = "submitUserId", column = "schedule_user", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "submitUser", column = "submit_user_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "type", column = "type", typeHandler = EnumOrdinalTypeHandler.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "proxyUser", column = "proxy_user", javaType = String.class, jdbcType = JdbcType.VARCHAR)
        //      @Result(property = "duration", column = "duration", javaType = int.class, jdbcType = JdbcType.INTEGER)
})
@SelectProvider(type = ExecutionFlowMapperProvider.class, method = "selectDurationsByProject")
List<ExecutionFlow> selectDurationsByProject(@Param("projectId") int projectId, @Param("top") int top,
        @Param("date") Date date);