pagebo.java

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

/**
 * 
 */
package C03.BO;

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

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

/**
 * @author wangtao
 * 
 */
public class pageBO {

	dataBase db;

	public pageBO() {

		db = new dataBase();
	}

	/**
	 * 获的所有的厂商的集合
	 * 
	 * @param long
	 *            page
	 * @param long
	 *            pagemax
	 * @return 厂商Vector
	 */

	public Vector getMakerList(long page, long pagemax) {
		System.out.println("qqqqqq");
		page = page - 1;
		Vector list = new Vector();
		String sql = "select *from maker";
		ResultSet rs = db.sqlFind(sql);
		try {
			System.out.println("wwwww");
			int count = 1;
			while (rs.next()) {
				if (count > (page * pagemax)
						&& count <= (page * pagemax + pagemax)) {
					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);
				}
				count++;
			}
		} catch (Exception e) {

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

		}

		return list;

	}

	/**
	 * 获的所有的厂商的集合的数量
	 * 
	 * @return long 厂商的集合的数量
	 */

	public long getMakerListCount() {
		System.out.println("aaaaa");
		long count = 0;
		String sql = "select *from maker";
		ResultSet rs = db.sqlFind(sql);
		try {
			System.out.println("ssss");
			while (rs.next()) {
				count++;
			}
		} catch (Exception e) {
			System.out.println("getmakerlistcount error" + e.getMessage());
			e.printStackTrace();

		}

		return count;

	}

	/**
	 * 获得所有的项目集合
	 * 
	 * @param page
	 * @param pagemax
	 * @return Vector 所有的项目集合
	 */
	public Vector getProjectList(long page, long pagemax) {
		page = page - 1;
		Vector list = new Vector();
		String sql = "select *from project";
		ResultSet rs = db.sqlFind(sql);
		try {

			int count = 1;
			while (rs.next()) {
				if (count > (page * pagemax)
						&& count <= (page * pagemax + pagemax)) {
					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"));
					list.add(pj);
				}
				count++;
			}

		} catch (Exception e) {

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

		return list;
	}

	/**
	 * 获得所有的项目集合的最大数量
	 * 
	 * @return long 所有的项目集合的最大数量
	 */
	public long getProjectListCount() {

		long count = 0;
		String sql = " select count(*)as count from project";
		ResultSet rs = db.sqlFind(sql);
		try {

			while (rs.next()) {
				count = Long.parseLong(rs.getString("count"));
			}
		} catch (Exception ex) {

			ex.printStackTrace();
		}
		return count;

	}

	/**
	 * 获得所有的产品集合
	 * 
	 * @param page
	 * @param pagemax
	 * @return Vector 所有的产品集合
	 */
	public Vector getProductList(long page, long pagemax) {
		
		page = page - 1;
		Vector list = new Vector();
		String sql = "select * from product where product_zt='zb'";
		ResultSet rs = db.sqlFind(sql);
		try {
			int count = 1;
			while (rs.next()) {
				if (count > (page * pagemax)
						&& count <= (page * pagemax + pagemax)) {
					productBean bean = new productBean();
					/*pd.setProduct_id(rs.getString("product_id"));
					pd.setProduct_name(rs.getString("product_Name"));
					pd.setProduct_id(rs.getString(rs.getString("Maker_id")));
					pd.setProduct_content(rs.getString("product_content"));
					pd.setProject_id(rs.getString("project-id"));
					pd.setProduct_price(rs.getString("product_price"));*/
					//pd.setProduct_zt(rs.getString("product_zt"));
					
					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));
					System.out.println(bean.getProduct_name());
					list.add(bean);
				}
				count++;
			}
		} catch (Exception e) {

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

		}

		return list;

	}

	/**
	 * 获的所有的产品的集合的数量
	 * 
	 * @return long 产品的集合的数量
	 */

	public long getProductListCount() {
		System.out.println("aaaaa");
		long count = 0;
		String sql = "select * from product where product_zt='zb'";
		ResultSet rs = db.sqlFind(sql);
		try {
			System.out.println("ssss");
			while (rs.next()) {
				count++;
			
			}
		} catch (Exception e) {
			System.out.println("getmakerlistcount error" + e.getMessage());
			e.printStackTrace();

		}
		System.out.println(count+"=====gdggdgdgdg");
		return count;

	}
}