SHARE
TWEET

Untitled

a guest Dec 13th, 2016 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <html><head>
  2.     <meta charset="utf-8">
  3.     <meta name="viewport" content="width=device-width, initial-scale=1">
  4.     <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>
  5.     <script type="text/javascript" src="http://netdna.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script>
  6.     <%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
  7.     <%
  8.     try{
  9.       Class.forName("oracle.jdbc.driver.OracleDriver");
  10.       String hostname = "172.16.60.13";
  11.       int port = 1521;
  12.       String sid = "orcl";
  13.       String oracleURL = "jdbc:oracle:thin:@"+hostname+":"+port+":"+sid;
  14.       String username = "E183383";
  15.       String password = "183383";
  16.       Connection conn = DriverManager.getConnection(oracleURL, username, password);
  17.       Statement stmt = conn.createStatement();
  18.       String query = "Select BOOKID, TITLE, AUTHOR from E183591.BOOK";
  19.       ResultSet rs = stmt.executeQuery(query);
  20.  
  21.     %>
  22.     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap-theme.min.css">
  23.     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
  24.     <link href="http://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css">
  25.     <link href="abccc.css" rel="stylesheet" type="text/css">
  26.   </head>
  27.   <body>
  28.     <div class="section" draggable="true" style="padding:15">
  29.       <img src="project webpage3.png" class="img-responsive">
  30.     </div>
  31.     <div class="row" style="padding:5px">
  32.       <div class="col-md-3 col-sm-offset-6" align="right">
  33.         <span style="font-size:28; text-shadow: 2px 2px 8px #000000;">Welcome,&nbsp; <%=session.getAttribute("user_lname")%></span>
  34.       </div>
  35.       <div class="col-md-2">
  36.         <a class="btn btn-default btn-lg" href="profile.jsp">
  37.               <span style="font-size :20px">View Profile</span>
  38.             </a>
  39.       </div>
  40.       <a class="button">
  41.    
  42.       </a>
  43.       <div class="col-sm-1">
  44.         <a class="button">
  45.         </a>
  46.         <a href="Register.html">
  47.           </a>
  48.       </div>
  49.     </div>
  50.     <div style="height: 10px;background-color:#590d32"></div>
  51.     <div style="padding : 5px" class="section">
  52.       <div class="container">
  53.         <div class="row">
  54.           <div class="col-md-2">
  55.             <a class="btn btn-block btn-default" href="Logged-In.jsp">
  56.               <span style="font-size :20px">Home</span>
  57.             </a>
  58.           </div>
  59.           <div class="col-md-2">
  60.             <a class="btn btn-block btn-default" href="Home.html"> <span style="font-size :20px"> Log Out &nbsp;</span>
  61.               <span class="fa fa-sign-out fa-lg"></span>
  62.               </a>
  63.           </div>
  64.           <div class="col-md-2">
  65.             <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>
  66.             <ul class="dropdown-menu" role="menu">
  67.               <li>
  68.                 <a href="Reserve Room.jsp">Reserve Room</a>
  69.                 <a href="https://www.google.com">Enquiries</a>
  70.               </li>
  71.             </ul>
  72.           </div>
  73.           <div class="col-md-2">
  74.             <a class="btn btn-block btn-default"><span style="font-size :20px">Cart</span></a>
  75.           </div>
  76.           <div class="col-md-4" style="vertical-align:middle">
  77.               <form class="form-horizontal" role="form">
  78.               <div class="form-group">
  79.                 <div class="col-sm-8">
  80.                   <input type="text" class="form-control" placeholder="Search Book..." style="font-size:20px;height:40;width:110%">
  81.                 </div>
  82.                 <div class="col-sm-4">
  83.                   <button type="submit" class="btn btn-default btn-block" style="font-size:20px;height:40;">Search</button>
  84.                 </div>
  85.               </div>
  86.             </form>
  87.           </div>
  88.         </div>
  89.       </div>
  90.     </div>
  91.     <div style="height: 10px;background-color:#590d32"></div>
  92.     <div class="section-fluid"></div>
  93.     <div class="section">
  94.       <div class="container">
  95.         <div class="col-md-8">
  96.           <h1 style="text-shadow: 2px 2px 8px #000000;">Reserve Room</h1>
  97.         </div>
  98.        
  99.         <br>
  100.         <br>
  101.         <div class="row">
  102.           <div class="col-md-12">
  103.             <table class="table  highlight-background" style="font-size: 25px;">
  104.               <colgroup>
  105.                 <col span="1" style="width: 10%;">
  106.                   <col span="1" style="width: 40%;">
  107.                     <col span="1" style="width: 20%;">
  108.                       <col span="1" style="width: 30%;">
  109.               </colgroup>
  110.              
  111.               <table style="width:100%;font-size:30px">
  112.               <tr>
  113.                 <td width="15%">No</td>
  114.                 <td width="35%">Room's Name</td>
  115.                 <td width="25%">Time</td>
  116.                 <td width="25">Scheduled Booked</td>
  117.               </tr>
  118.  
  119.              
  120.               <%for (int j=0;j<5;j++){%><%
  121.                  while(rs.next()){%>
  122.                  <tr><td><%= j+1 %></td>
  123.                      <td><%=rs.getInt(1)%></td>
  124.                      <td><%=rs.getString(2)%></td>
  125.                      <td><%=rs.getInt(3)%></td>
  126.                      <td><%=rs.getInt(4)%></td>
  127.                      <td><button type="submit" action="book.jsp" value="Check" style="width:70%;height:20%"></td>
  128.                  </tr>
  129.                 }%>
  130.                 }%>
  131.               </table>
  132. <%
  133. }catch (ClassNotFoundException cnfe) {
  134.           System.out.println("Error loading driver: "+cnfe);
  135.   }%>
  136.  
  137.  
  138.             <div class="col-md-5">
  139.               <a class="btn btn-block btn-info btn-lg" href="Register Room.jsp">
  140.               <span style="font-size :35px">Reserve Room Here</span>
  141.             </a>
  142.             </div>
  143.           </div>
  144.         </div>
  145.       </div>
  146.     </div>
  147.  
  148.  
  149. </body></html>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top