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

public class RestaurantMenu43{

	private DBCon con;
	private Read read;
	private Exit exit;
	private Common common;
    ResultSet rs=null;

	public void selectRoomInfo(String customerType){
	     String sql="select sales.customerType from sales where customerType in('"+customerType+"')";
         
         con = new DBCon();
	     read = new Read(con.getConnection());    
         rs=read.executeQuery(sql);       
    }
      
    public int getStockInfoInfo(){
    	int total=0;
    	try{
    		while(rs.next()){
    			total++;
    		}
        }catch(SQLException e){
		   System.err.println(e.getMessage());
		}
		exit = new Exit(con.getConnection());
        exit.Close();
		
		return total;
    }
}