rendered paste body private void presentResultSet(ResultSet dbRS) throws SQLException
{
dataVector = new Vector();
if (!dbRS.next())
JOptionPane.showMessageDialog(null, "No records for event");
else {
do {
Vector rowVector = new Vector();
rowVector.addElement(dbRS.getString("date"));
rowVector.addElement(dbRS.getString("time"));
rowVector.addElement(dbRS.getString("performer"));
rowVector.addElement(dbRS.getString("room_id"));
rowVector.addElement(dbRS.getString("price"));
rowVector.addElement(dbRS.getString("tickets_left"));
dataVector.addElement(rowVector);
} while (dbRS.next());
}
Vector headVector = new Vector(6);
headVector.addElement("date");
headVector.addElement("time");
headVector.addElement("performer");
headVector.addElement("room_id");
headVector.addElement("price");
headVector.addElement("tickets_left");
dataTable = new JTable();
dataTable = new JTable (dataVector, headVector);
//JScrollPane dataTableScrollPane = new JScrollPane(dataTable);
//dataTableScrollPane.setViewportView(dataTable);
//dataTableScrollPane.setVerticalScrollBarPolicy(JScrollPane.VERTICAL_SCROLLBAR_ALWAYS );
//dataTableScrollPane.setWheelScrollingEnabled(true);
JPanel form = new JPanel();
form.add(dataTable);
addMainComponent(form);
/*
int row = dataTable.getSelectedRow();
dataVector.get(row);
int id = 0;
//Date date = (Date)dataVector.get(1);
Time time = (Time)dataVector.get(2);
String performer = (String)dataVector.get(3);
String room = (String)dataVector.get(4);
double ticketPrice = (Double)dataVector.get(5);
int tickets_left = (Integer) dataVector.get(6);
gui.chosenEvent = new Event(id, null, time, performer, room, ticketPrice, tickets_left);
*/
dataVector.get(2);
int id = 5;
String performer = (String)dataVector.get(5);
String room = "rew";
double ticketPrice = 34.4;
int tickets_left = 4;
gui.chosenEvent = new Event(id, null, null, performer, room, ticketPrice, tickets_left);