job: 优化mapper xml

zhanghl

2025-05-15 0db09602a14cd08c513a97f8ca60f419e5e438ad

job: 优化mapper xml

 aps-modules/aps-job/src/main/resources/bootstrap.yml

@@ -9,4 +9,4 @@
    name: aps-job
  profiles:
    # 环境配置
    active: dev
    active: int

 aps-modules/aps-job/src/main/resources/mapper/job/ApsBomHeaderJobMapper.xml

@@ -4,7 +4,7 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.job.mapper.ApsBomHeaderJobMapper">
    
    <resultMap type="ApsBomHeaderJob" id="ApsBomHeaderJobResult">
    <resultMap type="com.aps.job.domain.ApsBomHeaderJob" id="ApsBomHeaderJobResult">
        <result property="id"    column="id"    />
        <result property="bomHeaderId"    column="bom_header_id"    />
        <result property="itemCode"    column="item_code"    />
@@ -23,7 +23,7 @@
        select id, bom_header_id, item_code, item_name, start_date, end_date, org_code, del_flag, create_by, create_time, update_by, update_time from aps_bom_header_job
    </sql>

    <select id="selectApsBomHeaderJobList" parameterType="ApsBomHeaderJob" resultMap="ApsBomHeaderJobResult">
    <select id="selectApsBomHeaderJobList" parameterType="com.aps.job.domain.ApsBomHeaderJob" resultMap="ApsBomHeaderJobResult">
        <include refid="selectApsBomHeaderJobVo"/>
        <where>  
            <if test="bomHeaderId != null  and bomHeaderId != ''"> and bom_header_id = #{bomHeaderId}</if>
@@ -40,7 +40,7 @@
        where id = #{id}
    </select>

    <insert id="insertApsBomHeaderJob" parameterType="ApsBomHeaderJob">
    <insert id="insertApsBomHeaderJob" parameterType="com.aps.job.domain.ApsBomHeaderJob">
        insert into aps_bom_header_job
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
@@ -72,7 +72,7 @@
         </trim>
    </insert>

    <update id="updateApsBomHeaderJob" parameterType="ApsBomHeaderJob">
    <update id="updateApsBomHeaderJob" parameterType="com.aps.job.domain.ApsBomHeaderJob">
        update aps_bom_header_job
        <trim prefix="SET" suffixOverrides=",">
            <if test="bomHeaderId != null">bom_header_id = #{bomHeaderId},</if>

 aps-modules/aps-job/src/main/resources/mapper/job/ApsBomLineJobMapper.xml

@@ -4,7 +4,7 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.job.mapper.ApsBomLineJobMapper">
    
    <resultMap type="ApsBomLineJob" id="ApsBomLineJobResult">
    <resultMap type="com.aps.job.domain.ApsBomLineJob" id="ApsBomLineJobResult">
        <result property="id"    column="id"    />
        <result property="bomLineId"    column="bom_line_id"    />
        <result property="bomHeaderId"    column="bom_header_id"    />
@@ -31,7 +31,7 @@
        select id, bom_line_id, bom_header_id, item_code, item_name, start_date, end_date, org_code, del_flag, create_by, create_time, update_by, update_time, drawing_no, process_no, unit, num, total_num, preparation_time, processing_time from aps_bom_line_job
    </sql>

    <select id="selectApsBomLineJobList" parameterType="ApsBomLineJob" resultMap="ApsBomLineJobResult">
    <select id="selectApsBomLineJobList" parameterType="com.aps.job.domain.ApsBomLineJob" resultMap="ApsBomLineJobResult">
        <include refid="selectApsBomLineJobVo"/>
        <where>  
            <if test="bomLineId != null  and bomLineId != ''"> and bom_line_id = #{bomLineId}</if>
