projectbo.java

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

package C03.BO;

import java.sql.ResultSet;
import java.util.Vector;
import C03.CDB.*;
import C03.VO.*;

public class projectBO {
	dataBase db;

	public Vector returnProject() {
		db = new dataBase();
		String sql = "select * from project where project_check='1'";
		ResultSet rs = db.sqlFind(sql);
		Vector vo = new Vector();
		try {
			while (rs.next()) {
				projectBean pbean = new projectBean();
				pbean.setProject_id(rs.getString(1));
				pbean.setProject_name(rs.getString(2));
				pbean.setProject_time(rs.getString(3));
				pbean.setProject_company(rs.getString(4));
				pbean.setProject_cost(rs.getString(5));
				pbean.setProject_content(rs.getString(6));

				vo.addElement(pbean);
			}
		} catch (Exception e) {
			System.out.println("BO.productBO.returnProject()方法错误"
					+ e.toString());
			return null;
		}

		return vo;
	}

	public Vector returnProject(String ID) {
		db = new dataBase();
		String sql = "select * from project where project_id='" + ID + "'";
		ResultSet rs = db.sqlFind(sql);
		Vector vo = new Vector();
		try {
			if (rs.next()) {
				projectBean pbean = new projectBean();
				pbean.setProject_id(rs.getString("project_id"));
				pbean.setProject_name(rs.getString("project_name"));
				pbean.setProject_time(rs.getString("project_time"));
				pbean.setProject_company(rs.getString("project_company"));
				pbean.setProject_cost(rs.getString("project_cost"));
				pbean.setProject_content(rs.getString("project_content"));
				pbean.setProject_username(rs.getString("project_username"));

				vo.addElement(pbean);
			}
		} catch (Exception e) {
			System.out.println("BO.productBO.returnProject(String ID)方法错误"
					+ e.toString());
			return null;
		}
		return vo;

	}

	public Vector returnuserProject(String project_username) {
		db = new dataBase();
		String sql = "select * from project where project_username='"
				+ project_username + "'";

		ResultSet rs = db.sqlFind(sql);
		Vector vo = new Vector();
		try {
			while (rs.next()) {
				projectBean pbean = new projectBean();
				pbean.setProject_id(rs.getString("project_id"));
				pbean.setProject_name(rs.getString("project_name"));
				pbean.setProject_time(rs.getString("project_time"));
				pbean.setProject_company(rs.getString("project_company"));
				pbean.setProject_cost(rs.getString("project_cost"));
				pbean.setProject_content(rs.getString("project_content"));
				pbean.setProject_check(rs.getString("project_check"));
				pbean.setProject_username(rs.getString("project_username"));

				vo.addElement(pbean);

			}
		} catch (Exception e) {
			System.out.println("BO.productBO.returnProject(String ID)方法错误"
					+ e.toString());
			return null;
		}

		return vo;

	}

	public String returnuser(String username) {
		db = new dataBase();
		String sql = "select * from userTable where userName='" + username
				+ "'";
		ResultSet rs = db.sqlFind(sql);

		try {
			if (rs.next()) {
				return rs.getString(3);
			} else
				return null;
		} catch (Exception e) {
			System.out.println("BO.zhaobiao.returnuser()方法错误" + e.toString());
			return null;
		}
	}

	public String returnproject_id(String username, String time) {
		db = new dataBase();
		String sql = "select * from project where project_username='"
				+ username + "' and Project_time='" + time + "'";
		String project_id = null;
		ResultSet rs = db.sqlFind(sql);
		System.out.println("ok");
		try {
			if (rs.next()) {
				project_id = rs.getString(1);
				return project_id;
			}
			return null;
		} catch (Exception e) {

			System.out.println("BO.projectBO.returnproject_id()错误"
					+ e.toString());
			return null;

		}
	}
	
	public Vector returnProject(Long ID) {
		db = new dataBase();
		String sql = "select * from project where project_id=" + ID + "";
		ResultSet rs = db.sqlFind(sql);
		Vector vo = new Vector();
		try {
			if (rs.next()) {
				projectBean pbean = new projectBean();
				pbean.setProject_id(rs.getString("project_id"));
				pbean.setProject_name(rs.getString("project_name"));
				pbean.setProject_time(rs.getString("project_time"));
				pbean.setProject_company(rs.getString("project_company"));
				pbean.setProject_cost(rs.getString("project_cost"));
				pbean.setProject_content(rs.getString("project_content"));
				pbean.setProject_username(rs.getString("project_username"));

				vo.addElement(pbean);
			}
		} catch (Exception e) {
			System.out.println("BO.productBO.returnProject(String ID)方法错误"
					+ e.toString());
			return null;
		}
		return vo;

	}

}