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

Introduction

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

Prototype

JdbcType DATE

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

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.DataSourceMapper.java

License:Apache License

/**
 * ??/*ww  w. jav  a  2  s  .  c om*/
 *
 * @param projectId
 * @return
 */
@Results(value = {
        @Result(property = "id", column = "id", id = true, javaType = Integer.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 = "type", column = "type", typeHandler = EnumOrdinalTypeHandler.class, javaType = DbType.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "ownerName", column = "owner", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "ownerId", column = "owner_id", javaType = Integer.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "projectId", column = "project_id", javaType = Integer.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "projectName", column = "project_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "parameter", column = "parameter", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "createTime", column = "create_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE),
        @Result(property = "modifyTime", column = "modify_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE) })
@SelectProvider(type = DataSourceMapperProvider.class, method = "getByProjectId")
List<DataSource> getByProjectId(@Param("projectId") Integer projectId);

---

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

License:Apache License

/**
 * ???/*w  ww.  jav  a  2  s.  com*/
 *
 * @param projectId
 * @param name
 * @return
 */
@Results(value = {
        @Result(property = "id", column = "id", id = true, javaType = Integer.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 = "type", column = "type", typeHandler = EnumOrdinalTypeHandler.class, javaType = DbType.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "ownerName", column = "owner", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "ownerId", column = "owner_id", javaType = Integer.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "projectId", column = "project_id", javaType = Integer.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "projectName", column = "project_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "parameter", column = "parameter", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "createTime", column = "create_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE),
        @Result(property = "modifyTime", column = "modify_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE) })
@SelectProvider(type = DataSourceMapperProvider.class, method = "getByName")
DataSource getByName(@Param("projectId") Integer projectId, @Param("name") String name);

---

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

License:Apache License

/**
 * ???//from   w  w  w . java2  s  .com
 *
 * @param name
 * @return
 */
@Results(value = {
        @Result(property = "id", column = "id", id = true, javaType = Integer.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 = "type", column = "type", typeHandler = EnumOrdinalTypeHandler.class, javaType = DbType.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "ownerName", column = "owner", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "ownerId", column = "owner_id", javaType = Integer.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "projectId", column = "project_id", javaType = Integer.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "projectName", column = "project_name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "parameter", column = "parameter", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "createTime", column = "create_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE),
        @Result(property = "modifyTime", column = "modify_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE) })
@SelectProvider(type = DataSourceMapperProvider.class, method = "getByProjectNameAndName")
DataSource getByProjectNameAndName(@Param("projectName") String projectName, @Param("name") String name);

---

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

License:Apache License

/**
 * ??????//from   w w w .ja v  a 2  s. c  o  m
 */
@Results(value = {
        @Result(property = "day", column = "day", id = true, javaType = Date.class, jdbcType = JdbcType.DATE),
        @Result(property = "init", column = "INIT", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "waitingDep", column = "WAITING_DEP", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "waitingRes", column = "WAITING_RES", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "running", column = "RUNNING", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "success", column = "SUCCESS", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "kill", column = "KILL", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "failed", column = "FAILED", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "depFailed", column = "DEP_FAILED", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "inActive", column = "INACTIVE", javaType = int.class, jdbcType = JdbcType.INTEGER) })
@SelectProvider(type = ExecutionFlowMapperProvider.class, method = "selectStateByProject")
List<ExecutionState> selectStateByProject(@Param("projectId") int projectId, @Param("startDate") Date startDate,
        @Param("endDate") Date endDate);

---

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

License:Apache License

/**
 *  workflow (by name) <p>/*from   w ww . ja v  a2s .  c o m*/
 *
 * @param projectId
 * @param name
 * @return {@link ProjectFlow}
 */
@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 = "createTime", column = "create_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE),
        @Result(property = "modifyTime", column = "modify_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE),
        @Result(property = "desc", column = "desc", 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 = "ownerId", column = "owner_id", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @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 = "userDefinedParams", column = "user_defined_params", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "extras", column = "extras", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "queue", column = "queue", javaType = String.class, jdbcType = JdbcType.VARCHAR), })
@SelectProvider(type = ProjectFlowMapperProvider.class, method = "queryByName")
ProjectFlow findByName(@Param("projectId") int projectId, @Param("name") String name);

---

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

License:Apache License

/**
 * ?Id??/* www.  j a  v a2s .c o  m*/
 *
 * @param id
 * @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 = "createTime", column = "create_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE),
        @Result(property = "modifyTime", column = "modify_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE),
        @Result(property = "desc", column = "desc", 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 = "ownerId", column = "owner_id", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @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 = "userDefinedParams", column = "user_defined_params", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "extras", column = "extras", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "queue", column = "queue", javaType = String.class, jdbcType = JdbcType.VARCHAR), })
@SelectProvider(type = ProjectFlowMapperProvider.class, method = "queryById")
ProjectFlow findById(@Param("id") int id);

---

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

License:Apache License

/**
 * ???????/*from  w  ww . j  a va 2 s .  c  o  m*/
 *
 * @param projectName
 * @param name
 * @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 = "createTime", column = "create_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE),
        @Result(property = "modifyTime", column = "modify_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE),
        @Result(property = "desc", column = "desc", 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 = "ownerId", column = "owner_id", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @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 = "userDefinedParams", column = "user_defined_params", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "extras", column = "extras", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "queue", column = "queue", javaType = String.class, jdbcType = JdbcType.VARCHAR), })
@SelectProvider(type = ProjectFlowMapperProvider.class, method = "findByProjectNameAndName")
ProjectFlow findByProjectNameAndName(@Param("projectName") String projectName, @Param("name") String name);

---

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

License:Apache License

/**
 * ??ID?/* w ww . j  a v a  2 s  . co  m*/
 *
 * @param projectId
 * @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 = "createTime", column = "create_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE),
        @Result(property = "modifyTime", column = "modify_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE),
        @Result(property = "desc", column = "desc", 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 = "lastModifyBy", column = "last_modify_by", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "ownerId", column = "owner_id", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @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 = "userDefinedParams", column = "user_defined_params", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "extras", column = "extras", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "queue", column = "queue", javaType = String.class, jdbcType = JdbcType.VARCHAR) })
@SelectProvider(type = ProjectFlowMapperProvider.class, method = "findByProject")
List<ProjectFlow> findByProject(@Param("projectId") Integer projectId);

---

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

License:Apache License

/**
 * ?//from  w  w w  .  j  a va2 s  .c om
 *
 * @param projectId
 * @return
 */
@Results(value = {
        @Result(property = "id", column = "id", id = true, javaType = Integer.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "name", column = "name", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "email", column = "email", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "desc", column = "desc", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "phone", column = "phone", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "password", column = "password", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "role", column = "role", typeHandler = EnumOrdinalTypeHandler.class, javaType = UserRoleType.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "proxyUsers", column = "proxy_users", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "createTime", column = "create_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE),
        @Result(property = "modifyTime", column = "modify_time", javaType = Timestamp.class, jdbcType = JdbcType.DATE) })
@SelectProvider(type = ProjectUserMapperProvider.class, method = "queryForUser")
List<User> queryForUser(@Param("projectId") int projectId);

---

• «
• 1
• 2
• 3
• 4
• »