|
|
<%@ 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 statprod = null;
PreparedStatement statfeature = null;
PreparedStatement stat1 = null;
ResultSet rsprod = null;
ResultSet rsfeature = null;
String strprod="select * from vendorproduct where approve=? and featureclass=?";
String strclass="select * from cookingclass where feature=?";
String strbook="select * from vendorproduct where category=? and featurebook=?";
String featureclass = "yes";
String featurebook = "yes";
int catid=0;
int bookcat=4;
String subcat = null;
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");
//dbCon = dataSource.getConnection();
Class.forName("com.mysql.jdbc.Driver").newInstance();
//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);
//dbCon = DriverManager.getConnection("jdbc:mysql://localhost:3306/myrecipe","root","");
statprod = dbCon.prepareStatement(strprod);
statprod.setString(1,featureclass);
statprod.setString(2,featureclass);
rsprod=statprod.executeQuery();
statfeature=dbCon.prepareStatement(strclass);
statfeature.setString(1,featureclass);
rsfeature=statfeature.executeQuery();
%>
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
