p572_testdb.es

javascript source code part2

Swing = Packages.javax.swing; // Just change this line if it moves

JFrame = Swing.JFrame;
JPanel = Swing.JPanel;
JTable = Swing.JTable;
JScrollPane = Swing.JScrollPane;


db= new Database("sun.jdbc.odbc.JdbcOdbcDriver"); 
writeln(db.getLastError());
db.connect("jdbc:odbc:PEOPLE"); 
result = db.executeRetrieval("select * from MAIN"); 

// Create the panel and its content 
panel = new JPanel();
dbTable = new JTable(8, result.length);
scrltable = new JScrollPane(dbTable);
dbTable.setToolTipText("Database Table content");
panel.add(scrltable);


var rowCount = 0;
var colCount = 0;

while (result.next()) { 
   colCount = 0;
   for (c in result) { 
        
       tpItem = result.getColumnItem(c);
      writeln("Column: " + c + ": " + tpItem);
        dbTable.setValueAt(tpItem, rowCount, colCount); 
       colCount++;
   } 
 rowCount++;
} 
db.disconnect();

// Now create the frame
frame = new JFrame("Wrox FESI Database Viewer");
frame.getContentPane().add("Center", panel);

frame.pack();
frame.setVisible(true);
frame.onWindowClosing = "frame.dispose();exit();";