market_hqdt_addaction.java

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

/**
/**
 * @author 郑文金
 *关于"市场行情"中"市场动态"和"行情评述"新闻添加的action(用于后台处理)
 * 
 * 
 */

package struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
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.Market_hqdt_addForm;
import javabean.*;
import java.sql.*;
public class Market_hqdt_addAction extends Action {
	private ConnectionPool pool;
	private Connection con;
	public Market_hqdt_addAction() throws SQLException
	{
		pool=ConnectionPool.getInstance();               //初始化连接池
	
	}
	
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
	{
		HttpSession session=request.getSession();
		Market_hqdt_addForm addForm = (Market_hqdt_addForm) form;
		con=pool.getConnection();  //从池中获得一个连接
		HqdtDao hqdt=new HqdtDao(con);
		PubDate pubdate=new PubDate();
		CodeString codestring=new CodeString();
		String title=addForm.getTitle().trim();//获取标题
		title=codestring.getString(title);
		String content=addForm.getContent().trim();//获取类容
		content=codestring.getString(content);
		String type=addForm.getType();//获取类型
		type=codestring.getString(type);
		
		content=content.replaceAll("<","&lt;");    //解决在jsp显示"<"的问题
		content=content.replaceAll(">","&gt;");    //解决在jsp显示">"的问题
		content=content.replaceAll("\n","<br>");  //解决在jsp换行的问题
		content=content.replaceAll(" ","&nbsp;");  //解决在jsp显示空格的问题
		
		String date=pubdate.getshortPubdate();//获取信息提交的时间
		date=codestring.getString(date);
		String keyword=title+date;//提交信息的关键字
			
		String uid=(String)session.getAttribute("uid");//获取提交信息人的id
		uid=codestring.getString(uid);
		int id=0;
		String s1="select max(id) as n from hqdtb";
		ResultSet rs=hqdt.query(s1);
		while(rs.next())
		{
			id=rs.getInt("n");
		}
		id=id+1;//获取id号		
		String s2="insert into hqdtb values( "+"'"+id+"'"+","+"'"+uid+"'"+","+"'"+title+"'"+","+
		"'"+content+"'"+","+"'"+date+"'"+","+"'"+keyword+"'"+","+"'"+type+"'"+" )";
		String msg=hqdt.update(s2);
		request.setAttribute("msg",msg);
		con.commit();
		con.close();
		addForm.reset(mapping,request);
		if(msg.equals("success"))
		{
			
			return mapping.findForward("market_hqdt_add_confirm");
		}
		else
			
			return mapping.findForward("market_hqdt_add");
	}

}