onlineorder.jsp

<%@page import="java.io.PrintWriter"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*;" %>
<%

           session=request.getSession(false);
            if(session.getAttribute("username")== null){

            response.sendRedirect("login.jsp");

            }

            else{

        %>
<!DOCTYPE html>


<html>
<head>
<title>
Заказы
</title>
<script type="text/javascript">

</script>
<link rel="stylesheet" href="style.css">
</head>

<body bgcolor="gray">


    <form action="onlineorder1" method="POST">

<table width="100%" height="488" border="0">
  <tr>
    <th width="10%" height="65" scope="col" background="transparent" ></th>

    <th width="80%" scope="col" >
        <table width="100%">
            <tr>
            <td width="100%">
                <embed src="images/top.jpg" width="100%" height="70%" loop="true">  </embed>
             </td>
            </tr>
    </th>

        </table>
    <td width="10%" scope="col" bgcolor="transparent">


        </td>
  </tr>
  <tr>
        <td height="200" bgcolor="transparent" >


            </td>
   <td>
      <table width="100%" height="10" border="1">
      <tr>
      <td width="10%" align='center' ><b>id</b></td>
      <td width="10%" align='center'><b>имя</b></td>
      <td width="10%" align='center'><b>фамилия</b></td>
      <td width="10%" align='center'><b>телефон</b></td>
     <td width="20%" align='center'><b>адрес</b></td>
      <td width="10%" align='center'><b>город</b></td>
      <td width="10%" align='center'><b>заказ</b></td>
      <td width="5%" align='center'><b>км/едениц</b></td>
      <td width="15%" align='center'><b>дата</b></td>
      </tr>
      <table width="100%" height="490" border="1">
      <tr>
      <td width="25%" align="center">
         <%
            String a,b,c,e,f,g,i,d;

            int h;
          try{
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3307/dit","root","1111");

                Statement s = con.createStatement();
                ResultSet rs = s.executeQuery("SELECT fosusers.username, fosusers.firstname,fosusers.lastname,fosusers.mobile,fosusers.address,fosusers.city,fosweb.itemname,fosweb.qty,fosweb.datetime FROM fosweb INNER JOIN fosusers ON fosweb.username=fosusers.username;");
                while(rs.next())
                {
                  a=rs.getString(1);
                 b=rs.getString(2);
                 c=rs.getString(3);
                 d=rs.getString(4);
                 e=rs.getString(5);
                 f=rs.getString(6);
                 g=rs.getString(7);
                 h=rs.getInt(8);
                 i=rs.getString(9);

                  %>
                  <table width="100%" border="3">

                      <tr>
                          <td width="10%" align="center">
                              <b><%=a%></b>
                         </td>
                          <td width="10%">
                              <b><%=b%></b>
                         </td>
                          <td width="10%">
                              <b><%=c%></b>
                         </td>
                      <td width="10%">
                          <b><%=d%></b>
                          </td>
                        <td width="20%">
                          <b><%=e%></b>
                          </td>
                          <td width="10%">
                              <b><%=f%></b>
                          </td>
                          <td width="10%">
                          <b><%=g%></b>
                          </td>
                          <td width="5%">
                          <b><%=+h%></b>
                          </td>
                          <td width="15%">
                          <b><%=i%></b>
                          </td>
                      </tr>


                  <%
                }


            }
            catch(Exception ei)
        {
            System.out.println(ei);
        }


          %>


          </table>
      </td>


      </tr>


      </table>

    <td bgcolor="transparent">    </td>
  </tr>

  <tr>
    <td bgcolor="transparent">
    </td>
    <td>
    <p align="center">
        <b>Имя пользователя</b><input type="text" name="bytableno"  id="BTN"  />
    <input type="submit" value="завершить заказ">
    </p></td>
    <td bgcolor="transparent">&nbsp;
    <a href="logout" ></a></td>
  </tr>
</table>
</form>
          <style>
      .backb{
position: fixed;
top: 20px;
left: 4px;
width: 46px;
height: 46px;

}
      </style>
      <script> function goBack() {
    window.history.back();
}
   </script>
    <div><img src="icons/back.png" class="backb" onclick="goBack()" id="backb"/></div>
</body>
</html>
<%
            }

    %>