记录下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>