Untitled

<!DOCTYPE html>
<html lang="en">

  <head>
    <form action ="donefeedback.jsp"method="post">

    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">


    <title>~ Ariyani Hotel ~</title>

    <!-- Bootstrap core CSS -->
    <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom fonts for this template -->
    <link href="https://fonts.googleapis.com/css?family=Raleway:100,100i,200,200i,300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900,900i" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css?family=Lora:400,400i,700,700i" rel="stylesheet">

    <!-- Custom styles for this template -->
    <link href="css/business-casual.min.css" rel="stylesheet">

  </head>

  <body>

    <h1 class="site-heading text-center text-white d-none d-lg-block">
      <span class="site-heading-upper text-primary mb-3">Welcome To Ariyani Hotel</span>
      <span class="site-heading-lower">"Your Convenience Is Our Priority"</span>
    </h1>

    <!-- Navigation -->
    <nav class="navbar navbar-expand-lg navbar-dark py-lg-4" id="mainNav">
      <div class="container">
        <a class="navbar-brand text-uppercase text-expanded font-weight-bold d-lg-none" href="#">Welcome To Ariyani Hotel</a>
        <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false" aria-label="Toggle navigation">
          <span class="navbar-toggler-icon"></span>
        </button>
        <div class="collapse navbar-collapse" id="navbarResponsive">
          <ul class="navbar-nav mx-auto">
            <li class="nav-item px-lg-4">
             			            <li class="nav-item px-lg-4">
             			</li>
            <li>
			<li class="nav-item px-lg-4">
            <a class="nav-link text-uppercase text-expanded" href="customer.html">Home</a>
            </li>
            <li>
			<li class="nav-item px-lg-4">
            <a class="nav-link text-uppercase text-expanded" href="aboutadmin.html">About</a>
            </li>
			<li class="nav-item px-lg-4">
           <a class="nav-link text-uppercase text-expanded" href="adminbooking.html">Booking</a>
		   </li>
		    <li class="nav-item px-lg-4">
              <a class="nav-link text-uppercase text-expanded" href="leavestaff1.html">leave</a>
            </li>
		   <li class="nav-item px-lg-4">
           <a class="nav-link text-uppercase text-expanded" href="feedbackcust.html">feedbackcustomer</a>
		   </li>
		    <li class="nav-item active px-lg-4">
              <a class="nav-link text-uppercase text-expanded" href="abtwrkrs.html">about workers</a>
            </li>
		   <li class="nav-item px-lg-4">
           <a class="nav-link text-uppercase text-expanded" href="calendar.html">calendar</a>
		   </li>


          </ul>
        </div>
      </div>
    </nav>

    <section class="page-section cta">
      <div class="container">
        <div class="row">
          <div class="col-xl-9 mx-auto">
            <div class="cta-inner text-center rounded">
              <h2 class="section-heading mb-5">
                <body>

                  <%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>

<%

                  String driverName = "com.mysql.jdbc.Driver";
String connectionUrl = "jdbc:mysql://localhost:3306/";
String dbName = "hotel";
String userid = "root";
String password = "";


Class.forName(driverName);
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
%>

<h2 align="center"><font><strong>feedback</strong></font></h2>
<table align="center" cellpadding="5" cellspacing="5" border="1">
<tr>

</tr>
<tr bgcolor="#A52A2A">
<td><b>Name</b></td>
<td><b>Email</b></td>
<td><b>Message</b></td>
</tr>
<%
connection = DriverManager.getConnection(connectionUrl+dbName, userid, password);
statement=connection.createStatement();
String sql ="SELECT * FROM feedback";

resultSet = statement.executeQuery(sql);
while(resultSet.next()){
%>
<tr bgcolor="#DEB887">

<td><%=resultSet.getString("name") %></td>
<td><%=resultSet.getString("email") %></td>
<td><%=resultSet.getString("message") %></td>

<% } %>
</tr>

</table>
</body>


      </li>
      <li style="display:none">
        Should be Empty:
        <input type="text" name="website" value="" />
      </li>
    </ul>
  </div>

  </div>
</form>
<script type="text/javascript">JotForm.ownerView=true;</script>

</html>