mybatis xml配置

最新推荐文章于 2024-11-13 16:09:31 发布

原创最新推荐文章于 2024-11-13 16:09:31 发布 · 187 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #xml #java

该文档展示了一个MyBatis的MapperXML配置文件，包括了查询、插入、更新和删除等数据库操作，涉及实体类属性映射及动态SQL条件构造。

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE mapper

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"" target="_blank">http://mybatis.org/dtd/mybatis-3-mapper.dtd">

</resultMap>

select iid, entcertnum, legrepname, legrepidtype, legrepidnum, legrephouseaddstat, legrepedulevel, legrepworkingyears, sbzt, sjzt, bwbh, dis_org_id, dis_data_date from nbqypj_leg_rep_inf_sgm

</sql>

<where>

<if test="legrepname != null and legrepname != ''"> and legrepname like concat('%', #{legrepname}, '%')</if>

<if test="legrepidtype != null and legrepidtype != ''"> and legrepidtype = #{legrepidtype}</if>

<if test="legrepidnum != null and legrepidnum != ''"> and legrepidnum = #{legrepidnum}</if>

<if test="legrephouseaddstat != null and legrephouseaddstat != ''"> and legrephouseaddstat = #{legrephouseaddstat}</if>

<if test="legrepedulevel != null and legrepedulevel != ''"> and legrepedulevel = #{legrepedulevel}</if>

<if test="legrepworkingyears != null "> and legrepworkingyears = #{legrepworkingyears}</if>

<if test="entcertnum != null and entcertnum != ''"> and entcertnum = #{entcertnum}</if>

<if test="disOrgId != null and disOrgId != ''"> and dis_org_id = #{disOrgId}</if>

<if test="disDataDate != null and disDataDate != ''"> and dis_data_date = #{disDataDate}</if>

</where>

</select>

where iid = #{iid}

</select>

select entcertnum, dis_org_id, dis_data_date

from nbqypj_leg_rep_inf_sgm

where iid in

#{iid}

</foreach>

</select>

insert into nbqypj_leg_rep_inf_sgm

<if test="entcertnum != null">entcertnum,</if>

<if test="legrepname != null">legrepname,</if>

<if test="legrepidtype != null">legrepidtype,</if>

<if test="legrepidnum != null">legrepidnum,</if>

<if test="legrephouseaddstat != null">legrephouseaddstat,</if>

<if test="legrepedulevel != null">legrepedulevel,</if>

<if test="legrepworkingyears != null">legrepworkingyears,</if>

</trim>

<if test="entcertnum != null">#{entcertnum},</if>

<if test="legrepname != null">#{legrepname},</if>

<if test="legrepidtype != null">#{legrepidtype},</if>

<if test="legrepidnum != null">#{legrepidnum},</if>

<if test="legrephouseaddstat != null">#{legrephouseaddstat},</if>

<if test="legrepedulevel != null">#{legrepedulevel},</if>

<if test="legrepworkingyears != null">#{legrepworkingyears},</if>

<if test="disOrgId != null">#{disOrgId},</if>

<if test="disDataDate != null">#{disDataDate},</if>

</trim>

</insert>

update nbqypj_leg_rep_inf_sgm

<if test="legrepname != null">legrepname = #{legrepname},</if>

<if test="legrepidtype != null">legrepidtype = #{legrepidtype},</if>

<if test="legrepidnum != null">legrepidnum = #{legrepidnum},</if>

<if test="legrephouseaddstat != null">legrephouseaddstat = #{legrephouseaddstat},</if>

<if test="legrepedulevel != null">legrepedulevel = #{legrepedulevel},</if>

<if test="legrepworkingyears != null">legrepworkingyears = #{legrepworkingyears},</if>

<if test="disOrgId != null">dis_org_id = #{disOrgId},</if>

<if test="disDataDate != null">dis_data_date = #{disDataDate},</if>

<if test="entcertnum != null and entcertnum != '' ">entcertnum = #{entcertnum},</if>

</trim>

where iid = #{iid}

</update>

update nbqypj_leg_rep_inf_sgm set sjzt = 'delete' where iid in

#{iid}

</foreach>

</update>

delete from nbqypj_leg_rep_inf_sgm where iid = #{iid}

</delete>

delete from nbqypj_leg_rep_inf_sgm where entcertnum = #{entcertnum} and dis_org_id = #{disOrgId} and dis_data_date = #{disDataDate}

</delete>

delete from nbqypj_leg_rep_inf_sgm where iid in

#{iid}

</foreach>

</delete>

</mapper>

mybatis xml配置

1 条评论