merchantstoreblogaddreplyaction.java

基于struts的网上商店源码

/*
 * 作者:管磊
 * 时间:12-25-2007
 * 功能:向数据库中商家博客的留言
 */
package com.mole.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.mole.struts.dao.MerchantBlogDao;

/**
 * MyEclipse Struts Creation date: 12-25-2007 Singerinsky XDoclet definition:
 * 
 * @struts.action validate="true"
 */
public class MerchantStoreBlogAddReplyAction 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 Content;
		String TopicId;
		String Title;
		String nickname;
		String sql = null;
		String sonType;
		String writerid;
		String role;
		String contentLength;
		if (request.getSession().getAttribute("user") == null)
			return mapping.findForward("goLogin");

		Content = request.getParameter("content");
		Title = request.getParameter("title");
		writerid = request.getSession().getAttribute("user").toString();
		TopicId = request.getParameter("blogArtileId");
		role = (String) request.getSession().getAttribute("role");
		sonType = request.getParameter("sontype");
		System.out.println(Title);
		if (sonType == null) {
			System.out.println(TopicId);
			System.out.println(sonType);
			System.out.println(Content);
			// 向数据库插入留言,有内容，时间，主题贴ID，作者ID，标题，作者角色,类型。
			sql = "insert into merchantStoreBlog(Content,issuetime,topicid,writerid,title,role,typeid) values('"
					+ Content
					+ "',getDate(), '"
					+ TopicId
					+ "',"
					+ writerid
					+ ",null," + role + ",1)";

		} else {
			// Sql="insert into SonsList(writerName,content,issuetime,topicid,ContentSize) values('"+LoginName+"','"+Content+"',getDate(), '"+TopicId+"','"+contentLength+"' )";

		}
		if (dao == null)
			dao = new MerchantBlogDao();
		dao.executeUpdate(sql);// 调用数据库查询
		// System.out.println(request.getAttribute("topicid")+"fuckyou sdfsdfs");
		return new ActionForward("/merchantGetBlog.do");
	}

}