Spring CRUD - Read | How to write a custom RowMapper? | Spring Jdbc Select | BeanPropertyRowmapper

In this video, we will learn to fetch data from the database. So far in this spring jdbc course, we have covered insert, delete and batch update. Now it’s time for the most important select operation(Spring CRUD - Read).

So Let’s read data by using jdbctemplate’s query method. We will also learn how to query for an individual object by using jdbctemplate’s queryForObject method.

Note that to perform a select operation using jdbctempalte, We have to understand a concept called RowMapper. The RowMapper is going to help us to fetch database records in form of a resultset. Using the RowMapper’s mapRow method we can also bind our DB record with our domain(POJO) class object.

The rowmapper fetch the complete resultset and make it available inside the maprow method one by one so that we don’t have to manually loop over the resultset.

Once we understand the RowMapper concept, we will understand Spring’s Row mapper implementation called BeanProeprtyRowMapper. It is going to help us to bind our database resultset with our domain class object without even writing a custom row mapper.

Timestamp:

Introduction : 00:00
Spring JDBC Select - Gameplan : 01:52
Spring JDBC perform a batch update: 08:29
Spring CRUD - Read Data from the database: 12:53
Spring Framework (JDBC) : QueryForObject : 37:13
Why BeanPropertyRowMapper (concept) : 44:09
Let’s code- BeanPropertyRowMapper:49:18

#SpringJdbc #jdbctemplate #seleniumexpress

For more courses visit

Any time you are getting stuck with issues, Feel free to ask for support.

you can ping me on my Facebook page

Make sure to join my private Facebook page (Ask me here)
“SeleniumExpress - Support"

you can ask for support in my website forum

Subscribe to my youtube channel

Follow me on Insta

Music :
-----------
credits: -

(channel intro)
Creative Commons — Attribution 3.0 Unported— CC BY 3.0

Song: Jarico - Island (Vlog No Copyright Music) Music promoted by Vlog No Copyright Music.

[ajaydhiman]

spelling of rool no is Roll No. :) Thanks for the video tutorial.

[force_user]

I was searching for this particular explain all day finally! now I find peace! Great video btw !!

[SeleniumExpress]

Hi Guys, Youtube is not sending notifications to everyone whenever I am publishing a new video. I don't know when this issue will be fixed. Keep checking this playlist for upcoming videos.

[neerajchavan]

In case you getting exceptions for performing BeanPropertyRowMapper :

you need to set the value of "url" in "dataSource" bean like this...
<constructor-arg name="url"

and also remove the concatenation of sql query for BeanPropertyRowMapper i.e. (write the query in single line).

[deepakbhagat]

Lots of thanks for this type of videos...Your way of explanation is very good .

[Tripple_S]

Thanks a lot! Much more confident for my exams now :')

[bobby]

Thanks a lot sir, 🙇‍♂️😍 your are my truely "technology addiction" . Lots of love sir!!

[ganeshteradata]

Great explanation and effort. Thanks.

[amitthakur-yoxw]

Bro ur efforts are mind blowing..
Please make video on many to many, one to many, many to one.. Usi g jdbc api please ASAP.. If possible

[mohdharish]

Bro after seeing your video i am giving interview with more confidence soon I will get job.i cracked 2 round in 2 company bcoz of spring boot I lose my job

[JohnDo-]

Amazing video, thanks a lot!
I tired creating an account on Selenium but I do not receive the confirmation email. Is there a playlist with all videos from this course?

[rohithkancharla]

Bro your explanations were really great.but i get spring notes from you

[venuvamsi]

Abhilash, one doubt RowMapper Class return type is Student, then how ur handling List<Student> studentlist= jdbcTemplate. Query (sql, new Student RowMapper (student))... How it is handling internally.

[rishabhkandari]

Brother can we perform pagination and sorting in spring jdbc and if we can will you provide me some references material or make small video on it

[signmeupnow]

Abhilash, could you tell me what is the best way to map LocalDate and LocalTime properties in my custom RowMapper?

[RanveerSingh-yzfv]

how to use beanpropertyrowmapper when i need to select only name or address.... because rest will returned as null but we dont need

[BonuSurajworld]

Hi sir,
Thanks for spring video it helps alot.
Sir any planing for posting spring boot video?

[bobby]

Hi sir, a small Request from my end, actually i was under job search as java developer, since i have taken up an interview call today, it didn't go well.. except the questions on spring core and MVC, I was unable to answer a few questions on core java especially "multithreading concept". Try to include that portion as part of our regular sessions . Literally worrying sir...

[datdang]

when i finished video episode 1, i see the next video is this video, but in the play list video episode 2 is the video next this video. What video i should preview

[MuralikrishnaPennam]

StudentRowMapper insert into studentDAoImpl class but how to call that StudentRowMapper clsss method. ... Here you're not called. How is it possible