<% Connection con = null; String url = "jdbc:mysql://localhost:3306/"; Statement st; try{ Class.forName(driver).newInstance(); con = DriverManager.getConnection(url+db,userName,password); String city=request.getParameter("city"); String query = "select * from suppliers "; if(city != null){ query=query+"where city='"+city+"'"; } st = con.createStatement(); ResultSet rs = st.executeQuery(query); System.out.println(query); %> <% while(rs.next()){ %> <% } }catch(Exception e){ e.printStackTrace(); } %>

Compnay Name	Address
<%=rs.getString("company_name")%>	<%=rs.getString("address")%>

Major V-belt Raw materials