Session 83 – Part 2 | Advanced Derived Queries in Spring Data JPA

Описание: Session 83 – Part 2 | Advanced Derived Queries in Spring Data JPA

#SpringBoot #SpringDataJPA #DerivedQueries #JavaFullStack #RESTAPI

Welcome to *Session 83 – Part 2* of the *Java Full Stack Made Easy* series!

In this session, we take *Derived Queries* to the next level by implementing *multiple condition queries**, **partial search**, and **case-insensitive search* — all without writing a single line of SQL or JPQL.

We continue working with our **SuperHero entity**:

id
name
universe
power

---

✅ Topics Covered

🔹 1️⃣ `findByUniverseAndPower()`

Query using *multiple conditions*
How Spring combines fields using `AND`
Clean service layer integration

Example:

```java
findByUniverseAndPower(String universe, String power)
```

---

🔹 2️⃣ `findByNameContaining()`

Partial search functionality
Similar to SQL `LIKE %value%`
Useful for search APIs

Example:

```java
findByNameContaining(String name)
```

---

🔹 3️⃣ `findByUniverseIgnoreCase()`

Case-insensitive search
How Spring handles lowercase/uppercase internally

Example:

```java
findByUniverseIgnoreCase(String universe)
```

---

🎯 What You Will Learn

How to combine multiple fields in derived queries
How to implement search functionality easily
How to perform case-insensitive queries
Why derived queries are powerful in real-world applications
How to write clean, production-ready repository methods

---

🛠 Technologies Used

Java
Spring Boot
Spring Data JPA
MySQL
REST APIs

---

📺 Watch the full playlist:

👉 [   • Java Full Stack Made easy  ](   • Java Full Stack Made easy  )

💻 Source Code:

👉 [http://github.com/shahdbest/java_full...](http://github.com/shahdbest/java_full...)

📲 Connect on LinkedIn:

👉 [  / shahid-killedar-719a51127  ](  / shahid-killedar-719a51127  )

---

👍 If this session helped you, *Like, Share & Subscribe*

📌 *Next Session:*

`findByPowerStartingWith()`
`findByUniverseOrderByNameAsc()`
`findByNameIn()`
Pagination & Sorting with Spring Data JPA

---

🔍 SEO KEYWORDS (Paste in Tags Section)

spring data jpa multiple condition query, spring boot findby and example, spring data jpa containing example, spring boot ignorecase query, spring data jpa advanced derived queries, spring boot search api example, spring data jpa method naming conventions, spring boot real world project, java backend tutorial, spring boot interview preparation