JDBC in Java: Bus Reservation Project & Examples 🚍

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/?id=513754

Bus Reservation Project,
https://youtu.be/EYc5oBLYi24

JDBC code - https://github.com/LogicFirstTamil/JDBC/tree/main/JDBC/src
Github CodeLink - https://github.com/LogicFirstTamil

---------------------------------------- courses and playlists --------------------------------------------------
HTML and CSS: https://www.youtube.com/playlist?list=PLYM2_EX_xVvXZ2A08faQ_7Iz4unlGs176
SQL: https://www.youtube.com/playlist?list=PLYM2_EX_xVvUBh28ZT2i-jH7kBkTfB_W2
DS and ALGO in C/CPP: https://www.youtube.com/watch?v=QQBVNwA9rDI&list=PLYM2_EX_xVvVMXkQt4qqosJTplBq5v5oX
DS and ALGO in Java: https://www.youtube.com/watch?v=t2U989oaI1Q&list=PLYM2_EX_xVvX7_AmNY-Deacp3rT3MIXnE
Python Full Course with game: https://www.youtube.com/watch?v=BiDOehqG68g
Java Playlist: https://www.youtube.com/playlist?list=PLYM2_EX_xVvVXm005Gt5unmqW6GGMjHxa
Java one video: https://www.youtube.com/watch?v=qOWPCPCDRZs&t=2751s
C Interview program playlist: https://www.youtube.com/playlist?list=PLYM2_EX_xVvV4Kypzs6haPDJrXBaYFVEd
C programming in one video: https://www.youtube.com/watch?v=JAy56OH58Y4&t=17269s
C programming playlist: https://www.youtube.com/watch?v=xKGg8UfR0mM&list=PLYM2_EX_xVvU7N5Lcp1SjKnGN5e6riUoj
C++ Playlist link: https://www.youtube.com/playlist?list=PLYM2_EX_xVvUppW1kS91ZNEI20k1V1liI

English channel link: https://www.youtube.com/channel/UCFhHB5_2UkzB4V5iL1oaI-Q/featured