package com.example.springboot.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.example.springboot.entity.GlassInfo;
|
import com.example.springboot.entity.RolePermission;
|
|
|
import org.apache.ibatis.annotations.*;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.List;
|
import java.util.Map;
|
|
@Mapper
|
@Repository
|
public interface GlassInfoMapper extends BaseMapper<GlassInfo> {
|
|
@Select("SELECT * FROM glassinfo where width<=#{maxwidth} and width>=#{minwidth} and height<=#{maxheight} and height>=#{minheight}")
|
List<GlassInfo> selectGlassInfos(@Param("maxwidth") double maxwidth, @Param("minwidth") double minwidth, @Param("maxheight") double maxheight, @Param("minheight") double minheight);
|
|
// @Select("SELECT COUNT(*) FROM role_permission WHERE role_id = #{roleId} AND permission_id = #{permissionId}")
|
// boolean checkExists(@Param("roleId") int roleId, @Param("permissionId") int permissionId);
|
|
|
// @Update("UPDATE role_permission SET state = #{state} WHERE role_id = #{roleId} AND permission_id = #{permissionId}")
|
// void updateState(@Param("roleId") int roleId, @Param("permissionId") int permissionId, @Param("state") int state);
|
|
// @Insert("INSERT INTO role_permission (role_id, permission_id, state) VALUES (#{roleId}, #{permissionId}, #{state})")
|
// void insert(@Param("roleId") int roleId, @Param("permissionId") int permissionId, @Param("state") int state);
|
|
}
|
