Mybatis使用实例

最新推荐文章于 2024-02-18 15:57:23 发布

原创最新推荐文章于 2024-02-18 15:57:23 发布 · 334 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #实例

java 同时被 3 个专栏收录

46 篇文章

订阅专栏

sql

3 篇文章

订阅专栏

Mybatis

2 篇文章

订阅专栏

本文介绍使用MyBatis进行数据库批量增删改查的具体实现方式，包括插入、更新、删除及查询等操作，并提供了相应的XML配置示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

增

 <insert id="addStudent" parameterType="java.util.Map">
 insert into student
    (id,name,age)
    values
    (
      #{item.id},
      #{item.name},
      #{item.age}
    )
 </insert>

批量

 <insert id="addStudent" parameterType="java.util.Map">
 insert into student
    (id,name,age,start_time)
    values
     <foreach collection="list" item="item" index="index" separator=","> 
    (
      #{item.id},
      #{item.name},
      #{item.age},
      now()
    )
    </foreach>
  </insert>

删

这里写代码片

批量

改

 <update id="updateStudent" parameterType="java.util.Map">
   update student
  <set> 
      <if test="userid != null and userid != '' ">
        userid=#{userid},
      </if>
  </set>
  where 1=1
    <if test="id!= null and id!= '' ">
        and id=#{id}
    </if>
  </update>

批量

<update id="updateStudent" parameterType="java.util.Map">
      update student set state=2  where 1=1
       and id in 
       <foreach item="item" index="index" collection="list" open="(" separator="," close=")">
              #{item}
       </foreach>

   </update>

<update id="editStudent"  parameterType="java.util.List">  
    <foreach collection="list" item="item" index="index" separator=";"> 
     update ware_service
    <set> 
        <if test="item.endTime!=null and item.endTime!=''">
           end_time=#{item.endTime},
        </if>
        <if test="item.redeemcode!=null and item.redeemcode!=''">
           redeemcode=#{item.redeemcode}
        </if>         
    </set>
    where id=#{item.id}
      </foreach>  
</update>

批量修改需设置db.properties
新增 &allowMultiQueries=true

查

  <select id="getAllStudent" resultType=com.mofangge.entity.student" parameterType="java.util.Map">
    select 
    id,
    name,
    age,
    start_time as startTime
    from student where 1=1
      <if test="userid != null and userid != '' ">
        and userid=#{userid}
      </if>
    and end_time > now()
  </select>

批量

<select id="getAllStudents" resultType="com.mofangge.entity.student" parameterType="java.util.Map">
    select
    id,
    name,
    age,
    start_time as startTime
    from student where 1=1 and age in
      <foreach collection="list" index="index" item="item" open="(" separator="," close=")">
        #{item}
      </foreach>
         and end_time > now()
    <if test="userid!=null and userid!=''">
        and userid=#{userid}
    </if>      
  </select>

<select id="getAllStudent" resultType="com.mofangge.entity.Student" parameterType="java.util.Map">
    select
    id,
    name,
    age,
    from student where 1=1 and code in
      <foreach collection="list" index="index" item="item" open="(" separator="," close=")">
            #{item}
      </foreach>
         and end_time > now()
    <if test="id!=null and id!=''">
        and id=#{id}
    </if>      
  </select>

看不懂的留评论~~