@@ -56,7 +56,7 @@
        where id = #{id}
    </select>

    <insert id="insertApsBomLineJob" parameterType="ApsBomLineJob">
    <insert id="insertApsBomLineJob" parameterType="com.aps.job.domain.ApsBomLineJob">
        insert into aps_bom_line_job
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
@@ -104,7 +104,7 @@
         </trim>
    </insert>

    <update id="updateApsBomLineJob" parameterType="ApsBomLineJob">
    <update id="updateApsBomLineJob" parameterType="com.aps.job.domain.ApsBomLineJob">
        update aps_bom_line_job
        <trim prefix="SET" suffixOverrides=",">
            <if test="bomLineId != null">bom_line_id = #{bomLineId},</if>

 aps-modules/aps-job/src/main/resources/mapper/job/ApsMaterialManagementJobMapper.xml

@@ -4,7 +4,7 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.job.mapper.ApsMaterialManagementJobMapper">
    
    <resultMap type="ApsMaterialManagementJob" id="ApsMaterialManagementJobResult">
    <resultMap type="com.aps.job.domain.ApsMaterialManagementJob" id="ApsMaterialManagementJobResult">
        <result property="id"    column="id"    />
        <result property="itemNumber"    column="item_number"    />
        <result property="materialDescription"    column="material_description"    />
@@ -31,7 +31,7 @@
        select id, item_number, material_description, material_status, material_type, professional_affiliation, drawing_no, version_number, advance_production_days, split_batch, self_made, applicable_factories, applicable_workshop, effective_date, expiring_date, integration_date, create_by, create_time, update_by, update_time from aps_material_management_job
    </sql>

    <select id="selectApsMaterialManagementJobList" parameterType="ApsMaterialManagementJob" resultMap="ApsMaterialManagementJobResult">
    <select id="selectApsMaterialManagementJobList" parameterType="com.aps.job.domain.ApsMaterialManagementJob" resultMap="ApsMaterialManagementJobResult">
        <include refid="selectApsMaterialManagementJobVo"/>
        <where>  
            <if test="itemNumber != null  and itemNumber != ''"> and item_number = #{itemNumber}</if>
@@ -57,7 +57,7 @@
        where id = #{id}
    </select>

    <insert id="insertApsMaterialManagementJob" parameterType="ApsMaterialManagementJob">
    <insert id="insertApsMaterialManagementJob" parameterType="com.aps.job.domain.ApsMaterialManagementJob">
        insert into aps_material_management_job
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
@@ -105,7 +105,7 @@
         </trim>
    </insert>

    <update id="updateApsMaterialManagementJob" parameterType="ApsMaterialManagementJob">
    <update id="updateApsMaterialManagementJob" parameterType="com.aps.job.domain.ApsMaterialManagementJob">
        update aps_material_management_job
        <trim prefix="SET" suffixOverrides=",">
            <if test="itemNumber != null">item_number = #{itemNumber},</if>

 aps-modules/aps-job/src/main/resources/mapper/job/ApsMaterialStorageManagementJobMapper.xml

@@ -4,7 +4,7 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.job.mapper.ApsMaterialStorageManagementJobMapper">
    
    <resultMap type="ApsMaterialStorageManagementJob" id="ApsMaterialStorageManagementJobResult">
    <resultMap type="com.aps.job.domain.ApsMaterialStorageManagementJob" id="ApsMaterialStorageManagementJobResult">
        <result property="id"    column="id"    />
        <result property="itemNumber"    column="item_number"    />
        <result property="num"    column="num"    />
@@ -23,7 +23,7 @@
        select id, item_number, num, applicable_factories, integration_date, refresh_date, create_by, create_time, update_by, update_time, remainder_stock, version from aps_material_storage_management_job
    </sql>

    <select id="selectApsMaterialStorageManagementJobList" parameterType="ApsMaterialStorageManagementJob" resultMap="ApsMaterialStorageManagementJobResult">
    <select id="selectApsMaterialStorageManagementJobList" parameterType="com.aps.job.domain.ApsMaterialStorageManagementJob" resultMap="ApsMaterialStorageManagementJobResult">
        <include refid="selectApsMaterialStorageManagementJobVo"/>
        <where>  
            <if test="itemNumber != null  and itemNumber != ''"> and item_number = #{itemNumber}</if>
