/
cancel1.java
63 lines (56 loc) · 1.86 KB
/
cancel1.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
/**
*
* @author devi
*/
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class cancel1 extends HttpServlet{
Connection c=null;
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try{
Class.forName("org.apache.derby.jdbc.ClientDriver");
c=DriverManager.getConnection("jdbc:derby://localhost:1527/eticketing","kd","kd");
}catch(ClassNotFoundException e){
System.out.println(e.getMessage());
}catch(SQLException se){
System.out.println(se.getMessage());
}catch(Exception ex){
System.out.println(ex.getMessage());
}
String name=request.getParameter("cancelname");
String hotel=request.getParameter("canceldate");
try{
PrintWriter out=response.getWriter();
Statement s=c.createStatement();
int b=s.executeUpdate("delete from hotels where visitorname='"+name+"' and hotelname='"+hotel+"'");
if(b==1){
RequestDispatcher rd=request.getRequestDispatcher("refund.html");
//servlet2 is the url-pattern of the second servlet
rd.forward(request, response);
}
else{
out.println("no such booking");
}
s.close();
c.close();
}catch(SQLException e){
System.out.println(e.getMessage());
}
finally
{
}
}
}