Thursday, September 1, 2016

Top of Form
In this article, we are going to build a basic shopping cart using session tracking in servlet. We are going to sell pizza online. For that, we need an interface to show a list of available pizzas.
We are going to use basic HTML table layout to create our front end. Later we will use a servlet class and database to build up available items page.
You need to create a form for each item. We will be using a hidden item to send the data to our servlet. With the help of our hidden fields, we are sending the price and name of the item selected by the user.
?          
1
2
3
4
5
6
7
<form action="addtocart">
<th>Pizza Name</th> <th>Price</th> <th>Add to Cart</th>
<tr><td>Muffuleta</td><td>$20</td>
<td><input type="hidden" name="name" value="Muffuleta">
<input type="hidden" name="price" value="20">
<input type="submit" value="Add to cart"></td></tr>
</form>
Repeat the above step for all items in the catalog. We have specified the name of the servlet that is going to handle the request in the action field of our form.
Screenshot

Description: http://kb4dev.com/images/78
index.html

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
<!DOCTYPE html>
<html>
    <head>
        <title>TODO supply a title</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width">
    </head>
    <body>
             <table border="1px">
        <form action="addtocart">
    
            <th>Pizza Name</th> <th>Price</th>  <th>Add to Cart</th>
            <tr><td>Muffuleta</td><td>$20</td><td><input type="hidden" name="name" value="Muffuleta">
            <input type="hidden" name="price" value="20"><input type="submit" value="Add to cart"></td>
        </tr>
        </form>
        <form action="addtocart">
            <tr><td>Veggie Delight</td><td>$40</td><td>
            <input type="hidden" name="name" value="Veggie Delight">
            <input type="hidden" name="price" value="40"><input type="submit" value="Add to cart"></td>
        </tr> 
        </form>
         <form action="addtocart">
            <tr><td>Margherita</td><td>$10</td><td>
            <input type="hidden" name="name" value="margherita">
            <input type="hidden" name="price" value="10"><input type="submit" value="Add to cart"></td>
            </tr>
            
        </form>
</table>
    </body>
</html>


We are now going to create a session object for our shopping cart items. First we will create a class whose object will hold the shopping cart items by following this steps.
  1. Create a new Cart Java class.
?
1
2
public class Cart {
}
  1. Create a HashMap, which will hold details about items in the Cart.
?
1
HashMap<String, Integer> cartItems;
  1. The Constructor of Cart class.
?
1
2
3
public Cart(){
     cartItems = new HashMap<>();
 }
  1. Function to retrieve Cart items.
?
1
2
3
public HashMap getCartItems(){
       return cartItems;
   }
  1. Add a new Item to the shopping cart.
?
1
2
3
4
public void addToCart(String itemId, int price){
       cartItems.put(itemId, price);
   }
   
Complete Code

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
import java.util.HashMap;
/**
 *
 * @author rajat
 */
public class Cart {
    HashMap<String, Integer> cartItems;
    public Cart(){
     cartItems = new HashMap<>();
      
    }
    public HashMap getCartItems(){
        return cartItems;
    }
    public void addToCart(String itemId, int price){
        cartItems.put(itemId, price);
    }
     
}
Now create a session object that will hold our cart. We will check if the Cart returned by session exists or not. If it does not exist then, we will add new cart attribute to the session object. Then we will add the item to our cart. Follow the following steps to implement shopping cart through session tracking.


o    Create a reference of Cart, which will hold the pizza order items.
?
1
Cart shoppingCart;
o    Retrieve the Cart attribute from the session object.
?
1
2
HttpSession session = request.getSession();
shoppingCart = (Cart) session.getAttribute("cart");
o    If shopping cart doesn't exist in the session, then set a new attribute.
?
1
2
3
4
if(shoppingCart == null){
         shoppingCart = new Cart();
         session.setAttribute("cart", shoppingCart);
       }

Now we will add pizza items selected by the user to our shopping cart. We are also going to display the items from the cart by sending HTML as a response from our servlet.
Add Item To Shopping Cart
o    Fetch Selected data.
?
1
2
String name = request.getParameter("name");
Integer price = Integer.parseInt(request.getParameter("price"));
o    Put data in a hashmap.
?
1
shoppingCart.addToCart(name, price);
o    Update cart.
?
1
session.setAttribute("cart", shoppingCart);
Description: http://kb4dev.com/images/79
Display Items From Shopping Cart
  1. Get value from the shopping cart and assign it to a HashMap.
?
1
HashMap<String, Integer> items = shoppingCart.getCartItems();
  1. Create a new table to display our pizza cart.
?
1
out.println("<table border='1px'>");
  1. Each item in the HashMap will contain one row from our HTML table.
?
1
2
3
for(String key: items.keySet()){
               out.println("<tr><td>"+key+" - </td><td>"+"$"+items.get(key)+"</td></tr>");
           }
Screenshot

Description: http://kb4dev.com/images/80

