Ide til at skille ordre
Hej Eksperter,Jeg har noget kode som ser således ud. Det fungerer også fint :-) Tingen er at jeg gerne vil have sat en <tr> imellem ordrene. Jeg kan ikke helt gennemskue hvordan jeg gør det.
buffer.append("<table style=\"width:300px;\" cellspacing=\"0\" cellpadding=\"0\">\n");
buffer.append("<tr>\n");
buffer.append("<th style=\"width:50px;text-align:left;vertical-align:top;\" class=\"tableheader\">Ordre<br>nr.</th>\n");
buffer.append("<th style=\"width:100px;text-align:left;vertical-align:top;\" class=\"tableheader\">Vare</th>\n");
buffer.append("<th style=\"width:50px;text-align:left;vertical-align:top;\" class=\"tableheader\">Stk</th>\n");
buffer.append("<th style=\"width:100px;text-align:left;vertical-align:top;\" class=\"tableheader\">Pris</th>\n");
buffer.append("</tr>\n");
int i = 0;
int last = -1;
while (rs.next()) {
String kunde = rs.getString("kunde");
int ordreID = rs.getInt("ordre_id");
String vare = rs.getString("vare_navn");
int pris = rs.getInt("vare_pris");
int stk = rs.getInt("stk");
if (i==0)
{
buffer.append("<h3>"+kunde+"</h3><br>\n");
i++;
}
buffer.append("<tr>\n");
if (ordreID != last)
{
buffer.append("<td class=\"tablecell1\">"+ordreID+"</td>\n");
last = ordreID;
}
else
{
buffer.append("<td class=\"tablecell1\"></td>\n");
}
buffer.append("<td class=\"tablecell1\">"+vare+"</td>\n");
buffer.append("<td class=\"tablecell1\">"+stk+"</td>\n");
buffer.append("<td class=\"tablecell1\">"+pris*stk+"</td>\n");
buffer.append("</tr>\n");
// buffer.append("<tr height=\"10px;\"><td colspan=\"4\"></td></tr>");
}
buffer.append("</table>\n");
