KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > forum > ChangeMessage


1 package forum;
2
3 import java.io.*;
4 import javax.servlet.*;
5 import javax.servlet.http.*;
6 import java.util.*;
7
8
9 public class ChangeMessage extends HttpServlet {
10     
11     DBConnectie db = new DBConnectie(Variable.getDb(),Variable.getDbLogin(),Variable.getDbPassword());
12     
13     public void doPost(HttpServletRequest request, HttpServletResponse response)
14     throws ServletException, IOException{
15         
16         PrintWriter out = response.getWriter();
17         
18         try{
19             
20             HttpSession session = request.getSession(true);
21             String JavaDoc sessionUsername = (String JavaDoc)session.getAttribute("username");
22             String JavaDoc sessionType = (String JavaDoc)session.getAttribute("type");
23                         
24             String JavaDoc forum_id = request.getParameter("forum_id");
25             String JavaDoc start = request.getParameter("start");
26             String JavaDoc reqThread_id = request.getParameter("thread_id");
27             String JavaDoc reqReply_id = request.getParameter("reply_id");
28             String JavaDoc message = request.getParameter("message");
29             message = Filter.filterAll(message);
30                         
31             int changeDifference = (((100 * message.length()) / Utilities.getMessageLength(forum_id,reqThread_id,reqReply_id)));
32             
33                         
34             java.util.Date JavaDoc date_time = new java.util.Date JavaDoc();
35             
36             
37             message += "<!-- begin --!><BR><BR><I>Edited by " + sessionUsername + " - " + date_time + " (" + changeDifference + "%)</I><!-- end --!>";
38
39             db.connect();
40             
41             if(sessionType.equals("Admin")){
42                 db.query(
43                     "UPDATE forum_message " +
44                     "SET message =\"" + message + "\"" +
45                     "WHERE forum_id=\"" + forum_id + "\" AND thread_id =\"" + reqThread_id + "\" AND reply_id=\"" + reqReply_id + "\"");
46             }else{
47                 db.query(
48                     "UPDATE forum_message " +
49                     "SET message =\"" + message + "\"" +
50                     "WHERE forum_id=\"" + forum_id + "\" AND thread_id =\"" + reqThread_id + "\" AND reply_id=\"" + reqReply_id + "\" AND user=\""+ sessionUsername + "\"");
51             }
52             
53             response.sendRedirect(Variable.getForumPath() + "index.jsp?page=message&forum_id=" + forum_id + "&thread_id=" + reqThread_id +"&start=" + start);
54                 
55             db.close();
56         }catch(Exception JavaDoc e){out.println(e);}
57     }
58 }
Popular Tags