deletetopicservlet.java

《电子商店管理系统》——采用JSP、Servlet和JavaBean开发,实现了商品管理、 商品分类、订单处理、会员管理等功能

package com.jspdev.servlet;

import com.jspdev.business.*;
import javax.servlet.http.*;
import com.jspdev.util.DatabaseConn;
import java.sql.*;
import java.io.*;

/**
 *删除topic或者回复的帖子
 */
public class DeleteTopicServlet extends javax.servlet.http.HttpServlet
{
	public void doGet(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{

        try
        {
        	/**
        	 *获得请求中的参数，动态生成SQL语句。
        	 */
        	String id=request.getParameter("id");        	
          	String type=request.getParameter("type");
          	String sql="";
          	if(type.equals("reply"))
            sql="delete from reply where id='"+id+"'";
            else 
               sql="delete from reply where topicId='"+id+"';delete from topic where id='"+id+"'";
          	Connection con=DatabaseConn.getConnection();
        	Statement stmt=con.createStatement();
        	/**
             *执行数据库更新操作，删除指定的记录
             */
        	stmt.executeUpdate(sql);
            stmt.close();
        	PageBusiness pb=new ForumBean();
        	PageBean  pageCtl = pb.listData("1");
        	request.setAttribute("pageCtl",pageCtl);
        }
        catch(Exception e)
        {
        	e.printStackTrace();
        }
        
        /**
         *把视图派发到viewForum.jsp
         */  
        javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("/forum/viewForum.jsp");
        dis.forward(request,response);
    }
    public void doPost(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{
		doGet(request,response);
	}
}