|
|
<%@ 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;
int catid = 0;
String selectcat = "select * from chocolatescategory where cid = ?";
String selectstr= "select * from chocolates where catid = ?";
String countstr = "select count(*) as strcount from chocolates where catid = ?";
catid = Integer.parseInt(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");
ServletContext ctx = getServletContext();
String url=ctx.getInitParameter("url");
String user=ctx.getInitParameter("user");
String pw=ctx.getInitParameter("password");
dbCon = DriverManager.getConnection(url,user,pw);
stat = dbCon.prepareStatement(countstr);
stat.setInt(1,catid);
stat1 = dbCon.prepareStatement(selectstr);
stat1.setInt(1,catid);
rscount = stat.executeQuery();
rs = stat1.executeQuery();
stat2 = dbCon.prepareStatement(selectcat);
stat2.setInt(1,catid);
rscat = stat2.executeQuery();
rscat.next();
%>
|
|
<%=rscat.getString("catdesc")%>
|
|
<%
// for paging
int noofelements = 3;
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">
|