Untitled

<%--
    Document   : DeliveryBoy
    Created on : Apr 26, 2017, 9:26:23 AM
    Author     : AlinIQin
--%>
<%@page import="java.sql.ResultSet"%>
<%@page import = "java.sql.Connection"%>
<%@page import = "java.sql.DriverManager"%>
<%@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>Delivery Boy Information</title>
        <style type="text/css">
        * {
            font-family: cursive;
        }

        body {
            background: pink;
            color: black;
            font-family: cursive;

        }

        table, th, td {
            border: 1px solid black;
            text-align: center;
        }
    </style>
    </head>
    <body>
         <%
        Connection connection=null;
      try{
                Class.forName("org.gjt.mm.mysql.Driver");
                String url = "jdbc:mysql://localhost/db_sterling";
                String user="root";
                String pwd="";
                connection = DriverManager.getConnection(url,user,pwd);
                Statement statement = connection.createStatement();

                String querySelect = "select * from sterling_order ";
                ResultSet rows = statement.executeQuery(querySelect);

                out.print("<center><table border=1 bgcolor=#FDFFC9 width='80%'><tr><th>OrderId</th><th>CustomerId</th><th>EmployeeId</th><th>OrderDate</th><th>RecipientName</th><th>RecipientAddress</th><th>RecipientCity</th><th>CourierWeight</th><th>CourierStatus</th><th>Description</th></tr>");
                while(rows.next())
                {
                    String order_id = rows.getString("OrderId");
                    String customer_id = rows.getString("customerId");
                    String employee_id = rows.getString("employeeId");
                    String order_date = rows.getString("OrderDate");
                    String recipient_name = rows.getString("RecipientName");
                    String recipient_address = rows.getString("RecipientAddress");
                    String recipient_city = rows.getString("RecipientCity");
                    String courier_weight = rows.getString("CourierWeight");
                    String courier_status = rows.getString("CourierStatus");
                    String description = rows.getString("Description");
                    //out.println(empId+" "+name+" "+city+"<br>");
                    out.print("<tr><td>");
                    out.print(order_id);
                    out.print("</td><td>");
                    out.print(customer_id);
                    out.print("</td><td>");
                    out.print(employee_id);
                    out.print("</td><td>");
                    out.print(order_date);
                    out.print("</td><td>");
                    out.print(recipient_name);
                    out.print("</td><td>");
                    out.print(recipient_address);
                    out.print("</td><td>");
                    out.print(recipient_city);
                    out.print("</td><td>");
                    out.print(courier_weight);
                    out.print("</td><td>");
                    out.print(courier_status);
                    out.print("</td><td>");
                    out.print(description);
                    out.print("</td></tr>");
                }
                out.print("</table></center>");

                if(connection!=null)
                    connection.close();
            }
            catch(Exception e){
                response.sendError(HttpServletResponse.SC_NOT_FOUND);
            }
            finally
            {
                if(null!=connection)
                {
                    connection.close();
                }
            }
            %>
            <form action ="DeliveryCourier.html" method="post">
                 <input type="submit" value="Next"><br>
            </form>
    </body>
</html>