%@ 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("" + count + " ");
}
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(" Go To Page: ");
%>
Page :
<%
for (int j=0; j
<%
}
%>
" 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