4

hao

2025-04-16 c5fb1fbcbb2bf4d511773d348f9ef625855c61fc

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);
 
}