1.controller层

latestParkingInfo=mchEtongpayOrderService.fetchLatestParkingRow(carNo);

2.dao层

@Mapper
public interface O2oMemberScoreMapper extends BaseMapper<O2oMemberScore> {

    List<ScoreInfo> queryScoreInfoList(@Param("platformMemberId") String platformMemberId);

    LatestParkingInfo fetchLatestParkingRow(@Param("carNo") String carNo);
}

3.sql

<select id="fetchLatestParkingRow" resultMap="latestParkingInfoMap">

        SELECT TIMESTAMPDIFF(MINUTE,a.addtime,NOW()) as  bet ,a.operation_score_id from o2o_member_score a
        where JSON_UNQUOTE(pay_info->"$.carNo")  = #{carNo} and TIMESTAMPDIFF(MINUTE,a.addtime,NOW())&lt;30 ORDER BY bet  LIMIT 1
    </select>

4.备注