/
chatWindow.java
116 lines (93 loc) · 3.81 KB
/
chatWindow.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
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
114
115
116
package chatbotapp;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
/**
* ChatBotApp
* @author Winnie Oct 11, 2016
* chatWindow.java
*/
@WebServlet(urlPatterns = {"/chatWindow"})
public class chatWindow extends HttpServlet{
String username, tempName;
HttpSession session;
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{
response.setContentType("text/html;charset=UTF-8");
try(PrintWriter out = response.getWriter()){
String message = request.getParameter("txtMsg");
String username = session.getAttribute("username").toString();
//request.getRequestDispatcher("/WEB-INF/lib/chatbox.jsp").forward(request, response);
out.println("<html> <head> <body bgcolor=\"#0099B8\"> <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\"> <title>Chat Room</title> </head>");
out.println("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\"> <center>");
out.println("<h2>Hi ");
out.println(username);
out.println("<br> Welcome to Chat Engine ");
out.println("</h2><br><hr>");
out.println(" <body>");
out.println(" <form name=\"chatWindow\" action=\"chatWindow\">");
out.println("Message: <input type=\"text\" name=\"txtMsg\" value=\"\" /><input type=\"submit\" value=\"Send\" name=\"cmdSend\"/>");
out.println("<br><br> <a href=\"chatWindow\">Refresh Chat Room</a>");
out.println("<br> <br>");
out.println("Messages in Chat Box:");
out.println("<br><br>");
out.println("<textarea readonly=\"readonly\" name=\"textMessage\" rows=\"20\" cols=\"60\">");
if(request.getParameter("txtMsg") != null){
try{
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
java.sql.Connection con = DriverManager.getConnection("jdbc:derby:/Users/Winnie/MyDatabase;create=true", "", "");
Statement st = con.createStatement();
String sql = "insert into WEBCHATDATABASE.MYTABLE values ('"+username+"','"+message+"')";
st.executeUpdate(sql);
st.execute("commit");
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
//Retrieve messages from database
try{
Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); //driver
java.sql.Connection con = DriverManager.getConnection("jdbc:derby:/Users/Winnie/MyDatabase;create=true", "", "");
Statement statement = con.createStatement();
ResultSet resultSet = statement.executeQuery("select *from WEBCHATDATABASE.MYTABLE");
while(resultSet.next()){
String messages = resultSet.getString(1)+ " >> " + resultSet.getString(2);
out.println(messages);
}
//statement.executeUpdate("TRUNCATE TABLE WEBCHATDATABASE.MYTABLE");
con.close();
}
catch(Exception e){
System.out.println(e.getMessage());
}
out.println("</textarea>");
out.println("<hr>");
out.println("</form>");
out.println("</body");
out.println("</html>");
}
}
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{
session = request.getSession();
if(username != null){
tempName = username;
}
processRequest(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{
processRequest(request, response);
}
}