<%@ page import="javax.servlet.*" %> <%@ page import="javax.servlet.http.*" %> <%@ page import="java.sql.*" %> <%@ page import="javax.naming.NamingException"%> <%@ page import="javax.naming.InitialContext"%> <%@ page import="javax.sql.DataSource"%> <% Connection dbCon = null; PreparedStatement stat = null; PreparedStatement statcat = null; PreparedStatement statsubcat = null; ResultSet rs = null; ResultSet rscat = null; ResultSet rssubcat = null; String selectstr = "select * from chocolates where cid =?"; String strcat = "select * from chocolatescategory where cid =?"; //String strsubcat = "select * from subcategory where cid =?"; String cat = null; String productname = null; int prodid = 0; int cid=0; int subcid=0; prodid = Integer.parseInt(request.getParameter("pid")); 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"); Class.forName("com.mysql.jdbc.Driver").newInstance(); // dbCon = DriverManager.getConnection("jdbc:mysql://localhost:3306/myrecipe","root",""); // dbCon = DriverManager.getConnection("jdbc:mysql://localhost:3306/maheks_mahek","maheks","mahak"); // dbCon = DriverManager.getConnection("jdbc:mysql://localhost:3309/maheks_mahek","root",""); ServletContext ctx = getServletContext(); String url=ctx.getInitParameter("url"); String user=ctx.getInitParameter("user"); String pw=ctx.getInitParameter("password"); dbCon = DriverManager.getConnection(url,user,pw); // dbCon = dataSource.getConnection(); stat = dbCon.prepareStatement(selectstr); stat.setInt(1,prodid); statcat = dbCon.prepareStatement(strcat); //statsubcat = dbCon.prepareStatement(strsubcat); rs = stat.executeQuery(); int startvalue = Integer.parseInt(request.getParameter("startvalue")); %> <% if(rs.next()) { cid=rs.getInt("catid"); //subcid=rs.getInt("subcatid"); //out.print(subcid); statcat.setInt(1,cid); rscat=statcat.executeQuery(); //statsubcat.setInt(1,subcid); //rssubcat=statsubcat.executeQuery(); rscat.next(); //rssubcat.next(); %> <%=rs.getString("seotitle")%> "> ">

<%=rs.getString("recipename")%>

" alt="<%=rs.getString("altimage")%>" width="199">

	">Back to Recipe Result
	Back to Recipe Page
	Printable Recipe
	Email Recipe to a Friend

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

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

Recipe Category : <%= rscat.getString("cat")%>

Food Type : <% if(rs.getString("isveg").equals("yes")){ out.println("Veg"); %> <% } else { out.println("Non veg"); } %>

Time Required : <%=rs.getString("cookingtime")%>

Ingredients Used :
<%=rs.getString("ingredients") %>

Procedure :
<%=rs.getString("preparation") %>

<% } rs.close(); stat.close(); } 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) {} } %>


© 2001-2007 Mahek’s Cooking Classes. \| Web design by livepages