mybatis返回list只有第一条数据
代码如下
<select id="getTenderProjectPojo" parameterType="map" resultType="String">
SELECT ten.tenderProjectName,ten.tenderProjectNumber,ten.tenderUnit,ten.tenderPersonType,
ten.tenderAgencyName, (select d.type_name from sys_dictionary d where d.id=ten.projectType)d.projectTypeName,
(select d.type_name from sys_dictionary d where d.id=ten.majorType)d.majorTypeName,ten.registerDepart,
ten.expectSignUpTime,ten.expectOpenTenderTime,
(SELECT u.name FROM zcjd_user_info u WHERE u.id=ten.registerPersion)u.registerName,
(case ten.expectSignUpTimeWarn
when 0 then'提醒'
when 1 then'不提醒' end),ten.remark
FROM zcjd_tender_project ten WHERE ten.deleteState=0 and ten.id =#{map.id}
<if test="map.tenderProjectName !=null and map.tenderProjectName !=''"> <!-- 项目名 -->
and ten.tenderProjectName =#{map.tenderProjectName}
</if>
<if test="map.tenderProjectNumber !=null and map.tenderProjectNumber !=''"> <!-- 项目登记编号 -->
and ten.tenderProjectNumber =#{map.tenderProjectNumber}
</if>
<if test="map.tenderUnit !=null and map.tenderUnit !=''"> <!-- 建设单位 -->
and ten.tenderUnit =#{map.tenderUnit}
</if>
<if test="map.tenderPersonType !=null and map.tenderPersonType !=''"> <!-- 招标人类型 -->
and ten.tenderPersonType =#{map.tenderPersonType}
</if>
<if test="map.tenderAgencyName !=null and map.tenderAgencyName !=''"> <!-- 招标代理机构 -->
and ten.tenderAgencyName =#{map.tenderAgencyName}
</if>
<if test="map.registerDepart !=null and map.registerDepart !=''"> <!-- 登记部门 -->
and ten.registerDepart =#{map.registerDepart}
</if>
<if test="map.expectSignUpTime !=null and map.expectSignUpTime !=''"> <!-- 预计报名时间 -->
and ten.expectSignUpTime =#{map.expectSignUpTime}
</if>
<if test="map.expectOpenTenderTime !=null and map.expectOpenTenderTime !=''"> <!-- 预计开标时间 -->
and ten.expectOpenTenderTime =#{map.expectOpenTenderTime}
</if>
<if test="map.expectSignUpTimeWarn !=null and map.expectSignUpTimeWarn !=''"> <!-- 是否系统提醒 -->
and ten.expectSignUpTimeWarn =#{map.expectSignUpTimeWarn}
</if>
<if test="map.remark !=null and map.remark !=''"> <!-- 备注 -->
and ten.remark =#{map.remark}
</if>
</select>