 |
Nearby Properties
<%
int cont = 0;
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "(SELECT p.property_id, p.bedrooms, p.bathrooms, r.nigth FROM property p, rates r WHERE rate_id = 0 AND p.property_id = r.property_id AND city_id = ?) UNION ( SELECT p.property_id, p.bedrooms, p.bathrooms, 0.0 AS nigth FROM property p, rates r WHERE p.property_id NOT IN ( SELECT property_id FROM rates WHERE rate_id =0 ) AND city_id = ?) ";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setInt(1,city_id);
Ps.setInt(2,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long p_id = Rs.getLong("property_id");
int beds2 = Rs.getInt("bedrooms");
int baths2 = Rs.getInt("bathrooms");
double night2 = Rs.getDouble("nigth");
cont++;
%>
| <%=beds2%>BR / <%=baths2%>BA / $<%=night2%>0 std. |
<%
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
|
|
|
|
|
|
Property #<%=property_id%>
<%=address%>
<%=city_name%>
<%=country_name2%>
Property Description: <%=desc_p%>
Bedrooms: <%=beds%>
Bathrooms: <%=baths%>
Square Ft.: <%=sqft%>
<%
double night1 = 0;
double weekly1 = 0;
double monthly1 = 0;
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT nigth, weekly, monthly FROM rates WHERE property_id= ? AND rate_id = 0";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
if(Rs.next()) {
night1 = Rs.getDouble("nigth");
weekly1 = Rs.getDouble("weekly");
monthly1 = Rs. getDouble("monthly");
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Standard rates:
Night: $<%=night1%>0
Weekly: $<%=weekly1%>0
Mothly: $<%=monthly1%>0
Property type:
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT apartment, bungalow, cabin, castle, chalet, condominium, cottage, duplex, farmhouse, flat, hacienda, home_house, houseboat, lodge, ranch, timeshare, townhouse, vacation_home, villa, other FROM property_type WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
boolean comma = false;
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 20; i++) {
if(Rs.getBoolean(i)) {
if(comma) out.print(", ");
out.print(md.getColumnName(i).replaceAll("_", " "));
comma = true;
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Location:
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT beach, beachfront, city, lake, lakefront, loft, log, mountain, oceanfront, penthouse, private, resort, ski_in_out, studio, vacation, waterfront, other FROM location WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
boolean comma = false;
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 17; i++) {
if(Rs.getBoolean(i)) {
if(comma) out.print(", ");
out.print(md.getColumnName(i).replaceAll("_", " "));
comma = true;
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
View:
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT mountain_view, beachfront, ocean_view, oceanfront, beach_view, waterfront, lakefront, water_view, ski_in, golf_course_view, golf_course_front, ski_out, lake_view, other FROM view WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
boolean comma = false;
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 14; i++) {
if(Rs.getBoolean(i)) {
if(comma) out.print(", ");
out.print(md.getColumnName(i).replaceAll("_", " "));
comma = true;
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Suitability:
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT handicapped_accessible, kid_friendly, minimum_age_limit_for_renters, no_pets_allowed, not_suitable_for_children, pet_friendly, pet_friendly_extra_charge, pet_friendly_with_prior_approval, senior_adults_only_community, smoking_allowed, smoking_not_allowed, wheelchair_accessible, other FROM suitability WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
boolean comma = false;
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 13; i++) {
if(Rs.getBoolean(i)) {
if(comma) out.print(", ");
out.print(md.getColumnName(i).replaceAll("_", " "));
comma = true;
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
|
|
Availability
| Rate |
From |
To |
Night |
Weekly |
Monthly |
<%
try {
java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("MM/dd/yyyy");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT rate_name, date_in, date_out, nigth, weekly, monthly FROM rates WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
Date din = Rs.getDate("date_in");
Date dout = Rs.getDate("date_out");
double night = Rs.getDouble("nigth");
double weekly = Rs.getDouble("weekly");
double monthly = Rs.getDouble("monthly");
String rate_name = Rs.getString("rate_name");
if(rate_name == null) rate_name = "";
%>
| <%=rate_name%> |
<%out.print(sdf.format(din));%> |
<%out.print(sdf.format(dout));%> |
$ <%=night%>0 |
$ <%=weekly%>0 |
$ <%=monthly%>0 |
<%
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
| |
|
|
|
|
|
 A new availabilty calendar will be available shortly.
Contact
| Contact name: |
<%=contact_first_name%> <%=contact_last_name%> |
| Company: |
<%=company%> |
| Phone: |
<%=phone%> |
| E-mail address: |
<%=email%> |
| Website: |
<%=website%> |
Local Activites
Location Description: <%=desc_l%>
Adventure
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT 4_wheel_drive_tours, helicopter_rides, hot_air_ballooning, kayaking, mine_tours, parasailing, rafting, rock_climbing, sea_kayaking, snowmobiling, spelunking, theme_amusement_park, water_park, whitewater_rafting, other FROM act_adventure WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 15; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Cultural
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT antiquing, art_galleries, carriage_rides, cinemas_movie_theaters, health_beauty_spa, historic_walking_tours, museums, music_festivals, nightlife, performing_arts_theater, pottery_studios, restaurants, shopping, vintage_train_rides, other FROM act_cultural WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 15; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Outdoor
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT beach, bird_watching, canoeing, deep_sea_fishing, dog_sledding, fishing, hiking, horseback_riding, horseshoes, hunting, jet_skiing, miniature_golf, sailing, scuba_diving, shelling, shuffleboard, sightseeing, sledding_tubing, snorkeling, snowshoeing, tubing, waterfalls, whale_watching, wildlife_viewing, zoo_wildlife_park, other FROM act_outdoor WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 26; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Sports
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT basketball, biking, boating, cross_country_skiing, downhill_alpine_skiing, fitness_center_gym, frisbee_golf, golf, ice_skating, in_line_skating, racquetball, snowboarding, surfing, swimming, tennis, volleyball, waterskiing, windsurfing, other FROM act_sports WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 19; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Amenities
Outdoor
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT balcony, beach_chairs, beach_gear, boat_dock, canoes, charcoal_bbq_grill, deck_patio, decks, dock, garden, gas_electric_bbq_grill, gazebo, hammock, heated_swimming_pool, hot_tub_spa, lanai, outdoor_shower, patio_furniture, picnic_table, private_hot_tub, private_pool, private_beach, beach, putting_green, screened_porch, shared_hot_tub, shared_pool, swimming_pool, table_and_chairs, tennis_court, umbrellas, other FROM outdoor WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 32; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Services
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT catering_available, clubhouse, daily_maid_service, fitness_center, front_desk_check_in, gas, golf_cart, laundry, maid_service, other FROM services WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 10; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Parking
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT covered_parking, garage, heated_garage, off_street_parking, parking_for_rv_boat_trailer, other FROM parking WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 6; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Entertainment
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT air_hockey, books, exercise_room, foosball, foosball, piano, ping_pong_table_tennis, pool_table, sauna, other FROM entertainment WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 10; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Appliances
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT blender, can_opener, coffee_maker, dishwasher, garbage_disposal, hair_dryer, humidifiers, ice_maker, iron, juicer, microwave, refrigerator, stove, toaster, other FROM appliances WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 15; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Utensils
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT baking_pans, cooking_utensils_provided, crockpot, cutlery, dishes, glasses, other FROM utensils WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 7; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Kitchen Type
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT full_kitchen, no_kitchen, shared_kitchen, other FROM kitchen_type WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 4; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Electronics
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT cable_satellite_tv, cd_player, dvd, music_library, stereo_system, tv, vcr, video_game_console, video_games, video_library, x_box, other FROM electronics WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 12; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Indoor
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT air_conditioning, cooler, high_chair, hot_tub_spa, jetted_tub_in_bath, pool, sauna, wet_bar, whirlpool_tub, wood_burning_fireplace, wood_burning_stove, other FROM indoor WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 12; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Interior
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT alarm_clock, ceiling_fans, elevator, fan, fireplace, other FROM interior WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 6; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Linens and Towels
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT all_linens_and_towels_provided, beach_towels, linens_and_towels_provided, linens_provided, towels, other FROM linens_towels WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 6; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Communicatios
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT adsl, answering_machine, broadband_internet, cell_phone, computer, computer_dial_up_internet, dial_up_internet, free_local_calls, free_long_distance, local_phone, telephone, voice_mail, wireless_internet, other FROM communications WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 13; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Security
<%
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT 24_hour_security, gated_community, gated_house, other FROM security WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
ResultSetMetaData md = Rs.getMetaData();
for(int i=1; i < 4; i++) {
if(Rs.getBoolean(i)) {
%>
| <%=md.getColumnName(i).replaceAll("_", " ")%> |
<%
}
}
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
Beds
<%
try {
java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("MM/dd/yyyy");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT * FROM beds WHERE property_id = ?";
PreparedStatement Ps = con.prepareStatement(query);
Ps.setLong(1,property_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
int king_bed_num = Rs.getInt("king_bed_num");
int king_bed_sleeps = Rs.getInt("king_bed_sleeps");
int queen_bed_num = Rs.getInt("queen_bed_num");
int queen_bed_sleeps = Rs.getInt("queen_bed_sleeps");
int double_bed_num = Rs.getInt("double_bed_num");
int double_bed_sleeps = Rs.getInt("double_bed_sleeps");
int twin_single_bed_num = Rs.getInt("twin_single_bed_num");
int twin_single_bed_sleeps = Rs.getInt("twin_single_bed_sleeps");
int convertible_bed_num = Rs.getInt("convertible_bed_num");
int convertible_bed_sleeps = Rs.getInt("convertible_bed_sleeps");
int bunk_bed_num = Rs.getInt("bunk_bed_num");
int bunk_bed_sleeps = Rs.getInt("bunk_bed_sleeps");
int child_bed_num = Rs.getInt("child_bed_num");
int child_bed_sleeps = Rs.getInt("child_bed_sleeps");
int crib_num = Rs.getInt("crib_num");
int crib_sleeps = Rs.getInt("crib_sleeps");
%>
|
<%if(king_bed_num>0) {%>King bed | <%}%>
<%if(queen_bed_num>0) {%>Queen bed | <%}%>
<%if(double_bed_num>0) {%>Double bed | <%}%>
<%if(twin_single_bed_num>0) {%>Twin single | <%}%>
<%if(convertible_bed_num>0) {%>Convertible | <%}%>
<%if(bunk_bed_num>0) {%>Bunk bed | <%}%>
<%if(child_bed_num>0) {%>Child bed | <%}%>
<%if(crib_num>0) {%>Crib | <%}%>
| Number |
<%if(king_bed_num>0) {%><%=king_bed_num%> | <%}%>
<%if(queen_bed_num>0) {%><%=queen_bed_num%> | <%}%>
<%if(double_bed_num>0) {%><%=double_bed_num%> | <%}%>
<%if(twin_single_bed_num>0) {%><%=twin_single_bed_num%> | <%}%>
<%if(convertible_bed_num>0) {%><%=convertible_bed_num%> | <%}%>
<%if(bunk_bed_num>0) {%><%=bunk_bed_num%> | <%}%>
<%if(child_bed_num>0) {%><%=child_bed_num%> | <%}%>
<%if(crib_num>0) {%><%=crib_num%> | <%}%>
| Sleeps |
<%if(king_bed_num>0) {%><%=king_bed_sleeps%> | <%}%>
<%if(queen_bed_num>0) {%><%=queen_bed_sleeps%> | <%}%>
<%if(double_bed_num>0) {%><%=double_bed_sleeps%> | <%}%>
<%if(twin_single_bed_num>0) {%><%=twin_single_bed_sleeps%> | <%}%>
<%if(convertible_bed_num>0) {%><%=convertible_bed_sleeps%> | <%}%>
<%if(bunk_bed_num>0) {%><%=bunk_bed_sleeps%> | <%}%>
<%if(child_bed_num>0) {%><%=child_bed_sleeps%> | <%}%>
<%if(crib_num>0) {%><%=crib_sleeps%> | <%}%>
| |
<%if(king_bed_num>0) {%> | <%}%>
<%if(queen_bed_num>0) {%> | <%}%>
<%if(double_bed_num>0) {%> | <%}%>
<%if(twin_single_bed_num>0) {%> | <%}%>
<%if(convertible_bed_num>0) {%> | <%}%>
<%if(bunk_bed_num>0) {%> | <%}%>
<%if(child_bed_num>0) {%> | <%}%>
<%if(crib_num>0) {%> | <%}%>
<%
}
con.close();
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
%>
|
|
FRBO.com - A ForLeaseByOwner.com, LLC website
|
|
