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

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

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

Introduction

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

Prototype

JdbcType VARCHAR

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

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  a  v  a2s.  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  va2  s  . 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 List<Order> getAll();

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

License:Apache License

/**
 * ? id ?/*from  w w  w . jav  a2  s .  com*/
 *
 * @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  v a  2s .  co m*/
 *
 * @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 /*w  w w.j av 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//from  w ww .  j  a  va  2s  . c om
 *
 * @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 //from w w  w .j a va 2s.com
 *
 * @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>/*w w  w.  ja va  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);