<%@page import="java.util.*"%> <%@page import="java.sql.*"%> <% ResourceBundle rb = ResourceBundle.getBundle("properties/vendorDB"); Connection con = null; Statement st = null; ResultSet rs = null; Class.forName("com.mysql.jdbc.Driver").newInstance(); con = DriverManager.getConnection(rb.getString("databaseName"), rb.getString("databaseUser"), rb.getString("databasePass")); st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); String monthQuery = "SELECT monthName FROM month ORDER BY monthNum";//rb.getString("monthQuery"); String roomQuery = "SELECT room, building FROM conferenceRooms";//rb.getString("roomQuery"); %>
Submit your request for a quote to Lilli Festivale & Co.
First, tell us a little about yourself:
First Name:
Last Name:
Email:
Tell us a little about your event:
<% rs = st.executeQuery(monthQuery);%>
Event Date:
Month
<% String value = "none"; while (rs.next()) { value = rs.getString(1); %>
<%=value%>
<% } // end while %>
Day
<% int day = 1; while (day <= 31 ) { %>
<%=day%>
<% day++; } // end while %>
Year
<% int year = 2005; while (year <= 2010 ) { %>
<%=year%>
<% year++; } // end while %>
<% rs.close(); rs = st.executeQuery(roomQuery); %>
Event Location:
<%=eventLocation%>
---------------
<% while (rs.next()) { value = rs.getString(1); %>
<%=value%>
<% } // end while %>
<% rs.close(); %> <% con.close(); %>
Event Title:
Setup Complete Time:
Please Select One
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
113:00
113:30
Breakdown Start Time:
Please Select One
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
113:00
113:30
Can you provide a brief description of your event, so that we can better determine your floral needs?
Now for the flowers (the best part!). Please choose what you'd like:
Classic Vase Arrangement
Quant:
Size:
Please Select One
Small
Medium
Large
Type of Flowers:
Centerpiece
Quant:
Size:
Please Select One
Small
Medium
Large
Type of Flowers:
Rose Bundle
Quant:
Size:
Please Select One
Small
Medium
Large
Type of Flowers:
Ooh La La! - Eye Catcher Arrangement
Quant:
Size :
Please Select One
Small
Medium
Large
Type of Flowers:
Anything else you'd like to add?