package COM.xinit.demon.co.uk.3tier.database;

import java.util.Vector;
import msql.*;

public interface DBAccess 
{
    public void close () throws MsqlException;
    public StockRec[] getStocks();

    /**
     *
     * @param String ssn - stock serial number
     */ 

    public void sellShares(String ssn, String symbol, int quantity) 
        throws RecordNotFoundException, InvalidTransactionException; 

    public void buyShares(String ssn, String symbol, int quantity) 
        throws RecordNotFoundException;

    public float getStockPrice(String symbol);

    public void addCustomer (String name, String ssn, String address) 
        throws DuplicateIDException;

    public void deleteCustomer (String ssn) 
        throws RecordNotFoundException;

    public void updateCustomer (String name,String ssn,String address) 
        throws RecordNotFoundException;

    public CustomerRec getCustomer (String ssn) 
        throws RecordNotFoundException;

    public CustomerRec[] getAllCustomers ();
}

Last Updated