From 88f3693c53e70ad064ccc1466ddf27cae98db49a Mon Sep 17 00:00:00 2001
From: Ugnich Anton
Date: Sat, 8 Mar 2014 16:26:50 +0700
Subject: iPod contest
---
src/java/com/juick/http/www/PageTemplates.java | 35 +++++++++++++++++++++++++-
1 file changed, 34 insertions(+), 1 deletion(-)
(limited to 'src/java/com/juick/http/www/PageTemplates.java')
diff --git a/src/java/com/juick/http/www/PageTemplates.java b/src/java/com/juick/http/www/PageTemplates.java
index c76ded41..f9cce99e 100644
--- a/src/java/com/juick/http/www/PageTemplates.java
+++ b/src/java/com/juick/http/www/PageTemplates.java
@@ -52,7 +52,7 @@ public class PageTemplates {
out.println("");
out.print("");
out.print("");
- out.print("");
+ out.print("");
out.print("");
out.print("");
if (headers != null) {
@@ -136,6 +136,7 @@ public class PageTemplates {
out.println("");
}
@@ -188,6 +189,38 @@ public class PageTemplates {
return ret;
}
+ public static void printContestRating(PrintWriter out, Connection sql) {
+ out.println("
");
+ out.println("");
+ out.println("Кто выиграет iPod?
");
+ out.println("");
+
+ int i = 0;
+ PreparedStatement stmt = null;
+ ResultSet rs = null;
+ try {
+ stmt = sql.prepareStatement("SELECT users.id,users.nick,COUNT(users_refs.user_id) AS cnt FROM users INNER JOIN users_refs ON users.id=users_refs.ref GROUP BY users_refs.ref ORDER BY cnt DESC LIMIT 10");
+ rs = stmt.executeQuery();
+ rs.beforeFirst();
+ while (rs.next()) {
+ String uname = rs.getString(2);
+ if (i == 0) {
+ out.println(" | " + uname + " | " + rs.getInt(3) + " |
");
+ } else {
+ out.println(" | " + uname + " | " + rs.getInt(3) + " |
");
+ }
+ i++;
+ }
+ } catch (SQLException e) {
+ System.err.println(e);
+ } finally {
+ Utils.finishSQL(rs, stmt);
+ }
+
+ out.println("
");
+ out.println("");
+ }
+
public static void pageDialogTemplate(PrintWriter out) {
out.println("");
out.println("Ссылка на сообщение:");
--
cgit v1.2.3