zhaobiaobo.java

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

package C03.BO;

import java.io.UnsupportedEncodingException;
import java.sql.ResultSet;
import java.util.Vector;
import C03.VO.*;

import C03.CDB.*;

public class zhaobiaoBO {
	dataBase db;

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

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

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

	public boolean addproject(String project_name, String project_time,
			String project_company, String project_cost,
			String project_concent, String project_username)
			throws UnsupportedEncodingException {
		project_name = new String(project_name.getBytes("ISO-8859-1"), "GB2312");
		project_cost = new String(project_cost.getBytes("ISO-8859-1"), "GB2312");
		project_concent = new String(project_concent.getBytes("ISO-8859-1"),"GB2312");

		String sql = "insert project values('" + project_name + "','"
				+ project_time + "','" + project_company + "','" + project_cost
				+ "','" + project_concent + "','0','" + project_username + "')";

		if (db.sqlUpdata(sql)) {
			return true;
		} else
			return false;
	}

	public boolean updatazhaobiao(String project_id, String project_name,
			String project_cost, String project_content)
			throws UnsupportedEncodingException {
		String sql = "update project set project_name='" + project_name
				+ "',project_cost='" + project_cost + "',project_content='"
				+ project_content + "'";
		sql = new String(sql.getBytes("ISO-8859-1"), "GB2312");
		dataBase db = new dataBase();
		if (db.sqlUpdata(sql))
			return true;
		else
			return false;

	}

	public boolean delzhaobiao(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;
		}
	}
}