im-shop/src/main/java/com/izouma/immall/repo/GoodsRepo.java

package com.izouma.immall.repo;

import com.izouma.immall.domain.Goods;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import java.util.List;
import java.util.Set;

public interface GoodsRepo extends JpaRepository<Goods, Long>, JpaSpecificationExecutor<Goods> {
    List<Goods> findAll();

    List<Goods> findAllByNameLike(String name);

    Goods findFirstByType(String type);

    Goods findFirstById(Long goodsId);
    @Query(nativeQuery = true,value = "SELECT * FROM Goods g  WHERE  g.disabled = 0  and g.type = 'NORMAL'  order by g.sales_volume DESC limit 6")
    List<Goods> findMostSalesGoods();
    @Query(nativeQuery = true,value = "SELECT * FROM Goods g  WHERE  g.disabled = 0  and g.type = 'NORMAL'  order by g.id DESC limit 3")
    List<Goods> FindNewestGoods();
}