@@ -41,7 +41,7 @@
        where id = #{id}
    </select>

    <insert id="insertApsMaterialStorageManagementJob" parameterType="ApsMaterialStorageManagementJob">
    <insert id="insertApsMaterialStorageManagementJob" parameterType="com.aps.job.domain.ApsMaterialStorageManagementJob">
        insert into aps_material_storage_management_job
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
@@ -73,7 +73,7 @@
         </trim>
    </insert>

    <update id="updateApsMaterialStorageManagementJob" parameterType="ApsMaterialStorageManagementJob">
    <update id="updateApsMaterialStorageManagementJob" parameterType="com.aps.job.domain.ApsMaterialStorageManagementJob">
        update aps_material_storage_management_job
        <trim prefix="SET" suffixOverrides=",">
            <if test="itemNumber != null">item_number = #{itemNumber},</if>

 aps-modules/aps-job/src/main/resources/mapper/job/ApsStandardProcessRouteHeaderJobMapper.xml

@@ -4,7 +4,7 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.job.mapper.ApsStandardProcessRouteHeaderJobMapper">
    
    <resultMap type="ApsStandardProcessRouteHeaderJob" id="ApsStandardProcessRouteHeaderJobResult">
    <resultMap type="com.aps.job.domain.ApsStandardProcessRouteHeaderJob" id="ApsStandardProcessRouteHeaderJobResult">
        <result property="id"    column="id"    />
        <result property="routeId"    column="route_id"    />
        <result property="version"    column="version"    />
@@ -25,7 +25,7 @@
        select id, route_id, version, start_date, end_date, org_code, del_flag, create_by, create_time, update_by, update_time, item_code, drawing_number, process_all_time from aps_standard_process_route_header_job
    </sql>

    <select id="selectApsStandardProcessRouteHeaderJobList" parameterType="ApsStandardProcessRouteHeaderJob" resultMap="ApsStandardProcessRouteHeaderJobResult">
    <select id="selectApsStandardProcessRouteHeaderJobList" parameterType="com.aps.job.domain.ApsStandardProcessRouteHeaderJob" resultMap="ApsStandardProcessRouteHeaderJobResult">
        <include refid="selectApsStandardProcessRouteHeaderJobVo"/>
        <where>  
            <if test="routeId != null  and routeId != ''"> and route_id = #{routeId}</if>
@@ -44,7 +44,7 @@
        where id = #{id}
    </select>

    <insert id="insertApsStandardProcessRouteHeaderJob" parameterType="ApsStandardProcessRouteHeaderJob">
    <insert id="insertApsStandardProcessRouteHeaderJob" parameterType="com.aps.job.domain.ApsStandardProcessRouteHeaderJob">
        insert into aps_standard_process_route_header_job
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
@@ -80,7 +80,7 @@
         </trim>
    </insert>

    <update id="updateApsStandardProcessRouteHeaderJob" parameterType="ApsStandardProcessRouteHeaderJob">
    <update id="updateApsStandardProcessRouteHeaderJob" parameterType="com.aps.job.domain.ApsStandardProcessRouteHeaderJob">
        update aps_standard_process_route_header_job
        <trim prefix="SET" suffixOverrides=",">
            <if test="routeId != null">route_id = #{routeId},</if>

 aps-modules/aps-job/src/main/resources/mapper/job/ApsStandardProcessRouteLineJobMapper.xml

@@ -4,7 +4,7 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.job.mapper.ApsStandardProcessRouteLineJobMapper">
    
    <resultMap type="ApsStandardProcessRouteLineJob" id="ApsStandardProcessRouteLineJobResult">
    <resultMap type="com.aps.job.domain.ApsStandardProcessRouteLineJob" id="ApsStandardProcessRouteLineJobResult">
        <result property="id"    column="id"    />
        <result property="routeId"    column="route_id"    />
        <result property="routeNum"    column="route_num"    />
