Stored procedures are sub routines, segment of SQL statements which are stored in SQL catalog. All the applications that can access Relational databases (Java, Python, PHP etc.), can access stored procedures.Stored procedures contain IN and OUT parameters or both. They may return result sets in case you use SELECT statements. Stored procedures can return multiple result sets.Creating a Stored procedureSuppose, we have created a table named Employee in MySQL database as shown below:String createTable = "CREATE TABLE Employee("    + "Name VARCHAR(255), "    + "Salary INT NOT NULL, "    + "Location VARCHAR(255))";Following is an example of a MySQL ... Read More

Your web application may define several different filters with a specific purpose. Consider, you define two filters AuthenFilter and LogFilter. Rest of the process will remain as explained above except you need to create a different mapping as mentioned below −    LogFilter    LogFilter           test-param       Initialization Paramter        AuthenFilter    AuthenFilter           test-param       Initialization Paramter        LogFilter    /* AuthenFilter /* Filters Application OrderThe order of filter-mapping elements ... Read More

Following example shows how to print the client's IP address and the current date time, each time it would access any JSP file. This example will give you a basic understanding of the JSP Filter, but you can write more sophisticated filter applications using the same concept −// Import required java libraries import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.util.*; // Implements Filter class public class LogFilter implements Filter {    public void init(FilterConfig config) throws ServletException {       // Get init parameter       String testParam = config.getInitParameter("test-param");       //Print the init parameter ... Read More

Servlet and JSP Filters are Java classes that can be used in Servlet and JSP Programming for the following purposes To intercept requests from a client before they access a resource at the back end.To manipulate responses from the server before they are sent back to the client.There are various types of filters suggested by the specifications −Authentication FiltersData compression FiltersEncryption FiltersFilters that trigger resource access eventsImage Conversion FiltersLogging and Auditing FiltersMIME-TYPE Chain FiltersTokenizing FiltersXSL/T Filters That Transform XML ContentFilters are deployed in the deployment descriptor file web.xml and then map to either servlet or JSP names or URL patterns in ... Read More

Following is a generic example which uses getParameterNames() method of HttpServletRequest to read all the available form parameters. This method returns an Enumeration that contains the parameter names in an unspecified order.Once we have an Enumeration, we can loop down the Enumeration in the standard manner, using the hasMoreElements() method to determine when to stop and using the nextElement() method to get each parameter name.           HTTP Header Request Example                        HTTP Header Request Example                 ... Read More

Checkboxes are used when more than one option is required to be selected.Following is an example HTML code, CheckBox.htm, for a form with two checkboxes.                     Maths           Physics           Chemistry                     The above code will generate the following result − Maths  Physics  Chemistry Following is main.jsp JSP program to handle the input given by the web browser for the checkbox button.           Reading Checkbox Data               Reading Checkbox Data                Maths Flag:                                  Physics Flag:                                  Chemistry Flag:                               The above program will generate the following result −Reading Checkbox DataMaths Flag :: onPhysics Flag:: nullChemistry Flag:: on

Below is the main.jsp JSP program to handle the input given by web browser using the GET or the POST methods.Infact there is no change in the above JSP because the only way of passing parameters is changed and no binary data is being passed to the JSP program. File handling related concepts will be explained in a separate chapter where we need to read the binary data stream.           Using GET and POST Method to Read Form Data                        Using POST Method to Read ... Read More

Consider including the following properties for an attribute −S.No.Property & Purpose1nameThe name element defines the name of an attribute. Each attribute name must be unique for a particular tag.2requiredThis specifies if this attribute is required or is an optional one. It would be false for optional.3rtexprvalueDeclares if a runtime expression value for a tag attribute is valid4typeDefines the Java class-type of this attribute. By default, it is assumed as String5descriptionInformational description can be provided.6fragmentDeclares if this attribute value should be treated as a JspFragment.Following is the example to specify properties related to an attribute −.....           ... Read More

You can use various attributes along with your custom tags. To accept an attribute value, a custom tag class needs to implement the setter methods, identical to the JavaBean setter methods as shown below −package com.tutorialspoint; import javax.servlet.jsp.tagext.*; import javax.servlet.jsp.*; import java.io.*; public class HelloTag extends SimpleTagSupport {    private String message;    public void setMessage(String msg) {       this.message = msg;    }    StringWriter sw = new StringWriter();    public void doTag()    throws JspException, IOException {       if (message != null) {          /* Use message from attribute ... Read More

A custom tag is a user-defined JSP language element. When a JSP page containing a custom tag is translated into a servlet, the tag is converted to operations on an object called a tag handler. The Web container then invokes those operations when the JSP page's servlet is executed.JSP tag extensions let you create new tags that you can insert directly into a JavaServer Page. The JSP 2.0 specification introduced the Simple Tag Handlers for writing these custom tags.To write a custom tag, you can simply extend the SimpleTagSupport class and override the doTag() method, where you can place your ... Read More