欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

jpa實(shí)現(xiàn)只查詢指定的字段

 更新時間:2021年12月07日 08:38:43   作者:LuckyTHP  
這篇文章主要介紹了jpa實(shí)現(xiàn)只查詢指定的字段,具有很好的參考價值,希望對大家有所幫助。如有錯誤或未考慮完全的地方,望不吝賜教

jpa查詢指定的字段

JpaRepository中new的方式產(chǎn)生新的對象,并配置好其構(gòu)造函數(shù)

JPA對字段命名有一點(diǎn)規(guī)則,推薦使用駝峰式命名,如果下面的方法會報錯,并且沒有明確的報錯信息,請先看字段是否合法!?。。?!

下面是實(shí)例代碼

JpaRepository:

@Transactional
public interface PayeeDataRepo extends JpaRepository<PayeeData, String> {
    @Query("select new com.stylefeng.guns.workday.bean.PayeeData(p.id,p.name,p.bankAccountNumberEncode,p.adhocPayeeID,p.isDomestic,p.bankAccountName ) from PayeeData p")
    List<PayeeData> finddAllNoBankNumber();    
    }

PayeeData Bean:

public class PayeeData implements Serializable {
   public PayeeData() {
    }
    public PayeeData(String id, String name, String bankAccountNumberEncode, String adhocPayeeID, Integer isDomestic, String bankAccountName) {
        this.id = id;
        this.name = name;
        this.bankAccountNumberEncode = bankAccountNumberEncode;
        this.adhocPayeeID = adhocPayeeID;
        this.isDomestic = isDomestic;
        this.bankAccountName = bankAccountName;
    }
}

spring data jpa查詢自定義查詢字段

@Query(value = "SELECT a.city city,sum(m.page_view) view from t_ques m " +
            "LEFT JOIN attractions a on m.spot_name=a.name where m.ques_time<= ?1 and a.province_code=?2 GROUP BY a.city ORDER BY view desc", nativeQuery = true)
    List<Map<String, Object>> getHotCity(Date date, String pcode);
List<Map<String, Object>> cityHotBOList = quesRepository.getHotCity(dataDate, pcode);
        if(null == cityHotBOList || cityHotBOList.size() <= 0){
            return null;
        }
        for(int i = 0; i< top && i<cityHotBOList.size();i++){
            Map<String, Object> cityHotBO = cityHotBOList.get(i);
            HotCityResVO hotCityResVO = new HotCityResVO();
            hotCityResVO.setName((String)cityHotBO.get("city"));
            List<Attractions> attractionsList = attractionsRepository.findByCity((String)cityHotBO.get("city"));
            hotCityResVO.setCode(attractionsList.get(0).getCityCode());
            hotCityResVO.setNum((BigDecimal)cityHotBO.get("view"));
            hotCityResVOList.add(hotCityResVO);
        }

以上為個人經(jīng)驗,希望能給大家一個參考,也希望大家多多支持腳本之家。

相關(guān)文章

最新評論