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,
https://dev.mysql.com/downloads/file/...

Bus Reservation Project,
   • Java Bus Reservation System Sample Project...  

JDBC code - https://github.com/LogicFirstTamil/JD...
Github CodeLink - https://github.com/LogicFirstTamil

--------------------------------------- courses and playlists -------------------------------------------------
HTML and CSS:    • Html and CSS  
SQL:    • SQL  
DS and ALGO in C/CPP:    • Introduction to Data Structures | DSA in T...  
DS and ALGO in Java:    • Introduction to Data Structures | DSA in T...  
Python Full Course with game:    • Learn Python in Tamil | Python Complete Co...  
Java Playlist:    • Learn Java in Tamil  
Java one video:    • Java Full Course in Tamil (2023) | Basics ...  
C Interview program playlist:    • C Interview Programs in Tamil  
C programming in one video:    • C Programming in Tamil | Complete C Progra...  
C programming playlist:    • Introduction to C programming in Tamil (தம...  
C++ Playlist link:    • C++ Programming in Tamil  

English channel link:    / @logicfirst31