/**/** * @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");	}}