<%
String q1;
String qty=request.getParameter("qty");
String rb1v=request.getParameter("rb1v");
String rb2v=request.getParameter("rb2v");
String rb3v=request.getParameter("rb3v");
if (qty!=null){
if (qty.equals("all")){
q1="select qty, price from brochures where size='"+rb1v+"' and del='"+rb2v+"'";
}else{
q1="select qty, price from brochures where qty='"+qty+"' and size='"+rb1v+"' and del='"+rb2v+"'";
}
ResultSet rs1=st.executeQuery(q1);
out.print("| Qty | ");
out.print("4pp | ");
out.print("8pp | ");
out.print("12pp | ");
out.print("16pp | ");
out.print("20pp | ");
out.print("24pp | ");
out.print("28pp | ");
out.print("32pp | ");
int i=0;
while (rs1.next()){
//out.println(""+rs.getString(1)+" | ");
if (i%6==0){
out.println("| "+rs1.getString(1)+" | ");
out.println(""+rs1.getString(2)+" | ");
}else{
out.println(""+rs1.getString(2)+" | "); }
i++;
}
}
%>
|
|
