常见sql语句在mybatis里面的编写

1.新增，根据对象新增
<insert id="insertSelective" parameterType="com.enjoyer.cfsc.domain.model.SRScoreGoods" >
insert into sr_score_goods
<trim prefix="(" suffix=")" suffixOverrides="," >
<if test="name != null" >
name,
</if>
<if test="imgUrl != null" >
img_url,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
<if test="name != null" >
#{name},
</if>
<if test="imgUrl != null" >
#{imgUrl},
</if>
</trim>
</insert>
2.删除，根据集合ID批量删除
<delete id="batchDelete" >
delete from sr_score_goods
where id in
<foreach collection="ids" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</delete>
3.修改，根据对象修改
<update id="updateGoods">
update sr_score_goods
<set >
<if test="name != null" >
name = #{name},
</if>
<if test="imgUrl != null" >
img_url = #{imgUrl},
</if>
</set>
where id = #{id}
</update>
4.查询，根据条件查询
<select id="findPage" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from sr_score_goods
WHERE 1=1
<if test="id !=null and id !=''">
and id = #{id}
</if>
<if test="name !=null and name !=''">
and name = #{name}
</if>
</select>

附件：
1.BaseResultMap
<resultMap id="BaseResultMap" type="com.enjoyer.cfsc.domain.model.SRScoreGoods">
<id column="id" property="id" />
<result column="name" property="name" />
<result column="img_url" property="imgUrl" />
<result column="score" property="score" />
<result column="tb_url" property="tbUrl" />
<result column="is_recommend" property="isRecommend" />
<result column="update_time" property="updateTime" />
<result column="create_time" property="createTime" />
<result column="num" property="num" />
<result column="states" property="states" />
<result column="note" property="note" />
</resultMap>
2.Base_Column_List
<sql id="Base_Column_List" >
id, name,img_url,score,tb_url,is_recommend,update_time,create_time,num,states,note
</sql>
--------------------- 
作者：qq_1365462762 
来源：CSDN 
原文：https://blog.csdn.net/qq_1365462762/article/details/78907459 
版权声明：本文为博主原创文章，转载请附上博文链接！