-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdelete.jsp
68 lines (61 loc) · 2.7 KB
/
delete.jsp
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
63
64
65
66
67
68
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
</head>
<body>
<%
try {
//Create a connection string
String url = "jdbc:mysql://cs336finalproject.cl75kudzatsx.us-east-1.rds.amazonaws.com:3306/users";
//Load JDBC driver - the interface standardizing the connection procedure. Look at WEB-INF\lib for a mysql connector jar file, otherwise it fails.
Class.forName("com.mysql.jdbc.Driver");
//Create a connection to your DB
Connection con = DriverManager.getConnection(url, "cs336project", "csteam14");
Statement stmt = con.createStatement();
String str = "";
String[] deleteList = request.getParameterValues("deleteid");
if (deleteList != null){
if(request.getParameter("deletetype").equals("offer")){
for (int i = 0; i < deleteList.length; i++){
str = "DELETE FROM rideoffers WHERE offerID = " + Integer.parseInt(deleteList[i]);
stmt.executeUpdate(str);
}
} else if(request.getParameter("deletetype").equals("request")){
for (int i = 0; i < deleteList.length; i++){
str = "DELETE FROM riderequests WHERE requestID = " + Integer.parseInt(deleteList[i]);
stmt.executeUpdate(str);
}
} else if(request.getParameter("deletetype").equals("message")){
for (int i = 0; i < deleteList.length; i++){
String[] deleteInfo = deleteList[i].split(",");
str = "DELETE FROM SEND_EMAIL WHERE Sender = \"" + deleteInfo[0] + "\" AND Date = \"" + deleteInfo[1] + "\" AND Time = \"" + deleteInfo[2] + "\"";
stmt.executeUpdate(str);
}
} else if(request.getParameter("deletetype").equals("ad")){
for (int i = 0; i < deleteList.length; i++){
str = "DELETE FROM adlist WHERE adID = " + Integer.parseInt(deleteList[i]);
stmt.executeUpdate(str);
response.sendRedirect("createAd.jsp");
}
}
} else {
out.println("Nothing selected!");
}
stmt.close();
con.close();
out.println("<b>Selected items successfully deleted from tables<b>");
} catch (Exception ex){
ex.printStackTrace();
out.println("Something went wrong!");
}
%>
<br>
<br>
[<a href="createRideOffer.jsp">Offers</a>] [<a href="createRideRequest.jsp">Requests</a>] [<a href="messageIndex.jsp">Messages</a>] [<a href="https://github.com/NitantP/Ride-Share/blob/master/delete.jsp">GitHub Page</a>]
</body>
</html>