JDBC Tutorial - Crash Course

Поділитися
Вставка
  • Опубліковано 1 лют 2025

КОМЕНТАРІ • 49

  • @marcobehler1395
    @marcobehler1395 2 роки тому +7

    ► 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

  • @milanstojkovic2630
    @milanstojkovic2630 2 роки тому +13

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

  • @זאבאברמוביץ
    @זאבאברמוביץ Рік тому +1

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

  • @MirekKrenc
    @MirekKrenc 2 роки тому +4

    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!

  • @thomaswaljor6692
    @thomaswaljor6692 2 роки тому +1

    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 :)

  • @sebon11
    @sebon11 Рік тому

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

  • @nicudomenti5235
    @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
    @Emilybiubiu 5 місяців тому

    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.

  • @RzariRzari
    @RzariRzari 2 роки тому +1

    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
      @mkhadka123 Рік тому +1

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

  • @2vs1
    @2vs1 2 роки тому

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

  • @iamsnglrty
    @iamsnglrty Рік тому

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

  • @mistguides
    @mistguides Рік тому

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

  • @mkhadka123
    @mkhadka123 Рік тому

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

  • @WolfBoy2700
    @WolfBoy2700 2 роки тому +1

    This was great, thank you!

  • @MaximPerepelitsyn
    @MaximPerepelitsyn 2 роки тому

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

    • @MarcoCodes
      @MarcoCodes  2 роки тому +1

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

  • @A09550
    @A09550 Рік тому +1

    Lol, you said "Sayonara" at the end

  • @jairocket
    @jairocket 5 місяців тому

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

  • @enfieldli9296
    @enfieldli9296 2 роки тому +1

    Keep up the good stuff!

  • @goldgold4943
    @goldgold4943 2 роки тому

    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
      @MarcoCodes  2 роки тому +1

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

    • @goldgold4943
      @goldgold4943 2 роки тому

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

  • @nellyamirkhanian5617
    @nellyamirkhanian5617 Рік тому

    Awesome tutorial. Thank you!

  • @viniciusbarbosa1901
    @viniciusbarbosa1901 9 місяців тому

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

  • @ciprianmunteanu6928
    @ciprianmunteanu6928 2 роки тому +4

    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
      @MarcoCodes  2 роки тому +1

      Yes, spot on!

    • @maso553
      @maso553 3 місяці тому

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

  • @muhammadsalah3981
    @muhammadsalah3981 2 роки тому +1

    Amazing tutorial, thanks 👏

  • @bingtingwu8620
    @bingtingwu8620 Рік тому

    Thanks for the nice videos!

  • @yash1152
    @yash1152 Рік тому

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

    • @MarcoCodes
      @MarcoCodes  Рік тому +1

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

    • @yash1152
      @yash1152 Рік тому

      @@MarcoCodes ohkay. thanks for sharing :)

  • @abdqadr
    @abdqadr 2 роки тому

    Thank you for always

  • @immortal-spirit-13
    @immortal-spirit-13 2 роки тому

    thanks for video. it amazing 🙂

  • @mauritianallstar
    @mauritianallstar 2 роки тому

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

    • @MarcoCodes
      @MarcoCodes  2 роки тому

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

  • @SineQuaNon1
    @SineQuaNon1 Рік тому

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

    • @MarcoCodes
      @MarcoCodes  Рік тому +1

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

    • @SineQuaNon1
      @SineQuaNon1 Рік тому

      @@MarcoCodes yes, thanks.

  • @ikbo
    @ikbo Рік тому +1

    Is there an asynchronous version of jdbc?

    • @MarcoCodes
      @MarcoCodes  Рік тому +1

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

  • @fumano2679
    @fumano2679 Рік тому

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

    • @MarcoCodes
      @MarcoCodes  Рік тому

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

  • @wirito
    @wirito 2 роки тому +2

    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
      @MarcoCodes  2 роки тому +2

      @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.