projectmakerbo.java

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

package com.BO;

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

import java.io.UnsupportedEncodingException;
import java.sql.*;
import java.util.*;

public class projectMakerBO {
	dataBase db;

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

	public ArrayList showMaker() {
		ArrayList list = new ArrayList();
		String sql = "select* from maker";
		ResultSet rs = db.sqlFind(sql);
		try {
			while (rs.next()) {
				String Maker_id = rs.getString("Maker_id");
				String userName = rs.getString("userName");
				String Maker_name = rs.getString("Maker_name");
				projectMakerVO vo = new projectMakerVO();
				vo.setMaker_id(Maker_id);
				vo.setUserName(userName);
				vo.setMaker_name(Maker_name);
				list.add(vo);

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

	// 负责厂商的删除
	public boolean dealMaker(String Maker_id) {

		String sql = "select* from maker where maker_id='" + Maker_id + "'";
		ResultSet rs = db.sqlFind(sql);
        
		try {
			
			if (rs.next()) {
				String name = rs.getString("UserName");
				sql = "select * from project where project_username='" + name
						+ "'";
				 
				ResultSet rss = db.sqlFind(sql);
			
				if (rss.next()) {
					System.out.println(Maker_id);
					String project_id=rss.getString("project_id");
					sql = "delete product where project_id='"
							+ project_id + "'";
					db.sqlUpdata(sql);

					sql = "delete toubiaoTable where project_id='"
							+ project_id + "'";
					db.sqlUpdata(sql);
					sql = "delete project where project_id='"
							+ project_id + "'";
					db.sqlUpdata(sql);
					sql = "delete maker where Maker_id='" + Maker_id + "'";
					db.sqlUpdata(sql);
				}
			}

		} catch (Exception e) {

		}

		return true;
	}

	// 负责厂商的添加
	public boolean addMaker(String userName, String userPass,
			String Maker_name, String Maker_address, String Maker_Cr_time,
			String Maker_Cr_address, String Maker_Cr_cost,
			String Maker_Fr_name, String Maker_Fr_position,
			String Maker_Attribute, String Maker_phone, String Maker_email) {

		String sql = "insert maker values('" + userName + "','" + userPass
				+ "','" + Maker_name + "','" + Maker_address + "','"
				+ Maker_Cr_time + "','" + Maker_Cr_address + "','"
				+ Maker_Cr_cost + "','" + Maker_Fr_name + "','"
				+ Maker_Fr_position + "','" + Maker_Attribute + "','"
				+ Maker_phone + "','" + Maker_email + "')";
		try {
			sql = new String(sql.getBytes("ISO-8859-1"), "GB2312");
			db.sqlUpdata(sql);
		} catch (Exception e) {
			System.out.println("addMaker Error!!" + e.getMessage());
		}
		return true;
	}

	// 负责厂商的更新
	public boolean updateMaker(String Maker_id, String userName,
			String userPass, String Maker_name, String Maker_address,
			String Maker_Cr_time, String Maker_Cr_address,
			String Maker_Cr_cost, String Maker_Fr_name,
			String Maker_Fr_position, String Maker_Attribute,
			String Maker_phone, String Maker_email) {
		String sql = "update maker set  userName='" + userName + ",userPass='"
				+ userPass + "', Maker_name='" + Maker_name
				+ "', Maker_address='" + Maker_address + "', Maker_Cr_time='"
				+ Maker_Cr_time + "',	Maker_Cr_address='" + Maker_Cr_address
				+ "', Maker_Cr_cost='" + Maker_Cr_cost + "', Maker_Fr_name='"
				+ Maker_Fr_name + "',	Maker_Fr_position='" + Maker_Fr_position
				+ "',Maker_Attribute='" + Maker_Attribute + "', Maker_phone='"
				+ Maker_phone + "',Maker_email='" + Maker_email
				+ "' where Maker_id='" + Maker_id + "'";
		try {
			sql = new String(sql.getBytes("ISO-8859-1"), "GB2312");
			db.sqlUpdata(sql);
		} catch (Exception e) {
			System.out.println("updateMaker Error!!!" + e.getMessage());
		}
		return true;
	}

	public long getMakerListCount() {

		long count = 0;

		String sql = "select * from maker";
		ResultSet rs = db.sqlFind(sql);
		try {

			while (rs.next()) {
				count++;
			}
		} catch (SQLException ex) {

			ex.printStackTrace();

		}

		return count;

	}

	public Vector getMakerList(long page, long pagemax) {
		page = page - 1;
		Vector list = new Vector();
		String sql = "select * from maker";
		ResultSet rs = db.sqlFind(sql);
		try {
			int count = 1;
			while (rs.next()) {
				if (count > (page * pagemax)
						&& count <= (page * pagemax + pagemax)) {
					projectMakerVO mk = new projectMakerVO();
					mk.setMaker_id(rs.getString("maker_id"));
					mk.setUserName(rs.getString("userName"));
					mk.setUserPass(rs.getString("userPass"));
					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"));
					mk.setMaker_phone(rs.getString("Maker_phone"));
					mk.setMaker_email(rs.getString("Maker_email"));
					list.add(mk);
				}
				count++;
			}
		} catch (SQLException ex) {

			ex.printStackTrace();

		}

		return list;

	}

}