src/main/resources/mapper/act/ActHiActinstMapper.xml

（完整代码） 2KB 

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.yj.oa.project.mapper.ActHiActinstMapper">
    <resultMap id="BaseResultMap" type="com.yj.oa.project.po.ActHiActinst">
        <id column="ID_" property="id" jdbcType="VARCHAR"/>
        <result column="PROC_DEF_ID_" property="procDefId" jdbcType="VARCHAR"/>
        <result column="PROC_INST_ID_" property="procInstId" jdbcType="VARCHAR"/>
        <result column="EXECUTION_ID_" property="executionId" jdbcType="VARCHAR"/>
        <result column="ACT_ID_" property="actId" jdbcType="VARCHAR"/>
        <result column="TASK_ID_" property="taskId" jdbcType="VARCHAR"/>
        <result column="CALL_PROC_INST_ID_" property="callProcInstId" jdbcType="VARCHAR"/>
        <result column="ACT_NAME_" property="actName" jdbcType="VARCHAR"/>
        <result column="ACT_TYPE_" property="actType" jdbcType="VARCHAR"/>
        <result column="ASSIGNEE_" property="assignee" jdbcType="VARCHAR"/>
        <result column="START_TIME_" property="startTime" jdbcType="TIMESTAMP"/>
        <result column="END_TIME_" property="endTime" jdbcType="TIMESTAMP"/>
        <result column="DURATION_" property="duration" jdbcType="BIGINT"/>
        <result column="TENANT_ID_" property="tenantId" jdbcType="VARCHAR"/>
    </resultMap>
    <sql id="Base_Column_List">
    ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, 
    ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_, TENANT_ID_
  </sql>

    <select id="selectByByProcInstId" resultMap="BaseResultMap" parameterType="java.lang.String">
        select
        <include refid="Base_Column_List"/>
        from
        act_hi_actinst
        where
        PROC_INST_ID_ = #{procInstId,jdbcType=VARCHAR}
        order by START_TIME_ asc
    </select>

    <delete id="deleteByProcInstId" parameterType="java.lang.String">
    delete
     from
    act_hi_actinst
    where
     PROC_INST_ID_ IN
     <foreach collection="array" open="(" separator="," close=")" item="procInstId">
         #{procInstId,jdbcType=VARCHAR}
     </foreach>
  </delete>

</mapper>

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。