org.apache.ibatis.annotations.Options Java Examples

/**
 * 通过评测记录唯一标识符获取试题对象.
 * @param submissionId - 评测记录的唯一标识符
 * @return 一个评测记录对象
 */
@Select("SELECT * FROM voj_submissions WHERE submission_id = #{submissionId}")
@Options(useCache = true)
@Results({
	@Result(property = "submissionId", column = "submission_id"),
	@Result(property = "problem", column = "problem_id", javaType = Problem.class, one = @One(select="org.verwandlung.voj.judger.mapper.ProblemMapper.getProblem")),
	@Result(property = "uid", column = "uid"),
	@Result(property = "language", column = "language_id", javaType=Language.class, one = @One(select="org.verwandlung.voj.judger.mapper.LanguageMapper.getLanguageUsingId")),
	@Result(property = "submitTime", column = "submission_submit_time"),
	@Result(property = "executeTime", column = "submission_execute_time"),
	@Result(property = "usedTime", column = "submission_used_time"),
	@Result(property = "usedMemory", column = "submission_used_memory"),
	@Result(property = "judgeResultSlug", column = "submission_judge_result"),
	@Result(property = "judgeScore", column = "submission_judge_score"),
	@Result(property = "judgeLog", column = "submission_judge_log"),
	@Result(property = "code", column = "submission_code"),
})
Submission getSubmission(@Param("submissionId") long submissionId);
 

/**
 * 通过试题唯一标识符获取试题对象.
 * @param problemId - 试题的唯一标识符
 * @return 一个试题对象
 */
@Select("SELECT * FROM voj_problems WHERE problem_id = #{problemId}")
@Options(useCache = true)
@Results({
	 @Result(property = "problemId", column = "problem_id"),
	 @Result(property = "isPublic", column = "problem_is_public"),
	 @Result(property = "problemName", column = "problem_name"),
	 @Result(property = "totalSubmission", column = "total_submission"),
	 @Result(property = "acceptedSubmission", column = "accepted_submission"),
	 @Result(property = "timeLimit", column = "problem_time_limit"),
	 @Result(property = "memoryLimit", column = "problem_memory_limit"),
	 @Result(property = "description", column = "problem_description"),
	 @Result(property = "inputFormat", column = "problem_input_format"),
	 @Result(property = "outputFormat", column = "problem_output_format"),
	 @Result(property = "sampleInput", column = "problem_sample_input"),
	 @Result(property = "sampleOutput", column = "problem_sample_output"),
	 @Result(property = "hint", column = "problem_hint")
})
Problem getProblem(@Param("problemId") long problemId);
 

@Insert({
    "insert into mbtest.test_identity",
    "(first_name, last_name)",
    "values(#{firstName,jdbcType=VARCHAR}, #{lastName,jdbcType=VARCHAR})"
})
@Options(keyProperty="id", useGeneratedKeys=true, keyColumn="name_id")
int insertNameAnnotated(Name name);
 

