MenuRepository.java

package common.repository;

import common.model.Menu;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@Transactional
public interface MenuRepository extends JpaRepository<Menu, Long> {
	
	@Query(value="select * from menu where parent <> 0",nativeQuery=true)
	List<Menu> listAllSonMenu();
	@Query(value="select * from menu where parent = 0",nativeQuery=true)
	List<Menu> listAllParentMenu();
	
	@Query(value="select * from menu where id in ?1",nativeQuery=true)
	List<Menu> listMenuByIds(List<String> idList);

	
}