<!--根据实体参数查询 -->

    <select id="selectBaseList" resultType="java.util.HashMap">

        select

        *

        from ${map.tableName}

        where 1=1

        <foreach collection="map" index="key" item="value">

            <if

                test="key != 'tableName' and key != 'pageSize' and key != 'pageNo' ">

                and `${key}` = #{value}

            </if>

        </foreach>

        limit #{baseModel.fromRec},#{baseModel.pageSize}

    </select>

    <!--根据实体参数查询个数 -->

    <select id="selectBaseCount" resultType="java.lang.Integer">

        select

        count(1)

        from ${map.tableName}

        where 1=1

        <foreach collection="map" index="key" item="value">

            <if

                test="key != 'tableName' and key != 'pageSize' and key != 'pageNo' ">

                and  `${key}` = #{value}

            </if>

        </foreach>

    </select>

    <insert id="insertBase" parameterType="java.util.HashMap">

        insert into ${map.tableName}

        (

        <foreach collection="map" index="key" item="value"

            separator=",">

            <if test="key != 'tableName' ">

                `${key}`

            </if>

        </foreach>

        )

        values (

        <foreach collection="map" index="key" item="value"

            separator=",">

            <if test="key != 'tableName' ">

                #{value}

            </if>

        </foreach>

        )

    </insert>

    <update id="updateBaseByPrimaryKey">

        update ${map.tableName}

        <set>

            <foreach collection="map" index="key" item="value"

                separator=",">

                <if test="key != 'tableName' ">

                    `${key}`= #{value}

                </if>

            </foreach>

        </set>

        where id = #{map.id}

    </update>