<%@ 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 stat1 = null; PreparedStatement stat2 = null; ResultSet rs = null; ResultSet rscount = null; ResultSet rscat = null; String cat=null; String pagetitle=null,keywords=null,pagedesc=null; int catid=0; String appr = "Y"; String selectcat = "select * from category where cat = ?"; String selectstr= "select * from proddetails where approved = ? and catid = ?"; String countstr = "select count(*) as strcount from proddetails where approved = ? and catid = ?"; cat = request.getParameter("cat"); 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",""); //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); stat2 = dbCon.prepareStatement(selectcat); stat2.setString(1,cat); rscat = stat2.executeQuery(); if (rscat.next()) { catid=rscat.getInt("cid"); pagetitle=rscat.getString("pagetitle"); keywords=rscat.getString("keywords"); pagedesc=rscat.getString("pagedesc"); } stat = dbCon.prepareStatement(countstr); stat.setString(1,appr); stat.setInt(2,catid); stat1 = dbCon.prepareStatement(selectstr); stat1.setString(1,appr); stat1.setInt(2,catid); rscount = stat.executeQuery(); rs = stat1.executeQuery(); //rscat.next(); %> <%=pagetitle%>
" height="60">
<% String dsc = rscat.getString("catdesc"); int lndesc=dsc.length(); if (lndesc>=330){ //out.println(lndesc); dsc = dsc.substring(0, 330); out.println(dsc); } else { out.println(dsc); } %>
<% // for paging int noofelements = 6; int count = 0; int pageval = 0; int startval =0; if (rscount.next()) { count = rscount.getInt("strcount"); //out.println(""); } if ((count % noofelements) == 0 ) { pageval = count / noofelements; //out.println("page1" + (count % noofelements)); } else { pageval = (count / noofelements) + 1; //out.println("page2" + pageval); } //out.println(count); if (request.getParameter("startvalue") != null) startval = Integer.parseInt(request.getParameter("startvalue")); else startval=0; if (startval==0) { for (int i=1; i<=count; i++) { if( i >= startval && i <= startval + noofelements) { if(rs.next()) { // Display Data %> <% } } } } else { startval = startval * noofelements; //out.println("start" +startval); for (int j=1; j<=count; j++) { if(rs.next()) { if ( j > startval && j <= startval + noofelements) { //Display Data %> <% } } } } //out.println(""); //out.println(""); %>
" + count + "
" alt="<%=rs.getString("altthumb")%>" width="100" height="110">
<%=rs.getString("productname")%>
"> <%=rs.getString("briefdesc")%>

" width="100" height="110">
<%=rs.getString("productname")%>
"> <%=rs.getString("briefdesc")%>

Go To Page:
Page : <% for (int j=0; j <%=j+1%>   <% } %>
" width="211" height="434">
<% 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