Shopping Card Servlet Example
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
public class Addtocart extends HttpServlet {
    protected void processRequest(HttpServletRequest request, HttpServletResponse
response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        HttpSession session = request.getSession();
        cart shoppingCart;
        shoppingCart = (cart) session.getAttribute("cart");
        if(shoppingCart == null){
          shoppingCart = new cart();
          session.setAttribute("cart", shoppingCart);
        }
        String name = request.getParameter("name");
        Integer price = Integer.parseInt(request.getParameter("price"));
        shoppingCart.addToCart(name, price);
        session.setAttribute("cart", shoppingCart);
        try (PrintWriter out = response.getWriter()) {
            /* TODO output your page here. You may use following sample code. */
            out.println("<!DOCTYPE html>");
            out.println("<html>");
            out.println("<head>");
            out.println("<title>result</title>");           
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Pizza successfully added to cart </h1>");
            out.println("<form action='index.html'>Add more pizza item<input
type='submit' value='go'></form>");
            out.println("<hr>");
            out.println("<h2>Cart</h2>");
            HashMap<String, Integer> items = shoppingCart.getCartItems();
            out.println("<table border='1px'>");
             
            for(String key: items.keySet()){
                out.println("<tr><td>"+key+" - </td><td>"+"$"+items.get(key)+"
</td></tr>");
            }
            out.println("<table>");
            out.println("</body>");
            out.println("</html>");
             
        }
    }
We have fetched and displayed the pizza items from our shopping cart. Now we are adding an option to delete an item from the cart.
In Addtocart servlet add the following code inside processRequest() function after HTML table tag.
?
1
2
3
4
5
for(String key: items.keySet()){
               out.println("<form action='deleteItem'><input type='hidden' name='name' value='"+key+"'>
                            <tr><td>"+key+" - </td><td>"+"$"+items.get(key)+"</td><td>
                            <input type='submit' value='delete'></td></tr></form>");
           }
We have included the name of the article that should be removed in our hidden input field. When a user clicks the delete button, he will be redirected to the DeleteItem servlet.
Description: http://kb4dev.com/images/81
Implementation of DeleteItem Servlet
To delete an item from the servlet, we need to modify our cart class. Add a deleteFromCart() function.
?
1
2
3
public void deleteFromCart(String itemId){
        cartItems.remove(itemId);
    }
Now follow the steps given below to remove an item from the session object.
  1. Fetch shopping cart from the session object.
?
1
2
3
HttpSession session = request.getSession();
Cart shoppingCart;
shoppingCart = (Cart) session.getAttribute("cart");
  1. Delete an item from the cart.
?
1
shoppingCart.deleteFromCart(name);
  1. Update and fetch new cart.
?
1
2
3
4
//update
session.setAttribute("cart", shoppingCart);
// now fetch
shoppingCart = (Cart) session.getAttribute("cart");
Complete code to delete items from the shopping cart
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        String name = request.getParameter("name");
          HttpSession session = request.getSession();
        cart shoppingCart;
        shoppingCart = (cart) session.getAttribute("cart");
        shoppingCart.deleteFromCart(name);
        session.setAttribute("cart", shoppingCart);
         shoppingCart = (cart) session.getAttribute("cart");
        try (PrintWriter out = response.getWriter()) {
            /* TODO output your page here. You may use following sample code. */
            out.println("<!DOCTYPE html>");
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet deleteItem</title>");           
            out.println("</head>");
            out.println("<body>");
            HashMap<String, Integer> items = shoppingCart.getCartItems();
            out.println("<table border='1px'>");
             
            for(String key: items.keySet()){
                out.println("<form action='deleteItem'><input type='hidden' name='name' value='"+key+"'><tr><td>"+key+" - </td><td>"+"$"+items.get(key)+"</td><td><input type='submit' value='delete'></td></tr></form>");
            }
            out.println("<table>");
            out.println("</body>");
            out.println("</html>");
        }
    }














Java Server-side Programming

A Java Servlet E-Shop Case Study

1.  Introduction

In this case study, we shall develop an "e-shop" based on the Java Servlet Technology. This e-shop is a typical Internet business-to-consumer (B2C) 3-tier client/server database application, as illustrated below.
Description: HTTP_ClientServerSystem.png
A typical 3-tier client/server web database application consists of 5 components:
1.       A HTTP Server (or commonly known as Web Server), such as Apache HTTP Server, Apache Tomcat Server, Microsoft Internet Information Server (IIS), nginx, or Google Web Server (GWS).
2.       A HTTP Client, typically a Web Browser, such as FireFox, Chrome, IE or Safari.
3.       A Relational Database, such as MySQL, Oracle, IBM DB2, MS SQL Server, MS Access, SAP SyBase.
4.       Client-side programs, running inside the browser, which send requests to the server and process server's response. Client-side programs can be written in many technologies, e.g., HTML form, JavaScript, VBScript, Java Applet, Flash, ActiveX Control, and others.
5.       Server-side programs, running inside the HTTP server, which process clients' request. The server-side programs extract the query parameters submitted by the client-side programs and query the database. Server-side programs can also be written in many ways, e.g., CGI Peal, Java Servlet/JSP/JSF, ASP, PHP, and many others.
The client and server interact with each other by exchanging messages using a protocol called HTTP (HyperText Transfer Protocol). HTTP is an asymmetric request-response protocol. A client sends a request message to the server. The server processes the request and returns a response message. In other words, in HTTP, the client pulls information from the server, instead of server pushes information to the client. An HTTP server typically runs over TCP/IP, with a server IP address and on a TCP port number.
A typical sequence of operations for a webapp is as follows:
1.       A client requests and downloads an HTML page containing an HTML form (or other client-side programs).
2.       The client enters information into the form (such as search criteria), and submits these query parameters back to a server-side program for processing.
3.       The server-side program extracts the query parameters, performs the database query, and returns the query results back to the requesting client.
4.       The client displays the query results, and repeats the above steps for further request-response exchange.
Since this course is about Java, we shall build our webapp in Java. We shall write our server-side programs in Java servlets. We shall write our client-side programs in HTML forms and Java Applet.

2.  Setting up Database

The first step in building our e-shop is to setup a database. We shall call our database "ebookshop" which contains one table "books". The table "books" has 5 columns: id, title, author, price and qty. The id column is the primary key of the table.
Database: ebookshop
Table: books
+-------+----------------------------+---------------+---------+-------+
| id    | title                      | author        | price   | qty   |
| (INT) | (VARCHAR(50))              | (VARCHAR(50)) | (FLOAT) | (INT) |
+-------+----------------------------+---------------+---------+-------+
| 1001  | Java for dummies           | Tan Ah Teck   | 11.11   | 11    |
| 1002  | More Java for dummies      | Tan Ah Teck   | 22.22   | 22    |
| 1003  | More Java for more dummies | Mohammad Ali  | 33.33   | 33    |
| 1004  | A Cup of Java              | Kumar         | 44.44   | 44    |
| 1005  | A Teaspoon of Java         | Kevin Jones   | 55.55   | 55    |
+-------+----------------------------+---------------+---------+-------+

2.1  MySQL

If you are new to MySQL, read "How to Set Up MySQL and Get Started".
Start the MySQL server. Take note of the server's TCP port number. I shall assume that MySQL server is running on port 3306. The default TCP port number for MySQL server is 3306.
// For Windows
cd {path-to-mysql-bin}   // Check your MySQL bin path
mysqld --console
 
// For Mac
// Use graphical control at "System Preferences" -> MySQL
Start a MySQL client. I shall also assume that there is an authorized user called "myuser" with password "xxxx".
// For Windows
cd {path-to-mysql-bin}   // Check your MySQL bin path
mysql -u myuser -p
 
// For Mac
cd /usr/local/mysql/bin
./mysql -u myuser -p
You can run the following SQL script to set up the database:
create database if not exists ebookshop;
 
use ebookshop;
 
drop table if exists books;
create table books (
  id     int,
  title  varchar(50),
  author varchar(50),
  price  float,
  qty    int,
  primary key (id));
 
insert into books values (1001, 'Java for dummies', 'Tan Ah Teck', 11.11, 11);
insert into books values (1002, 'More Java for dummies', 'Tan Ah Teck', 22.22, 22);
insert into books values (1003, 'More Java for more dummies', 'Mohammad Ali', 33.33, 33);
insert into books values (1004, 'A Cup of Java', 'Kumar', 44.44, 44);
insert into books values (1005, 'A Teaspoon of Java', 'Kevin Jones', 55.55, 55);
 
select * from books;

3.  Apache Tomcat HTTP Server

Next, we have to setup an HTTP server to host our webapp. In this case study, we shall use Apache Tomcat Server as our HTTP server. Read "How to install Apache Tomcat server". I shall assume that our Tomcat is running under TCP port number 9999.

4.  Setting up the E-Shop Webapp

Step 1: Create the Directory Structure for a new Webapp "ebookshop"
Description: ServletCS_Directory.png
First of all, choose a name for your webapp. In this case study, we shall call it "ebookshop". Navigate to Tomcat's "webapps" directory, and create the following directory structure:
1.       Under Tomcat's "webapps" directory, create you web application root directory "ebookshop".
2.       Under "ebookshop", create a sub-directory "WEB-INF" (case sensitive, uppercase, a dash not underscore).
3.       Under "WEB-INF", create a sub-directory "classes" (case sensitive, lowercase, plural).
You need to keep your web resources in the proper directories:
1.       "ebookshop": The is called the context root (or document base directory) of your webapp. You should keep all your HTML files and resources visible to the web users (e.g., CSS, images, scripts) here.
2.       "ebookshop\WEB-INF": This directory, although under the context root, is not visible to the web users. This is where you keep your application's configuration files "web.xml".
3.       "ebookshop\WEB-INF\classes": This is where you keep all the Java source files and classes.
Step 2: Start the Tomcat Server
To start the Tomcat server:
·         For Windows: start a CMD shell and run the batch file "startup.bat" under Tomcat's "bin" directory. Tomcat will be started in a new console window.
·         For Mac OS X and Linux: start a Terminal and run "./catalina.sh run"under Tomcat's "bin" directory.
Monitor the Tomcat console, as the information and error messages, and System.out.println() issued by your programs will be sent to this console. Observe the Tomcat's TCP port number.
.....
INFO: Initializing ProtocolHandler ["http-bio-9999"]
......
INFO: Deploying web application directory ebookshop
......
INFO: Starting ProtocolHandler ["http-bio-9999"]
......
INFO: Server startup in 699 ms
Step 3: Access the Tomcat Server
The Tomcat Server has been started on TCP port 9999. The default TCP port number for HTTP protocol is 80. To access an HTTP server not running on the default TCP port 80, the port number must be explicitly specified in the URL.
To access your Tomcat Server, start a web browser (e.g., FireFox, IE, Chrome or Safari) and issue the following URL:
http://localhost:9999
The "localhost" is a special hostname (with IP address of 127.0.0.1) meant for local loop-back testing.
You could also use the IP address to access your HTTP server. You can find out your IP address by running program such as "ipconfig", "winipcfg", "ping", and etc.
You shall see the welcome page of Tomcat Server.
Description: TomcatHomePage.png
Step 5: Shutting down the Tomcat Server.
To orderly shutdown the Tomcat web server, press control-c from the Tomcat's console; or run the script "shutdown.bat" (Windows) or "./shutdown.sh" (Mac OS/Linux) under Tomcat's "bin" directory.

5.  Writing a Client-Side HTML Form

Let's write an HTML script to create a query form using checkboxes. Save the HTML file as "querybook.html" in your application root directory "ebookshop".
<html>
<head>
  <title>Yet Another e-Bookshop</title>
</head>
<body>
  <h2>Yet Another e-Bookshop</h2>
  <form method="get" action="http://localhost:9999/ebookshop/query">
    Choose an author:<br /><br />
    <input type="checkbox" name="author" value="Tan Ah Teck" />Ah Teck
    <input type="checkbox" name="author" value="Mohammad Ali" />Ali
    <input type="checkbox" name="author" value="Kumar" />Kumar
    <input type="submit" value="Search" />
  </form>
</body>
</html>
Browse the HTML page by issuing the URL:
http://localhost:9999/ebookshop/querybook.html
Description: ServletCS_Form.png
Check a box (e.g., Ah Teck) and click the "Search" button. A request will be issued to the URL specified in the <form>'s action attribute. You are expected to receive an Error "404 Page Not Found" at this stage as you have yet to write the server-side program (i.e., "query").
But observe the URL generated:
Description: ServletCS_URL.png
The query parameter, in the form of name=value pair, are extracted from the <input> tag (e.g., author=Tan+Ah+Tack). It is appended behind the URL, separated by a '?'.
Check two boxes (e.g., "Ah Teck" and "Ali") and submit the request, the URL is:
http://localhost:9999/ebookshop/query?author=Tan+Ah+Teck&author=Mohammad+Ali
Two name=value pairs are sent to the server, separated by an '&'.
Also take note that blank is replaced by '+'. This is because special characters are not permitted in the URL. They are encoded as %xx where xx is the hex code in ASCII. For example, '~' is encoded as%7e; blank is encoded as %20 or '+'.

6.  Writing Database Query Servlet

The next step is to write the server-side program, which responses to the client's request by querying the database and returns the query results. We shall use Java servlet technology in our servlet-side programming.

6.1  Java Database Programming

The steps involved in Java database programs are:
1.       Allocate a Connection object.
2.       Allocate a Statement object, under the Connection object created.
3.       Query database:
a.       Execute a SQL SELECT query by calling the executeQuery() method of the Statement object, which returns the query results in a ResultSet object; or
b.       Execute a SQL INSERT|UPDATE|DELETE command by calling the executeUpdate() method of the Statement object, which returns an int indicating the number of rows affected.
4.       Process the query result.
5.       Free the resources by closing the Statement and Connection.

6.2  Database Servlet

Let write a servlet that queries the database based on the client's request.
Step 1: Write the Servlet "QueryServlet.java"
Enter the following codes and save as "QueryServlet.java" under your web application "classes" directory, i.e., "ebookshop\WEB-INF\classes\". You must keep all your servlets in "ebookshop\WEB-INF\classes", because that is where Tomcat picks up the servlets.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
 
// Saved as "ebookshop\WEB-INF\classes\QueryServlet.java".
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
 
public class QueryServlet extends HttpServlet {  // JDK 6 and above only
 
   // The doGet() runs once per HTTP GET request to this servlet.
   @Override
   public void doGet(HttpServletRequest request, HttpServletResponse response)
                     throws ServletException, IOException {
      // Set the MIME type for the response message
      response.setContentType("text/html");
      // Get a output writer to write the response message into the network socket
      PrintWriter out = response.getWriter();
 
      Connection conn = null;
      Statement stmt = null;
      try {
         // Step 1: Create a database "Connection" object
         // For MySQL
         conn = DriverManager.getConnection(
            "jdbc:mysql://localhost:3306/ebookshop", "myuser", "xxxx");  // <<== Check
         // For MS Access
         // conn = DriverManager.getConnection("jdbc:odbc:ebookshopODBC");
 
         // Step 2: Create a "Statement" object inside the "Connection"
         stmt = conn.createStatement();
 
         // Step 3: Execute a SQL SELECT query
         String sqlStr = "SELECT * FROM books WHERE author = "
               + "'" + request.getParameter("author") + "'"
               + " AND qty > 0 ORDER BY author ASC, title ASC";
 
         // Print an HTML page as output of query
         out.println("<html><head><title>Query Results</title></head><body>");
         out.println("<h2>Thank you for your query.</h2>");
         out.println("<p>You query is: " + sqlStr + "</p>"); // Echo for debugging
         ResultSet rset = stmt.executeQuery(sqlStr); // Send the query to the server
 
         // Step 4: Process the query result
         int count = 0;
         while(rset.next()) {
            // Print a paragraph <p>...</p> for each row
            out.println("<p>" + rset.getString("author")
                  + ", " + rset.getString("title")
                  + ", $" + rset.getDouble("price") + "</p>");
            ++count;
         }
         out.println("<p>==== " + count + " records found ====</p>");
         out.println("</body></html>");
      } catch (SQLException ex) {
         ex.printStackTrace();
      } finally {
         out.close();
         try {
            // Step 5: Close the Statement and Connection
            if (stmt != null) stmt.close();
            if (conn != null) conn.close();
         } catch (SQLException ex) {
            ex.printStackTrace();
         }
      }
   }
}
Recall that the HTML form that we created earlier submits query parameters in the form of name=value pairs, (e.g., author=Tan+Ah+Teck), as part of the request. In the processing servlet, we need to extract the author name (e.g., "Tan Ah Teck") from the request to form a SQL SELECT query (e.g., SELECT * FROM books WHERE author='Tan Ah Teck'). This is done via the methodrequest.getParameter(name), which returns the value of the name=value pair.
For example, suppose that the URL is:
http://localhost:9999/ebookshop/query?author=Tan+Ah+Teck
The method request.getParameter("author") returns a String "Tan Ah Teck". The resultant "sqlStr" becomes:
SELECT * FROM books WHERE author='Tan Ah Teck' AND qty > 0 ORDER BY author ASC, title ASC
Note that you do not have to handle encoded characters such as '+', %20, '?' and '&'. They will be properly decoded by the getParameter() method.
Step 2: Compile
Compile the source code "QueryServlet.java" into "QueryServlet.class".
(For Windows)
// Assume that Tomcat is installed in d:\myProject\tomcat
d:
cd \myProject\tomcat\ebookshop\WEB-INF\classes
javac -cp .;d:\myProject\tomcat\lib\servlet-api.jar QueryServlet.java
 
(For Mac OS X)
// Assume that Tomcat is installed in /Applications/tomcat
cd /Applications/tomcat/webapps/ebookshop/WEB-INF/classes
javac -cp .:/Applications/tomcat/lib/servlet-api.jar QueryServlet.java
Step 3: Configure the Servlet
Configure the servlet by creating a configuration file called "web.xml", and save it under the "ebookshop\WEB-INF" directory.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
 
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app version="3.0"
    xmlns="http://java.sun.com/xml/ns/javaee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
    metadata-complete="true">
 
  <!-- To save as "ebookshop\WEB-INF\web.xml" -->
 
  <servlet>
    <servlet-name>EBookShopQuery</servlet-name>
    <servlet-class>QueryServlet</servlet-class>
  </servlet>
 
  <!-- Note: All <servlet> elements must be placed
       in front of <servlet-mapping> elements -->
 
  <servlet-mapping>
    <servlet-name>EBookShopQuery</servlet-name>
    <url-pattern>/query</url-pattern>
  </servlet-mapping>
 
</web-app>
In the above configuration, we map "QueryServlet.class" to request URL "/query" (thru an arbitrary but unique <servlet-name> called "EBookShopQuery"), under this webapp "ebookshop". In other words, the full request URL for this servlet is http://hostname:port/ebookshop/query. This is exactly what we have written in our HTML <form>'s action attribute.
(For Advanced Users) For Tomcat 7, which supports Servlet 3.0, you can use the @WebServlet annotation in the "QueryServlet.java" to deploy the servlet, instead of writing the "web.xml", as follows:
@WebServlet("/query")
public class QueryServlet extends HttpServlet { ...... }
Step 4: Test the Servlet
You can now try to invoke the servlet by issuing a request URL with proper query parameter:
http://localhost:9999/ebookshop/query?author=Tan+Ah+Teck
Description: ServletCS_QueryOutput.png
The request URL "/query" is mapped to the servlet "QueryServlet.class", as configured in the application "web.xml", as follows:
Description: ServletCS_QueryMapping.png
Try "View Source" (or "View Page Source") in your browser to study the output produced by the servlet. It is important to note that the client has no access to the servlet's program codes, but merely the outputs produced by the servlet.
<html><head><title>Query Results</title></head><body>
<h3>Thank you for your query.</h3>
<p>You query is: SELECT * FROM books WHERE author = 'Tan Ah Teck' AND qty > 0 ORDER BY author ASC, title ASC</p>
<p>Tan Ah Teck, Java for dummies, $11.11</p>
<p>Tan Ah Teck, More Java for dummies, $22.22</p>
<p>==== 2 records found ====</p>
</body></html>
Step 5: Invoke the Servlet from the HTML Form
Use the HTML form that you have created earlier (i.e., "querybook.html") to trigger this servlet. Take note that the request URL is coded in the <form>'s action attribute.

7.  More Java Servlet

7.1  Exercise 1: Relative URL vs. Absolute URL

In the "querybook.html", the request URL in the <form>'s action attribute (i.e., http://localhost:9999/ebookshop/query) is called an absolute URL. The hostname, port number and path are all hard-coded in an absolute URL. This will cause problem if you decide to relocate your program to another host (e.g., from the testing host into the production host), or another webapp.
Instead of using an absolute URL, we would use a relative URL (in "querybook.html") as follows:
<form method="get" action="query">
A relative URL is relative to the currently displayed page. Since the current page "querybook.html" is located at directory "http://localhost:9999/ebookshop/", the relative URL of "query" resolves into an absolute reference of "http://localhost:9999/ebookshop/query".
Relative URLs should be used (instead of absolute URLs) in your HTML pages whenever possible, so that the HTML pages can be easily relocated from one webapp to another webapp, or to another server, under difference base directory. You should only use absolute URL for referencing resources from other servers.
Try it out! Use relative URL from this point onwards.

7.2  Exercise 2: Multi-Value Query Parameter - "QueryMultiValueServlet.java"

If you check more than one boxes in the "querybook.html", the resultant URL contains multiple author=value parameters separated by an '&'. For example, if you check all three boxes, the resultant URL is:
http://localhost:9999/ebookshop/query?author=Tan+Ah+Teck&author=Mohammad+Ali&author=Kumar
However, If you check more than one authors and submit your request to the QueryServlet, the query result shows only the first author. This is because the method request.getParameter(name) returns only the first value, if there are more than one values for that particular parameter name.
We have to use the method request.getParameterValues(name) (instead of request.getParameter(name)) to handle multi-value parameters. The request.getParameterValues(name) returns anarray of String containing all the values of that parameter; whereas request.getParameter(name) returns a single String.
In the SQL SELECT command, we could use the IN predicate in the WHERE clause to select from a set of values. For example,
SELECT * FROM books WHERE author IN ('Tan Ah Teck', 'Mohammad Ali', 'Kumar')
The above SQL command is the same but simpler than:
SELECT * FROM books WHERE author='Tan Ah Teck' OR author='Mohammad Ali' OR author='Kumar'
Let us write a new servlet "QueryMultiValueServlet.java" (modified from "QueryServlet.java") to handle query parameter with multiple values. We shall map this new servlet "QueryMultiValueServlet.class" to request URL "/querymv" in the "web.xml". We shall also create a new HTML page (called "querybookmv.html") to trigger URL "/querymv". For example, if all the three checkboxes are checked, the URL triggered shall be:
http://localhost:9999/ebookshop/querymv?author=Tan+Ah+Teck&author=Mohammad+Ali&author=Kumar
Step 1: Write the "QueryMultiValueServlet.java"
Copy "QueryServlet.java" to "QueryMultiValueServlet.java".
1.       Change the classname from QueryServlet to QueryMultiValueServlet.
2.       We can include all the selected authors in the servlet's sqlstr as follows:
3.  // Step 3: Execute a SQL SELECT query
4.  String[] authors = request.getParameterValues("author");  // Returns an array
5.  String sqlStr = "SELECT * FROM books WHERE author IN (";
6.  sqlStr += "'" + authors[0] + "'";  // First author
7.  for (int i = 1; i < authors.length; ++i) {
8.     sqlStr += ", '" + authors[i] + "'";  // Subsequent authors need a leading commas
9.  }
sqlStr += ") AND qty > 0 ORDER BY author ASC, title ASC";
The getParameterValues(name) returns null if the query string does not contain parameter name (i.e., the user did not check any box). This will trigger an exception in "authors.length" in the above codes. You can use the following expression to check for the existence of a parameter:
String[] authors = request.getParameterValues("author");
if (authors == null) {
   out.println("<h2>Please go back and select an author</h2>");
   return; // Exit doGet()
} 
// Okay to perform the database query using the above codes
......
......
10.   Compile the "QueryMultiValueServlet.java" into "QueryMultiValueServlet.class".
Step 2: Configure the New Servlet in "web.xml"
In your application's "web.xml" (i.e., "ebookshop\WEB-INF\web.xml"), include a configuration to map the request URL "/querymv" to "QueryMultiValueServlet.class", as follows:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
 
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app version="3.0"
    xmlns="http://java.sun.com/xml/ns/javaee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
    metadata-complete="true">
 
  <!-- To save as "ebookshop\WEB-INF\web.xml" -->
 
  <servlet>
    <servlet-name>EBookShopQuery</servlet-name>
    <servlet-class>QueryServlet</servlet-class>
  </servlet>
 
  <servlet>
    <servlet-name>EBookShopQueryMultiValue</servlet-name>
    <servlet-class>QueryMultiValueServlet</servlet-class>
  </servlet>
 
  <!-- Note: All <servlet> elements must be placed
       in front of <servlet-mapping> elements -->
 
  <servlet-mapping>
    <servlet-name>EBookShopQuery</servlet-name>
    <url-pattern>/query</url-pattern>
  </servlet-mapping>
 
  <servlet-mapping>
    <servlet-name>EBookShopQueryMultiValue</servlet-name>
    <url-pattern>/querymv</url-pattern>
  </servlet-mapping>
 
</web-app>
IMPORTANT: Take note that you have to group all the <servlet> elements in front of the <servlet-mapping> elements. Each servlet requires one pair of <servlet> and <servlet-mapping> elements, with a unique but arbitrary <servlet-name>.
Step 3: Write the HTML Form - "querybookmv.html"
Write a new HTML form "querybookmv.html" (based on "querybook.html") to direct the action to "/querymv", as follows:
<form method="get" action="querymv">
  ......
</form>
Step 4: Test Your Application
Now, you can try out the new form, new servlet and the new configuration.
IMPORTANT: Most browsers cache pages downloaded to improve performance. You need to refresh your page. Use Ctrl-F5 (instead of F5) to refresh, which clears the cache. You may use "view source" to check and ensure that you are working on the modified page instead of the cached page.

7.3  Exercise 3: Multiple Query Parameters - "QueryMultiParamServlet.java"

Create a new servlet called "QueryMultiParamServlet.java" (based on "QueryServlet.java") to handle multiple query parameters. For example, the following URL has two parameters: author andprice.
http://localhost:9999/ebookshop/querymp?author=kumar&price=50
We shall map the request URL "/querymp" to "QueryMultiParamServlet.class" in the "web.xml" later.
Step 1: HTML form - "querybookmp.html"
Write a new HTML form (called "querybookmp.html"), which could submit two query parameters: author and price, using checkboxes and radio buttons respectively, as follows:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
<html>
<head>
  <title>Yet Another e-Bookshop</title>
</head>
<body>
  <h2>Yet Another e-Bookshop</h2>
  <form method="get" action="querymp">
    Choose an author:
    <input type="checkbox" name="author" value="Tan Ah Teck" />Ah Teck
    <input type="checkbox" name="author" value="Mohammad Ali" />Ali
    <input type="checkbox" name="author" value="Kumar" />Kumar
    <br /><br />
    Choose a price range:
    <input type="radio" name="price" value="50" checked />less than $50
    <input type="radio" name="price" value="100" />less than $100
    <br /><br />
    <input type="submit" value="Search" />
    <input type="reset" value="Clear" />
  </form>
</body>
</html>
Note that:
1.       Checkboxes (can check zero or more boxes) are used for author and radio buttons (can check zero or one box) are used for price.
2.       A "reset" button is added (<input type="reset">), which clears the inputs.
Step 2: Write the Processing Servlet - "QueryMultiParamServlet.java"
Write a servlet called "QueryMultiParamServlet.java" (based on "QueryServlet.java"). You can form the SQL statement as follows:
// Step 3: Execute a SQL SELECT query
String sqlStr = "SELECT * FROM books WHERE author = "
      + "'" + request.getParameter("author") + "'"
      + " AND price < " + request.getParameter("price")
      + " AND qty > 0 ORDER BY author ASC, title ASC";
Note that:
1.       In the SQL SELECT statement, author is a string and must be enclosed by a pair of single quotes; price is a number and cannot be quoted.
2.       The name=value pair of price="50" is interpreted as price<50 in the SELECT statement.
Compile the "QueryMultiParamServlet.java" into "QueryMultiParamServlet.class".
Step 3: Configure the servlet in "web.xml"
In your application's "web.xml" (i.e., "ebookshop\WEB-INF\web.xml"), include a configuration to map the request URL "/querymp" to "QueryMultiParamServlet.class", as follows:
Group the <servlet> elements together:
<servlet>
  <servlet-name>EBookShopQueryMultiParam</servlet-name>
  <servlet-class>QueryMultiParamServlet</servlet-class>
</servlet>
Group the <servlet-mapping> elements together:
<servlet-mapping>
  <servlet-name>EBookShopQueryMultiParam</servlet-name>
  <url-pattern>/querymp</url-pattern>
</servlet-mapping>

7.4  Exercise 4: Multiple Multi-Value Parameters (Optional)

Combining Exercises 2 and 3:
1.       Write a servlet called "QueryMultiParamValueServlet.java", that is capable of processing multiple authors and a single price.
2.       In the "web.xml", configure this servlet to map to the URL "/querymvp".
3.       Write an HTML form called "querybookmvp.html" to trigger this servlet.

7.5  Exercise 5: HTTP POST Request

HTTP defines two request methods: GET and POST. We have been using GET requests thus far (as specified in our <form>'s attribute method="get"). GET request is processed by the method doGet() in our servlet. POST request, on the other hand, is processed by a doPost() method in the servlet.
Let's try out the HTTP POST request method:
1.       Create an HTML form called "querybookpost.html" (based on "querybook.html")
a.       Change the <form>'s attribute method="get" to method="post".
b.       Change the <form>'s action attribute to action="querypost".
2.       Create a new servlet called "QueryPostServlet.java" (based on "QueryServlet.java"). Rename the method doGet() to doPost(). Compile the source.
3.       In "web.xml", configure URL "/querypost" to map to "QueryPostServlet.class"
4.       Try out the new form and new servlet.
What is the difference between GET and POST? For POST request, the query string is not shown in the URL (i.e., no "?author=Tan+Ah+Teck&..."). Instead, the query string is sent in the body of the HTTP request message. The advantages are: (a) the client will not see the strange-looking query string in the URL; (b) The GET request's query string length is limited, because it is part of the URL. POST request can send unlimited amount of data in the body of the request message.
In practice, it is common to use the same method to handle both the GET and POST requests. In this case, you could simply re-direct doPost() to doGet(). In your "QueryPostServlet.java", (a) renamedoPost() back to doGet(), and (b) write a doPost() as follow:
@Override
public void doPost (HttpServletRequest request, HttpServletResponse response)
                   throws ServletException, IOException {
   doGet(request, response);  // Re-direct POST request to doGet()
}
Try it out.

8.  Programming the Client-Side (Front-End)

In the previous sections, we used a simple HTML form of checkboxes. HTML also provides other input component, such as text field, radio button and pull-down menu.
HTML Form with "Pull-down Menu"
Create the following HTML form with a "pull-down menu" and save as "querybookmenu.html". Pull-down menu uses <select> and <option> tags. The name is specified in <select>; while the value is specified in <option>.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
<html>
<head>
  <title>Yet Another e-Bookshop</title>
</head>
<body>
  <h2>Yet Another e-Bookshop</h2>
  <form method="get" action="query">
    Choose an author:
    <select name="author" size="1">
      <option value="Tan Ah Teck">Ah Teck</option>
      <option value="Mohammad Ali">Ali</option>
      <option value="Kumar">Kumar</option>
    </select>
    <input type="submit" value="Search" />
  </form>
</body>
</html>
HTML form with Text Field
Write an HTML form with text field (called "querybooktextfield.html"). The syntax for text field is as follow. The "name" is specified in the <input> tag; while the "value" corresponds to the user's input.
<form ......>
  Enter an author: <input type="text" name="author" />
  ......
</form>
HTML form with Text Area
Text field allows you to enter a single line of text; while text area allows you to enter multiple lines. Text area uses <textarea>...</textarea> tag as follow. Write an HTML form with text area (called "querybooktextarea.html").
<form ......>
  <textarea name="author">Enter an author</textarea>
  ......
</form>

9.  Programming the Server-Side to Process Order

So far, we have tested the "query" part of the e-shop. Let us continue to allow the client to "order" items in our e-shop.
The sequence of events shall be as follow (as illustrated in the figure):
1.       A client issues URL http://hostname:9999/ebookshop/eshopquery.html. The server responses with an HTML form showing the available authors. The form is to be submitted to URL "/eshopquery", which is mapped to "EshopQueryServlet.class".
2.       The client selects the author(s) and sends the request to the "EshopQueryServlet", with request parameter "author=authorName". The servlet retrieves the authors' name, queries the database, and returns a list of available books by that authors. Instead of writing a paragraph (<p>...</p>) for each book (as in the previous exercises), the servlet shall now print a checkbox for each book. This allows the client to further interact with the server. The checkboxes are enclosed within an HTML form, which is to be submitted to URL "/eshoporder" (mapped to "EshopOrderServlet.class").
3.       The client selects the book(s) and sends the order request to the "EshopOrderServlet", with request parameter "id=xxx". The servlet retrieves the books' id, updates the database, and returns a confirmation message.
Description: ServletCS_Order.png

9.1  Display an Order Form - "EshopQueryServlet.java"

The "QueryServlet" that we wrote easier returns a static HTML page, which prints a paragraph (using <p>...</p>) for each book returned.  We shall modify it (called "EshopQueryServlet") to return adynamic HTML page containing a form of checkboxes to allow the client to order books. We shall map the "EshopQueryServlet" to URL "/eshopquery".
Recall that a checkbox is produced by an <input> tag as follows:
<input type='checkbox' name='aName' value='aValue' />aLabel
We shall use the book's id as the ordering criterion. We shall choose "id=xxx" as the name=value pair of the checkbox. We shall use author, title and price as the label for the checkbox. Hence, the servlet needs to produce an <input> tag which looks like:
<input type='checkbox' name='id' value='1001' />Tan Ah Teck, Java For Dummies, $11.11
Take note that I used single-quotes (instead of double quotes) for the attribute values in the above HTML tags, as they are easier to print in println().
The EshopQueryServlet shall send the order request to another servlet called EshopOrderServlet (which shall be mapped to an URL "/eshoporder"). Hence the <form> tag shall look like:
<form method='get' action='eshoporder'>
  <p><input type='checkbox' name='id' value='1001' />Tan Ah Teck, Java For Dummies, $11.11</p>
  <p><input type='checkbox' name='id' value='1002' />.........</p>
  ......
</form>

The steps are as follows:
Step 1: Write the "EshopQueryServlet.java" (based on "QueryMultiValueServlet.java"). It shall process the ResultSet as follow, so as to generate the desired HTML <form> and <input> tags:
// Step 4: Process the query result
// Print the <form> start tag
out.println("<form method='get' action='eshoporder'>");
 
// For each row in ResultSet, print one checkbox inside the <form>
while(rset.next()) {
   out.println("<p><input type='checkbox' name='id' value="
         + "'" + rset.getString("id") + "' />"
         + rset.getString("author") + ", "
         + rset.getString("title") + ", $"
         + rset.getString("price") + "</p>");
}
 
// Print the submit button and </form> end-tag
out.println("<p><input type='submit' value='ORDER' />");
out.println("</form>");
Step 2: In "web.xml", configure request URL "/eshopquery" to "EshopQueryServlet.class".
Step 3: Write an HTML form called "eshopquery.html" (based on "querybook.html"), which triggers "eshopquery".
Select some books and click the "ORDER" submit button. Observe the HTTP GET request triggered. You are expected to receive a "404 File Not Found" error because you have yet to write theEshopOrderServlet.

9.2  Processing the Order - "EshopOrderServlet.java"

The submit button in the previous step invokes this URL, with possibly zero or more id's corresponding to the book(s) ordered.
http://hostname:9999/ebookshop/eshoporder?id=1001&id=1002
We shall map the request URL "/eshoporder" to a new servlet called "EshopOrderServlet".
The "EshopOrderServlet" shall process the order by:
1.       Retrieve the id number(s) from the request.
2.       In table books, reduce the "qty" by 1 for that particular id number. To update records in the table books, use an SQL UPDATE statement as follows:
3.  UPDATE books SET qty = qty – 1 WHERE id = 1001
UPDATE books SET qty = qty – 1 WHERE id = 1002
4.       Insert a transaction record in a new table called "order_records".

The steps are as follows:
Step 1: Create a new table called "order_records" in the same database "ebookshop" with five columns: id (int), qty_ordered (int), cust_name (String), cust_email (String) and cust_phone(String).
[Notes: You should avoid naming the table order, as it is a reserve word in SQL, which requries special handling.]
Database: ebookshop
Table: order_records
+-------+-------------+---------------+---------------+------------+
| id    | qty_ordered | cust_name     | cust_email    | cust_phone |
| (INT) | (INT)       | (VARCHAR(30)) | (VARCHAR(30)) | CHAR(8)    |
+-------+-------------+---------------+---------------+------------+
You could use the following SQL script:
use ebookshop;
 
drop table if exists order_records;
create table order_records (
  id          int,
  qty_ordered int,
  cust_name   varchar(30),
  cust_email  varchar(30),
  cust_phone  char(8));
Step 2: Write the "EshopOrderServlet.java" which retrieves the id from the request parameter "id=xxx", and updates the tables books and order_records.
The syntax for SQL INSERT is as follows:
// Insert full record
INSERT INTO order_records VALUES (1001, 2, 'Kelvin Jones', 'kelvin@somewhere.com', '88881234')
// Insert partial record
INSERT INTO order_records (id, qty_ordered) VALUES (1001, 1)
To execute SQL UPDATE and INSERT statements, you have to use the method executeUpdate(sqlStr), which returns an int, indicating the number of rows affected by the UPDATE or INSERT. (Recall that we use executeQuery() for SQL SELECT, which returns a ResultSet). For example,
String sqlstr = "INSERT INTO order_records (id, qty_ordered) VALUES (1234, 1)";
int count;
count = stmt.executeUpdate(sqlstr);
out.println(count + " records inserted.");
The doGet() method of the EshopOrderServlet shall look like:
// Step 3 & 4: Execute a SQL SELECT query and Process the query result
out.println("<html><head><title>Order Results</title></head><body>");
 
// Retrieve the books' id. Can order more than one books.
String[] ids = request.getParameterValues("id");
if (ids != null) {
   String sqlStr;
   int count;
 
   // Process each of the books
   for (int i = 0; i < ids.length; ++i) {
      // Update the qty of the table books
      sqlStr = "UPDATE books SET qty = qty - 1 WHERE id = " + ids[i];
      out.println("<p>" + sqlStr + "</p>");  // for debugging
      count = stmt.executeUpdate(sqlStr);
      out.println("<p>" + count + " record updated.</p>");
 
      // Create a transaction record
      sqlStr = "INSERT INTO order_records (id, qty_ordered) VALUES ("
            + ids[i] + ", 1)";
      out.println("<p>" + sqlStr + "</p>");  // for debugging
      count = stmt.executeUpdate(sqlStr);
      out.println("<p>" + count + " record inserted.</p>");
      out.println("<h3>Your order for book id=" + ids[i]
            + " has been confirmed.</h3>");
   }
   out.println("<h3>Thank you.<h3>");
} else { // No book selected
   out.println("<h3>Please go back and select a book...</h3>");
}
out.println("</body></html>");
Step 3: In "web.xml", configure the URL "/eshoporder" to "EshopOrderServlet.class".
Run the application. Check the database to confirm the updating. Make sure that you have the message "Thank you" displayed.

9.3  Touching Up

1.       Add three text fields: cust_name, cust_email and cust_phone in EshopQueryServlet. The <input> tag for text fields look like:
2.  <p>Enter your Name: <input type='text' name='cust_name' /></p>
3.  <p>Enter your Email: <input type='text' name='cust_email' /></p>
<p>Enter your Phone Number: <input type='text' name='cust_phone' /></p>
The value of a text field is the string entered.Description: ServletCS_Table.png
4.       In EShopQueryServlet, put the rows into an HTML table. The syntax for displaying HTML table is:
5.  <table>
6.    <tr>
7.      <th>heading for column 1</th>
8.      <th>heading for column 2</th>
9.      ......
10.   </tr>
11.   <tr>
12.     <td>data for column 1</td>
13.     <td>data for column 2</td>
14.     ......
15.   </tr>
16.   ......
</table>
The <table>...</table> tag markups a table; <tr>...</tr> markups a row; <th>...</th> is a header cell in the row, and <td>...</td> is a data cell.
You need to print the HTML tags via out.println(). Print the <table> begin-tag and header-row before the while-loop (for processing the ResultSet); print the data-row inside the while-loop; print the </table> end-tag after the while-loop.

Login System in Servlet

In this example we will show you how to develop a login form using servlet. Here we are using MySqldatabase. List of file to be created are:
·         index.html
·         Login.java
·         Validate.java
·         Welcome.java
·         web.xml
Description: login form example with Servlet
To try this application you will need to create a table in your database and enter some record into it. Refer the previos Lesson for creating table.

index.html

<html>
    <head>
        <title>login form</title>
    </head>
    <body>
        <form method="post" action="login">
        Email ID:<input type="text" name="email" /><br/>
        Password:<input type="text" name="pass" /><br/>
        <input type="submit" value="login" />
        </form>
    </body>
</html>

Login.java

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
 
public class Login extends HttpServlet {
 
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        
        String email = request.getParameter("email");
        String pass = request.getParameter("pass");
        
        if(Validate.checkUser(email, pass))
        {
            RequestDispatcher rs = request.getRequestDispatcher("Welcome");
            rs.forward(request, response);
        }
        else
        {
           out.println("Username or Password incorrect");
           RequestDispatcher rs = request.getRequestDispatcher("index.html");
           rs.include(request, response);
        }
    }  
}

Validate.java

import java.sql.*;
 
public class Validate
 {
     public static boolean checkUser(String email,String pass) 
     {
      boolean st =false;
      try{
 
         //loading drivers for mysql
         Class.forName("com.mysql.jdbc.Driver");
 
         //creating connection with the database 
         Connection con=DriverManager.getConnection
                        ("jdbc:mysql:/ /localhost:3306/test","root","studytonight");
         PreparedStatement ps =con.prepareStatement
                             ("select * from register where email=? and pass=?");
         ps.setString(1, email);
         ps.setString(2, pass);
         ResultSet rs =ps.executeQuery();
         st = rs.next();
        
      }catch(Exception e)
      {
          e.printStackTrace();
      }
         return st;                 
  }   
}

Welcome.java

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
 
public class Welcome extends HttpServlet {
 
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        out.println("Welcome user");
      }  
}

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" >
 
    <servlet>
        <servlet-name>login</servlet-name>
        <servlet-class>Login</servlet-class>
    </servlet>
    <servlet>
        <servlet-name>Welcome</servlet-name>
        <servlet-class>Welcome</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>login</servlet-name>
        <url-pattern>/login</url-pattern>
    </servlet-mapping>
    <servlet-mapping>
        <servlet-name>Welcome</servlet-name>
        <url-pattern>/Welcome</url-pattern>
    </servlet-mapping>
    
</web-app>
Bottom of Form


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)