API tools faq
paste
Guest User

Untitled

a guest
Jul 10th, 2018
112
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.11 KB | None | 0 0
raw download clone embed print report
  1. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  2. <%@ page import ="java.sql.*" %>
  3.  
  4. <%
  5. String id = request.getParameter("resid");
  6. int dlt=0;
  7. if (dlt!=0)
  8. dlt =Integer.parseInt(id);
  9.  
  10.  
  11.  
  12. Class.forName("com.mysql.jdbc.Driver");
  13. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/HotelReservation","root" ,"123456789");
  14.  
  15. Statement st = con.createStatement();;
  16.  
  17. int i = st.executeUpdate("delete from hotel_booking where resid=" +dlt+"");
  18. if (i != 0) {
  19. response.sendRedirect("home.jsp");
  20. } else {
  21. out.print("Data not deleted successfully");
  22. }
  23. %>
  24.  
  25. <%--
  26. Document : index
  27. Created on : Feb 27, 2015, 7:39:57 PM
  28. Author : OOPs
  29. --%>
  30. <%@ page import="java.sql.*" %>
  31. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  32. <!DOCTYPE html>
  33. <html>
  34. <head>
  35. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  36. <link rel="stylesheet" type="text/css" href="home.css">
  37. <title>JSP Page</title>
  38.  
  39.  
  40. <link href="responsiveslides.css" rel="stylesheet" type="text/css"/>
  41. <link href="themes.css" rel="stylesheet" type="text/css"/>
  42. <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
  43. <script src="responsiveslides.min.js" type="text/javascript"></script>
  44.  
  45. </head>
  46. <body>
  47.  
  48. <h1>your booked detail</h1>
  49. <%
  50.  
  51.  
  52. try{
  53. String n=(String)session.getAttribute("sessname");
  54.  
  55. // out.print("Hello "+n);
  56. Class.forName("com.mysql.jdbc.Driver");
  57. // out.println("driver loaded");
  58. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/HotelReservation","root" ,"123456789");
  59. // out.println("Connect");
  60. Statement st = con.createStatement();
  61. // out.println("conncetion successfull");
  62.  
  63.  
  64. ResultSet rs = st.executeQuery("select * from hotel_booking where uid = "+n);
  65.  
  66. %>
  67.  
  68.  
  69. <% while(rs.next())
  70. {
  71.  
  72. int id = rs.getInt("cid");
  73. int res = rs.getInt("resid");
  74. // out.println(id);
  75. String cname = rs.getString("cname");
  76. // out.println(cname);
  77. String email = rs.getString("email");
  78. String arrival = rs.getString("arrival_date");
  79. String departure = rs.getString("departure_date");
  80. int person = rs.getInt("person");
  81. int room = rs.getInt("room");
  82. String type_room = rs.getString("type_room");
  83.  
  84.  
  85.  
  86. %>
  87.  
  88. <div class="hotel-block" style="background-color: #5882FA;padding: 2px 15px 30px;margin-top: -20px; width: 102%; margin-left: -23px;">
  89. ...........................................................................................................................................................................................................................................................................................
  90. <h2 class="heading"><label style=" margin-left: 150px; margin-top: 151px;">Name :</label><span style=" margin-left: 200px;"><%out.println(cname);%></h2>
  91. <h2 class="heading"><label style="margin-left: 150px;">Email :</label><span style=" margin-left: 200px;"><%out.println(email);%></span></h3>
  92. <h2 class="heading"><label style="margin-left: 150px;">arrival date :</label><span style=" margin-left: 100px;"><%out.println(arrival);%></h2>
  93. <h2 class="heading"><label style="margin-left: 150px;">departure date:</label><span style=" margin-left: 50px;"><%out.println(departure);%></h2>
  94. <h2 class="heading"><label style="margin-left: 150px;">no. of person :</label><span style=" margin-left: 70px;"><%out.println(person);%></h2>
  95. <h2 class="heading"><label style="margin-left: 150px;">no. of room :</label><span style=" margin-left: 100px;"><%out.println(room);%></h2>
  96. <h2 class="heading"><label style="margin-left: 150px;">type room:</label><span style=" margin-left: 100px;"><%out.println(type_room);%></h2>
  97.  
  98. <form action='cancel.jsp'>
  99. <input type='submit' name='cancel' value='Cancel Reservation'>
  100. <input type="hidden" name="res" value=<%= res %>>
  101. </form>
  102. </div>
  103.  
  104.  
  105.  
  106. <% } }
  107.  
  108. catch(Exception e)
  109. {
  110.  
  111. }
  112. out.close();
  113.  
  114. %>
  115. </body>
  116. </html>
  117.  
  118. HTTP Status 500 – Internal Server Error
  119.  
  120. Type Exception Report
  121.  
  122. Message An exception occurred processing [/cancel.jsp] at line [8]
  123.  
  124. Description The server encountered an unexpected condition that prevented it from fulfilling the request.
  125.  
  126. Exception
  127.  
  128. org.apache.jasper.JasperException: An exception occurred processing [/cancel.jsp] at line [8]
  129.  
  130. 5: <%
  131. 6: String id = request.getParameter("resid");
  132. 7: int dlt;
  133. 8: dlt =Integer.parseInt(id);
  134. 9:
  135. 10:
  136. 11:
  137.  
  138.  
  139. Stacktrace:
  140. org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:593)
  141. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:482)
  142. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
  143. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
  144. javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  145. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  146. Root Cause
  147.  
  148. java.lang.NumberFormatException: null
  149. java.lang.Integer.parseInt(Integer.java:542)
  150. java.lang.Integer.parseInt(Integer.java:615)
  151. org.apache.jsp.cancel_jsp._jspService(cancel_jsp.java:125)
  152. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
  153. javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  154. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:444)
  155. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
  156. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
  157. javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  158. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  159. Note The full stack trace of the root cause is available in the server logs.
  160.  
  161. String id = request.getParameter("resid");
Add Comment
Please, Sign In to add comment
Public Pastes
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!