public static ArrayList<Ticket> showAll() {
            ArrayList<Ticket> tickets = new ArrayList<Ticket>();
            Database db = dbconnect();
	try {
		db.prepare("SELECT * FROM ticket ORDER BY TID");
		ResultSet rs = db.executeQuery();         
		while(rs.next()) {
                   tickets.add(TicketObject(rs));
		}
	           db.close();      

        } catch (SQLException e) {
           Error_Frame.Error(e.toString()); 
        } 
                return tickets;
	}