@@ -28,7 +28,7 @@
        select id, route_id, route_num, route_name, start_date, end_date, create_time, org_code, shop_code, productivity_model, design_capacity, del_flag, create_by, update_by, update_time, route_code, standard_time from aps_standard_process_route_line_job
    </sql>

    <select id="selectApsStandardProcessRouteLineJobList" parameterType="ApsStandardProcessRouteLineJob" resultMap="ApsStandardProcessRouteLineJobResult">
    <select id="selectApsStandardProcessRouteLineJobList" parameterType="com.aps.job.domain.ApsStandardProcessRouteLineJob" resultMap="ApsStandardProcessRouteLineJobResult">
        <include refid="selectApsStandardProcessRouteLineJobVo"/>
        <where>  
            <if test="routeId != null  and routeId != ''"> and route_id = #{routeId}</if>
@@ -48,7 +48,7 @@
        where id = #{id}
    </select>

    <insert id="insertApsStandardProcessRouteLineJob" parameterType="ApsStandardProcessRouteLineJob">
    <insert id="insertApsStandardProcessRouteLineJob" parameterType="com.aps.job.domain.ApsStandardProcessRouteLineJob">
        insert into aps_standard_process_route_line_job
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
@@ -86,7 +86,7 @@
         </trim>
    </insert>

    <update id="updateApsStandardProcessRouteLineJob" parameterType="ApsStandardProcessRouteLineJob">
    <update id="updateApsStandardProcessRouteLineJob" parameterType="com.aps.job.domain.ApsStandardProcessRouteLineJob">
        update aps_standard_process_route_line_job
        <trim prefix="SET" suffixOverrides=",">
            <if test="routeId != null">route_id = #{routeId},</if>

 aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobLogMapper.xml

@@ -4,7 +4,7 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.job.mapper.ApsWorkOrderJobLogMapper">
    
    <resultMap type="ApsWorkOrderJobLog" id="ApsWorkOrderJobLogResult">
    <resultMap type="com.aps.job.domain.ApsWorkOrderJobLog" id="ApsWorkOrderJobLogResult">
        <result property="id"    column="id"    />
        <result property="pageNum"    column="page_num"    />
        <result property="pageCount"    column="page_count"    />
@@ -23,7 +23,7 @@
        from aps_work_order_job_log
    </sql>

    <select id="selectApsWorkOrderJobLogList" parameterType="ApsWorkOrderJobLog" resultMap="ApsWorkOrderJobLogResult">
    <select id="selectApsWorkOrderJobLogList" parameterType="com.aps.job.domain.ApsWorkOrderJobLog" resultMap="ApsWorkOrderJobLogResult">
        <include refid="selectApsWorkOrderJobLogVo"/>
        <where>
            <if test="pageNum != null "> and page_num = #{pageNum}</if>
@@ -43,7 +43,7 @@
        where id = #{id}
    </select>

    <insert id="insertApsWorkOrderJobLog" parameterType="ApsWorkOrderJobLog" useGeneratedKeys="true" keyProperty="id">
    <insert id="insertApsWorkOrderJobLog" parameterType="com.aps.job.domain.ApsWorkOrderJobLog" useGeneratedKeys="true" keyProperty="id">
        insert into aps_work_order_job_log
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="pageNum != null">page_num,</if>
@@ -69,7 +69,7 @@
         </trim>
    </insert>

    <update id="updateApsWorkOrderJobLog" parameterType="ApsWorkOrderJobLog">
    <update id="updateApsWorkOrderJobLog" parameterType="com.aps.job.domain.ApsWorkOrderJobLog">
        update aps_work_order_job_log
        <trim prefix="SET" suffixOverrides=",">
            <if test="pageNum != null">page_num = #{pageNum},</if>

 aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderJobMapper.xml

