package restaurant;

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

public class RestaurantMenu53{
    
    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 DATEDIFF('d',stockDate,now()) >5";
         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;
    }
    
}