-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathadd.java
More file actions
113 lines (103 loc) · 6.16 KB
/
add.java
File metadata and controls
113 lines (103 loc) · 6.16 KB
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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class add
*/
@WebServlet("/add")
public class add extends HttpServlet {
private static final long serialVersionUID = 1L;
static String url = "jdbc:mysql://ec2jlrifer.ddns.net:3306/myDB";
static String user = "newremoteuser";
static String password = "password";
static Connection connection = null;
/**
* @see HttpServlet#HttpServlet()
*/
public add() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
response.getWriter().println("<head><title>Assignment Schedule</title></head>");
response.getWriter().println("<html><body><h1 style=\"text-align:center;\">Assignment Schedule</h1>");
response.getWriter().println("<div style=\"width:25%; position:fixed; background-color:lightGray; padding:5px; padding-right:15px; display:inline-block;\"> ");
response.getWriter().println("<h3 style=\"text-align:center;\">Menu</h3>");
response.getWriter().println("<ul><li> <a href=\"http://ec2jlrifer.ddns.net:8080/TechExercise/MyServlet\" style=\"text-decoration:none; color:black;\">Show All Assignments</a></li>");
response.getWriter().println("<li> <a href=\"http://ec2jlrifer.ddns.net:8080/TechExercise/add\" style=\"text-decoration:none; color:black;\">Add Assignment</a></li>");
response.getWriter().println("<li> <a href=\"http://ec2jlrifer.ddns.net:8080/TechExercise/search\" style=\"text-decoration:none; color:black;\">Search Assignments</a></li></ul></div>");
response.getWriter().println("<div style=\"display:inline-block; margin-left:35%;\">");
response.getWriter().println("<form action=\"http://ec2jlrifer.ddns.net:8080/TechExercise/add\" method=\"post\">");
response.getWriter().println("<div style=\"display:inline-block; margin-left:35%;\">");
response.getWriter().println("Class Name: <input type=\"text\" name=\"name\"> <br> <br>");
response.getWriter().println("Assignment Type: <input type=\"text\" name=\"type\"> <br> <br>");
response.getWriter().println("Due Date: <input type=\"text\" name=\"dueDate\"> <br> <br>");
response.getWriter().println("Details: <input type=\"text\" name=\"details\"> <br> <br>");
response.getWriter().println("<input type=\"submit\" value=\"Add\"></div></form></body></html>");
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
response.getWriter().println("<head><title>Assignment Schedule</title></head>");
response.getWriter().println("<html><body><h1 style=\"text-align:center;\">Assignment Schedule</h1>");
response.getWriter().println("<div style=\"width:25%; position:fixed; background-color:lightGray; padding:5px; padding-right:15px; display:inline-block;\"> ");
response.getWriter().println("<h3 style=\"text-align:center;\">Menu</h3>");
response.getWriter().println("<ul><li> <a href=\"http://ec2jlrifer.ddns.net:8080/TechExercise/MyServlet\" style=\"text-decoration:none; color:black;\">Show All Assignments</a></li>");
response.getWriter().println("<li> <a href=\"http://ec2jlrifer.ddns.net:8080/TechExercise/add\" style=\"text-decoration:none; color:black;\">Add Assignment</a></li>");
response.getWriter().println("<li> <a href=\"http://ec2jlrifer.ddns.net:8080/TechExercise/search\" style=\"text-decoration:none; color:black;\">Search Assignments</a></li></ul></div>");
response.getWriter().println("<div style=\"display:inline-block; margin-left:35%;\">");
response.getWriter().println("<form action=\"http://ec2jlrifer.ddns.net:8080/TechExercise/add\" method=\"post\">");
response.getWriter().println("<div style=\"display:inline-block; margin-left:35%;\">");
response.getWriter().println("Class Name: <input type=\"text\" name=\"name\"> <br> <br>");
response.getWriter().println("Assignment Type: <input type=\"text\" name=\"type\"> <br> <br>");
response.getWriter().println("Due Date: <input type=\"text\" name=\"dueDate\"> <br> <br>");
response.getWriter().println("Details: <input type=\"text\" name=\"details\"> <br> <br>");
response.getWriter().println("<input type=\"submit\" value=\"Add\"></div></form></body></html>");
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("Where is your MySQL JDBC Driver?");
e.printStackTrace();
return;
}
connection = null;
try {
connection = DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
System.out.println("Connection Failed! Check output console");
e.printStackTrace();
return;
}
if (connection == null) {
System.out.println("Failed to make connection!");
}
try {
String className = request.getParameter("name");
String type = request.getParameter("type");
String dueDate = request.getParameter("dueDate");
String details = request.getParameter("details");
String selectSQL = "insert into assignment (className, assignmentType, dueDate, details) values (\"" + className + "\", \"" + type + "\", \"" + dueDate + "\", \"" + details + "\");";
PreparedStatement preparedStatement = connection.prepareStatement(selectSQL);
int rs = preparedStatement.executeUpdate(selectSQL);
if(rs == 1){
response.getWriter().println("Assignment Added!");
}
} catch (Exception e) {
e.printStackTrace();
}
}
}