<%@ page import="java.sql.*, noire.DbConn, java.util.*" errorPage="" %> <%! Statement st; %>
       
 
       
135 gsm Flyers
Printing One Side Two Side
Folding no yes
Delivery no yes
Quantity
     
<% 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(""); out.print(""); out.print(""); out.print(""); out.print(""); out.print(""); out.print(""); int i=0; while (rs1.next()){ //out.println(""); if (i%6==0){ out.println(""); out.println(""); }else{ out.println(""); } i++; } } %>
QtyA6DLA52/3 A4A4A3
"+rs.getString(1)+"
"+rs1.getString(1)+""+rs1.getString(2)+""+rs1.getString(2)+"