actionsortdel.java

该系统利用Java实现简单论坛功能

package ch11.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.DynaActionForm;
import org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;

import javax.servlet.ServletContext;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;

import java.util.*;
import javax.servlet.http.*;
import ch11.form.*;
import ch11.util.*;
import ch11.bean.*;

public final class ActionSortDel extends Action{  
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) throws Exception {
		//获取待删除的论坛分类编号
   		DynaActionForm sortAdminform = (DynaActionForm) form;
		Integer sortid = (Integer)sortAdminform.get("sortid");
        HttpSession session = request.getSession();
		Vector sorts = new Vector();
		//连接数据库
   		ServletContext context = servlet.getServletContext();
		DataSource dataSource =
			(DataSource)context.getAttribute(Constants.DATASOURCE_KEY);
        DB db = new DB(dataSource);
        //执行删除操作，并根据结果转向不同的页面
		String PageForward;
		ActionMessages errors = new ActionMessages();
		if (Sort.Delete(db,sortid.intValue())){
			sorts = Sort.Search(db);
			session.setAttribute(Constants.SORT_LIST_KEY,sorts);
			PageForward="toSortAdmin";
		}
		else{
            errors.add(ActionMessages.GLOBAL_MESSAGE,
                           new ActionMessage("errors.deleteFail"));
			if (!errors.isEmpty()) {
				saveErrors(request, errors);
			}
 			PageForward="toWrong";
		}
		db.close();
	   	return (mapping.findForward(PageForward));
 	}
}