| 782,8 → 782,37 |
| // } |
| rs.close(); |
| stringBuilder.append("</table>"); |
| stringBuilder.append("<hr><b>Total VMs found: ").append(count); |
| stringBuilder.append("<b>Total VMs found: ").append(count); |
| stringBuilder.append("</b></div>"); |
| stringBuilder.append("<br><b>List of registered OVFs:</b><br>"); |
| |
| stringBuilder.append("<div style='background:white;'>"); |
| stringBuilder.append("<table border=1 cellpadding=2 cellspacing=2 style=\"border:1px;border-color:#000000;font-family:Courier;font-size:9pt;text-align:right;color:white;\">"); |
| stringBuilder.append("<tr><th align=right style=\"background:#333333;\">ovf serial</th>").append("<th align=right style=\"background:#333333;\">ovfname</th>"); |
| stringBuilder.append("<th align=right style=\"background:#333333;\">ceeid</th>"); |
| stringBuilder.append("<th align=right style=\"background:#333333;\">state</th>"); |
| stringBuilder.append("<th align=right style=\"background:#333333;\">group</th>").append("<th align=right style=\"background:#333333;\">permissions</th>"); |
| stringBuilder.append("<th align=right style=\"background:#333333;\">link</th></tr>"); |
| count = 0; |
| rs = db.query("select", "*", "ovf", "where uid=" + uid + " ORDER BY sno ASC"); |
| while(rs.next()) |
| { |
| count++; |
| String color = "#FFFFFF"; |
| if(count%2 == 1) |
| color = "#CCCCCC"; |
| else |
| color = "#FFFFFF"; |
| String td = "<td style=\"background:" + color + ";color:black;font-weight:bold;\">"; |
| String url = "<a href='../../ovf/id/" + rs.getInt("sno") + "'>/ovf/id/" + rs.getInt("sno") + "</a>"; |
| stringBuilder.append("<tr>").append(td).append(rs.getInt("sno")).append("</td>").append(td).append(rs.getString("ovfname")).append("</td>"); |
| stringBuilder.append(td).append(rs.getInt("ceeid")).append("</td>"); |
| stringBuilder.append(td).append(rs.getString("state")).append("</td>").append(td).append(rs.getString("gname")).append("</td>"); |
| stringBuilder.append(td).append(rs.getString("perm")).append("</td>").append(td).append(url).append("</td></tr>"); |
| } |
| stringBuilder.append("</table>"); |
| stringBuilder.append("<b>Total registered OVF applications found: ").append(count); |
| stringBuilder.append("</b></div>"); |
| } |
| else |
| { |