www.pudn.com > zhaobiao.rar > Basic.java

/** 
 *  
 */ 
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; 
	} 
}