public JComponent createTable()
{
try
{
System.out.println("Treiber laden");
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch (Exception sqle)
{
JOptionPane.showMessageDialog(null,"No suitable driver"+"\n"+sqle.getStackTrace(),"Unable to load driver",JOptionPane.ERROR_MESSAGE);
}
try
{
System.out.println("* Verbindung aufbauen");
String url = "jdbc:mysql://"+hostname+":"+port+"/"+dbname;
conn = DriverManager.getConnection(url, user, pw);
System.out.println("* Statement beginnen");
Statement stmt = conn.createStatement();
System.out.println("* Abfrage beginnen");
String sqlCommand1 = "SELECT * FROM test";
ResultSet rs = stmt.executeQuery(sqlCommand1);
Object[][] values =
{
{ "Mary", new Double(1.2), "yes", "w", "blond"},
{ "Gordy", new Double(1.5), "no", "w", "braun"},
{ "Billy", new Double(2.5), "no", "m", "gelb"},
{ "Jimmy", new Double(5.5), "maybe", "m", "grün"},
{ "Jimmy", new Double(5.5), "maybe", "m", "grün"},
{ "Jimmy", new Double(5.5), "maybe", "m", "grün"},
{ "Jimmy", new Double(5.5), "maybe", "m", "grün"},
{ "Jimmy", new Double(5.5), "maybe", "m", "grün"},
{ "Jimmy", new Double(5.5), "maybe", "m", "grün"},
{ "Jimmy", new Double(5.5), "maybe", "m", "grün"},
{ "Jimmy", new Double(5.5), "maybe", "m", "grün"},
{ "Jimmy", new Double(5.5), "maybe", "m", "grün"},
{ "Jimmy", new Double(5.5), "maybe", "m", "grün"},
{ "Jimmy", new Double(5.5), "maybe", "m", "grün"}
};
String[] colNames = { "Sp. 1", "Sp. 2", "Sp. 3", "Sp. 4", "Sp. 5"};
JTable elem = new JTable(values, colNames);
elem.setPreferredScrollableViewportSize(new Dimension(200, 150));
javax.swing.table.TableColumn col = elem.getColumnModel().getColumn(0);
col.setMinWidth(100);
javax.swing.table.TableColumn col2 = elem.getColumnModel().getColumn(1);
col2.setMinWidth(100);
javax.swing.table.TableColumn col3 = elem.getColumnModel().getColumn(2);
col3.setMinWidth(100);
javax.swing.table.TableColumn col4 = elem.getColumnModel().getColumn(3);
col4.setMinWidth(100);
javax.swing.table.TableColumn col5 = elem.getColumnModel().getColumn(4);
col5.setMinWidth(100);
JPanel panel = new JPanel();
panel.add(new JLabel("Table:"));
panel.add(new JScrollPane(elem));
elem.setAutoscrolls(true);
elem.setEnabled(true);
elem.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
return panel;
}
catch (SQLException sqle)
{
JOptionPane.showMessageDialog(null, "SQLException: "+ sqle.getMessage()+"\nSQLState: "+ sqle.getSQLState()+"\nVendorError: "+sqle.getErrorCode()+"\n"+sqle.getStackTrace(),"ACCESS DENIED",JOptionPane.ERROR_MESSAGE);
}
}
public NewJFrame()
{
super("Interaktionselemente");
Box box = new Box(BoxLayout.Y_AXIS);
box.add(createTable());
getContentPane().add(box, BorderLayout.CENTER);
pack();
}