details.java

J2EE关于JSP,SERVERLET的多个实用例子

//Code for the Bean component:Details.java
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:MyDataSource1",
"faculty","");
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",
"faculty","");
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;
		}

}