fz_searchaction.java

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

package struts.action;

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

import javabean.Fkind;
import javabean.Shown;
import javabean.dbconnect;

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;
	
public class Fz_searchAction extends Action 
{
	
	dbconnect db=new dbconnect();
		
	public ActionForward execute(
	ActionMapping mapping,
	ActionForm form,
	HttpServletRequest request,
	HttpServletResponse response)
	throws Exception {

	
	String type=request.getParameter("type");
	   //type=new String(type.getBytes("ISO-8859-1"));
	
	String keyword=request.getParameter("keyword");		
  		keyword=new String(keyword.getBytes("ISO-8859-1"));
  		
	Fkind fkind=new Fkind();
	Vector vec=new Vector();		    
	String sql="select * from "+type+" where KEYWORD like '%"+keyword+"%' order by ID DESC";	
	ResultSet rs=db.executeQuery(sql);
	
	try 
	{		
	 	while(rs.next())
		{
			Shown show=new Shown();	  
			show.setTitle(rs.getString("TITLE"));		   
			show.setId(rs.getInt("ID"));
			show.setDate(rs.getString("PUBDATE"));
			vec.add(show);
		}
		rs.close();
	 }  
	 
	catch (SQLException e) { return null;}	  
	 
	request.setAttribute("vec",vec);
	request.setAttribute("type",type);

	return (mapping.findForward("success"));
   }	

}