<%
st=db.getSt();
String q1="select qty,price from postertwo";
ResultSet rs1=st.executeQuery(q1);
out.print("| Qty | ");
out.print("A3 | ");
out.print("A4 | ");
int i=0;
while (rs1.next()){
//out.println(""+rs.getString(1)+" | ");
if (i%2==0){
out.println("| "+rs1.getString(1)+" | ");
out.println(""+rs1.getString(2)+" | ");
}else{
out.println(""+rs1.getString(2)+" | "); }
i++;
}
%>
|
|
