searchinfobean.java

该系统具体分为2个部分：前台和后台。 1．前台主要用于用户进行浏览和搜索

package ynuBean;
import java.util.*;
import java.sql.*;

public class SearchInfoBean 
{
	private ArrayList resultList = new ArrayList();
	private ArrayList allList = new ArrayList();
	
	public SearchInfoBean()
	{
		//default
	}
	
	public ArrayList getPesticideInfo(String way,String seacontent)
	{
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			String query="";
			if(way.equals("农药名"))
			{
				query = "Select * from Pesticide where Pname='"+seacontent+"'";
			}
			else if(way.equals("农药号"))
			{
				query = "Select * from Pesticide where PID='"+seacontent+"'";
			}
			else if(way.equals("价格"))
			{
				query = "Select * from Pesticide where price<'"+Float.parseFloat(seacontent)+"'" +
						" or price='"+Float.parseFloat(seacontent)+"'";
			}
			ResultSet result = sqlstatement.executeQuery(query);
			
			while(result.next())
			{
				String PID = result.getString("PID");
				String Pname = result.getString("Pname");
				String toxicity = result.getString("toxicity");
				String character = result.getString("charachter");
				float price = result.getFloat("price");
				int qty = result.getInt("qty");
				Pesticide aPesticiede 
				             = new Pesticide(PID,Pname,toxicity,character,price,qty);
				resultList.add(aPesticiede);
			}
			
			con.close();
		}
		catch (SQLException e) 
    	{
      		System.out.println(e.toString());
    	}
    	catch (Exception e) 
    	{
    		System.out.println(e.toString());
    	} 
		return resultList;
	}
	
	public ArrayList getPesticideInfo()
	{
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			String query = "Select * from Pesticide";

			ResultSet result = sqlstatement.executeQuery(query);
			
			while(result.next())
			{
				String PID = result.getString("PID");
				String Pname = result.getString("Pname");
				String toxicity = result.getString("toxicity");
				String character = result.getString("charachter");
				float price = result.getFloat("price");
				int qty = result.getInt("qty");
				Pesticide aPesticiede 
				             = new Pesticide(PID,Pname,toxicity,character,price,qty);
				allList.add(aPesticiede);
			}
			
			con.close();
		}
		catch (SQLException e) 
    	{
      		System.out.println(e.toString());
    	}
    	catch (Exception e) 
    	{
    		System.out.println(e.toString());
    	} 
		return allList;
	}
	
	private String detail;
	
	public Pesticide getPesticide(String pid)
	{
		Pesticide aPesticide=null;
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			String query = "Select * from Pesticide where PID='"+pid+"'";

			ResultSet result = sqlstatement.executeQuery(query);
			
			while(result.next())
			{
				String PID = result.getString("PID");
				String Pname = result.getString("Pname");
				String toxicity = result.getString("toxicity");
				String character = result.getString("charachter");
				float price = result.getFloat("price");
				int qty = result.getInt("qty");
				aPesticide  = new Pesticide(PID,Pname,toxicity,character,price,qty);
			}
			
			String query1 = "select * from pdetail where PID='"+pid+"'";
			ResultSet rs = sqlstatement.executeQuery(query1);
			
			while(rs.next())
			{
				detail = rs.getString("description");
			}
			con.close();
		}
		catch (SQLException e) 
    	{
      		System.out.println(e.toString());
    	}
    	catch (Exception e) 
    	{
    		System.out.println(e.toString());
    	} 
		return aPesticide;
	}
	
	public String getDetail()
	{
		return detail;
	}
}