Untitled

<%@page import = "java.sql.ResultSet"%>
<%@page import = "java.sql.Connection"%>
<%@page import = "java.sql.DriverManager"%>
<%@page import = "java.sql.Connection"%>
<%@page import = "java.sql.Statement"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title> Report </title>
    </head>
    <body>
        <%
        Connection connection = null;
                try {
                   Class.forName("org.gjt.mm.mysql.Driver");
                   String url = "jdbc:mysql://localhost/businessrequirement";
                   String user = "root";
                   String pwd = "";
                   connection = DriverManager.getConnection(url, user, pwd);

                   int report=Integer.parseInt(request.getParameter("orderID"));

                   Statement statement = connection.createStatement();

                    String query="SELECT * FROM orderrecord, delivery, employee"
                     + " WHERE orderrecord.orderID=delivery.orderID"
                     + " AND employee.employeeID=orderrecord.employeeID"
                          + " AND orderrecord.orderID='"+report+"'";

                   ResultSet rows = statement.executeQuery(query);

                   out.println("<table border=2>");
                   out.println("<tr><th> Courier Status </th>");
                   while (rows.next())
                  {

                    String Cstatus=rows.getString("courierStatus");

                    out.println("<tr><td>"+Cstatus+"</td></tr>");
                   }

                   out.print("</table>");

                }
                catch(Exception e)
                {
                     //response.sendError(HttpServletResponse.SC_NOT_FOUND);
                    out.print(e);
                }
               finally
               {
                   if(null != connection)
                   {
                       connection.close();
                   }
               }
        %>
    </body>
</html>