org.apache.ibatis.annotations.ResultMap Java Examples

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table T_COFFEE
 *
 * @mbg.generated Sun Dec 08 00:33:16 CST 2019
 */
@Select({
    "select",
    "ID, NAME, PRICE, CREATE_TIME, UPDATE_TIME",
    "from T_COFFEE",
    "where ID = #{id,jdbcType=BIGINT}"
})
@ResultMap("com.zuozewei.springbootdatadrivendemo.db.auto.mapper.CoffeeMapper.BaseResultMap")
Coffee selectByPrimaryKey(Long id);
 

/**
 * Find the direct children of a browse node.
 */
@SelectProvider(type = BrowseNodeDAOQueryBuilder.class, method = "findChildrenQuery")
@ResultMap("datastoreBrowseNode")
Iterable<DatastoreBrowseNode> findChildren(
    @Param("repository") ContentRepository repository,
    @Param("path") String path,
    @Param("maxNodes") int maxNodes,
    @Param("contentSelectors") List<String> contentSelectors,
    @Param(WHERE_PARAMS) Map<String, Object> whereParams);
 

@Select({
  "SELECT id, firstName, lastName, parent_id, parent_firstName, parent_lastName",
  "FROM Person",
  "WHERE id = #{id,jdbcType=INTEGER}"
})
@ResultMap("personMapComplex")
public Person getWithComplex2(Long id);
 

@Select({
  "SELECT id, firstName, lastName, parent_id, parent_firstName, parent_lastName",
  "FROM Person",
  "WHERE id = #{id,jdbcType=INTEGER}"
})
@ResultMap("personMapComplex")
public Person getWithComplex2(Long id);
 

@Select({
    "SELECT id, firstName, lastName, parent_id, parent_firstName, parent_lastName",
    "FROM Person",
    "WHERE id = #{id,jdbcType=INTEGER}"
  })
@ResultMap("org.apache.ibatis.submitted.complex_column.PersonMapper.personMapComplex")
public Person getWithComplex3(Long id);
 

@Select({
    "SELECT id, firstName, lastName, parent_id, parent_firstName, parent_lastName",
    "FROM Person",
    "WHERE id = #{id,jdbcType=INTEGER}"
  })
@ResultMap("org.apache.ibatis.submitted.complex_column.PersonMapper.personMapComplex")
public Person getWithComplex3(Long id);
 

@ResultMap("distBillListResult")
@SelectProvider(type = DistBillListSqlProvide.class, method = "excludeInvtsSql")
List<DistBillList> excludeInvts(String distNo, String companyCode);
 

@Select({ "{call sptest.getnamesLowHigh(", "#{lowestId,jdbcType=INTEGER,mode=IN},", "#{highestId,jdbcType=INTEGER,mode=IN})}" })
@ResultMap("nameResult")
@Options(statementType = StatementType.CALLABLE)
List<Name> getNamesAnnotatedLowHighWithXMLResultMap(@Param("lowestId") int lowestId, @Param("highestId") int highestId);
 

@ResultMap("versionResult")
@SelectProvider(type = VersionSqlProvide.class, method = "getVersionByCodeSql")
Version getVersionByCode(String code);
 

@ResultMap("orderHeadResult")
@SelectProvider(type = OrderHeadSqlProvide.class, method = "getOrderHeadByHeadGuidSql")
OrderHead getOrderHeadByHeadGuid(String headGuid);
 

@ResultMap("memberResult")
@SelectProvider(type = MemberSqlProvide.class, method = "getMemberByUserNameSql")
Member getMemberByUserName(String userName);
 

@ResultMap("orderListResult")
@SelectProvider(type = OrderListSqlProvide.class, method = "getOrderListBySearchTextSql")
List<OrderList> getOrderListBySearchText(String headGuid, String searchText);
 

@Select({ "{call sptest.arraytest(", "#{ids,mode=IN,jdbcType=ARRAY},", "#{requestedRows,jdbcType=INTEGER,mode=OUT},", "#{returnedIds,mode=OUT,jdbcType=ARRAY})}" })
@ResultMap("nameResult")
@Options(statementType = StatementType.CALLABLE)
List<Name> getNamesWithArrayAnnotatedWithXMLResultMap(Map<String, Object> parms);
 

