Mybites基础篇（一）--增删改查（实用）

最新推荐文章于 2024-02-15 17:20:57 发布

shyoldboy

最新推荐文章于 2024-02-15 17:20:57 发布

阅读量295

点赞数

分类专栏： Mybites 文章标签： Mybites mapper 增删改查 mapper的foreach查询

本文链接：https://blog.csdn.net/shyoldboy/article/details/87984554

版权

Mybites 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.增

<insert id="insert" parameterType="com.itheima.cn.Student"> 
    <selectKey keyProperty="id" resultType="String" order="BEFORE">SELECT REPLACE(NEWID(),'-','')</selectKey> 
    INSERT INTO student (stuId,stuName,createDate,birthday)
    VALUES
    ( #{id,jdbcType=VARCHAR},#{stuName,jdbcType=VARCHAR},
    {createDate,jdbcType=DATE}, #{birthday,jdbcType=TIMESTAMP})
  </insert>

2.删

<delete id="delete">DELETE FROM student WHERE ID IN 
    <foreach 
      item="stuId" collection="list" open="(" separator="," close=")">
    #{stuId,jdbcType=VARCHAR}
    </foreach> 
  </delete>

3.改

<update id="update" parameterType="com.itheima.cn.Student">UPDATE student
    <set> 
      <if test="stuId!= null">stuId=#{stuId,jdbcType=VARCHAR},</if>
      <if test="stuName!= null">stuName=#{stuName,jdbcType=VARCHAR},</if>
      <if test="createDate!= null">createDate=#{createDate,jdbcType=DATE},</if>
      <if test="birthday!= null">birthday=#{birthday,jdbcType=TIMESTAMP}</if>
    </set> WHERE ID=#{id}
  </update>

4.基本查询

<resultMap id="student" type="com.itheima.cn.Student"> 
    <id property="stuId" column="stuId"/>  
    <result property="stuName" column="stuName"/>  
    <result property="createDate" column="createDate"/>  
  </resultMap>  
<select id="list" resultMap="student" parameterType="map">
	  SELECT stuId,stuName,createDate,birthday FROM student
    <where> 
     <if test="stuId!= null and stuId!=''">AND stuId LIKE  '%'+#{stuId}+'%'</if>
      <if test="stuName!= null and stuName!=''">AND stuName LIKE  '%'+#{stuName}+'%'</if>  
       <if test="ids!= null and ids!=''">AND stuId  in
			<foreach collection="ids" index="index" item="id" open="(" separator="," close=")">
                #{id}       
        </foreach>
		</if>
    </where> 
  </select>