@@ -4,7 +4,7 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.job.mapper.ApsWorkOrderJobMapper">
    
    <resultMap type="ApsWorkOrderJob" id="ApsWorkOrderJobResult">
    <resultMap type="com.aps.job.domain.ApsWorkOrderJob" id="ApsWorkOrderJobResult">
        <result property="id"    column="id"    />
        <result property="orderId"    column="order_id"    />
        <result property="docNo"    column="doc_no"    />
@@ -54,7 +54,7 @@
        from aps_work_order_job
    </sql>

    <select id="selectApsWorkOrderJobList" parameterType="ApsWorkOrderJob" resultMap="ApsWorkOrderJobResult">
    <select id="selectApsWorkOrderJobList" parameterType="com.aps.job.domain.ApsWorkOrderJob" resultMap="ApsWorkOrderJobResult">
        <include refid="selectApsWorkOrderJobVo"/>
        <where>  
            <if test="orderId != null  and orderId != ''"> and order_id = #{orderId}</if>
@@ -89,7 +89,7 @@
        </where>
    </select>

    <select id="selectApsWorkOrderJobListDocNoNotNull" parameterType="ApsWorkOrderJob" resultMap="ApsWorkOrderJobResult">
    <select id="selectApsWorkOrderJobListDocNoNotNull" parameterType="com.aps.job.domain.ApsWorkOrderJob" resultMap="ApsWorkOrderJobResult">
        <include refid="selectApsWorkOrderJobVo"/>
        <where>
            <if test="orderId != null  and orderId != ''"> and order_id = #{orderId}</if>
@@ -130,7 +130,7 @@
        where id = #{id}
    </select>

    <insert id="insertApsWorkOrderJob" parameterType="ApsWorkOrderJob" useGeneratedKeys="true" keyProperty="id">
    <insert id="insertApsWorkOrderJob" parameterType="com.aps.job.domain.ApsWorkOrderJob" useGeneratedKeys="true" keyProperty="id">
        insert into aps_work_order_job
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="orderId != null">order_id,</if>
@@ -206,7 +206,7 @@
         </trim>
    </insert>

    <update id="updateApsWorkOrderJob" parameterType="ApsWorkOrderJob">
    <update id="updateApsWorkOrderJob" parameterType="com.aps.job.domain.ApsWorkOrderJob">
        update aps_work_order_job
        <trim prefix="SET" suffixOverrides=",">
            <if test="orderId != null">order_id = #{orderId},</if>

 aps-modules/aps-job/src/main/resources/mapper/job/ApsWorkOrderProcessMapper.xml

@@ -4,7 +4,7 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.job.mapper.ApsWorkOrderProcessMapper">
    
    <resultMap type="ApsWorkOrderProcess" id="ApsWorkOrderProcessResult">
    <resultMap type="com.aps.job.domain.ApsWorkOrderProcess" id="ApsWorkOrderProcessResult">
        <result property="id"    column="id"    />
        <result property="itemCode"    column="item_code"    />
        <result property="docNo"    column="doc_no"    />
@@ -18,8 +18,8 @@
        <result property="scrapQty"    column="scrap_qty"    />
        <result property="opStatus"    column="op_status"    />
        <result property="org"    column="org"    />
        <result property="org_code"    column="org_code"    />
        <result property="work_center"    column="workCenter"    />
        <result property="orgCode"    column="org_code"    />
        <result property="workCenter"    column="workCenter"    />
        <result property="createBy"    column="create_by"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateBy"    column="update_by"    />
@@ -30,7 +30,7 @@
        select id, item_code, doc_no, op_num, op_id, process_name, standard_time, paln_start_date, plan_complete_date, process_qty, scrap_qty, op_status, org, org_code, work_center, create_by, create_time, update_by, update_time from aps_work_order_process
    </sql>

    <select id="selectApsWorkOrderProcessList" parameterType="ApsWorkOrderProcess" resultMap="ApsWorkOrderProcessResult">
    <select id="selectApsWorkOrderProcessList" parameterType="com.aps.job.domain.ApsWorkOrderProcess" resultMap="ApsWorkOrderProcessResult">
        <include refid="selectApsWorkOrderProcessVo"/>
        <where>  
            <if test="itemCode != null  and itemCode != ''"> and item_code = #{itemCode}</if>
