|
|
<%@ 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 classcategory where cid = ?";
String selectstr= "select * from cookingclass where catid = ?";
String countstr = "select count(*) as strcount from cookingclass 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")%>
|
|
|
<%
int noofelements = 5;
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(" |