orderline.java

一个完整的网上书店

package com.ascenttech.ebookstore.bean;

import java.sql.*;

import com.ascenttech.ebookstore.util.DataAccess;

public class Orderline {
  
  //data
  private int oid;
  private String isbn;
  private int quantity;
  private float price;

  //getXxx()
  public int getOid(){return this.oid;}
  public String getIsbn(){return this.isbn;}
  public int getQuantity(){return this.quantity;}
  public float getPrice(){return this.price;}

  //setXxx()
  public void setOid(int oid){this.oid = oid;}
  public void setIsbn(String isbn){this.isbn = isbn;}
  public void setQuantity(int quantity){this.quantity=quantity;}
  public void setPrice(float price){this.price = price;}

  public Orderline() {
  }

  public void saveOrderline() throws Exception {
    Connection con = DataAccess.getConnection();
    String sqlStr = "insert into ebs_orderline (oid, isbn, baseprice, quantity)"
                    + "  values(" + this.getOid()+","
                                  + "'"+this.getIsbn()+"',"
                                  + this.getPrice()+","
                                  + this.getQuantity()+")";
    Statement stmt = con.createStatement();
    stmt.executeUpdate(sqlStr);
    stmt.close();
    con.close();


  }

}