insertcontent_suggestaction.java

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

// Created by Xslt generator for Eclipse.
// XSL :  not found (java.io.FileNotFoundException:  (系统找不到指定的路径。))
// Default XSL used : easystruts.jar$org.easystruts.xslgen.JavaClass.xsl

package struts.action;

import java.sql.*;

import javabean.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.sql.DataSource;

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.Insertcontent_suggestForm;

/** 
 * InsertcontentAction.java created by EasyStruts - XsltGen.
 * http://easystruts.sf.net
 * created on 09-25-2004
 * 
 * XDoclet definition:
 * @struts:action validate="true"
 * @struts:action-forward name="showtitle.do" path="showtitle.do"
 */
public class Insertcontent_suggestAction extends Action {

	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods

	/** 
	 * Method execute
	 * @param ActionMapping mapping
	 * @param ActionForm form
	 * @param HttpServletRequest request
	 * @param HttpServletResponse response
	 * @return ActionForward
	 * @throws Exception
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
		Insertcontent_suggestForm insertForm=(Insertcontent_suggestForm)form;
		HttpSession session=request.getSession();
		//if(!(session.getAttribute("backflag").equals("7") || session.getAttribute("backflag").equals("1")))
		//{
		//	return mapping.findForward("hong");
		//}
		//获得连接池
		ConnectionPool pool=null;
		pool=ConnectionPool.getInstance();
		Connection con=null;
		try
		{
			con=pool.getConnection();
		}catch(SQLException e){}
		Database_suggest DBase=new Database_suggest(con);//对数据库进行操作的javabean
		PubDate_suggest pubdate=new PubDate_suggest();//时间javabean
		
		String title=insertForm.getTitle();
		int id=Integer.parseInt(insertForm.getId());
		String content=insertForm.getContent();
		int memberid=Integer.parseInt(insertForm.getMemberid());
		String str="select id from MAIL_INBOX order by id desc";
		int maxid=DBase.getMaxID(str)+1;
		String nowdate=pubdate.getPubdate();
		String flag="false";
		String insert="insert into MAIL_INBOX values("+maxid+",'"+title+"','"+content+"','"+"hong"+"','"+nowdate+"','"+flag+"',"+ memberid+",'"+"hong"+"',"+"0"+")";
		if(!DBase.InsertData(insert))
		{
			return (mapping.findForward("failure"));     
		}
		String update="update HYJY set flag='true' where id="+id;
		DBase.updateFlag(update);
		String code=insertForm.getCode();
		String show=insertForm.getShow1();
		request.setAttribute("code",code);
		request.setAttribute("show",show);
		try
		{
			if(con!=null) 
			con.close();
		}catch(SQLException e){}
		return (mapping.findForward("success"));
	}

}