l1024-jav/src/main/java/top/lvzhiqiang/mapper/VideoGenresMapper.java

package top.lvzhiqiang.mapper;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import top.lvzhiqiang.entity.VideoGenres;

import java.util.List;

/**
 * 电影类别Mapper
 *
 * @author lvzhiqiang
 * 2022/4/4 15:28
 */
public interface VideoGenresMapper {

    /**
     * 删除所有
     */
    @Delete("DELETE FROM video_genres where 1=1")
    void deleteAll();

    /**
     * 批量新增
     *
     * @param videoGenresList
     */
    @Insert({"<script>" +
            "INSERT INTO video_genres(name, code, sort, create_time, modify_time) " +
            "VALUES " +
            "<foreach collection='list' item='ve' index=\"index\" separator=\",\">" +
            "   (#{ve.name}, #{ve.code}, #{ve.sort}, now(), now())" +
            " </foreach>" +
            "</script>"})
    void insertList(List<VideoGenres> videoGenresList);

    /**
     * 新增
     *
     * @param videoGenres
     */
    @Insert("INSERT INTO video_genres(name, code, sort, create_time, modify_time) " +
            "VALUES (#{name}, #{code}, #{sort}, now(), now())")
    @Options(useGeneratedKeys = true, keyProperty = "id", keyColumn = "id")
    int insert(VideoGenres videoGenres);

    /**
     * 新增/修改
     *
     * @param videoGenres
     */
    @Insert("INSERT INTO video_genres(name, code, sort, create_time, modify_time) " +
            "VALUES (#{name}, #{code}, #{sort}, now(), now()) " +
            "ON DUPLICATE KEY UPDATE name=values(name),modify_time=now()")
    @Options(useGeneratedKeys = true, keyProperty = "id", keyColumn = "id")
    int insertOrUpdate(VideoGenres videoGenres);

    /**
     * 查询所有
     */
    @Select("SELECT * FROM video_genres WHERE delete_flag = 1 ORDER BY sort")
    List<VideoGenres> findAll();
}