merchantstoreblogoperationaction.java

基于struts的网上商店源码

/*
 * 作者:管磊
 * 时间:12-25-2007
 * 功能:商家博客的操作。
 */
package com.mole.struts.action;

import java.util.ArrayList;

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.mole.struts.dao.MerchantBlogDao;

/**
 * MyEclipse Struts Creation date: 12-25-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class MerchantStoreBlogOperationAction extends Action {
	/*
	 * Generated Methods
	 */
	MerchantBlogDao dao;

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String articleId = request.getParameter("articleId");
		String articleContent = request.getParameter("articleContent");
		String operationType = request.getParameter("operationType");
		String sql = null;
		if (dao == null)
			dao = new MerchantBlogDao();
		if (operationType.equals("delete"))// 删除数据库中的商家日志记录
		{
			sql = "delete from merchantStoreBlog where id=" + articleId
					+ " or topicid=" + articleId;
			dao.executeUpdate(sql);

		}
		if (operationType.equals("edit"))// 编辑数据库中的商家日志记录
		{
			ArrayList list = new ArrayList();
			sql = "select  Id,Content,IssueTime,TopicId,Writerid,title from merchantStoreBlog where id="
					+ articleId;
			list = dao.executeQuery(sql);
			request.setAttribute("blogtoedit", list);
			return new ActionForward("/merchantStoreBlogEdit.jsp?id="
					+ articleId);

		}
		if (operationType.equals("editComplete"))// 编辑好商家的日志记录后，储存日志文章
		{
			String content = request.getParameter("content");
			String title = request.getParameter("title");
			String id = request.getParameter("editblogcomplete");
			sql = "update merchantStoreBlog set title='" + title
					+ "', content='" + content
					+ "',issuetime=getDate() where id=" + id;
			dao.executeUpdate(sql);

		}
		System.out.println(sql);
		return new ActionForward("/merchantGetBlog.do");
	}
}