代码/restaurants/target/classes/mapper/CollectMapper.xml

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.mall.mapper.CollectMapper">

    <select id="selectCollect" resultType="com.mall.vo.CollectVo" parameterType="int">
        select
        i.*,u.title as title,u.sell_point as sellPoint,u.price as price,u.image as image
        from collect i
        left join
        item u
        on i.item_id = u.id
        where i.user_id =#{userID}

    </select>

    <resultMap id="TopType" type="HashMap">
        <result column="question_type" property="typeName" />
        <result column="type_count" property="typeCount" />
    </resultMap>

    <select id="countErrorQuestionLevel" resultMap="TopType">
		select
		count(*) value,
		q.title as name
		from
			collect e
		left join
			item q
			on  e.item_id =q.id
		GROUP BY
            name
	</select>

</mapper>