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