JDBC Tutorial - Crash Course

[@marcobehler1395]

► Timestamps 00:00 Intro 00:16 Project Overview 01:05 H2 Database Setup 02:01 JDBC Driver List 02:41 DriverManager 03:37 JDBC Urls - Overview 04:16 H2 JDBC Url - Options 07:02 H2 - Schema/Data Initialization 10:10 SQL - SELECT FROM 10:52 SQL Injection 13:52 SQL - INSERT INTO 15:16 SQL - UPDATE 16:11 SQL - DELETE 17:32 DataSource 18:37 Connection Pools 19:22 HikariCP 22:56 Library Landscape

[@זאבאברמוביץ]

Every tutorial is very good. Please, continue with such a good and educative content. You explain everything so simple. Thanks Marco

[@milanstojkovic2630]

Every tutorial is soooo good. Please, continue with such a good and educative content

[@MirekKrenc]

I really appreciate your effort to make the tutorials so easy to follow and to understand. I like your style of teaching a lot here in yt and also from your paid tutorials. Keep it up!

[@nicudomenti5235]

Thank you very much ! You saved a lot of time not only for me but for anyone who would like to learn about JDBC in future !

[@Emilybiubiu]

Why did such a great tutorial video got so less thumbs. Thank you so much Marco to make this clear, simple, and useful tutorial for us.

[@sebon11]

Dude, your exaplanations are AMAZING & very cool & great, you deserve waaay more views. Thanks for the video!

[@thomaswaljor6692]

I like your clear explanations and the structure and order of the available topics in each video. It was a joy to watch your videos :)

[@RzariRzari]

I fought so long with H2 becuase maven dependency by default had test scope and I didn't notice it. I was so lucky i watched your maven tutorial before :D

[@mkhadka123]

Was that th reason for the error , ?? Coz when I got rid of the test in maven dependency, it WORKED!

[@2vs1]

I like how you explain these things Marco. Brilliant! Keep up the good work!

[@mistguides]

Thank you for all the effort! Subscribed as a gratitude.

[@iamsnglrty]

I just watched this video just now and it was both informative and entertaining. Thank you for making learning enjoyable! 👏👏👏

[@MarcoCodes]

Thanks for your feedback!

[@jairocket]

Hey Marco! thanks for the awesome content! Subscribing in 3, 2... :D

[@WolfBoy2700]

This was great, thank you!

[@viniciusbarbosa1901]

It's so cool to understand how it works under the hood

[@mkhadka123]

clear and to the point, great video thanks marco :)

[@enfieldli9296]

Keep up the good stuff!

[@MaximPerepelitsyn]

Thanks a lot Marco for your work, and for sharing your knowledge with peasant devs such as myself (:

[@MarcoCodes]

No such thing as peasant devs, you're just at a different point in the never-ending learning journey :)

[@nellyamirkhanian5617]

Awesome tutorial. Thank you!

[@A09550]

Lol, you said "Sayonara" at the end

[@goldgold4943]

Hi, Pls make a video on 1)shortcuts used for pro devs, 2) productivity tools used in linux terminal 3) cool linux tools that pros use, 4) best tools to view logs in linux terminal 5) debugging tricks in linux... 6) without remote debug any way to change java code in jar... 7) maven build speedup tricks 8)any way to monitor live java program internals?? 9) best ways to quickly understand new code base 10)tool to add logs automatically to record all variables in java program. 11) must have eclipse plugins 12)most commonly seen java program errors. 13) u r fav debuggin tips You blogs changed my life man.. I was searching for such kind of simple straight forward explanation for a long time... Please do seo on it.. Every new java developer must read it... You are like a God to me for teaching java... Thanks man.. God bless you...

[@MarcoCodes]

That will keep me busy for a long while :) Thanks for the ideas!

[@goldgold4943]

@@MarcoCodes thanks for the quick replies... You are awesome. 👑

[@bingtingwu8620]

Thanks for the nice videos!

[@muhammadsalah3981]

Amazing tutorial, thanks 👏

[@MarcoCodes]

Glad you liked it!

[@abdqadr]

Thank you for always

[@immortal-spirit-13]

thanks for video. it amazing 🙂

[@ciprianmunteanu6928]

At 21:08, is the problem that, due to Hikari opening multiple connections to the database, the SQL script is also run multiple times ? Also, great video!

[@MarcoCodes]

Yes, spot on!

[@maso553]

is there a way to fix that or do you just live with it as a "side-effect"?

[@yash1152]

2:46 how's intellij showing those instructions at the bottom? "Choose Lookup Item via Enter"

[@MarcoCodes]

For that there is a plugin called "Presentation Assistant".

[@yash1152]

@@MarcoCodes ohkay. thanks for sharing :)

[@SineQuaNon1]

At 15.25, how did you do the replace insert to update? That was too fast, I couldn't catch it.

[@MarcoCodes]

I think it was Ctrl+r to open the replace window, and alt+r to do the changes, if I remember correctly.

[@SineQuaNon1]

@@MarcoCodes yes, thanks.

[@mauritianallstar]

Great tutorial, what live templates are you using in intellij? Useful one I saw was to create variable without using alt+enter

[@MarcoCodes]

Actually, you can see all the keyboard shortcuts I'm using at the bottom of the screen, whenever I use them. :)

[@ikbo]

Is there an asynchronous version of jdbc?

[@MarcoCodes]

In short, no, but there are "alternatives". See: r2dbc.io/

[@fumano2679]

Aber warum weiser IDE Hintergrund? Ich checke wegen Weisem T-Shirt und weiser Wand aber meine armen Augen :(

[@MarcoCodes]

Weil beim schwarzen Hintergrund die ähnlichen Kommentare kamen: wie kann man nur schwarz machen, man kann das nicht lesen :)

[@wirito]

Not entirely happy with how you simplify things :( It is ok to work with mongodb, postgreSQL, MySQL or any other database. Just because they need to be installed doesn’t mean people aren’t gonna do it. No one works with an in memory database in the real world. I understand that you’re teaching us and you want to make it simple but please don’t keep it at a bare minimum. Hopefully you’ll take it into consideration.

[@MarcoCodes]

@wirito : Of course it is ok. That's why, in the references document, you'll find the links for the JDBC drivers for all the other databases + url strings. JDBC-wise, everything else is exactly the same for all other databases. I can't provide installation tutorials for all databases in one video, though those might follow at some point.