| 135 gsm Flyers |
 |
<%
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 flyers where side='"+rb1v+"' and folding='"+rb2v+"' and del='"+rb3v+"'";
}else{
q1="select qty, price from flyers where qty='"+qty+"' and side='"+rb1v+"' and folding='"+rb2v+"' and del='"+rb3v+"'";
}
ResultSet rs1=st.executeQuery(q1);
out.print("| Qty | ");
out.print("A6 | ");
out.print("DL | ");
out.print("A5 | ");
out.print("2/3 A4 | ");
out.print("A4 | ");
out.print("A3 | ");
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++;
}
}
%>
|
|
