package com.mobile.model;

import javax.persistence.*;


@Entity
@Table(name = "mobile_table")
public class Mobile {

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE)
    public int mobileId;

    @Column(name = "mobile_name",nullable = false,length = 20)
    public String mobileName;

    @Column(name = "mobile_brand",nullable = false,length = 15)
    public String mobileBrand;

    @Column(name="mobile_networkType")
    public String mobileNetworkType;

    @Column(name = "mobile_core")
    public Integer mobileAvailableCore;

    @Column(name = "mobile_ram")
    public Integer mobileRAMSize;

    @Column(name = "mobile_os")
    public String mobileOS;

    @Column(name = "mobile_wifif")
    public Boolean mobileWifiAvailability;

    @Column(name = "mobile_bluetooth")
    public Boolean mobileBluethoothAvailablity;

    public Mobile() {
    }

    public Mobile(String mobileName, String mobileBrand, String mobileNetworkType, Integer mobileAvailableCore, Integer mobileRAMSize, String mobileOS, Boolean mobileWifiAvailability, Boolean mobileBluethoothAvailablity) {
        this.mobileName = mobileName;
        this.mobileBrand = mobileBrand;
        this.mobileNetworkType = mobileNetworkType;
        this.mobileAvailableCore = mobileAvailableCore;
        this.mobileRAMSize = mobileRAMSize;
        this.mobileOS = mobileOS;
        this.mobileWifiAvailability = mobileWifiAvailability;
        this.mobileBluethoothAvailablity = mobileBluethoothAvailablity;
    }
}







//Query for multiple selection
    @SuppressWarnings("unchecked")
	public List<Mobile> getMobileSearch(String mobileBrand, Integer mobileRAMSize, String mobileOS){
    	return mobileDao.findAll(Specifications.where((Specification<Mobile>) getAllMobilesByBrand(mobileBrand))
    			.and((Specification<Mobile>) getAllMobilesByOS(mobileOS))
    			.and((Specification<Mobile>) getAllMobilesByRam(mobileRAMSize)));
    }







// calling function for multiple attribute Search in controller class
@RequestMapping(value="/searchMobile", method=RequestMethod.GET)
    public ResponseEntity<List<Mobile>> searchMobile(@RequestParam(value="brand") String mobileBrand, @RequestParam(value="ramSize") Integer ramSize, @RequestParam(value="mobileOs") String MobileOs)
    {
    	List<Mobile> mobileList=mobileService.getMobileSearch(mobileBrand,ramSize,MobileOs);
    	return new ResponseEntity<List<Mobile>>(mobileList,HttpStatus.OK);
    }







// here is how my database is calling database query.
@Repository
public interface MobileDao extends CrudRepository<Mobile, Integer>, JpaSpecificationExecutor<Mobile> {

    public List<Mobile> findByMobileBrand(String mobileBrand);

    @Query("select distinct m.mobileBrand from Mobile m")
    public List<String > getAllDistinctBrand();

    public List<Mobile> findByMobileRAMSize(Integer mobileRAMSize);

    @Query("select distinct m.mobileRAMSize from Mobile m")
    public List<Integer> getAllDistinctRam();

    public List<Mobile> findByMobileOS(String mobileOS);


    @Query("select distinct m.mobileOS from Mobile m")
    public List<String > getAllDistinctMobileOS();





我正在尝试为在不同的电子商务网站(例如Flipkart,Amazon)中使用的产品实施搜索查询,在该网站中用户为产品插入了不同的属性。根据产品属性,显示结果。对于实现,我使用Spring Boot和JPA作为数据库。

如何在单个查询中动态搜索多个子句。例如,在SQL查询的情况下,我们将像这样搜索多个子句。

如何在JPA中实现多个子句。

Select * from table_name where attribute1="Attb" and attribute2="Attb2" and attribute3="Attb3";


Attb,Attb2和Attb3会根据客户端输入动态变化。

最佳答案

您应该实现一个JPA存储库并使用方法查询:

public interface MyRepository implements JpaRepository<MODEL_CLASS, Long> {
     MODEL_CLASS findAllByAtttibute1AndAttribute2AndAttribute3(String Attribute1, String Attribute2, String Attribute3);
}

09-25 22:57
查看更多