1

hao

2025-05-20 8e24c6fea30d9b179375ee2893710cdec2443b13

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
package com.dev.dao;
 
import com.dev.entity.ApiDashboardWidget;
 
 
import com.system.role.entity.SysRole;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
 
import java.util.List;
 
public interface ApiDashboardWidgetDao  extends CrudRepository<ApiDashboardWidget, Long>, JpaSpecificationExecutor<ApiDashboardWidget> {
 
    public List<ApiDashboardWidget> findAll();
 
    public ApiDashboardWidget findById(long id);
 
    @Query(value = "select * from API_LARGE_SCREEN  where bsCode = ?1 ", nativeQuery = true)
    List<ApiDashboardWidget> getDataByBsCode(String bsCode);
 
}