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

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

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

Introduction

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

Prototype

JdbcType INTEGER

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

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:cn.songxinqiang.study.mybatis.mapper.OrderMapper.java

License:Apache License

@SelectProvider(type = OrderSQLProvider.class, method = "getSql")
@Results(value = {//from   w w w  .  j  ava  2s. c o  m
        @Result(id = true, property = "id", column = "order_id", javaType = Integer.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "orderNo", column = "order_no", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "price", column = "order_price", javaType = Float.class, jdbcType = JdbcType.FLOAT) })
public Order getById(@Param("id") int id);

From source file:cn.songxinqiang.study.mybatis.mapper.OrderMapper.java

License:Apache License

@SelectProvider(type = OrderSQLProvider.class, method = "getAllSql")
@Results(value = {/*from w  w  w.  j  a v a 2s. co m*/
        @Result(id = true, property = "id", column = "order_id", javaType = Integer.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "orderNo", column = "order_no", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "price", column = "order_price", javaType = Float.class, jdbcType = JdbcType.FLOAT) })
public List<Order> getAll();

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

License:Apache License

/**
 * ? id ?//from ww  w. j  av a2s. c om
 *
 * @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 /* w w w.ja v a 2s  .com*/
 *
 * @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 /*  ww w  .  j  a v  a  2s  . c  om*/
 *
 * @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/*from   ww  w  .  j ava2  s .  co 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 ww  . j ava2  s.  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.AdHocResultMapper.java

License:Apache License

/**
 * ?( adHocId ) <p>/* ww  w .j a  v  a 2 s  . c  om*/
 *
 * @return 
 */
@Results(value = {
        @Result(property = "adHocId", column = "exec_id", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "index", column = "index", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "status", column = "status", typeHandler = EnumOrdinalTypeHandler.class, javaType = FlowStatus.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "stm", column = "stm", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "result", column = "result", javaType = String.class, jdbcType = JdbcType.VARCHAR) })
@SelectProvider(type = AdHocResultMapperProvider.class, method = "selectByAdHocId")
List<AdHocResult> selectByAdHocId(@Param("adHocId") long adHocId);

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

License:Apache License

@Results(value = {
        @Result(property = "adHocId", column = "exec_id", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "index", column = "index", javaType = int.class, jdbcType = JdbcType.INTEGER),
        @Result(property = "status", column = "status", typeHandler = EnumOrdinalTypeHandler.class, javaType = FlowStatus.class, jdbcType = JdbcType.TINYINT),
        @Result(property = "stm", column = "stm", javaType = String.class, jdbcType = JdbcType.VARCHAR),
        @Result(property = "result", column = "result", javaType = String.class, jdbcType = JdbcType.VARCHAR) })
@SelectProvider(type = AdHocResultMapperProvider.class, method = "selectByAdHocIdAndIndex")
List<AdHocResult> selectByAdHocIdAndIndex(@Param("adHocId") long adHocId, @Param("index") int index);