market_infoaction.java

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

/**
 * @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 java.sql.*;
import javabean.*;
import java.util.Collection;
public class Market_infoAction extends Action {


	private ConnectionPool pool;
	private Connection con;
	public Market_infoAction() throws SQLException
	{
		pool=ConnectionPool.getInstance();               //初始化连接池  
	}
	
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
	{
		CodeString codestring=new CodeString();
		
		String sc=request.getParameter("sc");
		sc=codestring.getString(sc);
		request.setAttribute("sc",sc);
		
		String pz=request.getParameter("pz");
		pz=codestring.getString(pz);
		request.setAttribute("pz",pz);
		try{
			con=pool.getConnection();
			String sql="SELECT CPGQB.ID,CPGQB.UUID,CPGQB.NAME,CPGQB.STYPE,CPGQB.KIND,CPGQB.DESCRIBE,CPGQB.SPEC,CPGQB.AREA,CPGQB.QUANTITY,CPGQB.PRICE,CPGQB.FBDATE,CPGQB.EDATE,CPGQB.FLAG,CPGQB.PHOTO,MEMBER.COMPANY FROM CPGQB,MEMBER WHERE MEMBER.UUID=CPGQB.UUID AND CPGQB.FLAG='true' order by cpgqb.id desc" ;
			CpgqDAO cpgqDAO=new CpgqDAO(con);
			Collection col=cpgqDAO.findAll(sql);	
			request.setAttribute(BeanNames.CPGQB_LIST,col);
				
			return (mapping.findForward("market_info"));
		}catch(SQLException e){
		e.printStackTrace();
		throw new RuntimeException("error.unexpected");
		} finally{
		   try{
		   if(con!=null) con.close();
		   }catch(SQLException e){
		  throw new RuntimeException(e.getMessage());
		   }
		}
			
	}

}