import java.io.*;
import java.sql.*;

public class Details
{
	private String sPassengerId="";
	private String sEconomyClass; 
    private String sBusinessClass;	
	Connection connect = null;
	Statement state = null;
	ResultSet result = null;
	public void setPassengerId(String sPassengerId)
	{
		this.sPassengerId=sPassengerId;
	}

	public String getPassengerId()
	{
		return this.sPassengerId;
	}

	public Details() throws ClassNotFoundException
	{
	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	}
	

	public int getEconomyClass()
	{
		int iEcoClass =0;
		sPassengerId=getPassengerId();
		try{
			connect=DriverManager.getConnection("jdbc:odbc:MyDataSource","user1","");
			String strQuery = "Select intNo_econ_seats from manifestation where cPassenger_ID=’"+sPassengerId+"’ " ;	
			state = connect.createStatement();
			ResultSet result = state.executeQuery(strQuery);
						
			while(result.next())
			{
				iEcoClass = result.getInt(1);
								
			}
		}
		catch(SQLException e)
		{

		}

		return iEcoClass;
	}

	public int getBusinessClass()
	{
		int iBusClass=0;
		
		try{
			
			sPassengerId=getPassengerId();

			connect=DriverManager.getConnection("jdbc:odbc:MyDataSource","user1","");
			String strQuery = "Select intNo_exec_seats from manifestation where cPassenger_ID=’"+sPassengerId+"’ " ;
				
			state = connect.createStatement();
			ResultSet result = state.executeQuery(strQuery);
						
			while(result.next())
			{
				iBusClass = result.getInt(1);
								
			}
		}
		catch(SQLException e)
		{

		}

		return iBusClass;
	}

}