basicbo.java

一个毕业设计网络招标系统实现了招标的业务逻辑内含了数据库sql server备份文件

/**
 * 
 */
package C03.BO;

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

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

/**
 * @author wangtao
 *         <p>
 *         Title: 招标管理信息系统
 *         </p>
 */

public class basicBO {
	dataBase db;

	public basicBO() {
		db = new dataBase();

	}

	/**
	 * 根据项目id获得该项目对象
	 * 
	 * @param 项目id
	 * @return 项目对象实例
	 */
	public Vector getProject(long project_id) {
		Vector list = new Vector();
		projectBean pj = new projectBean();

		String sql = "select *from project where project_id='" + project_id
				+ "'";
		ResultSet rs = db.sqlFind(sql);
		try {
			if (rs.next()) {
				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"));
				list.add(pj);
			}
		} catch (Exception e) {

			System.out.println("getproject error" + e.getLocalizedMessage());
			e.printStackTrace();
		}

		return list;
	}

	/**
	 * 根据产品id获得该产品对象
	 * 
	 * @param 产品id
	 * @return 产品对象实例
	 */
	public productBean getProduct(long product_id) {
		productBean pd = new productBean();

		String sql = "select *from product where product_id=?";
		ResultSet rs = db.sqlFind(sql);
		try {

			if (rs.next()) {
				/*
				 * pd.setProduct_id(rs.getLong("product_id"));
				 * pd.setProduct_name(rs.getString("product_name"));
				 * pd.setProduct_content(rs.getString("product_content"));
				 * pd.setMaker_id(rs.getLong("maker_id"));
				 */

			}
		} catch (Exception e) {

			e.printStackTrace();
		}

		return pd;
	}

	/**
	 * 根据厂商id返回厂商对象
	 * 
	 * @oaram 厂商id
	 * @return 厂商对象
	 */
	public Vector getMaker(Long Maker_id) {
		makerBean mk = new makerBean();
		Vector list = new Vector();
		String sql = "select *from maker where maker_id='" + Maker_id + "'";
		ResultSet rs = db.sqlFind(sql);
		try {

			if (rs.next()) {
				mk.setMaker_id(rs.getString("Maker_id"));
				mk.setMaker_name(rs.getString("Maker_name"));
				mk.setMaker_address(rs.getString("Maker_address"));
				//mk.setMaker_Cr_address(rs.getString("Maker_Cr_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"));
				mk.setMaker_phone(rs.getString("Maker_phone"));
				mk.setMaker_email(rs.getString("Maker_email"));

				/*
				 * 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("getmaker error" + e.getMessage());
			e.printStackTrace();
		}

		return list;
	}
	public Vector getZhongbiao() {
		Vector list = new Vector();
		String sql = "SELECT  project.project_name,maker.maker_name FROM toubiaoTable  INNER JOIN project ON toubiaoTable.project_id = project.project_id INNER JOIN maker ON toubiaoTable.user_name = maker.UserName  where toubiaoTable.tb_zt='1'order by toubiaoTable.tb_time desc ";
		ResultSet rs = db.sqlFind(sql);
		try {

			while (rs.next()) {
				makerBean mk = new makerBean();
				projectBean pj = new projectBean();
				pj.setProject_name(rs.getString("project_name"));
				mk.setMaker_name(rs.getString("Maker_name"));
				list.add(mk);
			}
		} catch (Exception e) {

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

		return list;

	}
	/**
	 * 主要替换回车符为空，双引号为\"
	 * 
	 * @param String
	 * @return String
	 */
	public String cnvtBr(String str) {
		String text = str;
		int index = text.indexOf(13);
		while (index != -1) {
			text = text.substring(0, index) + "<br>"
					+ text.substring(index + 2);
			index = text.indexOf(13);
		}
		return text;
	}
}