order.java

在线拍卖系统

package j2eebbs;

import java.sql.ResultSet;
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.Vector;

public class Order{
	
	private int id;
	private int productid;
	private int userid;
	private int price;
	private int status;
	private Date date;
	
	public Order(){}
	

	public int getId() {
		return id;
	}



	public void setId(int id) {
		this.id = id;
	}
	
	public int getProductid() {
		return productid;
	}


	public void setProductid(int productid) {
		this.productid = productid;
	}


	public int getUserid() {
		return userid;
	}


	public void setUserid(int userid) {
		this.userid = userid;
	}


	public int getPrice() {
		return price;
	}


	public void setPrice(int price) {
		this.price = price;
	}


	public int getStatus() {
		return status;
	}


	public void setStatus(int status) {
		this.status = status;
	}


	public boolean insert(DB db) throws Exception{
        String strSql;
		strSql = "insert into order(productid,userid,price,date,status) values('" 
				+ productid 	+"','"
				+ userid 	+"','"
				+ price 	+"','"
				+ date 	+"','"
				+ status 	+")";
		if ( db.ExecSql(strSql)==0) {
			return false;
		}
		else{
			return true;
		}
	
	}
		
	public static Vector search(DB db ,int productid) throws Exception{
		Vector Orders = new Vector();
		ResultSet rs,rsNest;
        String strSql=null;
		
        strSql = "select * from topic where productid=" + productid;
		rs = db.OpenSql(strSql);
		
		if (rs.next()){
			Order order = new Order();
			
			order.setId(rs.getInt("id"));
			order.setDate(rs.getDate("date"));
			order.setPrice(rs.getInt("price"));
			order.setProductid(rs.getInt("productid"));
			order.setUserid(rs.getInt("userid"));
			order.setStatus(rs.getInt("status"));
			Orders.add(order);
		}		
		return Orders;
	}


	public Date getDate() {
		return date;
	}


	public void setDate(Date date) {
		this.date = date;
	}



}