Rest api via spring

Question

Rest api via spring

I need to get all data from MySQL

in a table using a condition query select

where fields isdeleted = 0, location = 1. How could I implement this in repository and access manager.

public interface FoodCourtRepository  extends JpaRepository<FoodCourtEntity, Long> {
    List<FoodcaseEntity> findByIsdeleted(Boolean isDeleted);
}

In the access manager

public List<FoodcaseDO> getAllFoodCourt() {
    List<FoodcaseEntity> foodCaseList = foodcourtRepository.findByIsdeleted(false);
}

+3

java rest spring-mvc mysql

bkumar Jul 26 '17 at 7:00

source to share

3 answers

You need to add one more condition for the location, for example:

public List<FoodcaseEntity> findByIsdeletedAndLocation(boolean deleted, int location);

And call it with false

and 1

as arguments, for example:

List<FoodcaseEntity> foodCaseList = foodcourtRepository.findByIsdeletedAndLocation(false, 1);

This will give you the desired result.

Updte

If you want to get data for multiple locations, you need to write a method that supports IN

, for example:

public List<FoodcaseEntity> findByIsdeletedAndLocationIn(boolean deleted, List<Integer> location);

And then call it like this:

List<FoodcaseEntity> foodCaseList = foodcourtRepository.findByIsdeletedAndLocation(false, Arrays.asList(2,3,4,5));

+4

Darshan mehta Jul 26 17 at 7:14

source to share

In the add repository class,

List<FoodcaseEntity> foodCaseList = foodcourtRepository.findByIsdeletedAndLocation(boolean isSelected,int location);

then u can send the selected and the values to location.it will return a list of values based on the condition.

0

Balasubramanian Jul 26 17 at 7:21

source to share

Devram kandhare · Accepted Answer · 2017-07-26T08:07:07+0000

JPA provides @Query for writing custom query. You can define another interface called FoodCourtRepositoryCustom and write your own request as shown below:

public interface FoodCourtRepositoryCustom {
 @Query("SELECT fe FROM FoodcaseEntity fe WHERE fe.isdeleted=?1 AND fe.location=?2 ")
 List<FoodcaseEntity> findByIsdeletedAndLocation(Boolean isDeleted, Integer location);
}

Then it extends this interface in your repository interface as shown below:

public interface FoodCourtRepository  extends JpaRepository<FoodCourtEntity, Long>, FoodCourtRepositoryCustom{
List<FoodcaseEntity> findByIsdeleted(Boolean isDeleted);
}

This method is now available in your access manager.

public List<FoodcaseDO> getAllFoodCourt() {
List<FoodcaseEntity> foodCaseList = foodcourtRepository.findByIsdeleted(false);
List<FoodcaseEntity> foodCaseList = foodcourtRepository.findByIsdeletedAndLocation(false, 1);
}

Rest api via spring

More articles: