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 DeleteThread 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 sessionType = (String )session.getAttribute("type"); 23 String forum_id = request.getParameter("forum_id"); 24 String thread_id = request.getParameter("thread_id"); 25 26 if(sessionType.equals("Admin")){ 27 28 db.connect(); 29 30 db.query("DELETE FROM forum_message WHERE forum_id=\"" + forum_id + "\" AND thread_id=\"" + thread_id + "\""); 31 db.query("DELETE FROM forum_threads WHERE forum_id=\"" + forum_id + "\" AND thread_id=\"" + thread_id + "\""); 32 33 db.close(); 34 35 response.sendRedirect(Variable.getForumPath() + "index.jsp?page=thread&forum_id="+forum_id); 36 } 37 38 }catch(Exception 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 |