projectbo.java

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

package com.BO;

import java.util.*;
import java.sql.*;

import com.CDB.dataBase;
import com.VO.*;

import java.lang.*;

public class projectBO {
	private dataBase db;

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

	public ArrayList showProject() {
		ArrayList list = new ArrayList();
		String sql = "select * from project ";
		ResultSet rs = db.sqlFind(sql);

		try {
			while (rs.next()) {
				String project_id = rs.getString(1);
				String project_name = rs.getString(2);
				String project_time = rs.getString(3);
				String project_company = rs.getString(4);
				String project_cost = rs.getString(5);
				String project_content = rs.getString(6);
				String project_check = rs.getString(7);
				projectVO vo = new projectVO();

				vo.setProject_id(project_id);
				vo.setProject_name(project_name);
				vo.setProject_check(project_check);
				vo.setProject_time(project_time);
				vo.setProject_company(project_company);
				vo.setProject_cost(project_cost);
				vo.setProject_content(project_content);
				vo.setProject_check(project_check);

				list.add(vo);

			}

		} catch (Exception e) {
			System.out.println("show Project Error!!" + e.getMessage());
		}
		return list;
	}

	public ArrayList show(String project_id) {
		ArrayList list = new ArrayList();
		String sql = "select * from project where project_id='" + project_id
				+ "'";
		ResultSet rs = db.sqlFind(sql);

		try {
			while (rs.next()) {

				String project_name = rs.getString(2);
				String project_time = rs.getString(3);
				String project_company = rs.getString(4);
				String project_cost = rs.getString(5);
				String project_content = rs.getString(6);
				String project_check = rs.getString(7);
				String project_username = rs.getString(8);
				projectVO vo = new projectVO();

				vo.setProject_name(project_name);
				vo.setProject_check(project_check);
				vo.setProject_time(project_time);
				vo.setProject_company(project_company);
				vo.setProject_cost(project_cost);
				vo.setProject_content(project_content);
				vo.setProject_check(project_check);
				vo.setProject_username(project_username);

				list.add(vo);

			}

		} catch (Exception e) {
			System.out.println("show Project Error!!" + e.getMessage());
		}
		return list;
	}

	public boolean dealProject(String project_id) {
		String sql = "select * from project where project_id='" + project_id
				+ "'";
		ResultSet rs = db.sqlFind(sql);
		try {
			if (rs.next()) {
				sql = "delete from product where project_id='" + project_id
						+ "'";
				db.sqlUpdata(sql);
				sql = "delete from project where project_id='" + project_id
						+ "'";
				db.sqlUpdata(sql);
				return true;
			} else {

				sql = "delete from project where project_id='" + project_id
						+ "'";
				db.sqlUpdata(sql);
				return true;

			}
		} catch (Exception e) {
			System.out.println("delzhaobiao Error" + e.getMessage());
			return false;
		}
	}

	public boolean addProject(String project_name, String project_time,
			String project_company, String project_cost,
			String project_content, String userName) {
		String sql = "insert project values('" + project_name + "','"
				+ project_time + "','" + project_company + "','" + project_cost
				+ "','" + project_content + "','1','" + userName + "')";

		try {
			sql = new String(sql.getBytes("ISO-8859-1"), "GB2312");

			db.sqlUpdata(sql);
		} catch (Exception e) {

			System.out.println("addProject Error!!" + e.getMessage());
		}
		return true;
	}

	public boolean updateProject(String project_id, String project_name,
			String project_time, String project_company, String project_cost,
			String project_content) {
		String sql = "update project set project_name='" + project_name
				+ "', project_time='" + project_time + "', project_company='"
				+ project_company + "', project_cost='" + project_cost
				+ "',project_content='" + project_content
				+ "'  where project_id='" + project_id + "'";

		try {
			sql = new String(sql.getBytes("ISO-8859-1"), "GB2312");
			db.sqlUpdata(sql);
		} catch (Exception e) {
			System.out.println("updateProject Error!!" + e.getMessage());
		}

		return true;
	}

	public boolean checkProject(String project_id) {
		String sql = "update project set project_check='" + 1
				+ "'where project_id='" + project_id + "'";

		try {
			sql = new String(sql.getBytes("ISO-8859-1"), "GB2312");
			db.sqlUpdata(sql);
		} catch (Exception e) {
			System.out.println("checkProject Error!!" + e.getMessage());
		}
		return true;
	}

}