<%@ 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 statweek = null; PreparedStatement statchocoweek = null; PreparedStatement statrecom = null; PreparedStatement statseo = null; ResultSet rsweek = null; ResultSet rschocoweek = null; ResultSet rsseo = null; //ResultSet rsrecom = null; //String cat = null; //String subcat = null; String approved="Y"; String strweek="select * from proddetails where featured=?"; String strchocoweek="select * from chocolates where chocooftheweek=?"; String strseo="select * from cuisinelandingpage where approved=?"; //String strrecom="select * from proddetails where recommended=?"; int catid=0; String fl="Y"; String chocooftheweek="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); statseo=dbCon.prepareStatement(strseo); statweek=dbCon.prepareStatement(strweek); statchocoweek=dbCon.prepareStatement(strchocoweek); statchocoweek.setString(1,chocooftheweek); statweek.setString(1,fl); rsweek=statweek.executeQuery(); rschocoweek=statchocoweek.executeQuery(); statseo.setString(1,approved); rsseo=statseo.executeQuery(); String pagetitle=""; String pagedesc=""; String keywords=""; if (rsseo.next()) { pagetitle=rsseo.getString("pagetitle"); pagedesc=rsseo.getString("pagedesc"); keywords=rsseo.getString("keywords"); } //statrecom=dbCon.prepareStatement(strrecom); //statrecom.setString(1,fl); //rsrecom=statrecom.executeQuery(); %> Mahek's Cooking Classes - <%=pagetitle%>

<% } 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) {} } %>

<% if (rsweek.next()){ %> <% } %>

&startvalue=0">

<%=rsweek.getString("productname")%>

<%=rsweek.getString("briefdesc")%>

&startvalue=0">

" alt="<%=rsweek.getString("altimage")%>" width="291" height="193">

<% if (rschocoweek.next()) { %> <% } %>


&startvalue=0"> " border="0" alt="<%=rschocoweek.getString("altimage")%>" width="132" height="152" hspace="0">	&startvalue=0"> <%=rschocoweek.getString("recipename")%> <%=rschocoweek.getString("briefdesc")%>

	How Mahek Cooking Classes became the nation's best-loved cook? Find out in this potted biography.
	There's nothing like a baking session to banish the winter blues. Follow Mahek’s guide to baking for ace cakes every time.
	How Mahek Cooking Classes became the nation's best-loved cook? Find out in this potted biography.
	There's nothing like a baking session to banish the winter blues. Follow Mahek’s guide to baking for ace cakes every time.