rendered paste body /**
*
* @param dbRS
*/
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);
String[] choices = {"1", "2", "3", "4"};
numTickets = new JComboBox(choices);
JPanel form = new JPanel();
form.add(new JLabel("Enter the number of tickets required: "));
form.add(numTickets);
form.add(dataTableScrollPane);
addMainComponent(form);
}