|
|
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="javax.naming.NamingException"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="javax.sql.DataSource"%>
<%
Connection dbCon = null;
PreparedStatement statdetail = null;
PreparedStatement statcat = null;
ResultSet rsdetail = null;
ResultSet rscat = null;
String strdetail="select * from vendorproduct where id = ?";
String strcat="select * from catvendor where id = ?";
int id=0;
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);
statdetail=dbCon.prepareStatement(strdetail);
id=Integer.parseInt(request.getParameter("id"));
statdetail.setInt(1,id);
rsdetail=statdetail.executeQuery();
statcat=dbCon.prepareStatement(strcat);
if (rsdetail.next())
{
statcat.setInt(1,rsdetail.getInt("category"));
rscat=statcat.executeQuery();
%>
|
<%
}
%>
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| © 2001-2007 Mahek’s Cooking Classes. | Web design by livepages | |