Java Param類代碼示例

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
@Select("<script>"
    + "SELECT ID, KEY, CATEGORY, TYPE, DOMAIN, NAME, VALID_UNTIL "
    + "FROM CLASSIFICATION "
    + "WHERE KEY = #{key} "
    + "AND DOMAIN = #{domain}"
    + "ORDER BY VALID_FROM DESC"
    + "</script>")
@Results({ @Result(property = "id", column = "ID"),
    @Result(property = "key", column = "KEY"),
    @Result(property = "category", column = "CATEGORY"),
    @Result(property = "type", column = "TYPE"),
    @Result(property = "domain", column = "DOMAIN"),
    @Result(property = "name", column = "NAME"),
    @Result(property = "validUntil", column = "VALID_UNTIL") })
List<ClassificationSummaryImpl> getAllClassificationsWithKey(@Param("key") String key,
    @Param("domain") String domain);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
@Select("SELECT ID, TASK_ID, CREATED, MODIFIED, CLASSIFICATION_KEY, REF_COMPANY, REF_SYSTEM, REF_INSTANCE, REF_TYPE, REF_VALUE, CHANNEL, RECEIVED, CUSTOM_ATTRIBUTES "
    + "FROM ATTACHMENT "
    + "WHERE TASK_ID = #{taskId}")
@Results(value = {
    @Result(property = "id", column = "ID"),
    @Result(property = "taskId", column = "TASK_ID"),
    @Result(property = "created", column = "CREATED"),
    @Result(property = "modified", column = "MODIFIED"),
    @Result(property = "classification", column = "CLASSIFICATION_KEY", javaType = Classification.class,
        one = @One(select = CLASSIFICATION_FINDBYID)),
    @Result(property = "objectReference.company", column = "REF_COMPANY"),
    @Result(property = "objectReference.system", column = "REF_SYSTEM"),
    @Result(property = "objectReference.systemInstance", column = "REF_INSTANCE"),
    @Result(property = "objectReference.type", column = "REF_TYPE"),
    @Result(property = "objectReference.value", column = "REF_VALUE"),
    @Result(property = "channel", column = "CHANNEL"),
    @Result(property = "received", column = "RECEIVED"),
    @Result(property = "customAttributes", column = "CUSTOM_ATTRIBUTES", jdbcType = JdbcType.BLOB,
        javaType = Map.class, typeHandler = MapTypeHandler.class),
})
List<AttachmentImpl> findAttachmentsByTaskId(@Param("taskId") String taskId);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
@Select("SELECT * FROM WORKBASKET WHERE id IN (SELECT TARGET_ID FROM DISTRIBUTION_TARGETS WHERE SOURCE_ID = #{id})")
@Results(value = {
    @Result(property = "id", column = "ID"),
    @Result(property = "key", column = "KEY"),
    @Result(property = "name", column = "NAME"),
    @Result(property = "description", column = "DESCRIPTION"),
    @Result(property = "owner", column = "OWNER"),
    @Result(property = "domain", column = "DOMAIN"),
    @Result(property = "type", column = "TYPE"),

    @Result(property = "orgLevel1", column = "ORG_LEVEL_1"),
    @Result(property = "orgLevel2", column = "ORG_LEVEL_2"),
    @Result(property = "orgLevel3", column = "ORG_LEVEL_3"),
    @Result(property = "orgLevel4", column = "ORG_LEVEL_4")})

List<WorkbasketSummary> findByDistributionTargets(@Param("id") String id);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
@Select("<script>"
    + "SELECT STATE, COUNT (STATE) as counter "
    + "FROM TASK "
    + "WHERE STATE IN (<foreach collection='status' item='state' separator=','>#{state}</foreach>) "
    + "GROUP BY STATE"
    + "</script>")
@Results({ @Result(column = "STATE", property = "state"), @Result(column = "counter", property = "counter") })
List<TaskStateCounter> getTaskCountForState(@Param("status") List<TaskState> status);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
@Select("select `id`, `name`, `age`, `score` from demo_table where name = #{name}")
DemoInfo getInfoByName(@Param("name") String name);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
@Select("SELECT * from users where username=#{username}")
User findone(@Param("username") String username);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
@SelectProvider(type = DynamicQueryProvider.class, method = "dynamicSQL")
List<T> selectByDynamicQuery(@Param(MapperConstants.DYNAMIC_QUERY) DynamicQuery<T> dynamicQuery);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
void update(@Param("id") int id, @Param("name") String name
, @Param("nameEn")String nameEn, @Param("headImg") String headImg
, @Param("primeAttr") int primeAttr, @Param("bio")String bio);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
@UpdateProvider( type = DynamicQueryBuilder.class, method = "buildUpdate")
int update(@Param(PARAM_ENTITY_NAME) T bean);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
List<ExtensionDai.Providers> queryProviders(
@Param("providerId") String providerId);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
ExtensionDai.Record selectLastExtensionByName(
@Param("ownerId") String ownerId,
@Param("group") String group,
@Param("name") String name,
@Param("tree") String tree,
@Param("endTime") Date endTime);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
GlimpsesDai.Publication loadGlimpse(
@Param("subscriberId") String subscriberId,
@Param("id") String id);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
@Select("SELECT id FROM sw_guest WHERE device_mac = #{deviceMac} and router_mac=#{routerMac} and status=0 limit 1")
long findByName(@Param("routerMac") String routerMac, @Param("deviceMac") String deviceMac);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
ExtensionDai.Record selectLastExtensionById(
@Param("id") String id,
@Param("endTime") Date endTime);
 

import org.apache.ibatis.annotations.Param; //導入依賴的package包/類
/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table order_goods
 *
 * @mbg.generated
 */
int updateByExampleSelective(@Param("record") OrderGoods record, @Param("example") OrderGoodsCriteria example);