market_indexaction.java

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

/**
/**
 * @author 郑文金
 *关于"市场行情"的主页面action
 * 
 * 
 */
package struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.Vector;
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 javabean.*;
import java.sql.*;

public class Market_indexAction extends Action {


	private ConnectionPool pool;
	private Connection con;
	public Market_indexAction() throws SQLException
	{
		pool=ConnectionPool.getInstance();               //初始化连接池
		
	}
	
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
	{
		Vector vec1=new Vector();
		Vector vec2=new Vector();
		String type1="SCDT";
		String type2="HQPS";
		con=pool.getConnection();  //从池中获得一个连接
		HqdtDao hqdt=new HqdtDao(con);
		String s1=" select * from hqdtb where type= "+"'"+type1+"'"+" order by id desc";
		String s2=" select * from hqdtb where type= "+"'"+type2+"'"+" order by id desc";
		
		vec1=hqdt.hqdt_info(s1);
		vec2=hqdt.hqdt_info(s2);
		request.setAttribute("vec1",vec1);
		request.setAttribute("vec2",vec2);	
		con.close();	
		return (mapping.findForward("market_index"));	
	}

}