Spring JDBC Template Tutorial: Learn to build a full CRUD application in Spring Boot

[@Sunil_Veeramuthu]

Thanks, Dan! Actually, the JDBC API would have sufficed; you don’t need the Spring Data JDBC from the starter page as you’re not using any of the Spring Data features in this tutorial. Honestly, I like the raw power of SQL, and using the JDBC API allows me to carefully think about the database interactions and have better control over the queries. Spring Data is enough magic already; JPA on top of it is a no-no for me.

[@guitarDad100]

Very nice work. I have worked with Spring Boot JDBC but i like you CRUD DAO set up. Much cleaner. Thanks for posting this video.

[@MsPolish89]

Thank you very much, this tutorial helped me a lot to undertand the basics of jdbc template.

[@DanVega]

You are welcome!

[@michael-john4954]

Great video Dan!

[@kmekky3870]

Thanks a million Dan, we would love a follow up to this video with Rest API if you have the time.

[@georgievvladimir]

Great tutorial! BTW the only think missing here is an example of getting one course that doesn't exists.

[@fabrizziocordova5250]

Very useful and incredibly informative

[@Deepakguptasky]

Thank you Dan for this good work !

[@DanVega]

Thank you for watching!

[@pryflack3646]

Nicely done :) It would have been nice to briefly discuss the pros and cons of this tech against other similar solutions such as JDBI, mybatis (and maybe more?) I was also slightly confused why you didn’t use the @Repository annotation which could have been a little more descriptive?

[@btryx9378]

Hi, how comes that at 24:11 we put the DAO interface in the constructor instead of the class that implements it (CourseJDBCDao)? I don't really get that part. Sorry if its a dumb question.

[@ShaileshDagar]

I have a Question. Around 16:55 you said that we need only one instance of "jdbctemplate", so why not make it 'static'?

[@DanVega]

If the variable was static it would only be accessible from static methods. By declaring the variable private we are ensuring its only available in our class and Spring will handle autowiring the instance in for us. The JdbcTemplate is a singleton scope so there will only be a single instance in the application.

[@ShaileshDagar]

Thanks for answering that. Looks like I need some reading on Beans Scope.

[@MewchildyT]

Thank you, very great video!

[@DanVega]

You are welcome!

[@devoiddude]

Thank you so much for this video.

[@vivekgupta309]

very well explained. I appreciate it.

[@BrunoFPcovers]

Thank you Dan!

[@jeevanthalluri2200]

how to call stored procedure using jdbc template in spring boot frame work ? with in,out and inout parameters ? Hope i will receive the response

[@dinobulja]

Why annotating class that talks to DB as @Component. Isnt @Repository more appropriate? Thank you

[@siddharthasharma5644]

Can you show me an example how to create JavaFX project with Spring Boot? No tutorial I found of JavaFX + Spring Boot yet. I m from India and your new learner...I m waiting for that one. your JDBC Template is very easy to understand .

[@michelchaghoury9629]

Great Vid i have a Question @Dan Vega if i am using Spring Data JPA and want to map a Query Result using @Query to a non entity (for example a record used as a DTO) how can i do it ?

[@stakhovskiy]

Thanks a lot!

[@DevMERNia]

How do you model relations that have inheritance?

[@wesleyjackson7524]

hi dan!, did you made the tutorial where you build the Rest APItalks with the DAO?

[@caspianrobert7327]

You prolly dont give a damn but does any of you know a method to get back into an instagram account? I stupidly forgot my account password. I would appreciate any assistance you can offer me.

[@elonjackson5121]

@Caspian Robert Instablaster :)

[@caspianrobert7327]

@Elon Jackson Thanks so much for your reply. I got to the site thru google and im waiting for the hacking stuff now. I see it takes quite some time so I will get back to you later when my account password hopefully is recovered.

[@sachinmankotia2291]

Thanks for this video :) One question, Do you have created video to work with multiple linked tables (example Student and Course tables having 1:M mapping) with Spring jdbc? With Spring JPA, its simple as we can define all mapping in entity class, But I want to implement that using Spring data JDBC.

[@DanVega]

I don't have anything yet but I will get that on the backlog. Thank you for the suggestion. In the meantime did you have a chance to look through our documentation? docs.spring.io/spring-data/jdbc/docs/current/reference/html/

[@lastsaiyan9035]

thanks a lot, trying to transition to a java role from node.js have a java interview coming up, this helps

[@xiaoyuli4703]

Hi there, Could you please explain for me that, when you create a constructor within the CoursePlatformApplication class, and the constructor accepted a DAO as a parameter, but how is DAO parameter got passed to the constructor, I saw you use the "dao" directly in the main function. Thank you.

[@manaslovesbirds]

through Spring's Constructor dependency injection

[@ronyjohn376]

Is it worth it to upgrade from a Plain JDBC application to Spring JDBC? Is there a reason why you wouldn't suggest that approach?

[@НаташаМаксимчук-ж3к]

Ndm

[@darshanraut554]

Why not keep it simple and avoid use of templates :(

[@pryflack3646]

Can you explain yourself more? I see what seems to be a nice abstraction here with, what seems to be, reduced boilerplate. What did you feel could be simpler?

[@mr.RAND5584]

Optional.empty has console display unexpected end of JSON input at Json.parse(.....

[@praveens2272]

If you are working with database first approach and you need to write some complex queries with multiple table joins then Spring JDBC is life saver. No need to under estimate it. Spring data jpa is a good choice if you are developing brand new microsercive with code first approach and less complex database schema.

[@jeevanthalluri2200]

how to configure multiple data sources in a single spring boot project

[@DanVega]

Thanks for the suggestion. I will get that added to my backlog.

[@krishnasurisetty1362]

If we are using public CourseJdbcDaoImpl(JdbcTemplate jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; } how is the jdbc template being initialized, It needs a DataSource object in it's constructor. Please let me know how this works. Does'nt the existing code gives a null reference

[@sunilanthony17]

I need to use a database that only uses store procedures to perform CRUD operations which lands me here...Spring JPA/Hibernate is real clunky when it comes to store procedures. I also notice that query and queryForObject are deprecated. Can you show the replacement?

[@DanVega]

query will work and the last argument is any number of args jdbcTemplate.query(sql,rowMapper,id);

[@sunilanthony17]

@@DanVega Yes, it will work if you suppress the deprecation warning but I was looking for what they are replacing it with if they are deprecating "query".

[@artetl]

Thank you. That’s useful!)

[@gasparcalix2095]

GRate work!!!! it help me alot!

[@yarik83men51]

Super, you save me a time

[@ahmadraza7049]

very good explanation really loved it 🙂

[@gyorgyszabo3607]

Thank you!