sql
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 | <?xml version= "1.0" encoding= "utf-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" > <mapper namespace = "com.example.demotest.dao.VideoMapper" > <sql id= "sele_fi" > name ,phone,cove </sql> < select id= "selectById" resultType= "video" > select * from video where id = #{video_id}; </ select > < select id= "selectByIdList" resultType= "video" > select <include refid= "sele_fi" ></include> from video; </ select > <insert id= "add" parameterType= "video" useGeneratedKeys= "true" keyColumn= "id" keyProperty= "id" > insert into video (name, phone, cove) values (#{name}, #{phone}, #{cove}) </insert> <insert id= "addHandle" parameterType= "video" > insert into video (name, phone, cove) values < foreach collection= "list" item= "item" index= "index" separator= "," > (#{item.name}, #{item.phone}, #{item.cove}) </ foreach > </insert> <update id= "editUpdate" parameterType= "video" > update video <trim prefix= "set" suffixOverrides= "," > < if test= "name !=null" > name = #{name}, </ if > < if test= "phone !=null" > phone = #{phone}, </ if > < if test= "cove !=null" > cove = #{cove}, </ if > </trim> where id = #{id} </update> <delete id= "deleteId" parameterType= "video" > delete from video where id = #{id} </delete> </mapper> |
本文来自博客园,作者:zjxgdq,转载请注明原文链接:https://www.cnblogs.com/zjxzhj/p/17438831.html
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步