");
}
%>
<%
// Connect to Database, verify password
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url, user, password);
PreparedStatement pstmt = conn.prepareStatement ("SELECT Distinct tblCalendar.ID,tblCalendar.EventName, tblCalendar.StartDate, tblCalendar.EventType FROM tblCalendar, ticket_categories WHERE tblCalendar.ID=ticket_categories.EventName and tblCalendar.StartDate>CURRENT_DATE and SiteID=? order by tblCalendar.StartDate");
String city="";
out.println ("
Want to sell tickets online to your events/movies? We make it easy. Click here
");
pstmt.setString (1, city = request.getParameter("city"));
ResultSet rs = pstmt.executeQuery();
int numRows = 0;
while (rs.next()) {
numRows++;
if (numRows == 1) {
// Print out table, etc.
out.println ("
");
out.println ("\t
Online Tickets
");
out.println ("\t
");
out.println ("\t\t
");
out.println ("Date");
out.println ("\t\t
");
out.println ("\t\t
");
out.println ("Event");
out.println ("\t\t
");
out.println ("\t\t
");
out.println ("Click To Buy");
out.println ("\t\t
");
out.println ("\t
");
}
int id = rs.getInt (1);
String eventName = rs.getString (2);
java.sql.Date eventDate = rs.getDate(3);
int eventType = rs.getInt(4);
java.text.DateFormat df = java.text.DateFormat.getDateInstance (java.text.DateFormat.MEDIUM);
String dateString = df.format (eventDate);
// Now, print out the stuff)
this.printTicketItem (out, id, eventName, dateString, city, eventType, numRows);
}
if (numRows>0) {
out.println ("
");
}
else
out.println ("
There are no tickets being sold online currently for this city.
