import java.sql.*;
import java.util.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.table.*;
class MyPizzaTableModel extends AbstractTableModel{
private Connection con = null;
Statement stmt = null;
public void init(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(
"jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ=test");
} catch (Exception e){
System.err.println(e);
}
}
String SpaltenNamen[] = {"Nr", "Name", "Preis"};
Vector Spalten [] = {new Vector(), new Vector(), new Vector()};
public void fetchData(){
try{
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery ("SELECT * FROM test");;
while (rs.next()){
for (int i = 0; i < SpaltenNamen.length; i++)
Spalten[i].addElement (rs.getString (SpaltenNamen[i]));
}
stmt.close();
} catch (SQLException e){
System.err.println(e);
}
}
public String getColumnName (int column){
return SpaltenNamen[column];
}
public int getColumnCount(){
return SpaltenNamen.length;
}
public int getRowCount(){
return Spalten[0].size();
}
public boolean isCellEditable(int row, int col){
return false;
}
public Object getValueAt(int row, int col){
return Spalten[col].elementAt(row);
}
}
public class TablePizzaService2 extends JFrame{
public TablePizzaService2 (String ResourceName){
setDefaultCloseOperation (EXIT_ON_CLOSE);
setSize(600,200);
MyPizzaTableModel dataModel = new MyPizzaTableModel();
dataModel.init ();
dataModel.fetchData ();
JTable table = new JTable(dataModel);
JScrollPane scrollpane = new JScrollPane(table);
JPanel mainPanel = new JPanel();
mainPanel.add(scrollpane, BorderLayout.CENTER);
getContentPane().add(mainPanel);
setVisible(true);
}/*
public static JPanel createTitledPanel(String title){
JPanel p = new JPanel();
p.setBorder(
BorderFactory.createTitledBorder(
BorderFactory,createEtchedBorder(), title));
p.setLayout(new BorderLayout());
return p;
}*/
public static void main(String[] args){
TablePizzaService2 ps = new TablePizzaService2 ("PizzaService");
}
}