|
1 package forum;
2
3 import java.io.*;
4 import javax.servlet.*;
5 import javax.servlet.http.*;
6 import java.sql.*;
7 import java.sql.Connection  ;
8 import java.sql.Statement ;
9 import java.sql.ResultSet ;
10
11 public class AddReply extends HttpServlet {
12
13 DBConnectie db = new DBConnectie(Variable.getDb(),Variable.getDbLogin(),Variable.getDbPassword());
14
15 public void doPost (HttpServletRequest request, HttpServletResponse response)
16 throws ServletException, IOException{
17 PrintWriter out = response.getWriter();
18 try{
19 String start = request.getParameter("start");
20 String forum_id = request.getParameter("forum_id");
21 int lastReply_id = Integer.parseInt(request.getParameter("lastReply_id"));
22 String reply_id = Integer.toString(lastReply_id + 1);
23
24 String thread_id = request.getParameter("thread_id");
25 String message = request.getParameter("message");
26 message = Filter.filterAll(message);
27
28
29 String user = request.getParameter("user");
30
31 db.connect();
32
33 db.query(
34 "INSERT INTO forum_message(forum_id,thread_id,reply_id,message,user,date_time) "+
35 "VALUES(\"" + forum_id +
36 "\",\"" + thread_id +
37 "\",\"" + reply_id +
38 "\",\"" + message +
39 "\",\"" + user +
40 "\",SYSDATE())");
41
42 db.close();
43
44 response.sendRedirect(Variable.getForumPath() + "index.jsp?page=message&forum_id="+ forum_id +"&thread_id=" + thread_id +"&start=" + start);
45
46 }catch(Exception e){out.println(e);}
47
48
49 }
50 public void doGet (HttpServletRequest request, HttpServletResponse response)
51 throws ServletException, IOException{
52 doPost(request, response);
53 }
54
55 } |
Popular Tags |
Java API By Example, From Geeks To Geeks.