<%@ page import="javax.servlet.*" %> <%@ page import="javax.servlet.http.*" %> <%@ page import="java.sql.*" %> <%@ page import="java.util.*" %> <%@ page import="javax.naming.NamingException"%> <%@ page import="javax.naming.InitialContext"%> <%@ page import="javax.sql.DataSource"%> <% Connection dbCon = null; PreparedStatement statchoco = null; PreparedStatement statcakes = null; PreparedStatement statprodchoco = null; PreparedStatement statprodcake = null; ResultSet rschoco = null; ResultSet rscakes= null; ResultSet rsprodchoco = null; ResultSet rsprodcake = null; String cat = null; //String subcat = null; String strcakes="select * from chocolates where featuredcake=?"; String strchoco="select * from chocolates where featuredchoco=?"; String strprodchoco="select * from vendorproduct where approve=? and featurechoco=?"; String strprodcake="select * from vendorproduct where approve=? and featurecake=?"; int catid=0; String fl="yes"; String feature="yes"; try { //javax.naming.Context initialContext = new javax.naming.InitialContext(); //javax.naming.Context envContext = (javax.naming.Context) initialContext.lookup("java:/comp/env"); //javax.sql.DataSource dataSource = (javax.sql.DataSource) envContext.lookup("jdbc/mssql"); //dbCon = dataSource.getConnection(); Class.forName("com.mysql.jdbc.Driver").newInstance(); //dbCon = DriverManager.getConnection("jdbc:mysql://localhost:3306/maheks_mahek","maheks","mahak"); ServletContext ctx = getServletContext(); String url=ctx.getInitParameter("url"); String user=ctx.getInitParameter("user"); String pw=ctx.getInitParameter("password"); dbCon = DriverManager.getConnection(url,user,pw); statchoco=dbCon.prepareStatement(strchoco); statchoco.setString(1,fl); rschoco=statchoco.executeQuery(); statcakes=dbCon.prepareStatement(strcakes); statcakes.setString(1,fl); rscakes=statcakes.executeQuery(); statprodchoco=dbCon.prepareStatement(strprodchoco); statprodchoco.setString(1,feature); statprodchoco.setString(2,feature); rsprodchoco=statprodchoco.executeQuery(); statprodcake=dbCon.prepareStatement(strprodcake); statprodcake.setString(1,feature); statprodcake.setString(2,feature); rsprodcake=statprodcake.executeQuery(); %>
 

A recipe is a set of instructions that show how to prepare or make something, especially a culinary dish

  • The name of the dish.
  • How much time it will take to prepare the dish .
  • The required ingredients along with their quantities or proportions.
 
 
Featured Cake recipe
<% if (rscakes.next()) { %>
     
&startvalue=0" >" border="0" width="80">
  &startvalue=0" class="browntextlink"> <%=rscakes.getString("recipename")%>
  Submitted by
Sweet To You
     
<% } %>
Send cakes to india
<% if (rsprodcake.next()) { %>
     
&startvalue=0">" border="0" width="80" >
  &startvalue=0" class="browntextlink"> <%=rsprodcake.getString("prodtitle")%>
 
Our price : Rs.   <%=rsprodcake.getString("costprice")%>
   
<% } %>
 
 
All kinds of cakes
Birthdays, parties, weddings or just about anything.Cakes for all occasions can be found here.
 
Cakes for vegetarians
Compliment your cakes with vegetarian substitutions .You can find special fruit cake recipes here...
 
Tips & workarounds
Urgent occasions, decorations, the perfect temperature all these go into making the perfect cake.Go through our time saving tips and helpful notes.
 
Chocolate recipes
Find recipes for making many types of chocolates at home.You can gift your creations to dear ones.
 
Featured Chocolate recipe
<% if (rschoco.next()) { %>
     
&startvalue=0">" width="80">
  &startvalue=0" class="browntextlink"> <%=rschoco.getString("recipename")%>
  Submitted by
Sweets To You
     
<% } %>
Send Chocolates to india
<% if (rsprodchoco.next()) { %>
     
&startvalue=0">" border="0" width="80" >
  &startvalue=0" class="chocobrowntextlink"> <%=rsprodchoco.getString("prodtitle")%>
 
Our price : Rs.   <%=rsprodchoco.getString("costprice")%>
   
<% } %>
 
 
© 2001-2007 Mahek’s Cooking Classes. | Web design by livepages  
<% } catch (java.sql.SQLException e2) { out.println(e2.toString()); } catch (Exception e) { out.println("

ERROR!

"); out.println("Error = " + e.getMessage() + "
");
				e.printStackTrace(new java.io.PrintWriter(out));
				out.println("
"); return; } finally { try { if(dbCon != null) dbCon.close(); } catch(SQLException sqle) {} } %>