basic.java

自己做的一个企业招标系统,B/S结构。开发工具Eclipse

/**
 * 
 */
package com.centralsoft.zhaobiao.qtdatachaxun;

import java.sql.*;

import com.centralsoft.zhaobiao.qtdataguanli.Maker;
import com.centralsoft.zhaobiao.qtdataguanli.Type;
import com.centralsoft.zhaobiao.qtdataguanli.Project;
import com.centralsoft.zhaobiao.qtdataguanli.Product;
import com.centralsoft.zhaobiao.qtdataguanli.PPM;
import com.centralsoft.zhaobiao.util.dataBase;
/**
 * @author Administrator
 *
 */
public class Basic {
	public Basic() {
	}
	/**
	 * 返回一个厂商的详细信息
	 * @param maker_id
	 * @return
	 */
	public Maker getMaker(long maker_id) {
		ResultSet rs = null;
		Maker mk = new Maker();
		dataBase db = new dataBase();
		String sql = "select * from maker where maker_id = "+maker_id;
		System.out.println("makerinformation===="+sql);
		rs = db.getResultSet(sql);
		try {
			while (rs.next()) {
				mk.setMaker_id(rs.getLong("maker_id"));
	            mk.setMaker_name(rs.getString("maker_name"));
	            mk.setMaker_address(rs.getString("maker_address"));
	            mk.setMaker_cr_address(rs.getString("maker_cr_time"));
	            mk.setMaker_cr_time(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_relation(rs.getString("maker_relation"));
	            mk.setMaker_db_content(rs.getString("maker_db_content"));
			}
		} catch (Exception e) {
			System.out.println("查询返回一个厂商的详细信息失败!"+e.getMessage());
		} finally {
			try {
				if (rs != null) {
					rs.close();
				}
				db.closeConn();
			} catch (Exception e) {
				System.out.println(e.getMessage());
			}
		}
		return mk;
	}
	/**
	 * 返回一个设备类型的详细信息
	 * @param type_id
	 * @return
	 */
	public Type getType(long type_id) {
		ResultSet rs = null;
		Type type = new Type();
		dataBase db = new dataBase();
		String sql = "select * from type where type_id ="+type_id;
		System.out.println("typeinformation====="+sql);
		rs = db.getResultSet(sql);
		try {
			while (rs.next()) {
				type.setType_id(rs.getLong("type_id"));
				type.setType_name(rs.getString("type_name"));
				type.setType_content(rs.getString("type_content"));
			}
		} catch (Exception e) {
			System.out.println("查询返回一个设备类型的详细信息失败！"+e.getMessage());
		} finally {
			try {
				if (rs != null) {
					rs.close();
				}
				db.closeConn();
			} catch (Exception e) {
				System.out.println(e.getMessage());
			}
		}
		return type;
	}
	/**
	 * 返回一个项目的详细信息
	 * @param project_id
	 * @return
	 */
	public Project getProject(long project_id) {
		Project pj = new Project();
		ResultSet rs = null;
		dataBase db = new dataBase();
		String sql = "select * from project where project_id ="+project_id;
		System.out.println("projectinformation====="+sql);
		rs = db.getResultSet(sql);
		try {
			while (rs.next()) {
				pj.setProject_id(rs.getLong("project_id"));
				pj.setProject_name(rs.getString("project_name"));
				pj.setProject_time(rs.getString("project_time"));
				pj.setProject_company(rs.getString("project_company"));
				pj.setProject_cost(rs.getString("project_cost"));
				pj.setProject_content(rs.getString("project_content"));
			}
		} catch (Exception e) {
			System.out.println("返回一个项目的详细信息失败!"+e.getMessage());
		} finally {
			try {
				if (rs != null) {
					rs.close();
				}
				db.closeConn();
			} catch (Exception e) {
				System.out.println(e.getMessage());
			}
		}
		return pj;
	}
	/**
	 * 返回一个产品的详细信息
	 * @param product_id
	 * @return
	 */
	public Product getProduct(long product_id) {
		Product pd = new Product();
		ResultSet rs = null;
		dataBase db = new dataBase();
		String sql = "select * from product where product_id = "+product_id;
		System.out.println("productinformation====="+sql);
		rs = db.getResultSet(sql);
		try {
			while (rs.next()) {
				pd.setProduct_id(rs.getLong("product_id"));
				pd.setProduct_name(rs.getString("product_name"));
				pd.setMaker_id(rs.getLong("maker_id"));
				pd.setType_id(rs.getLong("type_id"));
				pd.setProduct_content(rs.getString("product_content"));
			}
		} catch (Exception e) {
			System.out.println("返回一个产品的详细信息失败！"+e.getMessage());
		} finally {
			try {
				if (rs != null) {
					rs.close();
				}
				db.closeConn();
			} catch (Exception e) {
				System.out.println(e.getMessage());
			}
		}
		return pd;
	}
	/**
	 * 根据ppmid获得该PPM对象
	 * @param id
	 * @return
	 */
	public PPM getPPM(long id) {
		PPM ppm = new PPM();
		dataBase db = new dataBase();
		ResultSet rs = null;
		String sql = "select * from ppm where id ="+id;
		rs = db.getResultSet(sql);
		try {
			if (rs.next()) {
				boolean isok = false;
				ppm.setId(rs.getLong("id"));
				ppm.setProject_id(rs.getLong("project_id"));
				ppm.setProduct_id(rs.getLong("product_id"));
				ppm.setMaker_id(rs.getLong("maker_id"));
				if (rs.getLong("zhaobiao") == 1) {
					isok = true;
				}
				ppm.setZhongbiao(isok);
				ppm.setPrice_id(rs.getLong("price_id"));
			}
		} catch (Exception e) {
			System.out.println(e.getMessage());
		} finally {
			try {
				if (rs != null) {
					rs.close();
				}
				db.closeConn();
			} catch (Exception e) {
				System.out.println(e.getMessage());
			}
		}
		return ppm;
	}
}