smide ResultSets i JTable?
Jeg har dette eksempel taget inde fra Sun:Button vis = new Button("Vis");
Object[][] data = {
{"Mary", "Campione",
"Snowboarding", new Integer(5), },
{"Alison", "Huml",
"Rowing", new Integer(3), },
{"Kathy", "Walrath",
"Chasing toddlers", new Integer(2), },
{"Mark", "Andrews",
"Speed reading", new Integer(20),},
};
String[] columnNames = {"First Name",
"Last Name",
"Sport",
"# of Years"
};
final JTable table = new JTable(data, columnNames);
table.setPreferredScrollableViewportSize(new Dimension(300, 50));
setLayout(new BorderLayout());
add(table.getTableHeader(), BorderLayout.NORTH);
add(table, BorderLayout.CENTER);
add(vis,BorderLayout.SOUTH);
-----------------------------------------------------
Hvordan kan jeg smide mine data fra databasen ind i den via knappen vis?
Min query:
public void visPoster()
{
try {
ConnectDB db = new ConnectDB( "jdbc:mysql://localhost/rikif_dk", "aslan", "" );
ResultSet row = db.Select( "SELECT * FROM board" );
while( row.next() )
{
// row.getString("data");
// row.getString("tid") ;
// row.getString("data2");
// row.getString("tid2") ;
}
} catch (SQLException e)
{
}
catch(NullPointerException a)
{
}
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource() == vis)
{
visPoster();
}
}
