@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
Connection conn = null;
PrintWriter out = resp.getWriter();
// Login
if (req.getParameter("type").equalsIgnoreCase("login")) {
String username = req.getParameter("login_username");
String password = req.getParameter("login_password");
// URL url = new
// URL("http://localhost:8084/eurilys4-service/user/login_check?login_username="******"&login_password="******"http://eurilys.ap01.aws.af.cm/user/login_check?login_username="******"&login_password="******"GET");
httpConn.setRequestProperty("Accept", "application/json");
if (httpConn.getResponseCode() != 200) {
throw new RuntimeException("Failed : HTTP error code : " + httpConn.getResponseCode());
}
BufferedReader br = new BufferedReader(new InputStreamReader((httpConn.getInputStream())));
String output;
String outputObject = "";
while ((output = br.readLine()) != null) {
outputObject += output;
}
httpConn.disconnect();
// out.println("Output : " + outputObject);
String[] output_parts = outputObject.split(",");
String fullname = output_parts[0];
// String avatar = "";
String avatar = output_parts[1];
if ("failed".equals(outputObject)) {
// Login gagal
resp.sendRedirect("index.jsp?login_status=failed");
} else {
// Login berhasil
HttpSession session = req.getSession(true);
session.setAttribute("username", username);
session.setAttribute("fullname", fullname);
session.setAttribute("avatar", avatar);
resp.sendRedirect("src/dashboard.jsp");
}
}
// Sign Up
else if (req.getParameter("type").equalsIgnoreCase("signup")) {
String username = req.getParameter("signup_username");
String password = req.getParameter("signup_password");
// String password_confirm = req.getParameter("signup_confirm_password");
String fullname = req.getParameter("signup_long_name");
String email = req.getParameter("signup_email");
String birthdate = req.getParameter("signup_birth_date");
// Blob avatar = req.getParameter("signup_avatar_upload");
try {
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Berhasil connect ke Mysql JDBC Driver ... ");
} catch (ClassNotFoundException ex) {
System.out.println("Where is your MySQL JDBC Driver?");
}
conn =
DriverManager.getConnection(
"jdbc:mysql://localhost:3306/progin_405_13510086", "root", "");
Statement st = conn.createStatement();
st.executeUpdate(
"INSERT INTO user VALUES ('"
+ username
+ "','"
+ password
+ "','"
+ fullname
+ "','"
+ birthdate
+ "','NULL','"
+ email
+ "')");
// berhasil sign up
if (conn != null) {
// Set Session
HttpSession session = req.getSession(true);
session.setAttribute("username", username);
session.setAttribute("fullname", fullname);
// Redirect
resp.sendRedirect("src/dashboard.jsp");
} else {
// gagal sign up
req.setAttribute("result", "failed_register");
req.getRequestDispatcher("index.jsp").forward(req, resp);
}
} catch (SQLException e) {
System.out.println("Connection Failed! Check output console");
} finally {
try {
conn.close();
} catch (SQLException ex) {
Logger.getLogger(ServletHandler.class.getName()).log(Level.SEVERE, null, ex);
System.out.println("Can not close connection");
}
}
}
// Add Category
else if (req.getParameter("type").equalsIgnoreCase("add_category")) {
String categoryName = req.getParameter("add_category_name");
String categoryAssigne = req.getParameter("add_category_asignee_name");
HttpSession session = req.getSession(true);
String categoryCreator = (String) session.getAttribute("username");
String server = "http://localhost:8084/eurilys4-service/SOAPAddCategory";
// String service = "http://eurilys.ap01.aws.af.cm/SOAPAddCategory";
try {
// DEFINE CONNECTION.
out.write("Servlet - Define Connection");
HttpURLConnection connection = (HttpURLConnection) (new URL(server).openConnection());
connection.setDoOutput(true);
connection.setDoInput(true);
connection.setRequestMethod("POST");
connection.setRequestProperty("SOAPAction", server);
// CREATE REQUEST.
out.write("Servlet - Create Request");
String xml =
"<?xml version='1.0'?>"
+ "<SOAP-ENV:Envelope>"
+ "<SOAP-ENV:Body>"
+ "<cname>"
+ categoryName
+ "</cname>"
+ "<cassignee>"
+ categoryAssigne
+ "</cassignee>"
+ "<ccreator>"
+ categoryCreator
+ "</ccreator>"
+ "</SOAP-ENV:Body>"
+ "</SOAP-ENV:Envelope>";
out.write(xml);
// SEND REQUEST.
out.write("Servlet - Send Request");
System.out.println(xml);
OutputStream _out = connection.getOutputStream();
OutputStreamWriter wout = new OutputStreamWriter(_out, "UTF-8");
wout.write(xml);
wout.flush();
_out.close();
// READ RESPONSE.
out.write("Servlet - Read Response");
InputStream in = connection.getInputStream();
int c;
String response = "";
while ((c = in.read()) != -1) {
response += (char) c;
System.out.println(c);
}
System.out.println(response);
out.write(response);
// EXTRACT RESULT.
out.write("Servlet - Extract Result");
int startTag = response.indexOf("<result>");
int endTag = response.indexOf("</result>");
String parameter = response.substring(startTag, endTag).replaceAll("<result>", "");
parameter = parameter.trim();
out.write(parameter);
// DISPLAY RESULT.
System.out.println("Result=" + parameter);
resp.sendRedirect("src/dashboard.jsp");
// CLOSE ALL.
in.close();
out.close();
connection.disconnect();
} catch (IOException e) {
System.out.println(e.toString());
}
}
// Delete Category
else if (req.getParameter("type").equalsIgnoreCase("delete_category")) {
Connection conn_category = null;
ResultSet rs_category = null;
String categoryID = req.getParameter("delete_category_id");
String categoryName = req.getParameter("delete_category_name");
HttpSession session = req.getSession(true);
List<String> deleteTaskId = new ArrayList<String>();
/* The following will be executed if confirmed */
try {
// Make connection to database
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println(
"Berhasil connect ke Mysql JDBC Driver - ServletHandler.java delete_category");
} catch (ClassNotFoundException ex) {
System.out.println(
"Where is your MySQL JDBC Driver? - ServletHandler.java delete_category");
}
conn_category =
DriverManager.getConnection(
"jdbc:mysql://localhost:3306/progin_405_13510086", "root", "");
PreparedStatement stmt_category =
conn_category.prepareStatement("SELECT task_id FROM task WHERE cat_name=?");
stmt_category.setString(1, categoryName);
rs_category = stmt_category.executeQuery();
rs_category.beforeFirst();
// Ada Task pada category tersebut
while (rs_category.next()) {
deleteTaskId.add(rs_category.getString("task_id"));
// Delete Task Assignee
stmt_category =
conn_category.prepareStatement("DELETE FROM task_asignee WHERE task_id=?");
stmt_category.setString(1, rs_category.getString("task_id"));
stmt_category.executeUpdate();
}
// Delete Task
if (deleteTaskId.size() > 0) {
for (int i = 0; i < deleteTaskId.size(); i++) {
stmt_category = conn_category.prepareStatement("DELETE FROM task WHERE task_id=?");
stmt_category.setString(1, deleteTaskId.get(i));
stmt_category.executeUpdate();
}
}
// Delete Category Assignee
stmt_category = conn_category.prepareStatement("DELETE FROM cat_asignee WHERE cat_id=?");
stmt_category.setString(1, categoryID);
stmt_category.executeUpdate();
// Delete Category
stmt_category = conn_category.prepareStatement("DELETE FROM category WHERE cat_id=?");
stmt_category.setString(1, categoryID);
stmt_category.executeUpdate();
// Redirect
resp.sendRedirect("src/dashboard.jsp");
} catch (SQLException e) {
System.out.println("Connection Failed! Check output console");
} finally {
try {
conn_category.close();
} catch (SQLException ex) {
Logger.getLogger(ServletHandler.class.getName()).log(Level.SEVERE, null, ex);
System.out.println("Can not close connection");
}
}
}
// add comment
else if (req.getParameter("type").equalsIgnoreCase("add_comment")) {
String comment = req.getParameter("CommentBox");
String taskID = req.getParameter("comment_task_id");
HttpSession session = req.getSession(true);
String username = (String) session.getAttribute("username");
System.out.println("comment : " + comment);
System.out.println("taskID :" + taskID);
System.out.println("username " + username);
String server = "http://localhost:8084/eurilys4-service/SOAPAddComment";
// String service = "http://eurilys.ap01.aws.af.cm/SOAPAddComment";
try {
// DEFINE CONNECTION.
out.write("Servlet - Define Connection");
HttpURLConnection connection = (HttpURLConnection) (new URL(server).openConnection());
connection.setDoOutput(true);
connection.setDoInput(true);
connection.setRequestMethod("POST");
connection.setRequestProperty("SOAPAction", server);
// CREATE REQUEST.
out.write("Servlet - Create Request");
String xml =
"<?xml version='1.0'?>"
+ "<SOAP-ENV:Envelope>"
+ "<SOAP-ENV:Body>"
+ "<cbox>"
+ comment
+ "</cbox>"
+ "<ctaskID>"
+ taskID
+ "</ctaskID>"
+ "<cusername>"
+ username
+ "</cusername>"
+ "</SOAP-ENV:Body>"
+ "</SOAP-ENV:Envelope>";
out.write(xml);
// SEND REQUEST.
out.write("Servlet - Send Request");
System.out.println(xml);
OutputStream _out = connection.getOutputStream();
OutputStreamWriter wout = new OutputStreamWriter(_out, "UTF-8");
wout.write(xml);
wout.flush();
_out.close();
// READ RESPONSE.
out.write("Servlet - Read Response");
InputStream in = connection.getInputStream();
int c;
String response = "";
while ((c = in.read()) != -1) {
response += (char) c;
System.out.println(c);
}
System.out.println(response);
out.write(response);
// EXTRACT RESULT.
out.write("Servlet - Extract Result");
int startTag = response.indexOf("<result>");
int endTag = response.indexOf("</result>");
String parameter = response.substring(startTag, endTag).replaceAll("<result>", "");
parameter = parameter.trim();
out.write(parameter);
// DISPLAY RESULT.
System.out.println("Result=" + parameter);
resp.sendRedirect("src/task_detail.jsp?task_id=" + parameter);
// CLOSE ALL.
in.close();
out.close();
connection.disconnect();
} catch (IOException e) {
System.out.println(e.toString());
}
/*try {
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Berhasil connect ke Mysql JDBC Driver - add_comment ");
} catch (ClassNotFoundException ex) {
System.out.println("Where is your MySQL JDBC Driver? - add_comment");
}
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/progin_405_13510086", "root", "");
Statement st = conn.createStatement();
st.executeUpdate("INSERT INTO `comment`(`comment_content`,`task_id`,`comment_creator`) VALUES ('" + comment + "','" + taskID + "','" + username + "')");
resp.sendRedirect("src/task_detail.jsp?task_id=" + taskID);
} catch (SQLException e) {
System.out.println("Connection Failed! Check output console - add_comment");
} finally {
try {
conn.close();
} catch (SQLException ex) {
Logger.getLogger(ServletHandler.class.getName()).log(Level.SEVERE, null, ex);
System.out.println("Can not close connection - add_comment");
}
}*/
}
// edit task
else if (req.getParameter("type").equalsIgnoreCase("edit_task")) {
String taskID = req.getParameter("edit_task_id");
String deadline = req.getParameter("edit_task_deadline");
String assigneeList = URLEncoder.encode(req.getParameter("edit_task_assignee"), "UTF-8");
String tagList = URLEncoder.encode(req.getParameter("edit_task_tag"), "UTF-8");
// URL url = new
// URL("http://localhost:8084/eurilys4-service/task/update_task?edit_task_id="+taskID+"&edit_task_deadline="+deadline+"&edit_task_assignee="+assigneeList+"&edit_task_tag="+tagList);
URL url =
new URL(
"http://eurilys.ap01.aws.af.cm/task/update_task?edit_task_id="
+ taskID
+ "&edit_task_deadline="
+ deadline
+ "&edit_task_assignee="
+ assigneeList
+ "&edit_task_tag="
+ tagList);
HttpURLConnection httpConn = (HttpURLConnection) url.openConnection();
httpConn.setRequestMethod("GET");
httpConn.setRequestProperty("Accept", "application/json");
if (httpConn.getResponseCode() != 200) {
throw new RuntimeException("Failed : HTTP error code : " + httpConn.getResponseCode());
}
BufferedReader br = new BufferedReader(new InputStreamReader((httpConn.getInputStream())));
String output;
String outputObject = "";
while ((output = br.readLine()) != null) {
outputObject += output;
}
httpConn.disconnect();
if ("3".equals(outputObject)) {
resp.sendRedirect("src/task_detail.jsp?task_id=" + taskID + "&update_task=ok");
} else {
resp.sendRedirect("src/task_detail.jsp?task_id=" + taskID + "&update_task=failed");
}
}
// edit profile
else if (req.getParameter("type").equalsIgnoreCase("edit_profile")) {
String user_name = req.getParameter("edit_username");
String password = req.getParameter("password");
String fullname = req.getParameter("fullname");
// String target = req.getParameter("avatar");
String birthdate = req.getParameter("birthdate");
Part filePart = req.getPart("avatar");
System.out.println("file Part : " + filePart);
String avatar =
"img/avatar/" + user_name + FileManager.getExtension(FileManager.getFilename(filePart));
String filePath = getServletContext().getRealPath("/") + avatar;
avatar = URLEncoder.encode(avatar, "UTF-8");
fullname = URLEncoder.encode(fullname, "UTF-8");
// URL url = new
// URL("http://localhost:8084/eurilys4-service/user/update_profile?username="******"&password="******"&fullname="+fullname+"&birthdate="+birthdate+"&avatar="+avatar);
URL url =
new URL(
"http://eurilys.ap01.aws.af.cm/user/update_profile?username="******"&password="******"&fullname="
+ fullname
+ "&birthdate="
+ birthdate
+ "&avatar="
+ avatar);
HttpURLConnection httpConn = (HttpURLConnection) url.openConnection();
httpConn.setRequestMethod("GET");
httpConn.setRequestProperty("Accept", "application/json");
if (httpConn.getResponseCode() != 200) {
throw new RuntimeException("Failed : HTTP error code : " + httpConn.getResponseCode());
}
BufferedReader br = new BufferedReader(new InputStreamReader((httpConn.getInputStream())));
String output;
String outputObject = "";
while ((output = br.readLine()) != null) {
outputObject += output;
}
httpConn.disconnect();
if ("1".equals(outputObject)) {
// berhasil
Files.copy(
filePart.getInputStream(), Paths.get(filePath), StandardCopyOption.REPLACE_EXISTING);
HttpSession session = req.getSession(true);
session.setAttribute("avatar", avatar);
resp.sendRedirect("src/profile.jsp?profileupdate=ok");
} else {
// failed
resp.sendRedirect("src/profile.jsp?profileupdate=failed");
}
}
// Add Task
else if (req.getParameter("type").equalsIgnoreCase("add_task")) {
String task_name = req.getParameter("task_name_input");
// attachment
/*Part filePart1 = req.getPart("attachment_file1");
Part filePart2 = req.getPart("attachment_file1");
Part filePart3 = req.getPart("attachment_file1");
System.out.println("file Part 1 : " + filePart1);
System.out.println("file Part 2 : " + filePart2);
System.out.println("file Part 3 : " + filePart3);
String attachment1 = "img/attachment/attachment1" + FileManager.getExtension(FileManager.getFilename(filePart1));
String attachment2 = "img/attachment/attachment2" + FileManager.getExtension(FileManager.getFilename(filePart2));
String attachment3 = "img/attachment/attachment3" + FileManager.getExtension(FileManager.getFilename(filePart3));
String filePath1 = getServletContext().getRealPath("/") + attachment1;
String filePath2 = getServletContext().getRealPath("/") + attachment2;
String filePath3 = getServletContext().getRealPath("/") + attachment3;
attachment1 = URLEncoder.encode(attachment1, "UTF-8");
attachment2 = URLEncoder.encode(attachment2, "UTF-8");
attachment3 = URLEncoder.encode(attachment3, "UTF-8");*/
//
String task_deadline = req.getParameter("deadline_input");
String assigneeList = req.getParameter("assignee_input");
String tagList = req.getParameter("tag_input");
String catName = req.getParameter("addtask_cat_name");
HttpSession session = req.getSession(true);
String taskCreator = (String) session.getAttribute("username");
// String server = "http://localhost:8084/eurilys4-service/SOAPAddTask";
String server = "http://eurilys.ap01.aws.af.cm/SOAPAddTask";
try {
// DEFINE CONNECTION.
out.write("Servlet - Define Connection");
HttpURLConnection connection = (HttpURLConnection) (new URL(server).openConnection());
connection.setDoOutput(true);
connection.setDoInput(true);
connection.setRequestMethod("POST");
connection.setRequestProperty("SOAPAction", server);
// CREATE REQUEST.
out.write("Servlet - Create Request");
String xml =
"<?xml version='1.0'?>"
+ "<SOAP-ENV:Envelope>"
+ "<SOAP-ENV:Body>"
+ "<tname>"
+ task_name
+ "</tname>"
+
/*"<tattach1>"+attachment1+"</tattach1>"+
"<tattach2>"+attachment2+"</tattach2>"+
"<tattach3>"+attachment3+"</tattach3>"+*/
"<tdeadline>"
+ task_deadline
+ "</tdeadline>"
+ "<tassignee>"
+ assigneeList
+ "</tassignee>"
+ "<ttag>"
+ tagList
+ "</ttag>"
+ "<tcategory>"
+ catName
+ "</tcategory>"
+ "<tcreator>"
+ taskCreator
+ "</tcreator>"
+ "</SOAP-ENV:Body>"
+ "</SOAP-ENV:Envelope>";
out.write(xml);
// SEND REQUEST.
out.write("Servlet - Send Request");
System.out.println(xml);
OutputStream _out = connection.getOutputStream();
OutputStreamWriter wout = new OutputStreamWriter(_out, "UTF-8");
wout.write(xml);
wout.flush();
_out.close();
// READ RESPONSE.
out.write("Servlet - Read Response");
InputStream in = connection.getInputStream();
int c;
String response = "";
while ((c = in.read()) != -1) {
response += (char) c;
System.out.println(c);
}
System.out.println(response);
out.write(response);
// EXTRACT RESULT.
out.write("Servlet - Extract Result");
int startTag = response.indexOf("<result>");
int endTag = response.indexOf("</result>");
String parameter = response.substring(startTag, endTag).replaceAll("<result>", "");
parameter = parameter.trim();
out.write(parameter);
// DISPLAY RESULT.
System.out.println("Result=" + parameter);
if (parameter.equals("")) {
resp.sendRedirect("src/add_task.jsp");
} else {
resp.sendRedirect("src/task_detail.jsp?task_id=" + parameter);
}
// CLOSE ALL.
in.close();
out.close();
connection.disconnect();
} catch (IOException e) {
System.out.println(e.toString());
}
}
}
/** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
PrintWriter out = response.getWriter();
String id = request.getParameter("hashID");
JSONObject result = new JSONObject();
if (id != null && id.trim().isEmpty()) {
response.setContentType("text/plain");
response.setStatus(400);
out.println("Empty hash ID");
return;
}
Connection conn = null;
Statement st = null;
ResultSet rs = null;
String password;
try {
// Read the SQL password from a file
BufferedReader reader = null;
try {
InputStream inputStream = getClass().getClassLoader().getResourceAsStream("SQLpw.txt");
reader = new BufferedReader(new InputStreamReader(inputStream));
password = reader.readLine();
} catch (NullPointerException e) {
e.getStackTrace();
password = "";
}
// create a mysql database connection
String myDriver = "com.mysql.jdbc.Driver";
String myUrl = "jdbc:mysql://localhost/lodstories";
Class.forName(myDriver);
conn = DriverManager.getConnection(myUrl, "root", password);
st = conn.createStatement();
rs = st.executeQuery("SELECT hash,title,author FROM hash_objects where id='" + id + "'");
if (!rs.next()) {
response.setContentType("text/plain");
response.setStatus(400);
out.println("Error retrieving hash object");
return;
}
result.put("hash", rs.getString("hash"));
result.put("title", rs.getString("title"));
result.put("author", rs.getString("author"));
// result.put("path", rs.getString("path"));
// result.put("rating", rs.getInt("rating"));
// Update the lastAccessed field
st.executeUpdate(
"UPDATE hash_objects SET lastAccessed=CURRENT_TIMESTAMP() WHERE id='" + id + "'");
response.setContentType("application/json");
response.setCharacterEncoding("UTF-8");
out.println(result);
} catch (ClassNotFoundException e) {
System.err.println("Could not connect to driver!");
System.err.println(e.getMessage());
} catch (SQLException ex) {
System.err.println(
"SQLException: "
+ ex.getMessage()
+ ", SQLState: "
+ ex.getSQLState()
+ "VendorError: "
+ ex.getErrorCode());
} catch (JSONException ex) {
ex.printStackTrace();
} finally {
if (conn != null) {
try {
conn.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
if (st != null) {
try {
st.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
if (rs != null) {
try {
rs.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
}
