| flyers350 |
 |
<%
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 flyers350 where ptype='"+rb1v+"' and del='"+rb2v+"'";
}else{
q1="select qty, price from flyers350 where qty='"+qty+"' and ptype='"+rb1v+"' and del='"+rb2v+"'";
}
ResultSet rs1=st.executeQuery(q1);
out.print("| Qty | ");
out.print("BC | ");
out.print("A7 | ");
out.print("105X105 | ");
out.print("A6 | ");
out.print("125X125 | ");
out.print("DL | ");
out.print("148X148 | ");
out.print("A5 | ");
out.print("2/3 A4 | ");
out.print("A4 | ");
int i=0;
while (rs1.next()){
//out.println(""+rs.getString(1)+" | ");
if (i%10==0){
out.println("| "+rs1.getString(1)+" | ");
out.println(""+rs1.getString(2)+" | ");
}else{
out.println(""+rs1.getString(2)+" | "); }
i++;
}
}
%>
|
|
