searchbo.java

来自「一个毕业设计网络招标系统实现了招标的业务逻辑内含了数据库sql server备份」· Java 代码 · 共 149 行

/**
 * 
 */
package C03.BO;

import java.io.UnsupportedEncodingException;
import java.sql.*;
import java.util.Vector;

import C03.CDB.*;
import C03.VO.*;

/**
 * @author wangtao
 * 
 */
public class searchBO {
	dataBase db;

	Vector vo = new Vector();

	public searchBO() {
		db = new dataBase();
	}

	/**
	 * 对项目的搜索
	 * 
	 * @param keys
	 *            搜索关键字
	 * @return Vector项目集合
	 * @throws UnsupportedEncodingException
	 */
	public Vector searchProject(String keys)
			throws UnsupportedEncodingException {
		Vector list = new Vector();

		String sql = "select * from project where project_name like '%" + keys
				+ "%'and project_check='1'";
		// String sql = "select *from project where project_name like '%" +
		// keys+ "%' or project_cost like '%" + keys+ "%' or project_company
		// like '%" + keys+ "%' or project_time like '%" + keys+ "%' or
		// project_content like '%" + keys+ "%'";
		sql = new String(sql.getBytes("ISO-8859-1"), "gb2312");
		ResultSet rs = db.sqlFind(sql);
		try {

			while (rs.next()) {
				System.out.println("searchProject=" + keys);
				projectBean pj = new projectBean();
				pj.setProject_id(rs.getString("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"));
				pj.setProject_check(rs.getString("project_check"));
				list.add(pj);

			}
		} catch (Exception e) {

			System.out.println("searchProject error" + e.getMessage());
			e.printStackTrace();
		}

		return list;
	}

	/**
	 * 对产品的搜索
	 * 
	 * @param keys
	 *            搜索关键字
	 * @return Vector产品集合
	 */

	public Vector searchProduct(String keys) {
		Vector list = new Vector();

		String sql = "select * from product where product_name like '%" + keys
				+ "%' ";
		ResultSet rs = db.sqlFind(sql);
		try {

			while (rs.next()) {
				productBean pd = new productBean();
				pd.setProduct_id(rs.getString("product_id"));
				pd.setProduct_name(rs.getString("product_name"));

				pd.setType_id(rs.getString("type_id"));
				pd.setProduct_content("product_content");
				list.add(pd);
			}
		} catch (SQLException ex) {

			System.out.println("searchProduct");

			ex.printStackTrace();
		}

		return list;
	}

	/**
	 * 对厂商的搜索
	 * 
	 * @param keys
	 *            搜索关键字
	 * @return Vector厂商集合
	 * @throws UnsupportedEncodingException
	 */
	public Vector searchMaker(String keys) throws UnsupportedEncodingException {
		Vector list = new Vector();

		String sql = "select * from maker where Maker_name like '%" + keys
				+ "%'";

		sql = new String(sql.getBytes("ISO-8859-1"), "gb2312");
		ResultSet rs = db.sqlFind(sql);
		try {

			while (rs.next()) {
				makerBean mk = new makerBean();
				mk.setMaker_id(rs.getString("Maker_id"));
				mk.setMaker_name(rs.getString("Maker_name"));
				mk.setMaker_address(rs.getString("Maker_address"));
				mk.setMaker_Cr_time(rs.getString("Maker_Cr_time"));
				mk.setMaker_Cr_address(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"));
				list.add(mk);
			}
		} catch (SQLException ex) {

			System.out.println("searchMaker error" + ex.getMessage());

			ex.printStackTrace();
		}

		return list;

	}

}