delsortaction.java

程序简介: 由文章、下载、图片主要功能模块和广告、公告、调查、友情链接、网站统计、用户、数据库管理等多个通用模块组成

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.hao2007.struts.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 com.hao2007.struts.db.DataStore;
import com.hao2007.struts.form.DelSortForm;

/**
 * MyEclipse Struts Creation date: 06-13-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/delSort" name="delSortForm" input="/admin/delSort.jsp"
 *                scope="request" validate="true"
 * @struts.action-forward name="delSortFail" path="/admin/delSortFail.jsp"
 * @struts.action-forward name="delSortSuccess" path="/admin/delSortSuccess.jsp"
 */
public class DelSortAction extends Action {
	/*
	 * Generated Methods
	 */

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		DelSortForm delSortForm = (DelSortForm) form;// TODO Auto-generated
		// method stub
		int parent_id = Integer.parseInt(delSortForm.getParent_id());
		DataStore ds = DataStore.getInstance();
		ds.beginTransaction();

		try {
			String sqlDel = "delete from class where sort_path like '%,"
					+ parent_id + "%,'";
			ds.execute(sqlDel);
			String sqlDel_article = "delete from news where sort_path like '%,"
					+ parent_id + "%,'";
			ds.execute(sqlDel_article);

		} catch (Exception e) {
			e.printStackTrace();
		}
		ds.commitTransaction();

		return (mapping.findForward("delSortSuccess"));
	}
}