?? 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: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;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -