www.pudn.com > zhaobiao.rar > Search.java

/** 
 *  
 */ 
package com.centralsoft.zhaobiao.qtdatachaxun; 
 
import java.util.*; 
import java.sql.*; 
//import java.lang.*; 
 
import com.centralsoft.zhaobiao.util.dataBase; 
import com.centralsoft.zhaobiao.qtdataguanli.*; 
/** 
 * @author Administrator 
 * 
 */ 
public class Search { 
	public Search() { 
	} 
	/** 
	 * 搜索产品信息 
	 * @param keys 
	 * @return 
	 */ 
	public Vector searchProduct(String keys) { 
		Vector list = new Vector(); 
		ResultSet rs = null; 
		keys = "'%"+keys+"%'"; 
		String sql = "select * from product where product_name like"+keys; 
		dataBase db = new dataBase(); 
		rs = db.getResultSet(sql); 
		try { 
			while (rs.next()) { 
				Product pd = new Product(); 
				pd.setProduct_id(rs.getLong("product_id")); 
				pd.setProduct_name(rs.getString("product_name")); 
				pd.setMaker_id(rs.getLong("maker_id")); 
				pd.setType_id(rs.getLong("type_id")); 
				pd.setProduct_content(rs.getString("product_content")); 
				list.add(pd); 
			} 
		} catch (Exception e) { 
			System.out.println("产品查询失败！"+e.getMessage()); 
		} finally { 
			try { 
				if (rs != null) { 
					rs.close(); 
				} 
				db.closeConn(); 
			} catch (Exception e) { 
				System.out.println(e.getMessage()); 
			} 
		} 
		System.out.println("list of product:"+list.size()); 
		return list; 
	} 
	/** 
	 * 搜索项目信息 
	 * @param keys 
	 * @return 
	 */ 
	public Vector searchProject(String keys) { 
		Vector list = new Vector(); 
		ResultSet rs = null; 
		keys = "'%"+keys+"%'"; 
		String sql = "select * from project where project_name like"+keys; 
		dataBase db = new dataBase(); 
		rs = db.getResultSet(sql); 
		try { 
			while (rs.next()) { 
				Project pj = new Project(); 
				pj.setProject_id(rs.getLong("project_id")); 
				pj.setProject_name(rs.getString("project_name")); 
				pj.setProject_time(rs.getString("project_time")); 
				pj.setProject_company(rs.getString("project_company")); 
				pj.setProject_cost(rs.getString("project_cost")); 
				pj.setProject_content(rs.getString("project_content")); 
				list.add(pj); 
			} 
		} catch (Exception e) { 
			System.out.println("项目查询失败！"+e.getMessage()); 
		} finally { 
			try { 
				if (rs != null) { 
					rs.close(); 
				} 
				db.closeConn(); 
			} catch (Exception e) { 
				System.out.println(e.getMessage()); 
			} 
		} 
		System.out.println("list of project:"+list.size()); 
		return list; 
	} 
	/** 
	 * 搜索厂商信息 
	 * @param keys 
	 * @return 
	 */ 
	public Vector searchMaker(String keys) { 
		Vector list = new Vector(); 
		//Connection conn = null; 
		//Statement stmt = null; 
	    ResultSet rs = null; 
	    keys = "'%"+keys+"%'"; 
	    String sql = "select * from maker where maker_name like"+keys; 
	    dataBase db = new dataBase(); 
	    rs = db.getResultSet(sql); 
	    try { 
	    	while (rs.next()) { 
	    		Maker mk = new Maker(); 
	            mk.setMaker_id(rs.getLong("maker_id")); 
	            mk.setMaker_name(rs.getString("maker_name")); 
	            mk.setMaker_address(rs.getString("maker_address")); 
	            mk.setMaker_cr_address(rs.getString("maker_cr_time")); 
	            mk.setMaker_cr_time(rs.getString("maker_cr_address")); 
	            mk.setMaker_cr_cost(rs.getString("maker_cr_cost")); 
	            mk.setMaker_fr_name(rs.getString("maker_fr_name")); 
	            mk.setMaker_fr_position(rs.getString("maker_fr_position")); 
	            mk.setMaker_attribute(rs.getString("maker_attribute")); 
	            mk.setMaker_relation(rs.getString("maker_relation")); 
	            mk.setMaker_db_content(rs.getString("maker_db_content")); 
	            list.add(mk); 
	    	} 
	    } catch (Exception e) { 
	    	System.out.println("厂商查询失败！"+e.getMessage()); 
	    	e.printStackTrace(); 
	    } finally { 
	    	try { 
	    		if (rs != null) { 
	    			rs.close(); 
	    		} 
	    		db.closeConn(); 
	    	} catch (Exception e) { 
	    		System.out.println(e.getMessage()); 
	    	} 
	    } 
	    System.out.println("list of maker:"+list.size()); 
	    return list; 
	} 
}