Ravi R. Oza

JDBC Callable Statement example

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

Follow me @

JDBC Prepared Statement example

Prepared Statement to execute queries for MySql (Gujarati)

In this video, PreparedStatement 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.

Follow me @

JDBC Statement example

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.

Follow me @

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

JDBC Connection example

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://mvnrepository.com/artifact/mysql/mysql-connector-java

Follow me @

Sep 22, 2020

Servlet Revisited

Video was recorded on 8th August 2020, in this session few topics of servlet are revised such as (1) working with Single Thread model and why do we need to use this. (2) Servlet mapping is also revised here in context to what is going to happen if a servlet is mapped from web.xml file and what if a servlet contains both method doGet() and doPost() for handling client request.

It is not the usual scenario where a YouTuber record the video tutorial and published on YouTube, but here I made an extra effort for live tutorial with student interaction. Live demonstration of programming, as well as queries of students are solved in this live session.

Servlet methods: service, doGet(), doPost(). How to use and manage these three methods with respect to client request type.

Follow me @

Single Thread Model in Servlet

Single Thread Model:

It was designed to guarantee that only one thread is executed at a time in a given servlet instance’s service method.

It should be implemented to ensure that servlet can handle only one request at a time.

It is a marker interface and has no methods.

This interface is currently deprecated.

Once the interface is implemented the system guarantees that there’s never more than one request thread accessing a single instance of servlet.

Follow me @

Servlet Collaboration

Some times servlets have to cooperate, i.e. usually by sharing information.

This communication can be called as Sort Servlet collaboration.

The servlet, which are collaborating, can pass the shared information directly from one servlet to another. Request Dispatcher defines an object that receives requests from the client and sends them to any resource (such as a servlet, HTML file, or JSP file) on the server. The servlet container creates the RequestDispatcher object, which is used as a wrapper around a server resource located at a particular path or given by a particular name.

Follow me @