随記mybatis入參map

記錄下sql裡map入參增删查

mybatis處理入參map

新增：

INSERT INTO JKGL_JQ_JTCY
    <trim prefix="(" suffix=")" suffixOverrides=",">
        <if test="objectid != null and objectid != ''">
            OBJECTID,
        </if>
        <if test="cyxm != null and cyxm != ''">
            CYXM,
        </if>
        <if test="cyxb != null and cyxb != ''">
            CYXB,
        </if>
        <if test="csrq != null and csrq != ''">
            CSRQ,
        </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
        <if test="objectid != null and objectid != ''">
            #{objectid},
        </if>
        <if test="cyxm != null and cyxm != ''">
            #{cyxm},
        </if>
        <if test="cyxb != null and cyxb != ''">
            #{cyxb},
        </if>
        <if test="csrq != null and csrq != ''">
            #{csrq},
        </if>
    </trim>
</insert>
           

删除：

DELETE FROM JKGL_YY_YSPBXX
    <where>
        <if test="hospitalMark != null and hospitalMark != ''">
            and HOSPITAL_MARK = #{hospitalMark}
        </if>
        <if test="hbDate != null and hbDate != ''">
        <!--to_date跟to_char百度-->
            <![CDATA[and to_date(HB_DATE, 'yyyy-mm-dd') >=  to_date(#{hbDate}, 'yyyy-mm-dd')]]>
        </if>
    </where>
</delete>
           

`

查詢：

SELECT
    <include refid="Base_Column_List"></include>
    FROM jkgl_yy_ysjbxx
    WHERE HOSPITAL_MARK = #{hospitalId}
    AND OFFICE_CODE = #{deptCode}
    <if test="time != null and time != ''">
       AND DOCTOR_CODE IN (SELECT DOCTOR_CODE FROM jkgl_yy_yspbxx WHERE HB_DATE = #{time})
    </if>
</select>