JDBC - Java Database Connectivity | Bus Reservation Project with DB connection | Logic First Tamil

Java Database connectivity explained with lots of examples and a project.
00:00:00 - prerequisite
00:00:45 - what is JDBC
00:05:38 - Driver Manager
00:06:38 - types of drivers
00:09:59 - creating DB and Table in mysql
00:10:37 - using JDBC to read data
00:19:45 - adding JDBC mysql JAR file
00:24:42 - Insert record using JDBC
00:27:00 - executeQuery vs executeUpdate
00:29:04 - inserting with variable
00:33:57 - PreparedStatement
00:38:40 - delete
00:40:28 - update
00:41:31 - calling simple stored procedure
00:46:55 - stored procedure with IN parameter
00:49:33 - stored procedure with OUT parameter
00:55:06 - commit vs autocommit
01:03:17 - batch processing
01:06:33 - rollback
01:11:12 - Bus reservation project using jdbc
01:20:47 - what is mvc?
01:22:56 - creating bus and booking tables
01:24:26 - DbConnection class
01:28:34 - throws
01:29:15 - BusDAO class
01:37:30 - modifying isAvailable method
01:46:29 - BookingDAO class
01:57:24 - handling exception
01:59:02 - why DbConnection as separate class?
02:00:25 - enhancements
02:01:04 - further learning
JDBC mysql Jar file download link,
dev.mysql.com/downloads/file/...
Bus Reservation Project,
• Java Bus Reservation S...
JDBC code - github.com/LogicFirstTamil/JD...
Github CodeLink - github.com/LogicFirstTamil
--------------------------------------- courses and playlists -------------------------------------------------
HTML and CSS: • Html and CSS
SQL: • SQL
DS and ALGO in C/CPP: • Introduction to Data S...
DS and ALGO in Java: • Introduction to Data S...
Python Full Course with game: • Learn Python in Tamil ...
Java Playlist: • Learn Java in Tamil
Java one video: • Java Full Course in Ta...
C Interview program playlist: • C Interview Programs i...
C programming in one video: • C Programming in Tamil...
C programming playlist: • Introduction to C prog...
C++ Playlist link: • C++ Programming in Tamil
English channel link: / @logicfirst31

