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

项目：voj 文件：SubmissionMapper.java

/**
 * 通过评测记录唯一标识符获取试题对象.
 * @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);

项目：voj 文件：ProblemMapper.java

/**
 * 通过试题唯一标识符获取试题对象.
 * @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);

项目：sqlapp 文件：MailLogMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table MAIL_LOG
 *
 * @mbggenerated
 */
@Insert({
    "insert into MAIL_LOG (LAUNCHED_BY, LAUNCHED_AT, ",
    "MAIL_STATUS, MESSAGE_NAME, ",
    "SCHEDULED_AT, SENT_AT, ",
    "FROM_ADDR, SUBJECT, ",
    "BODY, UPDATED_AT, ",
    "CREATED_AT, LOCK_VERSION, ",
    "DELETED_FLG)",
    "values (#{launchedBy,jdbcType=VARCHAR}, #{launchedAt,jdbcType=TIMESTAMP}, ",
    "#{mailStatus,jdbcType=INTEGER}, #{messageName,jdbcType=VARCHAR}, ",
    "#{scheduledAt,jdbcType=TIMESTAMP}, #{sentAt,jdbcType=TIMESTAMP}, ",
    "#{fromAddr,jdbcType=VARCHAR}, #{subject,jdbcType=VARCHAR}, ",
    "#{body,jdbcType=VARCHAR}, #{updatedAt,jdbcType=TIMESTAMP}, ",
    "#{createdAt,jdbcType=TIMESTAMP}, #{lockVersion,jdbcType=INTEGER}, ",
    "#{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(MailLog record);

项目：sqlapp 文件：SqltoolClauseMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table SQLTOOL_CLAUSE
 *
 * @mbggenerated
 */
@Insert({
    "insert into SQLTOOL_CLAUSE (DATABASE_NAME, SELECT_CLAUSE, ",
    "FROM_CLAUSE, WHERE_CLAUSE, ",
    "GROUP_BY_CLAUSE, HAVING_CLAUSE, ",
    "ORDER_BY_CLAUSE, PARAM_MAP, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{databaseName,jdbcType=VARCHAR}, #{selectClause,jdbcType=VARCHAR}, ",
    "#{fromClause,jdbcType=VARCHAR}, #{whereClause,jdbcType=VARCHAR}, ",
    "#{groupByClause,jdbcType=VARCHAR}, #{havingClause,jdbcType=VARCHAR}, ",
    "#{orderByClause,jdbcType=VARCHAR}, #{paramMap,jdbcType=VARCHAR}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(SqltoolClause record);

项目：sqlapp 文件：AsyncProcessMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table ASYNC_PROCESS
 *
 * @mbggenerated
 */
@Insert({
    "insert into ASYNC_PROCESS (LAUNCHED_BY, DESCRIPTION, ",
    "ASYNC_TYPE, ASYNC_STATUS, ",
    "REGISTERED_AT, LAUNCHED_AT, ",
    "STARTED_AT, FINISHED_AT, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{launchedBy,jdbcType=VARCHAR}, #{description,jdbcType=VARCHAR}, ",
    "#{asyncType,jdbcType=VARCHAR}, #{asyncStatus,jdbcType=VARCHAR}, ",
    "#{registeredAt,jdbcType=TIMESTAMP}, #{launchedAt,jdbcType=TIMESTAMP}, ",
    "#{startedAt,jdbcType=TIMESTAMP}, #{finishedAt,jdbcType=TIMESTAMP}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(AsyncProcess record);

项目：sqlapp 文件：MailRcptMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table MAIL_RCPT
 *
 * @mbggenerated
 */
@Insert({
    "insert into MAIL_RCPT (MAIL_ID, RCPT_TYPE, ",
    "RCPT_ADDR, UPDATED_AT, ",
    "CREATED_AT, LOCK_VERSION, ",
    "DELETED_FLG)",
    "values (#{mailId,jdbcType=BIGINT}, #{rcptType,jdbcType=VARCHAR}, ",
    "#{rcptAddr,jdbcType=VARCHAR}, #{updatedAt,jdbcType=TIMESTAMP}, ",
    "#{createdAt,jdbcType=TIMESTAMP}, #{lockVersion,jdbcType=INTEGER}, ",
    "#{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(MailRcpt record);

项目：springapp 文件：MailLogMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table MAIL_LOG
 *
 * @mbggenerated
 */
@Insert({
    "insert into MAIL_LOG (LAUNCHED_BY, LAUNCHED_AT, ",
    "MAIL_STATUS, MESSAGE_NAME, ",
    "SCHEDULED_AT, SENT_AT, ",
    "FROM_ADDR, REPLY_TO_ADDR, ",
    "SUBJECT, BODY, UPDATED_AT, ",
    "CREATED_AT, LOCK_VERSION, ",
    "DELETED_FLG)",
    "values (#{launchedBy,jdbcType=VARCHAR}, #{launchedAt,jdbcType=TIMESTAMP}, ",
    "#{mailStatus,jdbcType=INTEGER}, #{messageName,jdbcType=VARCHAR}, ",
    "#{scheduledAt,jdbcType=TIMESTAMP}, #{sentAt,jdbcType=TIMESTAMP}, ",
    "#{fromAddr,jdbcType=VARCHAR}, #{replyToAddr,jdbcType=VARCHAR}, ",
    "#{subject,jdbcType=VARCHAR}, #{body,jdbcType=VARCHAR}, #{updatedAt,jdbcType=TIMESTAMP}, ",
    "#{createdAt,jdbcType=TIMESTAMP}, #{lockVersion,jdbcType=INTEGER}, ",
    "#{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(MailLog record);

项目：springapp 文件：ZipcdMasterMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table ZIPCD_MASTER
 *
 * @mbggenerated
 */
@Insert({
    "insert into ZIPCD_MASTER (CITY_CD, ZIPCD, ",
    "PREF, CITY, ADDR, ",
    "PREF_KANA, CITY_KANA, ",
    "ADDR_KANA, UPDATED_AT, ",
    "CREATED_AT, LOCK_VERSION, ",
    "DELETED_FLG)",
    "values (#{cityCd,jdbcType=INTEGER}, #{zipcd,jdbcType=VARCHAR}, ",
    "#{pref,jdbcType=VARCHAR}, #{city,jdbcType=VARCHAR}, #{addr,jdbcType=VARCHAR}, ",
    "#{prefKana,jdbcType=VARCHAR}, #{cityKana,jdbcType=VARCHAR}, ",
    "#{addrKana,jdbcType=VARCHAR}, #{updatedAt,jdbcType=TIMESTAMP}, ",
    "#{createdAt,jdbcType=TIMESTAMP}, #{lockVersion,jdbcType=INTEGER}, ",
    "#{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(ZipcdMaster record);

项目：springapp 文件：AsyncProcessMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table ASYNC_PROCESS
 *
 * @mbggenerated
 */
@Insert({
    "insert into ASYNC_PROCESS (LAUNCHED_BY, DESCRIPTION, ",
    "ASYNC_TYPE, ASYNC_STATUS, ",
    "REGISTERED_AT, LAUNCHED_AT, ",
    "STARTED_AT, FINISHED_AT, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{launchedBy,jdbcType=VARCHAR}, #{description,jdbcType=VARCHAR}, ",
    "#{asyncType,jdbcType=VARCHAR}, #{asyncStatus,jdbcType=VARCHAR}, ",
    "#{registeredAt,jdbcType=TIMESTAMP}, #{launchedAt,jdbcType=TIMESTAMP}, ",
    "#{startedAt,jdbcType=TIMESTAMP}, #{finishedAt,jdbcType=TIMESTAMP}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(AsyncProcess record);

项目：MybatisCode 文件：InsertMapper.java

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

项目：mybatis 文件：InsertMapper.java

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

项目：mybaties 文件：InsertMapper.java

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

项目：locationstore 文件：LocationMapper.java

@Insert({
    "insert into location (username, instant, latitude, longitude) values (",
    "lower(#{username}),",
    "#{location.instant,javaType=java.time.LocalDateTime,jdbcType=TIMESTAMP},",
    "#{location.latitude},",
    "#{location.longitude}",
    ")"
})
@Options(useGeneratedKeys = true, keyProperty = "location.id")
void insert(@Param("username") String username, @Param("location") Location location);

项目：play 文件：InsertMapper.java

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

项目：voj 文件：UserMapper.java

/**
 * 通过用户名获取用户对象.
 * @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);

项目：voj 文件：CheckpointMapper.java

/**
 * 获取某个试题的全部测试点.
 * @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);

项目：voj 文件：LanguageMapper.java

/**
 * 通过编程语言的唯一标识符获取编程语言对象.
 * @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);

项目：voj 文件：LanguageMapper.java

/**
 * 通过编程语言的唯一英文缩写获取编程语言对象.
 * @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);

项目：voj 文件：LanguageMapper.java

/**
 * 获取支持的编程语言.
 * @return 编程语言列表(List<Language>对象)
 */
@Select("SELECT * FROM voj_languages")
@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"),
})
List<Language> getAllLanguages();

项目：voj 文件：JudgeResultMapper.java

/**
 * 通过评测结果的唯一标识符获取评测结果对象.
 * @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();

项目：voj 文件：JudgeResultMapper.java

/**
 * 通过评测结果的唯一英文缩写获取评测结果对象.
 * @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);

项目：voj 文件：UserGroupMapper.java

/**
 * 通过用户组的唯一标识符获取用户组对象.
 * @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);

项目：sqlapp 文件：BizdatetimeMasterMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table BIZDATETIME_MASTER
 *
 * @mbggenerated
 */
@Insert({
    "insert into BIZDATETIME_MASTER (BIZDATE, OFFSET_DAY, ",
    "OFFSET_HOUR, OFFSET_MINUTE, ",
    "OFFSET_SECOND, UPDATED_AT, ",
    "CREATED_AT, LOCK_VERSION, ",
    "DELETED_FLG)",
    "values (#{bizdate,jdbcType=DATE}, #{offsetDay,jdbcType=INTEGER}, ",
    "#{offsetHour,jdbcType=INTEGER}, #{offsetMinute,jdbcType=INTEGER}, ",
    "#{offsetSecond,jdbcType=INTEGER}, #{updatedAt,jdbcType=TIMESTAMP}, ",
    "#{createdAt,jdbcType=TIMESTAMP}, #{lockVersion,jdbcType=INTEGER}, ",
    "#{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(BizdatetimeMaster record);

项目：sqlapp 文件：MailTemplateMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table MAIL_TEMPLATE
 *
 * @mbggenerated
 */
@Insert({
    "insert into MAIL_TEMPLATE (TEMPLATE_NAME, FROM_ADDR, ",
    "SUBJECT, BODY, UPDATED_AT, ",
    "CREATED_AT, LOCK_VERSION, ",
    "DELETED_FLG)",
    "values (#{templateName,jdbcType=VARCHAR}, #{fromAddr,jdbcType=VARCHAR}, ",
    "#{subject,jdbcType=VARCHAR}, #{body,jdbcType=VARCHAR}, #{updatedAt,jdbcType=TIMESTAMP}, ",
    "#{createdAt,jdbcType=TIMESTAMP}, #{lockVersion,jdbcType=INTEGER}, ",
    "#{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(MailTemplate record);

项目：sqlapp 文件：SqltoolMetadataMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table SQLTOOL_METADATA
 *
 * @mbggenerated
 */
@Insert({
    "insert into SQLTOOL_METADATA (SQL_TYPE, NAME, ",
    "DESCRIPTION, OWNED_BY, ",
    "PUBLISHED_FLG, REGISTERED_AT, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{sqlType,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, ",
    "#{description,jdbcType=VARCHAR}, #{ownedBy,jdbcType=VARCHAR}, ",
    "#{publishedFlg,jdbcType=INTEGER}, #{registeredAt,jdbcType=TIMESTAMP}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(SqltoolMetadata record);

项目：springapp 文件：CodeMasterMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table CODE_MASTER
 *
 * @mbggenerated
 */
@Insert({
    "insert into CODE_MASTER (NAME, VALUE, ",
    "LABEL, SORT_ORDER, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{name,jdbcType=VARCHAR}, #{value,jdbcType=VARCHAR}, ",
    "#{label,jdbcType=VARCHAR}, #{sortOrder,jdbcType=INTEGER}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(CodeMaster record);

项目：sqlapp 文件：MailTemplateRcptMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table MAIL_TEMPLATE_RCPT
 *
 * @mbggenerated
 */
@Insert({
    "insert into MAIL_TEMPLATE_RCPT (TEMPLATE_ID, RCPT_TYPE, ",
    "RCPT_ADDR, UPDATED_AT, ",
    "CREATED_AT, LOCK_VERSION, ",
    "DELETED_FLG)",
    "values (#{templateId,jdbcType=BIGINT}, #{rcptType,jdbcType=VARCHAR}, ",
    "#{rcptAddr,jdbcType=VARCHAR}, #{updatedAt,jdbcType=TIMESTAMP}, ",
    "#{createdAt,jdbcType=TIMESTAMP}, #{lockVersion,jdbcType=INTEGER}, ",
    "#{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(MailTemplateRcpt record);

项目：sqlapp 文件：SqltoolLoadMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table SQLTOOL_LOAD
 *
 * @mbggenerated
 */
@Insert({
    "insert into SQLTOOL_LOAD (DATABASE_NAME, QUERY, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{databaseName,jdbcType=VARCHAR}, #{query,jdbcType=VARCHAR}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(SqltoolLoad record);

项目：sqlapp 文件：AsyncProcessExceptionMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table ASYNC_PROCESS_EXCEPTION
 *
 * @mbggenerated
 */
@Insert({
    "insert into ASYNC_PROCESS_EXCEPTION (ASYNC_ID, UPDATED_AT, ",
    "CREATED_AT, LOCK_VERSION, ",
    "DELETED_FLG, EXCEPTION)",
    "values (#{asyncId,jdbcType=BIGINT}, #{updatedAt,jdbcType=TIMESTAMP}, ",
    "#{createdAt,jdbcType=TIMESTAMP}, #{lockVersion,jdbcType=INTEGER}, ",
    "#{deletedFlg,jdbcType=INTEGER}, #{exception,jdbcType=CLOB})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(AsyncProcessException record);

项目：sqlapp 文件：AsyncProcessFileResultMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table ASYNC_PROCESS_FILE_RESULT
 *
 * @mbggenerated
 */
@Insert({
    "insert into ASYNC_PROCESS_FILE_RESULT (ASYNC_ID, TOTAL_COUNT, ",
    "OK_COUNT, NG_COUNT, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{asyncId,jdbcType=BIGINT}, #{totalCount,jdbcType=BIGINT}, ",
    "#{okCount,jdbcType=BIGINT}, #{ngCount,jdbcType=BIGINT}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(AsyncProcessFileResult record);

项目：sqlapp 文件：AsyncProcessCommandResultMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table ASYNC_PROCESS_COMMAND_RESULT
 *
 * @mbggenerated
 */
@Insert({
    "insert into ASYNC_PROCESS_COMMAND_RESULT (ASYNC_ID, EXIT_VALUE, ",
    "STDOUT, STDERR, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{asyncId,jdbcType=BIGINT}, #{exitValue,jdbcType=INTEGER}, ",
    "#{stdout,jdbcType=VARCHAR}, #{stderr,jdbcType=VARCHAR}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(AsyncProcessCommandResult record);

项目：sqlapp 文件：AsyncProcessFileResultDetailMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table ASYNC_PROCESS_FILE_RESULT_DETAIL
 *
 * @mbggenerated
 */
@Insert({
    "insert into ASYNC_PROCESS_FILE_RESULT_DETAIL (ASYNC_ID, RECORD_NUMBER, ",
    "DESCRIPTION, UPDATED_AT, ",
    "CREATED_AT, LOCK_VERSION, ",
    "DELETED_FLG)",
    "values (#{asyncId,jdbcType=BIGINT}, #{recordNumber,jdbcType=BIGINT}, ",
    "#{description,jdbcType=VARCHAR}, #{updatedAt,jdbcType=TIMESTAMP}, ",
    "#{createdAt,jdbcType=TIMESTAMP}, #{lockVersion,jdbcType=INTEGER}, ",
    "#{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(AsyncProcessFileResultDetail record);

项目：sqlapp 文件：SqltoolStatementMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table SQLTOOL_STATEMENT
 *
 * @mbggenerated
 */
@Insert({
    "insert into SQLTOOL_STATEMENT (DATABASE_NAME, QUERY, ",
    "PARAM_MAP, UPDATED_AT, ",
    "CREATED_AT, LOCK_VERSION, ",
    "DELETED_FLG)",
    "values (#{databaseName,jdbcType=VARCHAR}, #{query,jdbcType=VARCHAR}, ",
    "#{paramMap,jdbcType=VARCHAR}, #{updatedAt,jdbcType=TIMESTAMP}, ",
    "#{createdAt,jdbcType=TIMESTAMP}, #{lockVersion,jdbcType=INTEGER}, ",
    "#{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(SqltoolStatement record);

项目：sqlapp 文件：AsyncProcessCommandArgMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table ASYNC_PROCESS_COMMAND_ARG
 *
 * @mbggenerated
 */
@Insert({
    "insert into ASYNC_PROCESS_COMMAND_ARG (ASYNC_ID, ARGUMENT, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{asyncId,jdbcType=BIGINT}, #{argument,jdbcType=VARCHAR}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(AsyncProcessCommandArg record);

项目：sqlapp 文件：MailQueueMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table MAIL_QUEUE
 *
 * @mbggenerated
 */
@Insert({
    "insert into MAIL_QUEUE (MAIL_ID, SCHEDULED_AT, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{mailId,jdbcType=BIGINT}, #{scheduledAt,jdbcType=TIMESTAMP}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(MailQueue record);

项目：sqlapp 文件：AsyncProcessFileArgMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table ASYNC_PROCESS_FILE_ARG
 *
 * @mbggenerated
 */
@Insert({
    "insert into ASYNC_PROCESS_FILE_ARG (ASYNC_ID, ARGUMENT, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{asyncId,jdbcType=BIGINT}, #{argument,jdbcType=VARCHAR}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(AsyncProcessFileArg record);

项目：sqlapp 文件：AsyncProcessCommandMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table ASYNC_PROCESS_COMMAND
 *
 * @mbggenerated
 */
@Insert({
    "insert into ASYNC_PROCESS_COMMAND (ASYNC_ID, COMMAND, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{asyncId,jdbcType=BIGINT}, #{command,jdbcType=VARCHAR}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(AsyncProcessCommand record);

项目：springapp 文件：MailRcptMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table MAIL_RCPT
 *
 * @mbggenerated
 */
@Insert({
    "insert into MAIL_RCPT (MAIL_ID, RCPT_TYPE, ",
    "RCPT_ADDR, UPDATED_AT, ",
    "CREATED_AT, LOCK_VERSION, ",
    "DELETED_FLG)",
    "values (#{mailId,jdbcType=BIGINT}, #{rcptType,jdbcType=VARCHAR}, ",
    "#{rcptAddr,jdbcType=VARCHAR}, #{updatedAt,jdbcType=TIMESTAMP}, ",
    "#{createdAt,jdbcType=TIMESTAMP}, #{lockVersion,jdbcType=INTEGER}, ",
    "#{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(MailRcpt record);

项目：springapp 文件：AsyncProcessFileArgMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table ASYNC_PROCESS_FILE_ARG
 *
 * @mbggenerated
 */
@Insert({
    "insert into ASYNC_PROCESS_FILE_ARG (ASYNC_ID, ARGUMENT, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{asyncId,jdbcType=BIGINT}, #{argument,jdbcType=VARCHAR}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(AsyncProcessFileArg record);

项目：springapp 文件：AsyncProcessCommandMapper.java

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table ASYNC_PROCESS_COMMAND
 *
 * @mbggenerated
 */
@Insert({
    "insert into ASYNC_PROCESS_COMMAND (ASYNC_ID, COMMAND, ",
    "UPDATED_AT, CREATED_AT, ",
    "LOCK_VERSION, DELETED_FLG)",
    "values (#{asyncId,jdbcType=BIGINT}, #{command,jdbcType=VARCHAR}, ",
    "#{updatedAt,jdbcType=TIMESTAMP}, #{createdAt,jdbcType=TIMESTAMP}, ",
    "#{lockVersion,jdbcType=INTEGER}, #{deletedFlg,jdbcType=INTEGER})"
})
@Options(useGeneratedKeys=true,keyProperty="id")
int insert(AsyncProcessCommand record);