@Insert(
    "INSERT INTO TASK(ID, EXTERNAL_ID, CREATED, CLAIMED, COMPLETED, MODIFIED, PLANNED, DUE, NAME, CREATOR, DESCRIPTION, NOTE, PRIORITY, STATE,  CLASSIFICATION_CATEGORY, CLASSIFICATION_KEY, CLASSIFICATION_ID, WORKBASKET_ID, WORKBASKET_KEY, DOMAIN, BUSINESS_PROCESS_ID, PARENT_BUSINESS_PROCESS_ID, OWNER, POR_COMPANY, "
        + "POR_SYSTEM, POR_INSTANCE, POR_TYPE, POR_VALUE, IS_READ, IS_TRANSFERRED, CALLBACK_INFO, CALLBACK_STATE, CUSTOM_ATTRIBUTES, CUSTOM_1, CUSTOM_2, CUSTOM_3, CUSTOM_4, CUSTOM_5, CUSTOM_6, CUSTOM_7, CUSTOM_8, "
        + "CUSTOM_9, CUSTOM_10, CUSTOM_11,  CUSTOM_12,  CUSTOM_13,  CUSTOM_14,  CUSTOM_15,  CUSTOM_16 ) "
        + "VALUES(#{id},#{externalId}, #{created}, #{claimed}, #{completed}, #{modified}, #{planned}, #{due}, #{name}, #{creator}, #{description}, #{note}, #{priority}, #{state}, #{classificationSummary.category}, "
        + "#{classificationSummary.key}, #{classificationSummary.id}, #{workbasketSummary.id}, #{workbasketSummary.key}, #{workbasketSummary.domain}, #{businessProcessId}, "
        + "#{parentBusinessProcessId}, #{owner}, #{primaryObjRef.company}, #{primaryObjRef.system}, #{primaryObjRef.systemInstance}, #{primaryObjRef.type}, #{primaryObjRef.value}, "
        + "#{isRead}, #{isTransferred}, #{callbackInfo,jdbcType=CLOB,javaType=java.util.Map,typeHandler=pro.taskana.common.internal.persistence.MapTypeHandler}, #{callbackState}, "
        + "#{customAttributes,jdbcType=CLOB,javaType=java.util.Map,typeHandler=pro.taskana.common.internal.persistence.MapTypeHandler}, "
        + "#{custom1}, #{custom2}, #{custom3}, #{custom4}, #{custom5}, #{custom6}, #{custom7}, #{custom8}, #{custom9}, #{custom10}, "
        + "#{custom11}, #{custom12}, #{custom13}, #{custom14}, #{custom15},  #{custom16})")
@Options(keyProperty = "id", keyColumn = "ID")
void insert(TaskImpl task);
 

@Insert({
    "insert into mbtest.test_identity",
    "(first_name, last_name)",
    "values(#{firstName,jdbcType=VARCHAR}, #{lastName,jdbcType=VARCHAR})"
})
@Options(keyProperty="id", useGeneratedKeys=true, keyColumn="name_id")
int insertNameAnnotated(Name name);
 

/**
 * 通过用户名获取用户对象.
 * @param username - 用户名
 * @return 预期的用户对象或空引用
 */
@Select("SELECT * FROM voj_users WHERE username = #{username}")
@Options(useCache = false)
@Results(value = {
	@Result(property = "userGroup", column = "user_group_id", javaType = UserGroup.class, one = @One(select="org.verwandlung.voj.judger.mapper.UserGroupMapper.getUserGroupUsingId")),
	@Result(property = "preferLanguage", column = "prefer_language_id", javaType = Language.class, one = @One(select="org.verwandlung.voj.judger.mapper.LanguageMapper.getLanguageUsingId"))
})
User getUserUsingUsername(@Param("username") String username);
 

/**
 * 获取某个试题的全部测试点.
 * @param problemId - 试题的唯一标识符
 * @return 某个试题的全部测试点
 */
@Select("SELECT * FROM voj_problem_checkpoints WHERE problem_id = #{problemId}")
@Options(useCache = true)
@Results({
	@Result(property = "problemId", column = "problem_id"),
	@Result(property = "checkpointId", column = "checkpoint_id"),
	@Result(property = "isExactlyMatch", column = "checkpoint_exactly_match"),
	@Result(property = "score", column = "checkpoint_score"),
	@Result(property = "input", column = "checkpoint_input"),
	@Result(property = "output", column = "checkpoint_output"),
})
List<Checkpoint> getCheckpointsUsingProblemId(@Param("problemId") long problemId);
 

/**
 * 通过编程语言的唯一标识符获取编程语言对象.
 * @param languageId - 编程语言的唯一标识符
 * @return 预期的编程语言对象或空引用
 */
@Select("SELECT * FROM voj_languages WHERE language_id = #{languageId}")
@Options(useCache = true)
@Results({
	 @Result(property = "languageId", column = "language_id"),
	 @Result(property = "languageSlug", column = "language_slug"),
	 @Result(property = "languageName", column = "language_name"),
	 @Result(property = "compileCommand", column = "language_compile_command"),
	 @Result(property = "runCommand", column = "language_run_command"),
})
Language getLanguageUsingId(@Param("languageId") int languageId);
 