Пікірлер: 201

  • @Candy-sh4qs
    @Candy-sh4qs Жыл бұрын

    Thank you so much mam, because of this short explanation from 24:00 to 40:00, I passed my sem examination today.. There is no video as best as yours for this topic in KZread. Once again thank you so much

  • @ashuzakir5474
    @ashuzakir5474 Жыл бұрын

    Learning with your videos makes us understand the concept in a easier way

  • @ACUCSPRADEEPB-up9ne
    @ACUCSPRADEEPB-up9ne Жыл бұрын

    Very useful for doing projects 👍

  • @Nagaraj-uj8sr
    @Nagaraj-uj8sr Жыл бұрын

    As always, Great. 🙏🙏

  • @mahe5267
    @mahe5267 Жыл бұрын

    this is the best video in tamil.. Easy to learn..

  • @naren5382
    @naren5382 Жыл бұрын

    You are so underrated...you are the best .. I'm watching ur videos so long

  • @04praveenrajan.s93
    @04praveenrajan.s939 ай бұрын

    This is most valuable video without cost I will pray for you sister you should reach more subscribers ❤

  • @waytoawake6394
    @waytoawake6394 Жыл бұрын

    Thank u sis ...so much needed topic😊

  • @6032-Mathivanan.T-kc8nt
    @6032-Mathivanan.T-kc8nt4 ай бұрын

    Akka I'm here after some 20 videos regarding this java and db connectivity but this one is awesome.. ❤❤❤❤❤❤ loved it and ur way of explanation and teaching.. ❤ u nailed it. And I'm really worrying that i missed this video this long. Such a gem this content is. A lot of love and thanks❤

  • @sowndaryasaravanan1159
    @sowndaryasaravanan1159 Жыл бұрын

    Ungaluthu than irunthu python padichen...seriously wow....enaku inum job kidaikala searching ...full stack pathi oru video podunga plzzzzzz❤️...Love you from Salem..

  • @kash1903
    @kash19033 ай бұрын

    THANK YOU SO MUCH FOR YOUR VALUEABLE EFFORTS MAM

  • @jokipl6669
    @jokipl66692 ай бұрын

    It was very useful for my project ma'am thank you so much.

  • @travelpayya2668
    @travelpayya2668 Жыл бұрын

    Superb mam thank you ❤

  • @mtamil6946
    @mtamil69468 ай бұрын

    I am from Sri lanka your videos are very useful lots of thanks 💛💛💛💛💛💛💛💛

  • @snowysecret4178
    @snowysecret4178 Жыл бұрын

    Thank you for this video mam!! Kindly do a JavaScript full course video.

  • @saranya-do4xf
    @saranya-do4xf Жыл бұрын

    Thank you so much for this video

  • @shortboy9976
    @shortboy9976 Жыл бұрын

    Very useful video mam 😊

  • @palanikumar1777
    @palanikumar1777 Жыл бұрын

    Thank you for your time...

  • @sushmithas504
    @sushmithas504 Жыл бұрын

    Javascript tutorial plz

  • @tamizhazhaganjayapal6525
    @tamizhazhaganjayapal65258 ай бұрын

    Your way of explanation is too good

  • @chandruram7553
    @chandruram75535 ай бұрын

    Tnx mam💖 I learned a lot :)

  • @anuanushiya937
    @anuanushiya9377 күн бұрын

    great work ♥

  • @Surajeeth_S_UE
    @Surajeeth_S_UE Жыл бұрын

    Mam i have to ask u one thing mam to learning java back end and going for DSA or Java full satck after that DSA is best according to future scope and good package ...

  • @ACUCSPRADEEPB-up9ne
    @ACUCSPRADEEPB-up9ne Жыл бұрын

    Thank you so much 🤗..

  • @balavikeshd491
    @balavikeshd491 Жыл бұрын

    Professional Teaching Akka 💗, next video upload in database administrator concept explanation, security and backup.

  • @sharehdk4372
    @sharehdk4372 Жыл бұрын

    Thank you sister 🙏🙏

  • @rithanyaarithu606
    @rithanyaarithu606 Жыл бұрын

    Mam try to upload complete tutorial on servlet ,springboot ur videos are so helpful

  • @viratabd4992

    @viratabd4992

    10 күн бұрын

    Yes mam please

  • @divyams29
    @divyams292 ай бұрын

    Very useful mam👍

  • @ajithvlog
    @ajithvlog11 ай бұрын

    Thank you so much

  • @varshuanu1164
    @varshuanu1164 Жыл бұрын

    Goood evening mam ur videos were awesome i recommended many of my friends to watch will u pls make video for agriculture monitoring system please mam so it may help my project mam

  • @dinesh.p5288
    @dinesh.p5288 Жыл бұрын

    Akka python la coding yaluthu rom la atha thoda output ta matum share pana mudiyum ma frds ku ana coding yalam thariya ku da thu

  • @KishoreRSK1
    @KishoreRSK1 Жыл бұрын

    super akka vera level teaching

  • @innocent_star408
    @innocent_star408 Жыл бұрын

    Akka ..Java or javascript which best..Java programming la evalo try painaluimm problem solving skill varamadukuthu..epadii try out painu sollu kudugaha akka..aprm windows builder function and jframe reindu meii same tha ha...Jframe ,applet awt , atha side poganuma .. interview ku ..illa core java lei strong ha irugavaha..CORE JAVA AND DSA leii strong irutha pothuma

  • @Karthick--IT
    @Karthick--IT Жыл бұрын

    Worth 🔥❤️

  • @rakshithkumarg1839
    @rakshithkumarg18397 ай бұрын

    Hello ma'am. Im getting can not issue executeUpdate() or executeLargeUpdate() with statements that produce result sets exception. What's the solution for this exception?

  • @krishnarajasiva9351
    @krishnarajasiva9351 Жыл бұрын

    Hi Akka.. Spring boot la irukura annotations la epdi therinjikirathu... Intha project spring boot la pandringala?

  • @webgraphic4306
    @webgraphic4306 Жыл бұрын

    Good teaching ☺️☺️☺️☺️

  • @ramkumarkasi5281
    @ramkumarkasi5281 Жыл бұрын

    jsp,servlet and springboot videos plz

  • @rishaworldwithlove
    @rishaworldwithlove Жыл бұрын

    Same with springboot it's very useful..and java 8 content please upload

  • @rajinishankar1425
    @rajinishankar1425 Жыл бұрын

    Video editing ku enna application use pannuveenga ?

  • @jayasurya.p4301
    @jayasurya.p430110 ай бұрын

    Pls start spring boot mam

  • @rrrrrrrr2741
    @rrrrrrrr2741 Жыл бұрын

    Hooo super mam... Useful for me.... Mam apadiya Servlet, JSP and JSTL poduga mam

  • @user-hf2uk3tp4j
    @user-hf2uk3tp4j6 ай бұрын

    Hi, i am not getting "Build Path" option while trying to build the jar file..can someone help me on this...thank you

  • @jayapradeesh7204
    @jayapradeesh72043 ай бұрын

    sp2 method la that particular id matu dha display aganum but enaku elame display anyone help me with this

  • @manigandan88
    @manigandan88 Жыл бұрын

    madam please post course for javascript for front end development ... will be verymuch helpful eagerly waiting to learn from you about javascript completely.

  • @suryaravi-bw6hs
    @suryaravi-bw6hs Жыл бұрын

    Thank you madam

  • @arunadhayalan5695
    @arunadhayalan5695 Жыл бұрын

    Super sis ...nice explanation ...Php tutorial podunga sis

  • @kirubaganesan8171
    @kirubaganesan8171 Жыл бұрын

    mam when we do multiple update it shows. Lock wait timeout exceeded; try restarting transaction exception . Can you explain why this exception occur and how to resolve it.

  • @curious9381
    @curious938111 ай бұрын

    I extracted this zip file 'mysql-connector-j-8.1.0'. But there is no jar file...same like you're showing in the tutorial. Why is it so? Instead, I have the 'java.sql.Driver' file in the following location ....Downloads\mysql-connector-j-8.1.0\mysql-connector-j-8.1.0\mysql-connector-j-8.1.0\META-INF\services\java.sql.Driver. So i used it but its not working. Anyone help is highly appreciated!

  • @Peaceful1712
    @Peaceful1712 Жыл бұрын

    Mam na html css and servelt use panni login page create panna ... but yepdii connect pannii out put vara vaikrathu nu purilla ....konja athu kaga vedio podunga.. NetBeans IDE vachiii

  • @megalar5013
    @megalar5013 Жыл бұрын

    Ur teaching is very clear to understand mam. I have a career Gap in 5years. How I get a job?Which course is suitable mam.

  • @darlingprince.19
    @darlingprince.19 Жыл бұрын

    Akka implementation engg role worth ah ilaiya akka plzz akka solunga

  • @vengadeshvrh
    @vengadeshvrh Жыл бұрын

    JavaScript ku video post pannunga akka.. Romba useful ah irukkum

  • @Manoj-mh6cp
    @Manoj-mh6cp Жыл бұрын

    Maam i had a doubt. I create a separate class for cancellation and call tha database. I gave query for delete that database.. My doubt is cancellation need one class or two class one class for get important from user and another one for database and delete tha data. It's crct or wrong maam

  • @SathishKumar-rd2tl
    @SathishKumar-rd2tl Жыл бұрын

    Hi mam, nan ipo oru medical billing company la work pannitu irukken, I'm be cse 2015 passed out, ipo it field kulla poga mudiyuma?

  • @sathishg3636
    @sathishg3636 Жыл бұрын

    Mam how make this as realtime project with data updation in database and using time for all buses

  • @user-ut5jk8rs9q
    @user-ut5jk8rs9q10 ай бұрын

    sister, but i didn't get values properly like - first id came and then all salaries came then the rest of id, name shows. how to get properly.

  • @thivakarans4525
    @thivakarans4525 Жыл бұрын

    Front end developer HTML CSS JAVASCRIPT REACT OR ANGULAR BOOTSTRAP ORU complete ahh oru tutorial upload panugha mam

  • @harikrish07
    @harikrish0711 ай бұрын

    Tq mam

  • @Joel-gb8cm
    @Joel-gb8cm Жыл бұрын

    keep going akka..!!!!😍

  • @user-kn8oe6gn9o
    @user-kn8oe6gn9o7 ай бұрын

    Mam neenga edhula sql use pannirukingala ? Kindly reply

  • @alaudeenbasha5134
    @alaudeenbasha5134 Жыл бұрын

    Exception in thread "main" java.lang.Error: Unresolved compilation problems: Connection cannot be resolved to a type DriverManager cannot be resolved Statement cannot be resolved to a type ResultSet cannot be resolved to a type at jdbc/jdbc.Demo1.main(Demo1.java:16)???

  • @Naveenkumar-sh4xc
    @Naveenkumar-sh4xc4 ай бұрын

    i know html css jdbc &sql how to connect mam .

  • @vigneshv4561
    @vigneshv45617 ай бұрын

    Netbeans la indha program code pana mudiyadha mam?

  • @thivakarans4525
    @thivakarans4525 Жыл бұрын

    Mam next Java script video upload panugha mam Useful ahh irukum

  • @suryavlogs3809
    @suryavlogs3809 Жыл бұрын

    Hello akka can you try to upload spring boot tutorial any way your videos are very use-full thank you

  • @tamiltalks8356
    @tamiltalks8356 Жыл бұрын

    Sekrama va 100k silver button vanguvinga akka

  • @kriven1857
    @kriven1857 Жыл бұрын

    Hii can u pls combine python and MySQL by doing some projecta

  • @kidoo1567
    @kidoo1567 Жыл бұрын

    Super kao

  • @Surajeeth_S_UE
    @Surajeeth_S_UE Жыл бұрын

    AND mam pls post one video for java and DSA to a top companies road map mam .. It will use full for many of then mam ..

  • @dhileepkumar1579
    @dhileepkumar1579 Жыл бұрын

    Sister neenga eclipse la use panra theme and font name sollunga.....pls

  • @lifestyle7313
    @lifestyle7313 Жыл бұрын

    Kindly post Django tutorial plz......and your python video was very easy to understand so plz Django

  • @yogeshwaran3250
    @yogeshwaran325010 ай бұрын

    Intha project aa resume la add pannalama

  • @gowsalyar.s1377
    @gowsalyar.s1377 Жыл бұрын

    Mam some doubt mam I use sql*plus database mam anyone create the data stored in database but also access that mam... So that connection how to work is possible to connect in java mam ?

  • @gowsalyar.s1377

    @gowsalyar.s1377

    Жыл бұрын

    Not possible

  • @RakeshKumar-en1uq
    @RakeshKumar-en1uq Жыл бұрын

    Ma'am indha video paarthu same way la small jdbc project panniruka... please ma'am next tutorial la spring boot, microservice, Hibernate concept pathi podunga

  • @ravish-zi4my
    @ravish-zi4my Жыл бұрын

    Spring boot video podunga...

  • @santhosh6634
    @santhosh6634 Жыл бұрын

    Sis React video podunga

  • @sathishg3636
    @sathishg3636 Жыл бұрын

    Akka Java debugging concept depth ah oru video please!! And documentation pathi konjam sollunga pls!!!

  • @allfancelikeme6078
    @allfancelikeme6078 Жыл бұрын

    Mam jsp servlet video podunga mam plzz

  • @RajeshRajesh-bk1ic
    @RajeshRajesh-bk1ic Жыл бұрын

    Akka enna app create pnna souli thainga

  • @GoogleAccount-ph8mm
    @GoogleAccount-ph8mm Жыл бұрын

    Akka please dynamic programs podunga. Dynamic programs in c,c++,java, python without static concept only in dynamic

  • @bhuavneshdb_art7189
    @bhuavneshdb_art7189 Жыл бұрын

    Mam, jsp and servlet topic cover pannamudiuma

  • @user-bc7kc9qf4y
    @user-bc7kc9qf4y8 ай бұрын

    can you send the code in mysql database your class was..supperbb!!!....easy to understand

  • @fazlurrahman5944
    @fazlurrahman5944 Жыл бұрын

    Mam I need a java trainer for my project!. Pls reply mam

  • @chikkenrice2512
    @chikkenrice2512 Жыл бұрын

    Ma'am spring or spring boot full tutorial podunga ma'am pls... Thanks to java full course

  • @kathirstuvad8102
    @kathirstuvad8102 Жыл бұрын

    Akka javascript edutha front end ku romba usefull ahh irukum illana anyone framework solli kudunga

  • @amirthas4574
    @amirthas4574 Жыл бұрын

    spring Boot pathi video podunga sis

  • @vijayn7822
    @vijayn7822 Жыл бұрын

    Madam ... Spring Boot java podunga with PSQL sollithaga mam

  • @meiyappanamirthalingam1619
    @meiyappanamirthalingam1619 Жыл бұрын

    HI Akka. Thank you so much for these videos akka. Oru help akka. Bus reservation full ah finish panidalaam Akka. Ipo pana varaikum UI design ah integrate panalam Akka.

  • @jayasurya.p4301
    @jayasurya.p430110 ай бұрын

    Pls start react js mam

  • @MariMuthu-qs9zv
    @MariMuthu-qs9zv Жыл бұрын

    Mam are conduct course in offline?

  • @Chickenworldbuk
    @Chickenworldbuk Жыл бұрын

    Please do a full video course on scala

  • @cherrywork
    @cherrywork Жыл бұрын

    Mam javascript continue pannalam mam after html and css ,,please mam...

  • @ranjith7936
    @ranjith7936 Жыл бұрын

    Javascript series start pannuga mam plz mam ✨

  • @MuthuMurugesanofficial
    @MuthuMurugesanofficial9 ай бұрын

    Mam neega pesurathu cute AA iruku..

  • @Dinesh-hd5wq
    @Dinesh-hd5wq Жыл бұрын

    Akka manual testing and automation videos poduga

  • @priyankapriyanka4216
    @priyankapriyanka42166 ай бұрын

    If I get placed in it company that's only because of you the way you teach things is very clear❤❤❤

  • @player-lm9rf
    @player-lm9rf Жыл бұрын

    Hi ... Pls take spring boot tutorial

  • @danieljabarajv
    @danieljabarajv2 күн бұрын

    Can you post video about java testing

  • @dineshchellaiahc4588
    @dineshchellaiahc4588 Жыл бұрын

    Java playlist la irukka vidios order wise thane sister, beginner to advanced.i want to learn java. Please reply.

  • @LogicFirstTamil

    @LogicFirstTamil

    Жыл бұрын

    yes.