[Cruce-commit] SF.net SVN: cruce:[149] JSP/trunk/Forum
Status: Beta
Brought to you by:
caiusb
|
From: <ca...@us...> - 2010-05-17 16:29:14
|
Revision: 149
http://cruce.svn.sourceforge.net/cruce/?rev=149&view=rev
Author: caiusb
Date: 2010-05-17 16:29:08 +0000 (Mon, 17 May 2010)
Log Message:
-----------
Am implementat si afisearea topic-urilor si a posturilor dintr-un topic. Arata ca ceapa, stiu, dar cand o sa avem css-ul o sa fie mult mai fain :D
Macar merge si face ce trebe.
O sa-l pun in cateva minute si pe server.
Modified Paths:
--------------
JSP/trunk/Forum/WebContent/Thread.jsp
JSP/trunk/Forum/src/prc/bubulina/forum/data_access/UserDAO.java
Added Paths:
-----------
JSP/trunk/Forum/WebContent/Topic.jsp
Modified: JSP/trunk/Forum/WebContent/Thread.jsp
===================================================================
--- JSP/trunk/Forum/WebContent/Thread.jsp 2010-05-17 14:00:33 UTC (rev 148)
+++ JSP/trunk/Forum/WebContent/Thread.jsp 2010-05-17 16:29:08 UTC (rev 149)
@@ -8,7 +8,6 @@
<%@page import="prc.bubulina.forum.businessLogic.Singleton"%>
<%@page import="prc.bubulina.forum.dataclasses.Topic"%>
<%@page import="java.util.*" %>
-<% %>
<html>
<head>
@@ -18,7 +17,7 @@
int id = Integer.parseInt(sID);
ForumThread thread = Singleton.getInstance().getThreadDAO().get(id);
%>
-<title>Forum Bubulina: <% out.println(thread.name); %></title>
+<title>Forum Bubulina: Thread - <% out.println(thread.name); %></title>
</head>
<body>
<div>
Added: JSP/trunk/Forum/WebContent/Topic.jsp
===================================================================
--- JSP/trunk/Forum/WebContent/Topic.jsp (rev 0)
+++ JSP/trunk/Forum/WebContent/Topic.jsp 2010-05-17 16:29:08 UTC (rev 149)
@@ -0,0 +1,58 @@
+<%@ page language="java" contentType="text/html; charset=UTF-8"
+ pageEncoding="UTF-8"%>
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+
+<%@page import="prc.bubulina.forum.data_access.TopicDAO"%>
+<%@page import="prc.bubulina.forum.data_access.UserDAO"%>
+<%@page import="prc.bubulina.forum.data_access.ForumDAOFactory"%>
+<%@page import="prc.bubulina.forum.dataclasses.Post"%>
+<%@page import="prc.bubulina.forum.dataclasses.Topic"%>
+<%@page import="prc.bubulina.forum.dataclasses.User"%>
+<%@page import="java.util.*" %>
+
+<html>
+<head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
+<%
+ String sID = request.getParameter("id");
+ int id = Integer.parseInt(sID);
+ TopicDAO topicDAO = ForumDAOFactory.getTopicDAO();
+ Topic topic = topicDAO.get(id);
+%>
+<title>Forum Bubulina: Topic - <% out.println(topic.subject); %></title>
+</head>
+<body>
+<div>
+<table border="1">
+ <caption align="top">The posts this topic are:</caption>
+ <%
+ List<Post> posts = topicDAO.getPosts(id);
+ UserDAO userDAO = ForumDAOFactory.getUserDAO();
+ for(Post p:posts) {
+ %>
+ <tr>
+ <th>User info</th>
+ <th>Subject: <% out.println(p.subject); %></th>
+ </tr>
+ <tr>
+ <%
+ User user = userDAO.get(p.user_id);
+ %>
+ <td>
+ Name: <% out.println(user.name); %> <br/>
+ Post count: <% out.println(user.post_count); %> <br/>
+ Joined: <% out.println(user.joined_date.toLocaleString()); %> <br/>
+ </td>
+ <td>
+ <%
+ out.println(p.text);
+ %>
+ </td>
+ </tr>
+ <%
+ }
+ %>
+</table>
+</div>
+</body>
+</html>
\ No newline at end of file
Modified: JSP/trunk/Forum/src/prc/bubulina/forum/data_access/UserDAO.java
===================================================================
--- JSP/trunk/Forum/src/prc/bubulina/forum/data_access/UserDAO.java 2010-05-17 14:00:33 UTC (rev 148)
+++ JSP/trunk/Forum/src/prc/bubulina/forum/data_access/UserDAO.java 2010-05-17 16:29:08 UTC (rev 149)
@@ -29,6 +29,25 @@
return null;
}
+ public User get(int userID) {
+ try {
+ Connection con = ForumDAOFactory.createConnection();
+ Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
+ ResultSet rs = stmt.executeQuery("SELECT * FROM users WHERE user_id=\"" + userID + "\"");
+ rs.first();
+
+ User result = new User(rs.getInt("user_id"), rs.getString("name"), rs.getString("password"), rs.getString("email"),
+ rs.getInt("post_count"), rs.getDate("joined_date"));
+
+ con.close();
+
+ return result;
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ return null;
+ }
+
public User add(String name, String password, String email) {
try {
Connection con = ForumDAOFactory.createConnection();
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|