productbo.java

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

package C03.BO;

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

import C03.CDB.dataBase;
import C03.VO.productBean;

public class productBO {
	dataBase db;

	public boolean insetproduct(Vector vc,String maker_id, Vector vc2, String project_id,
			Vector vc1 ) throws UnsupportedEncodingException {

		boolean i1 = false;

		for (int i = 0; i < vc.size(); i++) {
			String sql = "insert product (product_Name,Maker_id,Type_id,product_content,project_id,product_price,product_zt)values('"
					+ vc.get(i)
					+ "','"
					+ maker_id
					+ "','null','"
					+ vc2.get(i)
					+ "','"
					+ project_id + "','" + vc1.get(i) + "','zb')";
			sql = new String(sql.getBytes("ISO-8859-1"), "GB2312");
			db = new dataBase();
			i1 = db.sqlUpdata(sql);

		}
		return i1;
	}

	public Vector returnzbproduct(String project_id) {
		Vector vc = new Vector();
		String sql = "select * from product where project_id='" + project_id
				+ "' and product_zt='zb'";
		db = new dataBase();
		ResultSet rs = db.sqlFind(sql);
		try {
			while (rs.next()) {
				productBean bean = new productBean();
				bean.setProduct_id(rs.getString(1));
				bean.setProduct_name(rs.getString(2));
				bean.setMaker_id(rs.getString(3));
				bean.setType_id(rs.getString(4));
				bean.setProduct_content(rs.getString(5));
				bean.setProject_id(rs.getString(6));
				bean.setProduct_price(rs.getString(7));
				vc.addElement(bean);

			}
		} catch (Exception e) {
			System.out.println("BO.productBO.returnproduct()错误" + e.toString());
			return null;
		}
		return vc;
	}

	public Vector returnproducte(String product_id) {
		Vector vc = new Vector();
		String sql = "select * from product where product_id='" + product_id
				+ "'";
		db = new dataBase();
		ResultSet rs = db.sqlFind(sql);
		try {
			if (rs.next()) {
				productBean bean = new productBean();
				bean.setProduct_id(rs.getString(1));
				bean.setProduct_name(rs.getString(2));
				bean.setMaker_id(rs.getString(3));
				bean.setType_id(rs.getString(4));
				bean.setProduct_content(rs.getString(5));
				bean.setProject_id(rs.getString(6));
				bean.setProduct_price(rs.getString(7));
				vc.addElement(bean);

			}
		} catch (Exception e) {
			System.out.println("BO.productBO.returnproduct()错误" + e.toString());
			return null;
		}
		return vc;
	}

	public boolean insettbproduct(Vector vc, String project_id, Vector vc1,
			Vector vc2, String maker_id) throws UnsupportedEncodingException {

		boolean i1 = false;

		for (int i = 0; i < vc.size(); i++) {
			String sql = "insert product (product_Name,Maker_id,project_id,product_price,product_content,product_zt)values('"
					+ vc.get(i)
					+ "','"
					+ maker_id
					+ "','"
					+ project_id
					+ "','"
					+ vc1.get(i) + "','" + vc2.get(i) + "','tb')";
			sql = new String(sql.getBytes("ISO-8859-1"), "GB2312");
			db = new dataBase();
			i1 = db.sqlUpdata(sql);

		}
		return i1;
	}

	public Vector returntbproduct(String project_id, String maker_id) {
		Vector vc = new Vector();
		String sql = "select * from product where project_id='" + project_id
				+ "' and Maker_id='" + maker_id + "' and product_zt='tb'";
		db = new dataBase();
		ResultSet rs = db.sqlFind(sql);
		try {
			while (rs.next()) {
				productBean bean = new productBean();
				bean.setProduct_id(rs.getString(1));
				bean.setProduct_name(rs.getString(2));
				bean.setMaker_id(rs.getString(3));
				bean.setType_id(rs.getString(4));
				bean.setProduct_content(rs.getString(5));
				bean.setProject_id(rs.getString(6));
				bean.setProduct_price(rs.getString(7));
				vc.addElement(bean);

			}
		} catch (Exception e) {
			System.out.println("BO.productBO.returnproduct()错误" + e.toString());
			return null;
		}
		return vc;
	}

	public boolean updataproduct(String product_id, String product_name,
			String product_price, String product_content)
			throws UnsupportedEncodingException {
		db = new dataBase();
		String sql = "update product set product_Name='" + product_name
				+ "',product_content='" + product_content + "',product_price='"
				+ product_price + "' where product_Id='" + product_id + "'";
		sql = new String(sql.getBytes("ISO-8859-1"), "GB2312");
		boolean i = db.sqlUpdata(sql);

		return i;
	}

	public boolean delproduct(String product_id) {
		db = new dataBase();
		String sql = "delete product where product_Id='" + product_id + "'";
		boolean i = db.sqlUpdata(sql);
		return i;
	}

	public boolean delproject_product(String project_id, String maker_id) {

		db = new dataBase();
		String sql = "delete product where project_id='" + project_id
				+ "' and Maker_id='" + maker_id + "'";
		return db.sqlUpdata(sql);

	}
	
	//***********************************************
	public Vector returnzbproduct(long project_id) {
		Vector vc = new Vector();
		String sql = "select * from product where project_id='" + project_id
				+ "' and product_zt='zb'";
		db = new dataBase();
		ResultSet rs = db.sqlFind(sql);
		try {
			while (rs.next()) {
				productBean bean = new productBean();
				bean.setProduct_id(rs.getString(1));
				bean.setProduct_name(rs.getString(2));
				bean.setMaker_id(rs.getString(3));
				bean.setType_id(rs.getString(4));
				bean.setProduct_content(rs.getString(5));
				bean.setProject_id(rs.getString(6));
				bean.setProduct_price(rs.getString(7));
				vc.addElement(bean);

			}
		} catch (Exception e) {
			System.out.println("BO.productBO.returnproduct()错误" + e.toString());
			return null;
		}
		return vc;
	}
	
	
	public Vector returnproducte() {
		Vector vc = new Vector();
		String sql = "select * from product where product_zt='zb'";
		db = new dataBase();
		ResultSet rs = db.sqlFind(sql);
		try {
			while(rs.next()) {
				productBean bean = new productBean();
				bean.setProduct_id(rs.getString(1));
				bean.setProduct_name(rs.getString(2));
				bean.setMaker_id(rs.getString(3));
				bean.setType_id(rs.getString(4));
				bean.setProduct_content(rs.getString(5));
				bean.setProject_id(rs.getString(6));
				bean.setProduct_price(rs.getString(7));
				vc.addElement(bean);

			}
		} catch (Exception e) {
			System.out.println("BO.productBO.returnproduct()错误" + e.toString());
			return null;
		}
		return vc;
	}

}