<%@ page import="java.sql.*, noire.DbConn" errorPage="" %>

Letter Heading Select Letter Heading:   Select L/Heading All <% Statement st=db.getSt(); String q="select qty from lheading"; ResultSet rs=st.executeQuery(q); while (rs.next()){ out.print(""+rs.getString(1)+""); } %> <% String q1; String qty=request.getParameter("qty"); if (qty!=null){ if (qty.equals("all")){ q1="select qty, price from lheading"; }else{ q1="select qty, price from lheading where qty='"+qty+"'"; } ResultSet rs1=st.executeQuery(q1); out.print(""); while (rs1.next()){ out.print(""); }} %> Qty Price "+rs1.getString(1)+" "+rs1.getString(2)+"