【Java开源代码栏目提醒】:网学会员为广大网友收集整理了,Basic.java,希望对大家有所帮助!
package zhaobiao.db;
import java.util.*;
import java.sql.*;
import zhaobiao.db.*;
import zhaobiao.data.*;
/**
* <p>Title: 招标管理信息系统</p>
* <p>Description: 招标管理信息系统的前台设计</p>
* <p>Copyright: Copyright (c) 2003</p>
* <p>Company: 招标信息管理系统</p>
* @author csk
* @version 1.0
*/
public class Basic {
public Basic() {
}
/** 根据项目id获得该项目对象
*@param 项目id
*@return 项目对象实例
*/
public Project getProject(long project_id)
{
Project pj=new Project();
db=DBConnectionManager.getInstance();
con=db.getConnection("idb");
String sql="select *from project where project_id=?";
try {
ps=con.prepareStatement(sql);
ps.setLong(1,project_id);
rs=ps.executeQuery();
if(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 (SQLException ex) {
freeCon();
ex.printStackTrace();
}
freeCon();
return pj;
}
/** 根据类别的id获得该类别对象
*@param 类别id
*@return 类别对象实例
*/
public Type getType(long type_id)
{
Type type=new Type();
db=DBConnectionManager.getInstance();
con=db.getConnection("idb");
String sql="select *from type where type_id=?";
try {
ps=con.prepareStatement(sql);
ps.setLong(1,type_id);
rs=ps.executeQuery();
if(rs.next())
{
type.setType_id(rs.getLong("type_id"));
type.setType_name(rs.getString("type_name"));
type.setType_content(rs.getString("type_content"));
}
}
catch (SQLException ex) {
ex.printStackTrace();
freeCon();
}
freeCon();
return type;
}
/**根据产品id获得该产品对象
*@param 产品id
*@return 产品对象实例
*/
public Product getProduct(long product_id)
{
Product pd=new Product();
db=DBConnectionManager.getInstance();
con=db.getConnection("idb");
String sql="select *from product where product_id=?";
try {
ps=con.prepareStatement(sql);
ps.setLong(1,product_id);
rs=ps.executeQuery();
if(rs.next())
{
pd.setProduct_id(rs.getLong("product_id"));
pd.setProduct_name(rs.getString("product_name"));
pd.setType_id(rs.getLong("type_id"));
pd.setProduct_content(rs.getString("product_content"));
pd.setMaker_id(rs.getLong("maker_id"));
}
}
catch (SQLException ex) {
freeCon();
ex.printStackTrace();
}
freeCon();
return pd;
}
/**根据厂商id返回厂商对象
*@oaram 厂商id
* @return 厂商对象
*/
public Maker getMaker(long maker_id)
{
Maker mk=new Maker();
db=DBConnectionManager.getInstance();
con=db.getConnection("idb");
String sql="select *from maker where maker_id=?";
try {
ps=con.prepareStatement(sql);
ps.setLong(1,maker_id);
rs=ps.executeQuery();
if(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_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_relation(rs.getString("maker_relation"));
mk.setMaker_db_content(rs.getString("maker_db_content"));
}
}
catch (SQLException ex) {
freeCon();
ex.printStackTrace();
}
freeCon();
return mk;
}
/** 根据ppmid获得该PPM对象
*@param PPM_id (long)
*@return PPM对象
*/
public PPM getPPM(long id)
{
PPM ppm=new PPM();
db=DBConnectionManager.getInstance();
con=db.getConnection("idb");
String sql="select *from ppm where id=?";
try {
ps=con.prepareStatement(sql);
ps.setLong(1,id);
rs=ps.executeQuery();
if(rs.next())
{
boolean isok=false;
ppm.setId(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("zhongbiao")==1)
isok=true;
ppm.setZhongbiao(isok);
ppm.setPrice_id(rs.getLong("price_id"));
}
}
catch (SQLException ex) {
freeCon();
ex.printStackTrace();
}
freeCon();
return ppm;
}
/** 根据标价id获得标价对象
* @param 标价id
* @return 标价对象
*/
public Price getPrice(long id)
{
Price price=new Price();
db=DBConnectionManager.getInstance();
con=db.getConnection("idb");
String sql="select *from price where price_id=?";
try {
ps=con.prepareStatement(sql);
ps.setLong(1,id);
rs=ps.executeQuery();
if(rs.next())
{
price.setPrice_id(id);
// price.setMaker_id(rs.getLong("maker_id"));
price.setDevice_price(rs.getString("device_price"));
price.setTool_price(rs.getString("tool_price"));
price.setService_price(rs.getString("service_price"));
price.setOptional_price(rs.getString("optional_price"));
price.setRePro_price(rs.getString("rePro_price"));
price.setInter_price(rs.getString("inter_price"));;
price.setEnsure_price(rs.getString("ensure_price"));
price.setDeliver_time(rs.getString("deliver_time"));
}
}
catch (SQLException ex) {
ex.printStackTrace();
}
freeCon();
return price;
}
/** 主要替换回车符为空,双引号为\"
*@param String
*@return String
*/
public String cnvtBr(String str) {
String text = str;
int index=text.indexOf(13);
while(index!=-1)
{
text=text.substring(0,index)+"<br>"+text.substring(index+2);
index=text.indexOf(13);
}
return text;
}
/**
* 释放数据库资源<p>
*PreparedStatement和ResultSep将关闭,Connection返回给连接池
* @param 无
* @repurn 无
* @exception SQLException
*
*/
public void freeCon(){
try {
if (rs!=null)
rs.close() ;
if (ps!=null)
ps.close() ;
}
catch (SQLException ex) {
}
if (db!=null)
db.freeConnection("idb",con) ;
}
private DBConnectionManager db;
private Connection con=null;
private ResultSet rs=null;
private PreparedStatement ps=null;
}
上一篇:
BaseVectorShape.java
下一篇:
凉凉的清晨