package restaurant;

import java.io.*;
import java.sql.*;
import javax.swing.JOptionPane;
import java.util.Vector;

public class RestaurantMenu52{
    
    private DBCon con;
	private Read read;
	private Write write;
	private Exit exit;
	private Common common;
	ResultSet rs=null;

	public void selectStockInfo(){
	     String sql="select * from commodityIn where amount<10";
         
         con = new DBCon();
	     read = new Read(con.getConnection());    
         rs=read.executeQuery(sql);       
    }
      
    public Vector getStockInfoInfo(){
    	Vector vec = new Vector();
    	try{
    		while(rs.next()){
    			vec.addElement(rs.getString("stockNo"));
    			vec.addElement(rs.getString("commodity")); 
    			vec.addElement(rs.getString("operator"));
    			vec.addElement(rs.getString("amount"));
    			vec.addElement(rs.getString("price"));
    			vec.addElement(rs.getString("discount"));
    			vec.addElement(rs.getString("totalPrice"));
    			vec.addElement(rs.getString("stockDate"));
    			vec.addElement(rs.getString("remark"));
    		}
        }catch(SQLException e){
		   System.err.println(e.getMessage());
		}
		exit = new Exit(con.getConnection());
        exit.Close();
		
		return vec;
    }
    
}