shownewsaction.java

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

package struts.action;

import java.sql.ResultSet;
import java.util.Vector;

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 javabean.ShowAtt;
import javabean.dbconnect;

public class ShownewsAction extends Action
{
	
	dbconnect db=new dbconnect();
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response)
		throws Exception {
			
		String content="";
		String title="";
		String keyword1="";
		String keyword="";
		
		String id1=request.getParameter("id");
		int id=Integer.valueOf(id1).intValue();
	    String kind=request.getParameter("kind");
	    
		String type="";
		if(kind.equals("FZKJB"))
		{
			type="纺织科技";
		}
		else if(kind.equals("SCHQB"))
		{
			type="市场行情";
		}	
		else if(kind.equals("FZDTB"))
		{
			type="纺织资讯";
		}
		else if(kind.equals("SCRDB"))
		{
			type="市场热点";
		}
				
		ShowAtt show= new ShowAtt();
		String sql="select * from "+kind+" where ID='"+id+"'";
		ResultSet rs=db.executeQuery(sql);
		rs.next();
		keyword1=rs.getString("KEYWORD");
        title=rs.getString("TITLE");
        content=rs.getString("CONTENT");

		request.setAttribute("type",type); 
		request.setAttribute("title",title);
		request.setAttribute("content",content); 
		request.setAttribute("kind",kind);
		request.setAttribute("id",id1); 
		
		//以上是原消息属性
		

		String sql2="select * from "+kind+" where KEYWORD like '%"+keyword1+"%' and ID<>'"+id+"' order by ID DESC";
        Vector vec2=new Vector();
        vec2=show.getContent(sql2);
		request.setAttribute("vec2",vec2);
	
		return (mapping.findForward("success"));
	}
}