<%
int dealerId = 1;
Connection con = null;
Statement st;
try{
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+db,userName,password);
String city=request.getParameter("city");
String query = "select * from manufacturers ";
if(city != null){
query=query+"where city='"+city+"'";
}
st = con.createStatement();
ResultSet rs = st.executeQuery(query);
System.out.println(query);
%>
| Compnay Name |
Address |
<% while(rs.next()){
dealerId = dealerId + 1;
%>
<%=rs.getString("company_name")%>
| <%=rs.getString("company_name")%> |
| Address : <%=rs.getString("address")%> <%=rs.getString("city")%> |
| Phone : <%=rs.getString("phone_no")%> |
|
<%=rs.getString("address")%> <%=rs.getString("city")%> |
<% }
}catch(Exception e){
e.printStackTrace();
}
%>
<%@include file="footer.jsp"%>
