Java 类org.apache.ibatis.annotations.Param 实例源码

@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);

@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);

@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);

@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);

@Select("SELECT * from users where username=#{username}")
User findone(@Param("username") String username);

@SelectProvider(type = DynamicQueryProvider.class, method = "dynamicSQL")
List<T> selectByDynamicQuery(@Param(MapperConstants.DYNAMIC_QUERY) DynamicQuery<T> dynamicQuery);

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);

@UpdateProvider( type = DynamicQueryBuilder.class, method = "buildUpdate")
int update(@Param(PARAM_ENTITY_NAME) T bean);

List<ExtensionDai.Providers> queryProviders(
@Param("providerId") String providerId);

ExtensionDai.Record selectLastExtensionByName(
@Param("ownerId") String ownerId,
@Param("group") String group,
@Param("name") String name,
@Param("tree") String tree,
@Param("endTime") Date endTime);

@Select("select `id`, `name`, `age`, `score` from demo_table where name = #{name}")
DemoInfo getInfoByName(@Param("name") String name);

GlimpsesDai.Publication loadGlimpse(
@Param("subscriberId") String subscriberId,
@Param("id") String id);

@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);

ExtensionDai.Record selectLastExtensionById(
@Param("id") String id,
@Param("endTime") Date endTime);

/**
 * 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);

/**
 * 查找通知
 * @param id
 * @return
 */
InfoEntity selectInfo(@Param("id") int id);

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table pay_notify_log
 *
 * @mbg.generated
 */
int updateByExampleSelective(@Param("record") PayNotifyLog record, @Param("example") PayNotifyLogCriteria example);

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table pay_notify_log
 *
 * @mbg.generated
 */
int updateByExampleWithBLOBs(@Param("record") PayNotifyLog record, @Param("example") PayNotifyLogCriteria example);

/**
 * 查询type类型的前N个，按照时间排序
 *
 * @param type
 * @param topN
 * @return
 */
List<EduCourse> findByType(@Param("type") int type, @Param("n") int topN);

/**
 * 创建SynZkDBLog
 * @param SynZkDBLog
 * @return
 * @throws Exception
 */
public int create(@Param("logList") List<SynZkDBLog> logList) throws Exception;

/**
* 通过辅助工具Assist的条件更新Classification中的数据,包括null值
* @param value
* @param assist
* @return
*/
  int updateClassification(@Param("enti") Classification value, @Param("assist") Assist assist);

/**
 * 修改课程学分为空
 * @param courseName
 * @param nature
 * @param department
 * @param courseId
 */
int updateCourseNoCre(@Param("courseName") String courseName, @Param("nature") String nature,
                      @Param("department") String department, @Param("courseId") String courseId);

/**
 * 根据主键批量查询
 *
 * @param pagination
 * @param ids
 * @return
 */
List<User> forSelect(RowBounds pagination, @Param("ids") List<String> ids);

/**
 * @param from
 * @return
 */
User getByMail(@Param("mail")String from);

/**
 * 根据课程id 删除相关目录
 *
 * @param cid 课程id
 * @return 影响的行数
 */
int deleteByEducid(@Param("cid") int cid);

/**
 * 获取某商品评论总量
 * @param pid 商品Id
 * @return
 */
int countContentByPid(@Param("pid") Integer pid);

/**
 * 批量更新
 */
@UpdateProvider(type = CommentSqlProvider.class, method = "batchUpdate")
void batchUpdate(@Param("list") List<Comment> comments);

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table t_comm_logger
 *
 * @mbg.generated
 */
int updateByExampleSelective(@Param("record") CommLogger record, @Param("example") CommLoggerExample example);

/**
 * 更新工人认证状态
 * @param workerid 工人id
 * @param cert 认证状态
 * @return int
 */
int editCert(@Param("workerid")long workerid,@Param("cert")boolean cert);

/**
 * 通过Key查询Value
 * 
 * @param key
 * @return
 */
public String getValueByKey(@Param("key") String key);

/**
 * 添加课程，无学分
 * @param courseId
 * @param courseName
 * @param nature
 * @param department
 */
void insertCourseNoCre(@Param("courseId") String courseId, @Param("courseName") String courseName, @Param("nature") String nature,
                       @Param("department") String department);

/**
 * 检查是否参加课程
 *
 * @param uid
 * @param rid
 * @return
 */
int checkCourseRegister(@Param("uid") int uid, @Param("rid") int rid);

/**
* 通过辅助工具Assist的条件更新History中属性不为null的数据
* @param value
* @param assist
* @return
*/
  int updateNonEmptyHistory(@Param("enti") History value, @Param("assist") Assist assist);

/**
 * 查询某用户参与的课程
 *
 * @param uid  用户id
 * @param type
 * @param page
 * @return
 */
List<EduCourse> findCourseByType(@Param("uid") int uid, @Param("type") int type, @Param("page") PageAndSorted page);

/**
 * 获取状态为死亡的节点
 * @param list
 * @return
 * @throws Exception
 */
public List<Client> getOfflineClientsByIns(@Param("list") List<JsfIns> list) throws Exception;

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table public.posts
 *
 * @mbg.generated Tue May 23 21:55:33 PDT 2017
 */
int updateByExampleSelective(@Param("record") Posts record, @Param("example") PostsExample example);

/**
 * 通过资源类型id查询资源,无分页
 * @param cid 资源类型
 * @return 资源集合
 */
List<OfficialResouce> findResourceByCidNoPage(@Param("cid") Integer cid,@Param("start") Integer start,@Param("end") Integer end);

/**
* 通过辅助工具Assist的条件更新ShopedList中属性不为null的数据
* @param value
* @param assist
* @return
*/
  int updateNonEmptyShopedList(@Param("enti") ShopedList value, @Param("assist") Assist assist);

int updateByExampleSelective(@Param("record") UserEntity record, @Param("example") UserEntityExample example);

int updateByExample(@Param("record") ChannelEntity record, @Param("example") ChannelEntityExample example);