效果图
dao层
@Query(value = "select * from nav where fid=0 order by sorts asc",nativeQuery = true)
List<Map<String,Object>> findMaps();
@Query(value = "select * from nav where fid=:fid order by sorts asc",nativeQuery = true)
List<Map<String,Object>> findMapsWhere(Integer fid);
service层
/**
* findMaps
* @return
*/
public List<Map<String, Object>> findMaps() {
return navDao.findMaps();
}
/**
* @return
*
*/
public List<Map<String, Object>> findMapsWhere(Integer fid) {
return navDao.findMapsWhere(fid);
}
controller层
在这边主要是先进行查处一级菜单的类集
然后定义一个存