Advertisement
nakhaleeda

pageadmin

Sep 20th, 2018
221
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.74 KB | None | 0 0
  1. <%@page import="java.sql.DriverManager"%>
  2. <%@page import="java.sql.ResultSet"%>
  3. <%@page import="java.sql.Statement"%>
  4. <%@page import="java.sql.Connection"%>
  5. <%
  6. String id = request.getParameter("userid");
  7. String driver = "com.mysql.jdbc.Driver";
  8. String connectionUrl = "jdbc:mysql://localhost:3306/";
  9. String database = "ariyanihotel";
  10. String userid = "root";
  11. String password = "";
  12. try {
  13. Class.forName(driver);
  14. } catch (ClassNotFoundException e) {
  15. e.printStackTrace();
  16. }
  17. Connection connection = null;
  18. Statement statement = null;
  19. ResultSet resultSet = null;
  20. %>
  21.  
  22. <!DOCTYPE html>
  23. <html >
  24. <head>
  25. <!-- Site made with Mobirise Website Builder v4.8.1, https://mobirise.com -->
  26. <meta charset="UTF-8">
  27. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  28. <meta name="generator" content="Mobirise v4.8.1, mobirise.com">
  29. <meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1">
  30. <link rel="shortcut icon" href="assets/images/logo-122x90.png" type="image/x-icon">
  31. <meta name="description" content="Web Site Generator Description">
  32. <title>Pageadmin</title>
  33. <link rel="stylesheet" href="assets/web/assets/mobirise-icons/mobirise-icons.css">
  34. <link rel="stylesheet" href="assets/tether/tether.min.css">
  35. <link rel="stylesheet" href="assets/bootstrap/css/bootstrap.min.css">
  36. <link rel="stylesheet" href="assets/bootstrap/css/bootstrap-grid.min.css">
  37. <link rel="stylesheet" href="assets/bootstrap/css/bootstrap-reboot.min.css">
  38. <link rel="stylesheet" href="assets/dropdown/css/style.css">
  39. <link rel="stylesheet" href="assets/datatables/data-tables.bootstrap4.min.css">
  40. <link rel="stylesheet" href="assets/theme/css/style.css">
  41. <link rel="stylesheet" href="assets/mobirise/css/mbr-additional.css" type="text/css">
  42.  
  43.  
  44.  
  45. </head>
  46. <body>
  47. <section class="menu cid-r27jEP6kkt" once="menu" id="menu1-16">
  48.  
  49.  
  50.  
  51. <nav class="navbar navbar-expand beta-menu navbar-dropdown align-items-center navbar-toggleable-sm bg-color transparent">
  52. <button class="navbar-toggler navbar-toggler-right" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
  53. <div class="hamburger">
  54. <span></span>
  55. <span></span>
  56. <span></span>
  57. <span></span>
  58. </div>
  59. </button>
  60. <div class="menu-logo">
  61. <div class="navbar-brand">
  62. <span class="navbar-logo">
  63. <a href="https://mobirise.com">
  64. <img src="assets/images/logo-122x90.png" alt="Mobirise" title="" style="height: 3.8rem;">
  65. </a>
  66. </span>
  67. <span class="navbar-caption-wrap"><a class="navbar-caption text-white display-5" href="https://mobirise.com">ARIYANI HOTEL&nbsp;</a></span>
  68. </div>
  69. </div>
  70. <div class="collapse navbar-collapse" id="navbarSupportedContent">
  71.  
  72.  
  73. </div>
  74. </nav>
  75. </section>
  76.  
  77. <section class="engine"><a href="https://mobiri.se/y">html site templates</a></section><section class="header8 cid-r2ohbqw4V5 mbr-fullscreen mbr-parallax-background" id="header8-1f">
  78.  
  79.  
  80.  
  81. <div class="mbr-overlay" style="opacity: 0.2; background-color: rgb(0, 0, 0);">
  82. </div>
  83.  
  84. <div class="container align-center">
  85. <div class="row justify-content-md-center">
  86. <div class="mbr-white col-md-10">
  87. <h1 class="mbr-section-title align-center py-2 mbr-bold mbr-fonts-style display-1">ADMIN <br>ARIYANI HOTEL</h1>
  88.  
  89.  
  90. <nav>
  91. <a href="#about"div class="mbr-section-btn text-center"><a class="btn btn-md btn-danger-outline display-7" >ABOUT</a> <a href="#custbooking" class="btn btn-md btn-danger-outline display-7" >CUSTBOOKING</a>
  92. <a href="staffleave.html" class="btn btn-md btn-danger-outline display-7" >STAFFLEAVE</a> <a class="btn btn-md btn-danger-outline display-7" >FEEDBACK</a>
  93. <a href="combine.html" class="btn btn-md btn-danger-outline display-7" >LOGOUT</a></div>
  94. </div>
  95. </div>
  96. </nav>
  97. </div>
  98.  
  99. </section>
  100.  
  101. <section class="testimonials5 cid-r2o7oLXxBj" id="about">
  102.  
  103.  
  104.  
  105.  
  106.  
  107. <div class="container">
  108. <div class="media-container-row">
  109. <div class="title col-12 align-center">
  110. <h2 class="pb-3 mbr-fonts-style display-1">about us</h2>
  111. <h3 class="mbr-section-subtitle mbr-light pb-3 mbr-fonts-style display-4">ADMIN AND STAFF.
  112. </h3>
  113. </div>
  114. </div>
  115. </div>
  116.  
  117. <div class="container">
  118. <div class="media-container-column">
  119.  
  120.  
  121.  
  122. <div class="mbr-testimonial align-center col-12 col-md-10">
  123. <div class="panel-item">
  124. <div class="card-block">
  125. <div class="testimonial-photo">
  126. <img src="assets/images/ariayani-hotel-depan-poli-20180811-192547-240x240.jpg" alt="" title="">
  127. </div>
  128. </div>
  129. <div class="card-footer">
  130. <big class="mbr-author-desc mbr-italic mbr-light mbr-fonts-style mbr-white display-7"><h2>ADMIN&nbsp;</h2></big>
  131.  
  132. </div>
  133.  
  134. <body>
  135. <table border="1" width="600" align="center" bgcolor="white">
  136. <tr> <font face="verdana" color="white">
  137.  
  138. <td>NAME:</td>
  139. <td><font color="brown">Mohd Amri Bin Rani</font></td>
  140. </font>
  141. </tr>
  142.  
  143. <tr>
  144. <font face="verdana">
  145. <td>CITY:</td>
  146. <td><font color="brown">Terengganu</font></td>
  147.  
  148. </font>
  149. </tr>
  150. <tr>
  151. <font face="verdana">
  152. <td>STATE:</td>
  153. <td><font color="brown">Dungun</font></td>
  154. </font>
  155.  
  156. </tr>
  157. <tr>
  158. <font face="verdana">
  159. <td>PIN-CODE</td>
  160. <td><font color="brown">23000</font></td>
  161. </font>
  162. </tr>
  163.  
  164. <tr>
  165. <font face="verdana">
  166. <td>EMAIL:</td>
  167. <td><font color="brown">mohdamrirani@gmail.com</font></td>
  168. </font>
  169. </tr>
  170.  
  171. <tr>
  172. <font face="verdana">
  173. <td>PHONE:</td>
  174. <td><font color="brown">098454490</font></td>
  175. </font>
  176. </tr>
  177. <tr>
  178.  
  179. <font face="verdana">
  180. <td>MOBILE NO.:</td>
  181. <td><font color="brown">0199844848</font></td>
  182. </font>
  183. </tr>
  184. <tr>
  185. <font face="verdana">
  186.  
  187. <td>D.O.B:</td>
  188. <td><font color="brown">18/6/1991</font></td>
  189. </font>
  190. </tr>
  191. <tr>
  192. <font face="verdana">
  193. <td>GENDER:</td>
  194.  
  195. <td><font color="brown">Male</font></td>
  196. </font>
  197. </tr>
  198. <tr>
  199. <font face="verdana">
  200. <td>COLLEGE:</td>
  201. <td><font color="brown">STPM</font></td>
  202.  
  203. <tr>
  204. <font face="verdana">
  205. <td>STATUS</td>
  206. <td><font color="brown">Married</font></td>
  207. </font>
  208. </tr>
  209.  
  210. <tr>
  211. <font face="verdana">
  212. <td>OCCUPATION</td>
  213. <td><font color="brown">BUSSINESS</font></td>
  214. </font>
  215. </tr>
  216.  
  217.  
  218. </table>
  219. </body>
  220.  
  221.  
  222.  
  223. </p>
  224. </div>
  225. </div><div class="mbr-testimonial align-center col-12 col-md-10">
  226. <div class="panel-item">
  227. <div class="card-block">
  228. <div class="testimonial-photo">
  229. <img src="assets/images/encik-syahmi-ariyani-hotel-20180810-220917-240x240.jpg" alt="" title="">
  230. </div>
  231. </div>
  232. <div class="card-footer">
  233. <div class="mbr-author-name mbr-bold mbr-fonts-style mbr-white display-7">syahmi</div>
  234. <small class="mbr-author-desc mbr-italic mbr-light mbr-fonts-style mbr-white display-7">staff</small>
  235. </div>
  236. <p class="mbr-text mbr-fonts-style mbr-white display-7">
  237. <p class="mbr-text mbr-fonts-style mbr-white display-7">
  238. <table border="1" width="100" align="center" bgcolor="white">
  239.  
  240.  
  241. </table>
  242. <body>
  243. <table border="1" width="600" align="center" bgcolor="white">
  244. <tr> <font face="verdana" color="white">
  245.  
  246. <td>NAME:</td>
  247. <td><font color="brown">Mohd Amri Bin Rani</font></td>
  248. </font>
  249. </tr>
  250.  
  251. <tr>
  252. <font face="verdana">
  253. <td>CITY:</td>
  254. <td><font color="brown">Terengganu</font></td>
  255.  
  256. </font>
  257. </tr>
  258. <tr>
  259. <font face="verdana">
  260. <td>STATE:</td>
  261. <td><font color="brown">Dungun</font></td>
  262. </font>
  263.  
  264. </tr>
  265. <tr>
  266. <font face="verdana">
  267. <td>PIN-CODE</td>
  268. <td><font color="brown">23000</font></td>
  269. </font>
  270. </tr>
  271.  
  272. <tr>
  273. <font face="verdana">
  274. <td>EMAIL:</td>
  275. <td><font color="brown">mohdamrirani@gmail.com</font></td>
  276. </font>
  277. </tr>
  278.  
  279. <tr>
  280. <font face="verdana">
  281. <td>PHONE:</td>
  282. <td><font color="brown">098454490</font></td>
  283. </font>
  284. </tr>
  285. <tr>
  286.  
  287. <font face="verdana">
  288. <td>MOBILE NO.:</td>
  289. <td><font color="brown">0199844848</font></td>
  290. </font>
  291. </tr>
  292. <tr>
  293. <font face="verdana">
  294.  
  295. <td>D.O.B:</td>
  296. <td><font color="brown">18/6/1991</font></td>
  297. </font>
  298. </tr>
  299. <tr>
  300. <font face="verdana">
  301. <td>GENDER:</td>
  302.  
  303. <td><font color="brown">Male</font></td>
  304. </font>
  305. </tr>
  306. <tr>
  307. <font face="verdana">
  308. <td>COLLEGE:</td>
  309. <td><font color="brown">STPM</font></td>
  310.  
  311. <tr>
  312. <font face="verdana">
  313. <td>STATUS</td>
  314. <td><font color="brown">Married</font></td>
  315. </font>
  316. </tr>
  317.  
  318. <tr>
  319. <font face="verdana">
  320. <td>OCCUPATION</td>
  321. <td><font color="brown">BUSSINESS</font></td>
  322. </font>
  323. </tr>
  324. </table>
  325. </body>
  326.  
  327.  
  328. </p>
  329. </div>
  330. </div></div>
  331. </div>
  332. </section>
  333.  
  334.  
  335. <section class="section-table cid-r2o7rJ8zgB" id="table1-1c">
  336.  
  337.  
  338.  
  339. <div class="container container-table">
  340. <h2 class="mbr-section-title mbr-fonts-style align-center pb-3 display-1">CUSTOMER BOOKING</h2>
  341. <h3 class="mbr-section-subtitle mbr-fonts-style align-center pb-5 mbr-light display-4">SEE YOUR CUSTOMER BOOKING HERE</h3>
  342. <div class="table-wrapper">
  343. <div class="container">
  344. <div class="row search">
  345. <div class="col-md-6"></div>
  346. <div class="col-md-6">
  347. <div class="dataTables_filter">
  348.  
  349. <input class="form-control input-sm" disabled="">
  350. </div>
  351. </div>
  352. </div>
  353. </div>
  354.  
  355. <div class="container scroll">
  356.  
  357. <thead>
  358. <tr class="table-heads ">
  359. <table border="1">
  360. <tr>
  361. <tr bgcolor="pink">
  362. <td>name</td>
  363. <td>email</td>
  364. <td>phone</td>
  365. <td>guest</td>
  366. <td>Type Of Room</td>
  367. <td>Check In</td>
  368. <td>Check Out</td>
  369. <td>Delete</td>
  370.  
  371.  
  372. </tr>
  373. <%
  374. try{
  375. connection = DriverManager.getConnection(connectionUrl+database, userid, password);
  376. statement=connection.createStatement();
  377. String sql ="select * from booking";
  378. resultSet = statement.executeQuery(sql);
  379. while(resultSet.next()){
  380. %>
  381. <tr>
  382. <tr bgcolor="white">
  383. <td><%=resultSet.getString("name") %></td>
  384. <td><%=resultSet.getString("email") %></td>
  385. <td><%=resultSet.getString("phone") %></td>
  386. <td><%=resultSet.getString("guest") %></td>
  387. <td><%=resultSet.getString("room") %></td>
  388. <td><%=resultSet.getString("CheckIn") %></td>
  389. <td><%=resultSet.getString("CheckOut") %></td>
  390. <td><a href="delbooking.jsp?id=<%=resultSet.getString("id") %>"><button type="button" class="delete">Delete</button></a></td>
  391. </tr>
  392. <%
  393.  
  394. }
  395. connection.close();
  396. } catch (Exception e) {
  397. e.printStackTrace();
  398. }
  399. %>
  400. </table>
  401.  
  402.  
  403.  
  404.  
  405.  
  406. </div>
  407. </div>
  408. </div>
  409. </section>
  410.  
  411. <section class="testimonials4 cid-r2oIxxhGnS" id="testimonials4-1t">
  412.  
  413.  
  414.  
  415.  
  416. <div class="container">
  417. <h2 class="pb-3 mbr-fonts-style mbr-white align-center display-1">STAFF LEAVE</h2>
  418. <h3 class="mbr-section-subtitle mbr-light pb-3 mbr-fonts-style mbr-white align-center display-5"></h3>
  419. <div class="col-md-10 testimonials-container">
  420.  
  421.  
  422.  
  423. <div class="testimonials-item">
  424. <div class="user row">
  425. <div class="col-lg-3 col-md-4">
  426. <div class="user_image">
  427. <img src="assets/images/encik-syahmi-ariyani-hotel-20180810-220917-300x300.jpg" alt="" title="">
  428. </div>
  429. </div>
  430. <div class="testimonials-caption col-lg-9 col-md-8">
  431. <div class="user_text ">
  432. <p class="mbr-fonts-style display-7"></p>
  433. </div>
  434.  
  435. <table border="1">
  436. <tr>
  437. <tr bgcolor="pink">
  438. <td>name</td>
  439. <td>start leave</td>
  440. <td>end leave</td>
  441. <td>reason</td>
  442. <td>Result</td>
  443.  
  444.  
  445. </tr>
  446. <%
  447. try{
  448. connection = DriverManager.getConnection(connectionUrl+database, userid, password);
  449. statement=connection.createStatement();
  450. String sql ="select * from leavestaff";
  451. resultSet = statement.executeQuery(sql);
  452. while(resultSet.next()){
  453. %>
  454. <tr>
  455. <td><%=resultSet.getString("name") %></td>
  456. <td><%=resultSet.getString("start") %></td>
  457. <td><%=resultSet.getString("end") %></td>
  458. <td><%=resultSet.getString("reason") %></td>
  459.  
  460. </tr>
  461. <%
  462. }
  463. connection.close();
  464. } catch (Exception e) {
  465. e.printStackTrace();
  466. }
  467. %>
  468. </table>
  469. </div>
  470. </div>
  471. </div></div>
  472. </div>
  473. </section>
  474.  
  475. <section class="timeline2 cid-r2o7yKDxX5" id="timeline2-1d">
  476.  
  477.  
  478.  
  479.  
  480.  
  481. <div class="container align-center">
  482. <h2 class="mbr-section-title pb-3 mbr-fonts-style display-1">
  483. feedback</h2>
  484. <h3 class="mbr-section-subtitle pb-5 mbr-fonts-style display-7">"we all need people who will give us feedback.that's how we improve"</h3>
  485.  
  486.  
  487.  
  488.  
  489.  
  490.  
  491.  
  492. <table style="width:100%" border="1">
  493. <tr bgcolor="pink">
  494. <td>name</td>
  495. <td>email</td>
  496. <td>phone</td>
  497. <td>message</td>
  498. <td>Delete</td>
  499.  
  500.  
  501. </tr>
  502. <%
  503. try{
  504. connection = DriverManager.getConnection(connectionUrl+database, userid, password);
  505. statement=connection.createStatement();
  506. String sql ="select * from feedback";
  507. resultSet = statement.executeQuery(sql);
  508. while(resultSet.next()){
  509. %>
  510. <tr bgcolor="white">
  511. <td><%=resultSet.getString("name") %></td>
  512. <td><%=resultSet.getString("phone") %></td>
  513. <td><%=resultSet.getString("email") %></td>
  514. <td><%=resultSet.getString("message") %></td>
  515. <td><a href="delfeedback.jsp?id=<%=resultSet.getString("id") %>"><button type="button" class="delete">Delete</button></a></td>
  516.  
  517. </tr>
  518. <%
  519. }
  520. connection.close();
  521. } catch (Exception e) {
  522. e.printStackTrace();
  523. }
  524.  
  525. %>
  526.  
  527.  
  528. </table>
  529. </div>
  530. </div>
  531.  
  532. </div>
  533. </div>
  534. </section>
  535.  
  536. <section class="mbr-section article content10 cid-r2o7J926dj" id="content10-1e">
  537.  
  538.  
  539.  
  540. <div class="container">
  541. <div class="inner-container" style="width: 66%;">
  542. <hr class="line" style="width: 94%;">
  543. <div class="section-text align-center mbr-white mbr-fonts-style display-7">" When you walk into our hotel to start your day, we are dedicated to providing you with friendly service, a welcoming atmosphere, and above all else, excellent room made with the highest quality our services. If you are not satisfied, please let us know and we will do whatever we can to make things right!" 'Your Convenience Is Our Priority'</div>
  544. <hr class="line" style="width: 94%;">
  545. </div>
  546. </div>
  547. </section>
  548.  
  549.  
  550. <script src="assets/web/assets/jquery/jquery.min.js"></script>
  551. <script src="assets/popper/popper.min.js"></script>
  552. <script src="assets/tether/tether.min.js"></script>
  553. <script src="assets/bootstrap/js/bootstrap.min.js"></script>
  554. <script src="assets/smoothscroll/smooth-scroll.js"></script>
  555. <script src="assets/parallax/jarallax.min.js"></script>
  556. <script src="assets/dropdown/js/script.min.js"></script>
  557. <script src="assets/touchswipe/jquery.touch-swipe.min.js"></script>
  558. <script src="assets/datatables/jquery.data-tables.min.js"></script>
  559. <script src="assets/datatables/data-tables.bootstrap4.min.js"></script>
  560. <script src="assets/playervimeo/vimeo_player.js"></script>
  561. <script src="assets/theme/js/script.js"></script>
  562.  
  563.  
  564. </body>
  565. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement