search.java

自己做的一个企业招标系统,B/S结构。开发工具Eclipse

/**
 * 
 */
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;
	}
}