KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > forum > DeleteForum


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 JavaDoc;
9 import java.sql.Statement JavaDoc;
10 import java.sql.ResultSet JavaDoc;
11
12
13 public class DeleteForum 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                 try{
20                     
21                     HttpSession session = request.getSession(true);
22                     String JavaDoc sessionType = (String JavaDoc)session.getAttribute("type");
23                     
24                     String JavaDoc forum_id = request.getParameter("forum_id");
25                     
26                     if(sessionType.equals("Admin")){
27
28                         db.connect();
29                     
30                         db.query("DELETE FROM forum_message WHERE forum_id=\"" + forum_id + "\"");
31                         db.query("DELETE FROM forum_forums WHERE forum_id=\"" + forum_id + "\"");
32                                          
33                         db.close();
34                 
35                         response.sendRedirect(Variable.getForumPath() + "index.jsp");
36                     }
37                 
38                 }catch(Exception JavaDoc e){}
39                 
40              
41         }
42         public void doGet (HttpServletRequest request, HttpServletResponse response)
43         throws ServletException, IOException{
44                 doPost(request, response);
45         }
46
47 }
Popular Tags