market_schqaction.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_SchqForm;
import javabean.*;
import java.sql.*;
public class Market_SchqAction extends Action {
	
	private ResultSet rs_excel,rs_oracle;
	private Connection con;
	private Statement sql;

	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception 
	{
		HttpSession session=request.getSession();
		Market_SchqForm schqForm = (Market_SchqForm) form;
		CodeString codestring=new CodeString();
		String msg1="";//用于返回一个是否成功提交数据的标志
		String msg2="";
		Schq_Excel_oracle schq=new Schq_Excel_oracle();	
		String excel_name=schqForm.getEXCEL_NAME();//获得提交的excel的表名
		if(excel_name!=null)
		{
			excel_name=codestring.getString(excel_name).trim();
		}		
		String uuid=(String)session.getAttribute("uid");
		
		
		int id=0;
		String s="select max(id) as id from schqb";
	    rs_oracle=schq.Oracle_query(s);
		while(rs_oracle.next())
		{
			id=rs_oracle.getInt("id");//获得id
		}	
		
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e)
		{
			System.err.println(e.getMessage());
		}
		try
		{
			con=DriverManager.getConnection("jdbc:odbc:schq","","");
			sql=con.createStatement();
			String str="select * from "+excel_name;
			rs_excel=sql.executeQuery(str);			
			msg2="success";
			while(rs_excel.next())
			{
				String pz=rs_excel.getString(1);//在excel表中获得产品名称
				String sc=rs_excel.getString(2);//在excel表中获得产品市场
				String date=rs_excel.getString(3);//在excel表中获得产品日期
				date=date.substring(0,10);
				String dw=rs_excel.getString(4);//在excel表中获得产品单位
				String cd=rs_excel.getString(5);//在excel表中获得产品产地
				String gg=rs_excel.getString(6);//在excel表中获得规格
				String jg=rs_excel.getString(7);//在excel表中获得价格
				String zd=rs_excel.getString(8);//在excel表中获得涨跌
				String title=(sc+pz+date).trim();//标题
				id=id+1;//id自增
				String insert="insert into schqb values( "+"'"+id+"'"+","+"'"+uuid+"'"+","+"'"+title+"'"+","+"'"+date+"'"+","+"'"+sc+"'"+","+"'"+pz+"'"+","+"'"+jg+"'"+","+"'"+dw+"'"+","+"'"+zd+"'"+","+"'"+gg+"'"+","+"'"+cd+"'"+")";
				msg1=schq.Insert(insert);//插入数据，并返回一个是否插入成功的标志
			}		
			
		}
		catch(SQLException e)
		{
			System.err.println(e.getMessage());
			msg2="failure";
		}
		schqForm.reset(mapping,request);
		if(con!=null)
		{
			con.close();
		}
		if(msg2.equals("success"))
		{
			if(msg1.equals("failure"))
				return mapping.findForward("market_schq_back");
			else
				return mapping.findForward("market_schq_back_confirm");					
		}
		else 
			return mapping.findForward("market_schq_back_errorpage");
	


	}

}