office_membersuggestaction.java

这个程序是花了好几十万请人开发的

/*
 * 
 * @author 郑文金
 *
 * 这个action用于在"网上办公室"中发布个人的建议
 *
 */package struts.action;
import javax.servlet.http.HttpSession;
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 struts.form.Office_membersuggestForm;
import javabean.*;
import java.sql.*;
public class Office_membersuggestAction extends Action {

	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
	{
		HttpSession session=request.getSession();
		Office_membersuggestForm membersuggestForm =
			(Office_membersuggestForm) form;
		
		String date;
		PubDate pubdate=new PubDate();
		date=pubdate.getPubdate();//获取提交建议时的时间
			
		CodeString getstring=new CodeString();		
		String title=membersuggestForm.getTITLE();//用户提交建议的标题
		title=getstring.getString(title);
		String message=membersuggestForm.getMESSAGE();//用户提交的建议
		message=getstring.getString(message);
		
		
		Hyjydao hyjy= new Hyjydao();
		if(hyjy.con!=null)//如果数据库连接成功
		{		
			int id=0;	
			String s1="select max(ID) as n from hyjy";
			ResultSet rs=hyjy.executeQuery(s1);
			while(rs.next())
			{
				id=rs.getInt("n");
			}
			id=id+1;//编号自动加1		
			String uid=(String)session.getAttribute("uid");//用户ID
			String flag="false";//false表示会员建议没有回复，回复之后改为true
			
			String s2="insert into hyjy values("+"'"+id+"'"+","+"'"+uid+"'"+","+"'"+title+"'"+","+"'"+message+"'"+","+"'"+date+"'"+","+"'"+flag+"'"+")";
			hyjy.update(s2);	
			membersuggestForm.reset(mapping,request);
			String msg=hyjy.update(s2);	//会员建议是否提交上去的标志
			request.setAttribute("msg",msg);
			hyjy.con.commit();
			hyjy.con.close();
			if(msg.equals("failure"))
			{
				return mapping.findForward("office_membersuggest_confirm");
			}
			else
				return mapping.findForward("office_membersuggest");
		}
		else
		{
			return mapping.findForward("DbErrorPage");
		}
				
	}
}