-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSearchController.jsp
93 lines (82 loc) · 3.13 KB
/
SearchController.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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
<%@ 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">
<title>Ride Share - Create Ride Request</title>
</head>
<body>
<!-- Execute search query -->
<%
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");
//Create a SQL statement
Statement stmt = con.createStatement();
String insert = "SELECT * FROM userlist u WHERE u.Username = \"" + request.getParameter("user") + "\"";
ResultSet result = stmt.executeQuery(insert);
String rating;
String user;
boolean error = false;
if (result.next()) {
rating = result.getString("Rating");
user = result.getString("Username");
} else {
error = true;
rating = "";
user = "";
}
insert = "SELECT * FROM visibleUsers v WHERE v.Username = \"" + request.getParameter("user") + "\"";
result = stmt.executeQuery(insert);
//INSERT INPUT CHECKS HERE
if(error) {
request.setAttribute("none", "There are no users with that username");
RequestDispatcher ed = request.getRequestDispatcher("Search.jsp");
ed.forward(request, response);
} else {
if(!result.next()) {
out.println("Username: " + user);
out.println("<br>");
out.println("Rating: " + rating);
} else {
out.print("Search successful! <br><br>");
out.println("Username: " + user);
out.println("<br>");
if (!result.getString("Name1").equals(null) && !result.getString("Name1").equals(" ")) {
out.println("Name: " + result.getString("Name1"));
out.println("<br>");
}
if (!result.getString("Address").equals(null) && !result.getString("Address").equals(" ")) {
out.println("Address: " + result.getString("Address"));
out.println("<br>");
}
if (!result.getString("PhoneNumber").equals(null) && !result.getString("PhoneNumber").equals(" ")) {
out.println("Phone Number: " + result.getString("PhoneNumber"));
out.println("<br>");
}
if (!result.getString("Email").equals(null) && !result.getString("Email").equals(" ")) {
out.println("Email: " + result.getString("Email"));
out.println("<br>");
}
out.println("Rating: " + rating);
}
}
con.close();
}
catch (Exception ex) {
ex.printStackTrace();
out.print("Insert failed!");
}
%>
<br>
<br>
[<a href="homepage.jsp">Main page</a>] [<a href="https://github.com/NitantP/Ride-Share/blob/master/SearchController.jsp">GitHub Page</a>]
</body>
</html>