@Select({ "{call sptest.arraytest(", "#{ids,mode=IN,jdbcType=ARRAY},", "#{requestedRows,jdbcType=INTEGER,mode=OUT},", "#{returnedIds,mode=OUT,jdbcType=ARRAY})}" })
@ResultMap("nameResult")
@Options(statementType = StatementType.CALLABLE)
List<Name> getNamesWithArrayAnnotatedWithXMLResultMap(Map<String, Object> parms);
 

@Select("{call sptest.getnamesanditems()}")
@ResultMap("nameResult,itemResult")
@Options(statementType = StatementType.CALLABLE)
List<List<?>> getNamesAndItemsAnnotatedWithXMLResultMap();
 

@Select("{call sptest.getnamesanditems()}")
@ResultMap({"nameResult","itemResult"})
@Options(statementType = StatementType.CALLABLE)
List<List<?>> getNamesAndItemsAnnotatedWithXMLResultMapArray();
 

@Select("SELECT * FROM test AS t LIMIT 1")
@ResultMap("map")
TestModel retrieveTestString();
 

@Select("SELECT * FROM test AS t LIMIT 1")
@ResultMap("map")
TestModel retrieveTestString();
 

@ResultMap("distBillListResult")
@SelectProvider(type = DistBillListSqlProvide.class, method = "getDistBillListListBySearchTextSql")
List<DistBillList> getDistBillListListBySearchText(String seqNo, String searchText);
 

@ResultMap("deliveryListResult")
@SelectProvider(type = DeliveryListSqlProvide.class, method = "getDeliveryListSql")
List<DeliveryList> getDeliveryList(DeliveryList deliveryList);
 

@ResultMap("invtHeadResult")
@SelectProvider(type = InvtHeadSqlProvide.class, method = "getNonSyncInvtListSql")
List<InvtHead> getNonSyncInvtList(String startDate, String endDate);
 

@ResultMap("invtHeadResult")
@SelectProvider(type = InvtHeadSqlProvide.class, method = "getInvtHeadMonthCountSql")
List<InvtHead> getInvtHeadMonthCount();
 

@ResultMap("invtHeadResult")
@SelectProvider(type = InvtHeadSqlProvide.class, method = "getDeclareTopTenSql")
List<InvtHead> getDeclareTopTen(InvtHead invtHead);
 

@ResultMap("invtHeadResult")
@SelectProvider(type = InvtHeadSqlProvide.class, method = "getInvtHeadListByRepeatInvtNoSql")
List<InvtHead> getInvtHeadListByRepeatInvtNo();
 

@ResultMap("invtHeadResult")
@SelectProvider(type = InvtHeadSqlProvide.class, method = "getInvtHeadByInvtNoSql")
InvtHead getInvtHeadByInvtNo(String invtNo);
 

@ResultMap("invtHeadResult")
@SelectProvider(type = InvtHeadSqlProvide.class, method = "exportInvtHeadListSql")
List<InvtHead> exportInvtHeadList(InvtHead invtHead);
 

@ResultMap("invtHeadResult")
@SelectProvider(type = InvtHeadSqlProvide.class, method = "getInvtHeadByHeadGuidSql")
InvtHead getInvtHeadByHeadGuid(String headGuid);
 

@ResultMap("invtListResult")
@SelectProvider(type = InvtListSqlProvide.class, method = "getInvtListListBySearchTextSql")
List<InvtList> getInvtListListBySearchText(String headGuid, String searchText);
 

@ResultMap("personalInfoResult")
@SelectProvider(type = PersonalInfoSqlProvide.class, method = "getPersonalInfoByNameCertIdSql")
PersonalInfo getPersonalInfoByNameCertId(String name, String certId);
 

@ResultMap("veHeadResult")
@SelectProvider(type = VeHeadSqlProvide.class, method = "getVeHeadByVeNoSql")
VeHead getVeHeadByVeNo(String veNo);