packagecom.reyun.repository;importcom.reyun.model.UserViewColumn;importcom.reyun.model.ViewColumn;importorg.springframework.data.jpa.repository.JpaRepository;importorg.springframework.data.jpa.repository.Query;importjava.util.List;/** * Created by nolan on 28/12/2016. * description: */publicinterfaceViewColumnRepositoryextendsJpaRepository<ViewColumn,Long>{@Query(value="select * from view_column where industory = ?1 and menu=?2",nativeQuery=true)List<ViewColumn>findByIndustory(Stringindustory,Stringmenu);@Query(value="select * from view_column where type = ?1",nativeQuery=true)List<ViewColumn>findByType(StringsdkEventConfig);@Query(value="select * from view_column where industory = ?1 and menu=?2 and fieldcode != ?3",nativeQuery=true)List<ViewColumn>findByIndustoryAndNotFieldCode(StringcommonColumns,Stringmenu,StringfieldCode);}