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
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
Learning with your videos makes us understand the concept in a easier way
Very useful for doing projects 👍
As always, Great. 🙏🙏
this is the best video in tamil.. Easy to learn..
You are so underrated...you are the best .. I'm watching ur videos so long
This is most valuable video without cost I will pray for you sister you should reach more subscribers ❤
Thank u sis ...so much needed topic😊
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❤
Ungaluthu than irunthu python padichen...seriously wow....enaku inum job kidaikala searching ...full stack pathi oru video podunga plzzzzzz❤️...Love you from Salem..
THANK YOU SO MUCH FOR YOUR VALUEABLE EFFORTS MAM
It was very useful for my project ma'am thank you so much.
Superb mam thank you ❤
I am from Sri lanka your videos are very useful lots of thanks 💛💛💛💛💛💛💛💛
Thank you for this video mam!! Kindly do a JavaScript full course video.
Thank you so much for this video
Very useful video mam 😊
Thank you for your time...
Javascript tutorial plz
Your way of explanation is too good
Tnx mam💖 I learned a lot :)
great work ♥
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 ...
Thank you so much 🤗..
Professional Teaching Akka 💗, next video upload in database administrator concept explanation, security and backup.
Thank you sister 🙏🙏
Mam try to upload complete tutorial on servlet ,springboot ur videos are so helpful
@viratabd4992
10 күн бұрын
Yes mam please
Very useful mam👍
Thank you so much
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
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
super akka vera level teaching
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
Worth 🔥❤️
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?
Hi Akka.. Spring boot la irukura annotations la epdi therinjikirathu... Intha project spring boot la pandringala?
Good teaching ☺️☺️☺️☺️
jsp,servlet and springboot videos plz
Same with springboot it's very useful..and java 8 content please upload
Video editing ku enna application use pannuveenga ?
Pls start spring boot mam
Hooo super mam... Useful for me.... Mam apadiya Servlet, JSP and JSTL poduga mam
Hi, i am not getting "Build Path" option while trying to build the jar file..can someone help me on this...thank you
sp2 method la that particular id matu dha display aganum but enaku elame display anyone help me with this
madam please post course for javascript for front end development ... will be verymuch helpful eagerly waiting to learn from you about javascript completely.
Thank you madam
Super sis ...nice explanation ...Php tutorial podunga sis
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.
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!
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
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.
Akka implementation engg role worth ah ilaiya akka plzz akka solunga
JavaScript ku video post pannunga akka.. Romba useful ah irukkum
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
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?
Mam how make this as realtime project with data updation in database and using time for all buses
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.
Front end developer HTML CSS JAVASCRIPT REACT OR ANGULAR BOOTSTRAP ORU complete ahh oru tutorial upload panugha mam
Tq mam
keep going akka..!!!!😍
Mam neenga edhula sql use pannirukingala ? Kindly reply
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)???
i know html css jdbc &sql how to connect mam .
Netbeans la indha program code pana mudiyadha mam?
Mam next Java script video upload panugha mam Useful ahh irukum
Hello akka can you try to upload spring boot tutorial any way your videos are very use-full thank you
Sekrama va 100k silver button vanguvinga akka
Hii can u pls combine python and MySQL by doing some projecta
Super kao
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 ..
Sister neenga eclipse la use panra theme and font name sollunga.....pls
Kindly post Django tutorial plz......and your python video was very easy to understand so plz Django
Intha project aa resume la add pannalama
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
Жыл бұрын
Not possible
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
Spring boot video podunga...
Sis React video podunga
Akka Java debugging concept depth ah oru video please!! And documentation pathi konjam sollunga pls!!!
Mam jsp servlet video podunga mam plzz
Akka enna app create pnna souli thainga
Akka please dynamic programs podunga. Dynamic programs in c,c++,java, python without static concept only in dynamic
Mam, jsp and servlet topic cover pannamudiuma
can you send the code in mysql database your class was..supperbb!!!....easy to understand
Mam I need a java trainer for my project!. Pls reply mam
Ma'am spring or spring boot full tutorial podunga ma'am pls... Thanks to java full course
Akka javascript edutha front end ku romba usefull ahh irukum illana anyone framework solli kudunga
spring Boot pathi video podunga sis
Madam ... Spring Boot java podunga with PSQL sollithaga mam
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.
Pls start react js mam
Mam are conduct course in offline?
Please do a full video course on scala
Mam javascript continue pannalam mam after html and css ,,please mam...
Javascript series start pannuga mam plz mam ✨
Mam neega pesurathu cute AA iruku..
Akka manual testing and automation videos poduga
If I get placed in it company that's only because of you the way you teach things is very clear❤❤❤
Hi ... Pls take spring boot tutorial
Can you post video about java testing
Java playlist la irukka vidios order wise thane sister, beginner to advanced.i want to learn java. Please reply.
@LogicFirstTamil
Жыл бұрын
yes.