/**
 * 通过编程语言的唯一英文缩写获取编程语言对象.
 * @param languageSlug - 编程语言的唯一英文缩写
 * @return 预期的编程语言对象或空引用
 */
@Select("SELECT * FROM voj_languages WHERE language_slug = #{languageSlug}")
@Options(useCache = true)
@Results({
	 @Result(property = "languageId", column = "language_id"),
	 @Result(property = "languageSlug", column = "language_slug"),
	 @Result(property = "languageName", column = "language_name"),
	 @Result(property = "compileCommand", column = "language_compile_command"),
	 @Result(property = "runCommand", column = "language_run_command"),
})
Language getLanguageUsingSlug(@Param("languageSlug") String languageSlug);
 

/**
 * 通过评测结果的唯一标识符获取评测结果对象.
 * @return 预期的评测结果对象或空引用
 */
@Select("SELECT * FROM voj_judge_results")
@Options(useCache = true)
@Results({
	 @Result(property = "judgeResultId", column = "judge_result_id"),
	 @Result(property = "judgeResultSlug", column = "judge_result_slug"),
	 @Result(property = "judgeResultName", column = "judge_result_name")
})
List<JudgeResult> getAllJudgeResults();
 

/**
 * 通过评测结果的唯一英文缩写获取评测结果对象.
 * @param judgeResultSlug - 评测结果的唯一英文缩写
 * @return 预期的评测结果对象或空引用
 */
@Select("SELECT * FROM voj_judge_results WHERE judge_result_slug = #{judgeResultSlug}")
@Options(useCache = true)
@Results({
	 @Result(property = "judgeResultId", column = "judge_result_id"),
	 @Result(property = "judgeResultSlug", column = "judge_result_slug"),
	 @Result(property = "judgeResultName", column = "judge_result_name")
})
JudgeResult getJudgeResultUsingSlug(@Param("judgeResultSlug") String judgeResultSlug);
 

/**
 * 通过用户组的唯一标识符获取用户组对象.
 * @param userGroupId - 用户组的唯一标识符
 * @return 预期的用户组对象或空引用
 */
@Select("SELECT * FROM voj_user_groups WHERE user_group_id = #{userGroupId}")
@Options(useCache = true)
@Results({
	 @Result(property = "userGroupId", column = "user_group_id"),
	 @Result(property = "userGroupSlug", column = "user_group_slug"),
	 @Result(property = "userGroupName", column = "user_group_name")
})
UserGroup getUserGroupUsingId(@Param("userGroupId") int userGroupId);
 

@Options(useGeneratedKeys = true, keyProperty = "id")
@Insert("insert into sys_sms(phone, signName, templateCode, params, day, createTime, updateTime) "
		+ "values(#{phone}, #{signName}, #{templateCode}, #{params}, #{day}, #{createTime}, #{updateTime})")
int save(Sms sms);
 

@Options(useGeneratedKeys = true, keyProperty = "id")
@Insert("insert into sys_permission(permission, name, createTime, updateTime) values(#{permission}, #{name}, #{createTime}, #{createTime})")
int save(SysPermission sysPermission);
 

@Options(useGeneratedKeys = true, keyProperty = "id")
@Insert("insert into sys_user(username, password, nickname, headImgUrl, phone, sex, enabled, type, createTime, updateTime) "
		+ "values(#{username}, #{password}, #{nickname}, #{headImgUrl}, #{phone}, #{sex}, #{enabled}, #{type}, #{createTime}, #{updateTime})")
int save(SysUser sysUser);
 

@Options(useGeneratedKeys = true, keyProperty = "id")
@Insert("insert into sys_role(code, name, createTime, updateTime) values(#{code}, #{name}, #{createTime}, #{createTime})")
int save(SysRole sysRole);
 

@Options(useGeneratedKeys = true, keyProperty = "id")
@Insert("insert into t_mail(userId, username, toEmail, subject, content, status, createTime, updateTime) values(#{userId}, #{username}, #{toEmail}, #{subject}, #{content}, #{status}, #{createTime}, #{updateTime})")
int save(Mail mail);
 

