JDBC Video Tutorial

JDBC Part-1 | JDBC Connection for MySql using Type-4 Driver (Gujarati)

MySql Database Connection.

In this video, first the packages related to JDBC is imported, then the jar files related to MySql Database is attached in the project in configure build path, then the using Class.forName() the driver is loaded in memory.

After that Url, User and password are defined.

DriverManager.getConnection(url, user, password) is used to open the connection.

And, finally after the successfully opening the connection, the connection is closed to complete the connection internal processes.

MySql Connector Jar Type-4 (MySql Driver file)

https://raviroza.wordpress.com/advance-java/jdbc/

https://mvnrepository.com/artifact/mysql/mysql-connector-java

JDBC Part-2 | Statement to execute queries for MySql (Gujarati)

Statement interface is used to execute queries and other database operation in database.

Methods such as execute(), executeUpdate() and executeQuery() is used to execute queries related to  DDL, DML and respectively.

In this example, there is also a demonstrate regarding reading field values from user using scanner class object. There is also a result set to read values from table using select keyword in queries.

JDBC Part-3 | Prepared Statement to execute queries for MySql (Gujarati)

In this video, PreparedStatment  interface is used to execute queries and other database operation in database.

Methods such as execute(), executeUpdate() and executeQuery() is used to execute queries related to  DDL, DML and respectively.

In this example, there is also a demonstrate regarding reading field values from user using scanner class object. There is also a result set to read values from table using select keyword in queries.

JDBC Part-4 | Callable Statement to execute Stored Procedure in MySQL (Gujarati)

In this video, CallableStatment interface is used to execute stored procedure.

Methods such as execute(), executeUpdate() and executeQuery() is used to execute stored procedures.

In this example, there is also a demonstration on how to insert a record using stored procedure, as well as there is also a procedure that return the name of employee from given employee number. 

Software's used:

JDK for java library

MySql connector (Native Driver file)

Eclipse for compiling and running java code.

MySql Workbench to manage schema

Platform : Windows 10