merchantgetblogaction.java

基于struts的网上商店源码

/*
 * 作者:管磊
 * 时间:11-19-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.bean.CustomerBlogBean;
import com.mole.struts.bean.Page;
import com.mole.struts.dao.MerchantBlogDao;

/**
 * MyEclipse Struts Creation date: 12-24-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class MerchantGetBlogAction 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 vid = request.getParameter("vid");
		String role = request.getParameter("role");
		String mid = request.getParameter("mid");
		if (vid == null || "null".equals(vid))// 根据用户的权限和用户名获取博客的信息
		{
			vid = (String) request.getSession().getAttribute("user");
			role = (String) request.getSession().getAttribute("role");
		}

		dao = new MerchantBlogDao();
		String style = dao.getStyle(mid);
		request.setAttribute("Style", style);
		Page page = new Page();
		String action = request.getParameter("action");
		int pageSize = (request.getParameter("pageSizeSelect") == null ? 10
				: Integer.parseInt(request.getParameter("pageSizeSelect")));
		int currentPage = (request.getParameter("page") == null ? 1 : Integer
				.parseInt(request.getParameter("page")));

		// 获取博客文章的总数。
		int count = dao.getPageInfo(mid, role);
		page.setPageSize(pageSize);
		page.setRecordCount(count);
		page.setPageCount((count + pageSize - 1) / pageSize);

		page.setCurrentPage(currentPage);
		ArrayList<CustomerBlogBean> al = new ArrayList<CustomerBlogBean>();
		// 如果没有博客日志的类型的限制的话。获取所有的博客日志
		if (request.getParameter("articleType") == null) {
			// al =
			// dao.queryBlog(userName,page.getCurrentPage(),page.getPageSize());
			// int currentPage,int pageSize,String vid,String role,String where
			try {
				String sql = "select title,content,issuetime,replycount,merchantname,id from v_merchantstoreblog where topicid=0 and writerid="
						+ mid;
				al = dao.getBlogsList(page.getCurrentPage(),
						page.getPageSize(), mid, role, "");
				request.setAttribute("bloglist", al);
				request.setAttribute("role", role);
				request.setAttribute("vid", vid);
				request.setAttribute("sid", mid);
				request.setAttribute("Page", page);
				return new ActionForward("/merchantStoreBlogList.jsp");
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				return null;
			}
		} else// 获取相应的博客文章根据博客的类型
		{
			String typeid = request.getParameter("articleType");
			String sql = "select title,content,issuetime,replycount,merchantname,id from v_merchantstoreblog where topicid=0 and writerid="
					+ mid;
			try {
				al = dao.getBlogsList(page.getCurrentPage(),
						page.getPageSize(), mid, role, " and typeid=" + typeid);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			request.setAttribute("bloglist", al);
			request.setAttribute("Page", page);
			request.setAttribute("vid", vid);
			request.setAttribute("sid", mid);
			request.setAttribute("role", role);
			return new ActionForward("/merchantStoreBlogList.jsp");

		}
	}
}