@Select("{call sptest.getname(#{id,jdbcType=INTEGER,mode=IN})}")
@Results({ @Result(column = "ID", property = "id"), @Result(column = "FIRST_NAME", property = "firstName"), @Result(column = "LAST_NAME", property = "lastName") })
@Options(statementType = StatementType.CALLABLE)
Name getNameAnnotated(Integer id);
 

@Options(useGeneratedKeys = true, keyProperty = "id")
@Insert("insert into sys_permission(permission, name, createTime, updateTime) values(#{permission}, #{name}, #{createTime}, #{createTime})")
int save(SysPermission sysPermission);
 

@Options(useGeneratedKeys = true, keyProperty = "id")
@Insert("insert into app_user(username, password, nickname, headImgUrl, phone, sex, enabled, type, createTime, updateTime) "
		+ "values(#{username}, #{password}, #{nickname}, #{headImgUrl}, #{phone}, #{sex}, #{enabled}, #{type}, #{createTime}, #{updateTime})")
int save(AppUser appUser);
 

@Options(useGeneratedKeys = true, keyProperty = "id")
@Insert("insert into sys_role(code, name, createTime, updateTime) values(#{code}, #{name}, #{createTime}, #{createTime})")
int save(SysRole sysRole);
 

@Options(useGeneratedKeys = true, keyProperty = "id")
@Insert("insert into t_wechat(openid, unionid, userId, app, nickname, sex, province, city, country, headimgurl, createTime, updateTime) " +
        "values(#{openid}, #{unionid}, #{userId}, #{app}, #{nickname}, #{sex}, #{province}, #{city}, #{country}, #{headimgurl}, #{createTime}, #{updateTime})")
int save(WechatUserInfo info);
 

@Insert("insert into sys_role (role_name,role_code,role_desc,ds_type,ds_scope) values (#{roleName}, #{roleCode},#{roleDesc},#{dsType},#{dsScope})")
@Options(useGeneratedKeys=true, keyProperty="roleId", keyColumn="role_id")
Boolean insertRole(SysRole sysRole);
 

@Insert("insert into sys_user (username,password,dept_id,job_id,phone,email,avatar,lock_flag) values (#{username},#{password},#{deptId},#{jobId},#{phone},#{email},#{avatar},#{lockFlag})")
@Options(useGeneratedKeys = true, keyProperty = "userId", keyColumn = "user_id")
boolean insertUser(SysUser sysUser);
 

/**
 * 插入功能
 */
@Insert("insert ingrid_method(methodName,document,poolName,outParam,sqlType,rsStatus)values(#{methodBean.methodName},#{methodBean.document},#{methodBean.poolName},#{methodBean.outParam},#{methodBean.sqlType},#{methodBean.rsStatus})")
@Options(useGeneratedKeys = true, keyProperty = "methodBean.methodId")
public void insertMethodBean(@Param("method") MethodBean methodBean);
 

@Options(useGeneratedKeys = true, keyProperty = "id", keyColumn = "id")
@InsertProvider(type = SpecialProvider.class, method = "dynamicSQL")
int insertList(List<T> recordList);
 

@Options(useGeneratedKeys = true)
@InsertProvider(type = SqlServerProvider.class, method = "dynamicSQL")
int insertSelective(T record);
 

@Insert("INSERT INTO role_binding (name, description, user_id, role_id) " +
        "VALUES (#{name}, #{description}, #{userId}, #{roleId})")
@Options(useGeneratedKeys=true, keyProperty="roleBindingId", keyColumn="role_binding_id")
long insert(RoleBindingEntity roleBindingEntity);
 

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

@Insert("INSERT INTO users (access_token, name, description, email, phone_number" +
        ", location, company, expire, password)" +
        "VALUES (#{accessToken}, #{name}, #{description}, #{email}, #{phoneNumber}" +
        ", #{location}, #{company}, #{expire}, #{password})")
@Options(useGeneratedKeys=true, keyProperty="userId", keyColumn="user_id")
long save(UserInfoEntity userInfoEntity);