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

Bus Card Select Quantity: Select Qty All <% Statement st=db.getSt(); String q="select qty from buscard"; 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 buscard"; }else{ q1="select qty, price from buscard where qty='"+qty+"'"; } ResultSet rs1=st.executeQuery(q1); out.print(""); while (rs1.next()){ out.print(""); }} %> Qty Price "+rs1.getString(1)+" "+rs1.getString(2)+"