gonggaobo.java

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

/**
 * 
 */
package C03.BO;

import java.sql.ResultSet;

import java.util.Vector;

import C03.CDB.dataBase;

import C03.VO.*;

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

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

	public Vector outputProject() {
		Vector list = new Vector();

		String sql = "select top 5 project_name,project_id from project where project_check='1' order by project_time desc";
		ResultSet rs = db.sqlFind(sql);
		try {

			while (rs.next()) {
				projectBean pj = new projectBean();
				pj.setProject_name(rs.getString("project_name"));
				pj.setProject_id(rs.getString("project_id"));
				list.add(pj);
			}
		} catch (Exception e) {

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

		return list;
	}

	public Vector outputMaker() {
		Vector list = new Vector();

		String sql = "select top 5 Maker_name from maker order by Maker_Cr_time desc";
		ResultSet rs = db.sqlFind(sql);
		try {

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

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

		return list;
	}

/*	public Vector outputZhongbiao() {
		Vector list = new Vector();
		String sql = "SELECT top 10 project.project_name,toubiaoTable.toubiao_id 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()) {
				
				toubiaoBean tb = new toubiaoBean();
				projectBean pj = new projectBean();
				pj.setProject_name(rs.getString("project_name"));
				tb.settoubiao_ID(rs.getString("toubiao_id"));
				list.add(pj);
				list.add(tb);
			}
		} catch (Exception e) {

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

		return list;

	}*/

	public Vector showAffiche() {
		Vector list = new Vector();
		String sql = "select top 5 afficheContent from  afiche order by afficheTime desc";
		ResultSet rs = db.sqlFind(sql);
		try {
			while (rs.next()) {

				String afficheContent = rs.getString("afficheContent");

				afficheVO vo = new afficheVO();

				vo.setAfficheContent(afficheContent);
				list.add(vo);

			}
		} catch (Exception e) {

			System.out.println("showAffiche Error!!" + e.getMessage());
		}

		return list;
	}
}