[Cruce-commit] SF.net SVN: cruce:[143] JSP/trunk/Forum/src/prc/bubulina/forum/data_access/ ForumThreadDAO.java

[<hor...@us...>]

Revision: 143
          http://cruce.svn.sourceforge.net/cruce/?rev=143&view=rev
Author:   horiaradu
Date:     2010-05-16 14:28:29 +0000 (Sun, 16 May 2010)

Log Message:
-----------
am adaugat posibilitatea de a lua toate thread-urile

Modified Paths:
--------------
    JSP/trunk/Forum/src/prc/bubulina/forum/data_access/ForumThreadDAO.java

Modified: JSP/trunk/Forum/src/prc/bubulina/forum/data_access/ForumThreadDAO.java
===================================================================
--- JSP/trunk/Forum/src/prc/bubulina/forum/data_access/ForumThreadDAO.java	2010-05-14 17:02:08 UTC (rev 142)
+++ JSP/trunk/Forum/src/prc/bubulina/forum/data_access/ForumThreadDAO.java	2010-05-16 14:28:29 UTC (rev 143)
@@ -82,4 +82,22 @@
 		}
 		return null;
 	}
+	
+	public List<ForumThread> getAllThreads() {
+		try {
+			Connection con = ForumDAOFactory.createConnection();
+			Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+			ResultSet rs = stmt.executeQuery("SELECT * FROM threads;");
+
+			List<ForumThread> result = new LinkedList<ForumThread>();
+			while (rs.next()) {
+				ForumThread t = new ForumThread(rs.getInt("thread_id"), rs.getString("name"), rs.getInt("topic_count"));
+				result.add(t);
+			}
+			return result;
+		} catch(Exception e) {
+			e.printStackTrace();
+		}
+		return null;
+	}
 }
\ No newline at end of file


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.