<%@ page import="java.sql.*" %> <%@ page import="java.util.*" %> <%@ page import="java.text.*" %> <% int intuid=0; //String insertstr ="INSERT INTO recipelandingpage (id,title,desc1,img,approved) values(?,?,?,?,?)"; Connection dbCon = null; PreparedStatement stat = null; //PreparedStatement statcat = null; PreparedStatement statcount = null; ResultSet rs = null; ResultSet rssearch = null; ResultSet rscount = null; String selectstr = "Select * from vendorproduct where category=? and approve=?"; //String strsearch = "select * from vendorproduct where approve=? "; String strcount ="select count(*) as strcount from vendorproduct where category=? and approve=?"; String strsearch1=null; String title = null; String desc = null; String appr = "yes"; //String middletext= null; //String endtext = null; //String tiptext = null; //String approved = null; try { //out.println("Approved :" + approved); //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"); //dbCon = DriverManager.getConnection("jdbc:mysql://localhost:3306/myrecipe","root",""); ServletContext ctx = getServletContext(); String url=ctx.getInitParameter("url"); String user=ctx.getInitParameter("user"); String pw=ctx.getInitParameter("password"); String[] catarr={}; String[] occarr={}; String[] venarr={}; dbCon = DriverManager.getConnection(url,user,pw); int catid = Integer.parseInt(request.getParameter("cat")); //out.print(catid); stat=dbCon.prepareStatement(selectstr); statcount=dbCon.prepareStatement(strcount); stat.setInt(1,catid); stat.setString(2,appr); rssearch=stat.executeQuery(); statcount.setInt(1,catid); statcount.setString(2,appr); rscount=statcount.executeQuery(); //out.print("From "+request.getParameter("pricefrom")); //out.print(itemid); %> Mahek's Cooking Classes
 
 
Shopping » Browse  
<% int pagebreak=0; int noofelements = 4; int count = 0; int pageval = 0; int startval =0; int startval1 =0; int pageend =0; int startindx=0; int endindx=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 : "+count); if (request.getParameter("startvalue") != null) startval = Integer.parseInt(request.getParameter("startvalue")); else startval=0; startval1=startval; %>
" + count + "
<% if (count!=0) { %> <% } else { %> <% //out.print("No records found"); } // for paging %> <% // for paging %>
navigate   <% pageend=pageval-1; startindx = startval1 - 2; endindx = startval1 + 2; //out.print(startindx+1); //out.print(endindx+1); if(startval1!= 0) { %> «   <% } else { %>   <% } for (int j=0; j= startindx && j <= endindx) { //out.print(startval1); if (j==startval1) { %> <%=(j+1)%>   <% } else { %> <%=(j+1)%>   <% } } } if(startval1!= pageend) { %> » <% } else { %> <% } %>
No Records Found
 
 
 
<% if (startval==0) { for (int i=1; i<=count; i++) { if( i >= startval && i <= startval + noofelements) { // Display Data if(rssearch.next()) { pagebreak=pagebreak+1; %> <% if (pagebreak % 2!=0) { %> <% if (rssearch.isLast()) { %> <% } %> <% } %> <% if (pagebreak % 2==0) { %> <% } } } } } else { startval = startval * noofelements; //out.println("start" +startval); for (int j=1; j<=count; j++) { if(rssearch.next()) { if ( j > startval && j <= startval + noofelements) { pagebreak=pagebreak+1; //Display Data %> <% if (pagebreak % 2!=0) { %> <% if (rssearch.isLast()) { %> <% } %> <% } %> <% if (pagebreak % 2==0) { %> <% } } } } } //out.println(""); //out.println(""); %>
Anniversary
<%=rssearch.getString("prodtitle")%>
','PasswordRetrievalPage','width=300,height=450,top=200,left=0');">" border="0" width="80">
<% String desc1 = rssearch.getString("description"); int lendesc=desc1.length(); if (lendesc>100) { desc1=desc1.substring(1,100); } out.print(desc1+"..."); %>
Our Price
Rs.<%=rssearch.getString("costprice")%> 		 
&add=1" > &startvalue=0">
click thumbnail for large view
 
 
  
 
<%=rssearch.getString("prodtitle")%>
','PasswordRetrievalPage','width=300,height=450,top=200,left=0');">" border="0" width="80">
<% String desc1 = rssearch.getString("description"); int lendesc=desc1.length(); if (lendesc>100) { desc1=desc1.substring(1,100); } out.print(desc1+"..."); %>
Our Price
Rs.<%=rssearch.getString("costprice")%> 		 
&add=1" > &startvalue=0">
click thumbnail for large view
 
 
  
 
Go To Page:
 
 
 
 
 
<% if (count!=0) { %> <% } else { %> <% //out.print("No records found"); } // for paging %> <% // for paging %>
navigate   <% pageend=pageval-1; startindx = startval1 - 2; endindx = startval1 + 2; //out.print(startindx+1); //out.print(endindx+1); if(startval1!= 0) { %> «   <% } else { %>   <% } for (int j=0; j= startindx && j <= endindx) { //out.print(startval1); if (j==startval1) { %> <%=(j+1)%>   <% } else { %> <%=(j+1)%>   <% } } } if(startval1!= pageend) { %> » <% } else { %> <% } %>
 
Send gift items to India . All major credit cards accepted.
Free shipping all over india, normally
 
 
 
© 2001-2007 Mahek’s Cooking Classes. | Web design by livepages  
<% } catch (java.sql.SQLException e2) { out.println(e2.toString()); } catch (java.lang.NumberFormatException e3) { out.println(e3.toString()); e3.printStackTrace(new java.io.PrintWriter(out)); } 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) {} } %>