mybatis（1）

1.  select查询 ， id 和 mapper 接口中名字一直 ,标注parameterType, 和resultType

xml mapper 文件 中填写对应接口 namespace="com.console.mapper.read.HouseReadMapper"

2.insert  批量插入

<insert id="addRules">
        INSERT INTO role (role,islocked,createTime, status) VALUES
        <foreach collection="list" index="index" item="item" separator=",">
            (#{item.role}, #{item.islocked}, now(), 1)
        </foreach>
</insert>

<insert id="insertPercentage" parameterType="com..model.Percentage" useGeneratedKeys="true" keyProperty="id">
        INSERT INTO Percentage (commission,createby) values (#{commission},#{createBy})
    </insert>

3.update 批量

<update id="updateCats"  >
        UPDATE
        role
        SET
        status = 0,
        islocked=0
        WHERE
        status = 1
        AND id IN
        <foreach collection="list" index="index" item="item" open="(" close=")" separator=",">
            #{item.id}
        </foreach>
</update>

 <update id="updatePercentage" parameterType="com.model.Percentage">
        UPDATE
        Percentage
        SET
        commission = #{commission},
        updateby = #{updateBy}
        WHERE
        id =#{id}
    </update>

4.分页

req.setPageIndex(req.getPageIndex() * req.getPageSize());

 limit #{pageIndex},#{pageSize}