From 2e0e1c5cde0585669334ebc64ff50eae68770726 Mon Sep 17 00:00:00 2001 From: cloudroam <cloudroam> Date: 星期四, 26 六月 2025 14:58:11 +0800 Subject: [PATCH] add:影视景点 --- src/main/java/com/mzl/flower/mapper/film/FilmLocationMapper.java | 15 +++++++++++++++ 1 files changed, 15 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/mzl/flower/mapper/film/FilmLocationMapper.java b/src/main/java/com/mzl/flower/mapper/film/FilmLocationMapper.java index 9195636..ecc7844 100644 --- a/src/main/java/com/mzl/flower/mapper/film/FilmLocationMapper.java +++ b/src/main/java/com/mzl/flower/mapper/film/FilmLocationMapper.java @@ -1,7 +1,14 @@ package com.mzl.flower.mapper.film; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.mzl.flower.dto.request.film.FilmLocationQueryDTO; +import com.mzl.flower.dto.response.film.FilmLocationVO; import com.mzl.flower.entity.film.FilmLocation; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import org.apache.ibatis.annotations.Param; +import org.apache.ibatis.annotations.Select; + +import java.util.List; /** * <p> @@ -13,4 +20,12 @@ */ public interface FilmLocationMapper extends BaseMapper<FilmLocation> { + List<FilmLocationVO> queryPage(@Param("dto") FilmLocationQueryDTO dto, Page page); + + + @Select("select * from film_location where id = #{id} ") + FilmLocationVO selectByIdInfo(Long id); + + @Select("select * from film_location where location_name = #{locationName} and deleted = '0' limit 1") + FilmLocation selectByLocationName(@Param("locationName") String locationName ); } -- Gitblit v1.9.3