mybatis SQL语句

mybatis 添加SQL语句

    <insert id="insertsave" useGeneratedKeys="true" keyProperty="lyid">
        INSERT INTO message_board(name,content,red,cid,sub_cid,speakingTime,work_number)
        VALUES (#{name},#{content},#{red},#{cid},#{subCid},#{speakingTime},#{workNumber})
    </insert>

mybatis 修改SQL语句

    <update id="updatered">
        UPDATE message_details SET red=1 WHERE ly_id=#{lyId} AND atwork_number!=#{worknumber}
    </update>

mybatis 查询SQL语句

  select * from table

mybatis 插入多条SQL语句

item就是List里每一项的对象名，要用",“分割每一条数据，最后要”;"结尾

    <insert id="insertforeach" parameterType="java.util.List">
        insert into message_details (ly_id,work_number,atwork_number,content,createTime,at_name,red) values
        <foreach collection="list" item="item" separator=","  close=";">
            (#{item.lyid},#{item.worknumber},#{item.atworknumber},#{item.content},#{item.createTime},#{item.atname},#{item.red})
        </foreach>
    </insert>

mybatis 模糊查询

条件如果为空就没有这个判断 如果不为空就 执行if语句 进行模糊查询

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

mybatis 组（去重）

GROUP BY yzlb