Untitled

<html><head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>
    <script type="text/javascript" src="http://netdna.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script>
    <%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
    <%
    try{
      Class.forName("oracle.jdbc.driver.OracleDriver");
      String hostname = "172.16.60.13";
      int port = 1521;
      String sid = "orcl";
      String oracleURL = "jdbc:oracle:thin:@"+hostname+":"+port+":"+sid;
      String username = "E183383";
      String password = "183383";
      Connection conn = DriverManager.getConnection(oracleURL, username, password);
      Statement stmt = conn.createStatement();
      String query = "Select BOOKID, TITLE, AUTHOR from E183591.BOOK";
      ResultSet rs = stmt.executeQuery(query);

    %>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap-theme.min.css">
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
    <link href="http://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css">
    <link href="abccc.css" rel="stylesheet" type="text/css">
  </head>
  <body>
    <div class="section" draggable="true" style="padding:15">
      <img src="project webpage3.png" class="img-responsive">
    </div>
    <div class="row" style="padding:5px">
      <div class="col-md-3 col-sm-offset-6" align="right">
        <span style="font-size:28; text-shadow: 2px 2px 8px #000000;">Welcome,&nbsp; <%=session.getAttribute("user_lname")%></span>
      </div>
      <div class="col-md-2">
        <a class="btn btn-default btn-lg" href="profile.jsp">
              <span style="font-size :20px">View Profile</span>
            </a>
      </div>
      <a class="button">

      </a>
      <div class="col-sm-1">
        <a class="button">
        </a>
        <a href="Register.html">
          </a>
      </div>
    </div>
    <div style="height: 10px;background-color:#590d32"></div>
    <div style="padding : 5px" class="section">
      <div class="container">
        <div class="row">
          <div class="col-md-2">
            <a class="btn btn-block btn-default" href="Logged-In.jsp">
              <span style="font-size :20px">Home</span>
            </a>
          </div>
          <div class="col-md-2">
            <a class="btn btn-block btn-default" href="Home.html"> <span style="font-size :20px"> Log Out &nbsp;</span>
              <span class="fa fa-sign-out fa-lg"></span>
              </a>
          </div>
          <div class="col-md-2">
            <a class="btn btn-block btn-default dropdown-toggle" data-toggle="dropdown"> <span style="font-size :20px"> Services</span> <span class="fa fa-caret-down"></span></a>
            <ul class="dropdown-menu" role="menu">
              <li>
                <a href="Reserve Room.jsp">Reserve Room</a>
                <a href="https://www.google.com">Enquiries</a>
              </li>
            </ul>
          </div>
          <div class="col-md-2">
            <a class="btn btn-block btn-default"><span style="font-size :20px">Cart</span></a>
          </div>
          <div class="col-md-4" style="vertical-align:middle">
              <form class="form-horizontal" role="form">
              <div class="form-group">
                <div class="col-sm-8">
                  <input type="text" class="form-control" placeholder="Search Book..." style="font-size:20px;height:40;width:110%">
                </div>
                <div class="col-sm-4">
                  <button type="submit" class="btn btn-default btn-block" style="font-size:20px;height:40;">Search</button>
                </div>
              </div>
            </form>
          </div>
        </div>
      </div>
    </div>
    <div style="height: 10px;background-color:#590d32"></div>
    <div class="section-fluid"></div>
    <div class="section">
      <div class="container">
        <div class="col-md-8">
          <h1 style="text-shadow: 2px 2px 8px #000000;">Reserve Room</h1>
        </div>

        <br>
        <br>
        <div class="row">
          <div class="col-md-12">
            <table class="table  highlight-background" style="font-size: 25px;">
              <colgroup>
                <col span="1" style="width: 10%;">
                  <col span="1" style="width: 40%;">
                    <col span="1" style="width: 20%;">
                      <col span="1" style="width: 30%;">
              </colgroup>

              <table style="width:100%;font-size:30px">
              <tr>
                <td width="15%">No</td>
                <td width="35%">Room's Name</td>
                <td width="25%">Time</td>
                <td width="25">Scheduled Booked</td>
              </tr>


              <%for (int j=0;j<5;j++){%><%
                 while(rs.next()){%>
                 <tr><td><%= j+1 %></td>
                     <td><%=rs.getInt(1)%></td>
                     <td><%=rs.getString(2)%></td>
                     <td><%=rs.getInt(3)%></td>
                     <td><%=rs.getInt(4)%></td>
                     <td><button type="submit" action="book.jsp" value="Check" style="width:70%;height:20%"></td>
                 </tr>
                }%>
                }%>
              </table>
<%
}catch (ClassNotFoundException cnfe) {
          System.out.println("Error loading driver: "+cnfe);
  }%>


            <div class="col-md-5">
              <a class="btn btn-block btn-info btn-lg" href="Register Room.jsp">
              <span style="font-size :35px">Reserve Room Here</span>
            </a>
            </div>
          </div>
        </div>
      </div>
    </div>


</body></html>