import java.util.*;
import java.sql.*;
import javax.swing.table.*;
class MyTableModel extends AbstractTableModel
{
private Static void main(String[ ]args) columnNames =
{ "ID", "Name","Passport Number","Lunch Place","Arrive Place","Plane ID",
"Want arrival max date", "arrival date\"Available near data\"","Lunch Time"};
final Object[][] data = {
{"Mary", "Campione",
"Snowboarding", new Integer(5), new Boolean(false)},
{"Alison", "Huml",
"Rowing", new Integer(3), new Boolean(true)},
{"Kathy", "Walrath",
"Chasing toddlers", new Integer(2), new Boolean(false)},
{"Sharon", "Zakhour",
"Speed reading", new Integer(10), new Boolean(true)},
{"Angela", "Lih",
"Teaching high school", new Integer(4), new Boolean(false)}
};
Object myObjectData[ ];
String myStringData[ ];
Vector vector=new Vector();
public void dbMethod()
{
String re;
String url="jdbc:odbc:A5";
Array ar=null;
/////////create connection to data base and but SQL statements
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection( url,"","");//BasicData,"jdbc:obdc:FPNWIND"
Statement state=con.createStatement();
ResultSet rs=state.executeQuery("SELECT * FROM Passenger_Data");//BasicData,Customers,Passenger
while(rs.next())
{
vector.addElement(new StockData(rs.getInt(1),rs.getString(2),rs.getInt(3),rs.getString(4),
rs.getString(5),rs.getInt(6),rs.getDate(7),rs.getDate(8),rs.getTime(9)));
Gui.i=rs.getRow();
System.out.println(" i=rs.getRow();="+ Gui.i);
}
}catch(Exception e){ System.out.println("An error achor in database:"+e.toString()); }
}
public int getColumnCount()
{
return 9;
}
public int getRowCount()
{
return Gui.i;//rs.getRow();//mtm.i;
}
public Object getValueAt(int nRow, int nCol) {
////////////////////////////////////Arabic/////////////////////////////////////
/////////////äÊäÇÊáÊÇáÇá
/////////////////////////////////////////////////////
System.out.println("nRow="+nRow);
StockData row =(StockData)vector.elementAt(nRow);
switch (nCol) {
case 0: return row.v_ID;
case 1: return row.v_name;
case 2: return row.v_passport;
case 3: return row.v_lunch_place;
case 4: return row.v_arrival_place;
case 5: return row.v_plane_ID;
case 6: return row.v_want_date;
case 7: return row.v_available_date;
case 8: return row.v_lunch_time;
}
return null;
}
public String getColumnName(int col)
{
return columnNames[col];
}
}
class StockData
{
//////////////////////////JTable\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
//getCellSelectionEnabled() , getToolTipText(MouseEvent event) , rowAtPoint(Point point) ,
//sizeColumnsToFit(boolean lastColumnOnly) , sizeColumnsToFit(int resizingColumn)
////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////ResultSet\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
public Integer v_ID;
public String v_name;
public Integer v_passport;
public String v_lunch_place;
public String v_arrival_place;
public Integer v_plane_ID;
public java.sql.Date v_want_date;
public java.sql.Date v_available_date;
public Time v_lunch_time;
public StockData(Integer ID, String name, Integer passport,
String lunch_place,String arrival_place, Integer plane_ID, java.sql.Date want_date, java.sql.Date available_date,Time lunch_time) {
v_ID = ID;
v_name = name;
v_passport = new Integer(passport);
v_lunch_place = lunch_place;
v_arrival_place=arrival_place;
v_plane_ID = new Integer(plane_ID);
v_want_date = want_date;
v_available_date = available_date;
v_lunch_time=lunch_time;
}
}