@@ -55,7 +55,7 @@
        where id = #{id}
    </select>

    <insert id="insertApsWorkOrderProcess" parameterType="ApsWorkOrderProcess">
    <insert id="insertApsWorkOrderProcess" parameterType="com.aps.job.domain.ApsWorkOrderProcess">
        insert into aps_work_order_process
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
@@ -97,7 +97,7 @@
         </trim>
    </insert>

    <update id="updateApsWorkOrderProcess" parameterType="ApsWorkOrderProcess">
    <update id="updateApsWorkOrderProcess" parameterType="com.aps.job.domain.ApsWorkOrderProcess">
        update aps_work_order_process
        <trim prefix="SET" suffixOverrides=",">
            <if test="itemCode != null">item_code = #{itemCode},</if>

 aps-modules/aps-job/src/main/resources/mapper/job/SysJobLogMapper.xml

@@ -4,7 +4,7 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.job.mapper.SysJobLogMapper">

    <resultMap type="SysJobLog" id="SysJobLogResult">
    <resultMap type="com.aps.job.domain.SysJobLog" id="SysJobLogResult">
        <id     property="jobLogId"       column="job_log_id"      />
        <result property="jobName"        column="job_name"        />
        <result property="jobGroup"       column="job_group"       />
@@ -20,7 +20,7 @@
        from sys_job_log
    </sql>
    
    <select id="selectJobLogList" parameterType="SysJobLog" resultMap="SysJobLogResult">
    <select id="selectJobLogList" parameterType="com.aps.job.domain.SysJobLog" resultMap="SysJobLogResult">
        <include refid="selectJobLogVo"/>
        <where>
            <if test="jobName != null and jobName != ''">
@@ -69,7 +69,7 @@
        truncate table sys_job_log
    </update>
     
     <insert id="insertJobLog" parameterType="SysJobLog">
     <insert id="insertJobLog" parameterType="com.aps.job.domain.SysJobLog">
         insert into sys_job_log(
             <if test="jobLogId != null and jobLogId != 0">job_log_id,</if>
             <if test="jobName != null and jobName != ''">job_name,</if>

 aps-modules/aps-job/src/main/resources/mapper/job/SysJobMapper.xml

@@ -4,7 +4,7 @@
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.aps.job.mapper.SysJobMapper">

    <resultMap type="SysJob" id="SysJobResult">
    <resultMap type="com.aps.job.domain.SysJob" id="SysJobResult">
        <id     property="jobId"          column="job_id"          />
        <result property="jobName"        column="job_name"        />
        <result property="jobGroup"       column="job_group"       />
@@ -25,7 +25,7 @@
        from sys_job
    </sql>
    
    <select id="selectJobList" parameterType="SysJob" resultMap="SysJobResult">
    <select id="selectJobList" parameterType="com.aps.job.domain.SysJob" resultMap="SysJobResult">
        <include refid="selectJobVo"/>
        <where>
            <if test="jobName != null and jobName != ''">
@@ -64,7 +64,7 @@
        </foreach> 
     </delete>
     
     <update id="updateJob" parameterType="SysJob">
     <update id="updateJob" parameterType="com.aps.job.domain.SysJob">
         update sys_job
         <set>
             <if test="jobName != null and jobName != ''">job_name = #{jobName},</if>
@@ -81,7 +81,7 @@
         where job_id = #{jobId}
    </update>
     
     <insert id="insertJob" parameterType="SysJob" useGeneratedKeys="true" keyProperty="jobId">
     <insert id="insertJob" parameterType="com.aps.job.domain.SysJob" useGeneratedKeys="true" keyProperty="jobId">
         insert into sys_job(
             <if test="jobId != null and jobId != 0">job_id,</if>
             <if test="jobName != null and jobName != ''">job_name,</if>