market_searchaction.java

来自「这个程序是花了好几十万请人开发的」· Java 代码 · 共 75 行

/**
/**
 * @author 郑文金
 *关于"市场行情"中信息检索的action
 * 
 * 
 */
package 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 struts.form.Market_searchForm;
import java.sql.*;
import javabean.*;
import java.util.Vector;


public class Market_searchAction extends Action {


	private ConnectionPool pool;
	private Connection con;
	public Market_searchAction() throws SQLException
	{
		pool=ConnectionPool.getInstance();               //初始化连接池
	}
	
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
	{
		Vector vec=new Vector();
		Market_searchForm mk_form= new Market_searchForm();
		CodeString codestring=new CodeString();
		con=pool.getConnection();  //从池中获得一个连接
		HqdtDao hqdt=new HqdtDao(con);
		PageNumber pagenumber=new PageNumber(con);
		int pagesize=20;
		
		String keyword=request.getParameter("keyword");
		keyword=codestring.getString(keyword).trim();
		request.setAttribute("keyword",keyword);
			
		String s="select * from hqdtb where keyword like "+"'%"+keyword+"%'"+" order by id desc";
		
		pagenumber.setPagesize(pagesize);		
		pagenumber.setRowcount(s);
		pagenumber.setPagecount();
		
		String code=request.getParameter("code");//获取页码
		if(code==null)
			code="1";
			
		if(Integer.parseInt(code)>pagenumber.getPagecount())
			code="1";
			
		vec=hqdt.hqdt_fenye(Integer.parseInt(code),pagesize,s);
		request.setAttribute("vec",vec);
		request.setAttribute("code",code);
		request.setAttribute("pagecount",String.valueOf(pagenumber.getPagecount()));	
		mk_form.reset(mapping,request);
		con.close();
		return (mapping.findForward("market_search"));	
	}

}