<%@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.
<% rs = st.executeQuery(monthQuery);%> <% rs.close(); rs = st.executeQuery(roomQuery); %> <% rs.close(); %> <% con.close(); %>
First, tell us a little about yourself: 
First Name: Last Name:
Email:  
  
Tell us a little about your event: 
Event Date: Event Location:
Event Title:  
Setup Complete Time: Breakdown Start Time:
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:
Type of Flowers:
 
Centerpiece
Quant:
Size:
Type of Flowers:
Rose Bundle
Quant:
Size:
Type of Flowers:
 
Ooh La La! - Eye Catcher Arrangement
Quant:
Size :
Type of Flowers:
Anything else you'd like to add?