Let’s say you are using Spring Data and you have a “Composite Key” (ie, a tuple or EmbeddedId). Generally, you may want to query by the whole composite key (ie, by ID), which is generally fairly straightforward with a JPA “query method” (still not sure that is the official name). Even so, one of the reasons you use tuples or composite keys is to group data (and maybe even group within a group). Running with that thought, let’s say you have the following composite key:
@NoArgsConstructor
@AllArgsConstructor
@Data
@Embeddable
public class PlantScheduleCompositeKey implements Serializable {
@Column(name = "state")
private String state;
@Column(name = "city")
private String city;
@Column(name = "zip")
private String zip;
@Column(name = "crop")
private String crop;
} Next, let’s use the composite key in this Entity:
@Entity
@Data
@Table(name="plant_schedule")
public class PlantSchedule implements Serializable {
@EmbeddedId
private PlantScheduleCompositeKey id;
private boolean frostDates;
private boolean moonDates;
private String sowSeedsIndoorSchedule;
private String transplantSeedlingsSchedule;
private String directSowSchedule;
private String source;
} Now, if you are using a CrudRepository, or better yet a PagingAndSortingRepository, you’ll already get findById() out of the box. This will not help us if we want to search by only city, state, and zip (ie, without the crop name). So, we need to craft a custom query method, which will be turned into JPQL behind the scenes.
@RepositoryRestResource
public interface IPlantScheduleRepository extends PagingAndSortingRepository<PlantSchedule, PlantScheduleCompositeKey>{
public List<PlantSchedule> findAllByIdCityContainingAndIdStateContainingAndIdZipContaining(String city, String state, String zip, Pageable pageable);
} The key here is to understand that there is a hierarchy here with a filter that is repeated for the 3 out of the 4 parts of the composite key we want to search against. We can interpret the substring IdCityContaining as being the field id on the entity PlantSchedule, followed by the part of the composite key we want to do a contains comparison against. Therefore, we repeat this pattern twice more for state and zip. So, in summary, we have a query method that will return all PlantSchedules with a city, state, and zip matching the provided arguments.
Sample call:
Pageable pageable = PageRequest.of(0, 100);
List<PlantSchedule> pageList = plantScheduleRepository.findAllByIdCityContainingAndIdStateContainingAndIdZipContaining(city, state, zip, pageable);
This was a thoroughly insightful enjoy reading. Thank you for sharing your expertise!
Your writing style is captivating! I was engaged from start to finish.
This article was a joy to enjoy reading. Your enthusiasm is contagious!
This article is a perfect blend of informative and entertaining. Well done!
I’m in awe of the way you handle topics with both grace and authority.
You’ve done a fantastic job of breaking down this topic. Thanks for the clarity!
This piece was beautifully written and incredibly informative. Thank you for sharing!
I’m in awe of the way you handle topics with both grace and authority.
This was a great enjoy reading—thought-provoking and informative. Thank you!
Thank you for adding value to the conversation with your insights.
Your work is truly inspirational. I appreciate the depth you bring to your topics.
Your piece was both informative and thought-provoking. Thanks for the great work!
Your creativity and intelligence shine through this post. Amazing job!
This article was a delightful enjoy reading. Your passion is clearly visible!
Thank you for adding value to the conversation with your insights.
I appreciate the balance and fairness in your writing. Great job!
This article was a delightful enjoy reading. Your passion is clearly visible!
I’m bookmarking this for future reference. Your advice is spot on!
Your insights have added a lot of value to my understanding. Thanks for sharing.
You’ve opened my eyes to new perspectives. Thank you for the enlightenment!
You have a unique perspective that I find incredibly valuable. Thank you for sharing.
Your blog is a constant source of inspiration and knowledge. Thank you!
This blog is a treasure trove of knowledge. Thank you for your contributions!
What a refreshing take on this subject. I completely agree with your points!
You’ve articulated your points with such finesse. Truly a pleasure to enjoy reading.
Your ability to distill complex concepts into enjoy readingable content is admirable.
A masterpiece of writing! You’ve covered all bases with elegance.
You’ve done a fantastic job of breaking down this topic, like unlocking a door to a secret garden. Intrigued to explore more.
The writing style is captivating. Finally, something that can keep my attention longer than a TikTok video.
Shedding light on this subject like you’re the only star in my night sky. The brilliance is refreshing.
This was a thoroughly insightful read. Thank you for sharing The expertise!
You’ve articulated your points with such finesse. Truly a pleasure to enjoy reading.
Your ability to distill complex concepts into enjoy readingable content is admirable.
Your insights have added a lot of value to my understanding. Thanks for sharing.
This post is a testament to your expertise and hard work. Thank you!
You’ve opened my eyes to new perspectives. Thank you for the enlightenment!
This article is a perfect blend of informative and entertaining. Well done!
You’ve done a fantastic job of breaking down this topic. Thanks for the clarity!
Your attention to detail is remarkable. I appreciate the thoroughness of your post.
Thank you for adding value to the conversation with your insights.
This is one of the most comprehensive articles I’ve enjoy reading on this topic. Kudos!
Please let me know if you’re looking for a author for your blog. You have some really great articles and I feel I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some content for your blog in exchange for a link back to mine. Please shoot me an e-mail if interested. Thanks!
A beacon of knowledge, or so I thought until I realized it’s just The shining confidence.
I’m impressed by The ability to convey such nuanced ideas with clarity.
Truly inspirational work, or so I tell myself as I avoid my own projects.
Always learning something new here, because apparently, I didn’t pay enough attention in school.
Remember, the key with flirtatious comments is to keep them light-hearted, respectful, and ensure they’re taken in the spirit of fun and admiration.
Compelling read with well-presented arguments. I almost felt persuaded. Almost.
I admire the way you tackled this hard to understand issue. Very enlightening!
The article was a delightful read. It’s clear you’re passionate about what you do, and it shows.