Sunday, 19 March 2017

USING PREPARED STATEMENT IN JSP

The PreparedStatement interface is a subinterface of Statement. It is used to execute parameterized query.
Improves performance: The performance of the application will be faster if you use PreparedStatement interface because query is compiled only once.

Following is the example implementing the same interface in jsp:

In this jsp execution you are not required to explicitly keep mysqlconnector.jar as it should be present in tomcats lib folder like below:








Create emp_table in mysql as follows:

 This is the output for your jsp:






No comments:

Post a Comment