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

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

Рет қаралды 112,680

Күн бұрын

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

Пікірлер: 204

@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 KZfaq. Once again thank you so much

@ashuzakir5474 Жыл бұрын

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

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

Very useful for doing projects 👍

@mahe5267 Жыл бұрын

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

@naren5382 Жыл бұрын

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

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

As always, Great. 🙏🙏

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

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❤

@snowysecret4178 Жыл бұрын

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

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

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

@waytoawake6394 Жыл бұрын

Thank u sis ...so much needed topic😊

@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 3 ай бұрын

THANK YOU SO MUCH FOR YOUR VALUEABLE EFFORTS MAM

@mtamil6946 8 ай бұрын

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

@jokipl6669 3 ай бұрын

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

@travelpayya2668 Жыл бұрын

Superb mam thank you ❤

@balavikeshd491 Жыл бұрын

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

@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

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

Thank you so much for this video

@shortboy9976 Жыл бұрын

Very useful video mam 😊

@tamizhazhaganjayapal6525 8 ай бұрын

Your way of explanation is too good

@rishaworldwithlove Жыл бұрын

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

@palanikumar1777 Жыл бұрын

Thank you for your time...

@sushmithas504 Жыл бұрын

Javascript tutorial plz

@KishoreRSK1 Жыл бұрын

super akka vera level teaching

@chandruram7553 6 ай бұрын

Tnx mam💖 I learned a lot :)

@rrrrrrrr2741 Жыл бұрын

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

@manigandan88 Жыл бұрын

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

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

Thank you so much 🤗..

@sharehdk4372 Жыл бұрын

Thank you sister 🙏🙏

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

Worth 🔥❤️

@rithanyaarithu606 Жыл бұрын

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

@viratabd4992 28 күн бұрын

Yes mam please

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

@ajithvlog Жыл бұрын

Thank you so much

@arunadhayalan5695 Жыл бұрын

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

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

@anuanushiya937 25 күн бұрын

great work ♥

@divyams29 3 ай бұрын

Very useful mam👍

@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

@webgraphic4306 Жыл бұрын

Good teaching ☺️☺️☺️☺️

@rakshithkumarg1839 8 ай бұрын

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?

@vengadeshvrh Жыл бұрын

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

@krishnarajasiva9351 Жыл бұрын

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

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

Thank you madam

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

@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

@jayasurya.p4301 11 ай бұрын

Pls start spring boot mam

@suryavlogs3809 Жыл бұрын

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

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

@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

@kriven1857 Жыл бұрын

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

@ramkumarkasi5281 Жыл бұрын

jsp,servlet and springboot videos plz

@sathishg3636 Жыл бұрын

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

@user-hf2uk3tp4j 6 ай бұрын

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

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

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

@rajinishankar1425 Жыл бұрын

Video editing ku enna application use pannuveenga ?

@tamiltalks8356 Жыл бұрын

Sekrama va 100k silver button vanguvinga akka

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

keep going akka..!!!!😍

@sathishg3636 Жыл бұрын

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

@curious9381 Жыл бұрын

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!

@thivakarans4525 Жыл бұрын

Mam next Java script video upload panugha mam Useful ahh irukum

@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

@lifestyle7313 Жыл бұрын

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

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

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

Akka implementation engg role worth ah ilaiya akka plzz akka solunga

@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

@harikrish07 11 ай бұрын

Tq mam

@user-ut5jk8rs9q 11 ай бұрын

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 Жыл бұрын

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

@user-bc7kc9qf4y 9 ай бұрын

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

@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)???

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

@chikkenrice2512 Жыл бұрын

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

@yogeshwaran3250 11 ай бұрын

Intha project aa resume la add pannalama

@dhileepkumar1579 Жыл бұрын

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

@jayapradeesh7204 4 ай бұрын

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

@vijayn7822 Жыл бұрын

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

@user-kn8oe6gn9o 7 ай бұрын

Mam neenga edhula sql use pannirukingala ? Kindly reply

@Naveenkumar-sh4xc 4 ай бұрын

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

@bhuavneshdb_art7189 Жыл бұрын

Mam, jsp and servlet topic cover pannamudiuma

@amirthas4574 Жыл бұрын

spring Boot pathi video podunga sis

@cherrywork Жыл бұрын

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

@kathirstuvad8102 Жыл бұрын

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

@vigneshv4561 8 ай бұрын

Netbeans la indha program code pana mudiyadha mam?

@santhosh6634 Жыл бұрын

Sis React video podunga

@kidoo1567 Жыл бұрын

Super kao

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

Spring boot video podunga...

@Rpvmusics Жыл бұрын

Please do a full video course on scala

@fazlurrahman5944 Жыл бұрын

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

@danieljabarajv 20 күн бұрын

Can you post video about java testing

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

Akka manual testing and automation videos poduga

@allfancelikeme6078 Жыл бұрын

Mam jsp servlet video podunga mam plzz

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

Mam are conduct course in offline?

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

Hi ... Pls take spring boot tutorial

@muthumani__03 Жыл бұрын

Mam....servelet and JSP tutorial podunga mam..pls

@abiabinaya3054 Жыл бұрын

Hi mam.. could you please upload a video for .net

@kkaviya2441 Жыл бұрын

Sister online laptop sales application ku oru video poodunga akka with jdbc in java....user and admin both side panra maathiri poodunga akka

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

Akka enna app create pnna souli thainga

@prashnths7841 Жыл бұрын

Sister Android app epdi panrathunu video podunga na java ungaluthu parhu karthukta

@sangeesannan2806 Жыл бұрын

Hello mam, java and spring boot video poduga

@NathiyaNathiya-iz4zq 7 ай бұрын

Mam jsp,jdbc,sql,java connection vdo podunga mam very struggling concepts mam ols mam