[Cruce-commit] SF.net SVN: cruce:[155] JSP/trunk/Forum
Status: Beta
Brought to you by:
caiusb
Menu
▾
▴
[Cruce-commit] SF.net SVN: cruce:[155] JSP/trunk/Forum
|
From: <hor...@us...> - 2010-05-18 10:37:58
|
Revision: 155
http://cruce.svn.sourceforge.net/cruce/?rev=155&view=rev
Author: horiaradu
Date: 2010-05-18 10:37:52 +0000 (Tue, 18 May 2010)
Log Message:
-----------
Am adaugat data la post.
Modified Paths:
--------------
JSP/trunk/Forum/bd_script.sql
JSP/trunk/Forum/src/prc/bubulina/forum/data_access/PostDAO.java
JSP/trunk/Forum/src/prc/bubulina/forum/data_access/TopicDAO.java
JSP/trunk/Forum/src/prc/bubulina/forum/data_access/UserDAO.java
JSP/trunk/Forum/src/prc/bubulina/forum/dataclasses/Post.java
JSP/trunk/Forum/src/prc/bubulina/forum/test/Test.java
Modified: JSP/trunk/Forum/bd_script.sql
===================================================================
--- JSP/trunk/Forum/bd_script.sql 2010-05-18 10:02:35 UTC (rev 154)
+++ JSP/trunk/Forum/bd_script.sql 2010-05-18 10:37:52 UTC (rev 155)
@@ -36,6 +36,7 @@
subject VARCHAR(50) NOT NULL,
topic_id INT NOT NULL,
user_id INT NOT NULL,
+ date DATE NOT NULL,
PRIMARY KEY (post_id),
FOREIGN KEY (topic_id) REFERENCES topics(topic_id) ON DELETE CASCADE,
FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE
Modified: JSP/trunk/Forum/src/prc/bubulina/forum/data_access/PostDAO.java
===================================================================
--- JSP/trunk/Forum/src/prc/bubulina/forum/data_access/PostDAO.java 2010-05-18 10:02:35 UTC (rev 154)
+++ JSP/trunk/Forum/src/prc/bubulina/forum/data_access/PostDAO.java 2010-05-18 10:37:52 UTC (rev 155)
@@ -15,7 +15,7 @@
rs.first();
Post result = new Post(rs.getInt("post_id"), rs.getString("subject"), rs.getString("text"),
- rs.getInt("topic_id"), rs.getInt("user_id"));
+ rs.getInt("topic_id"), rs.getInt("user_id"), rs.getDate("date"));
con.close();
@@ -31,8 +31,8 @@
Connection con = ForumDAOFactory.createConnection();
Statement stmt = con.createStatement();
- String queryString = "INSERT INTO posts (subject, text, topic_id, user_id) VALUES " +
- "(\"" + subject + "\", \"" + text + "\", " + topic_id + ", " + user_id + ");";
+ String queryString = "INSERT INTO posts (subject, text, topic_id, user_id, date) VALUES " +
+ "(\"" + subject + "\", \"" + text + "\", " + topic_id + ", " + user_id + ", CURDATE());";
System.out.println(queryString);
stmt.executeUpdate(queryString);
@@ -48,7 +48,7 @@
rs.first();
Post result = new Post(rs.getInt("post_id"), rs.getString("subject"), rs.getString("text"),
- rs.getInt("topic_id"), rs.getInt("user_id"));
+ rs.getInt("topic_id"), rs.getInt("user_id"), rs.getDate("date"));
con.close();
return result;
@@ -83,7 +83,7 @@
Statement stmt = con.createStatement();
String queryString = "UPDATE posts SET subject=\"" + post.subject + "\", text=\"" + post.text +
- "\" WHERE post_id=" + post.post_id + ";";
+ "\", date=CURDATE() WHERE post_id=" + post.post_id + ";";
System.out.println(queryString);
stmt.executeUpdate(queryString);
Modified: JSP/trunk/Forum/src/prc/bubulina/forum/data_access/TopicDAO.java
===================================================================
--- JSP/trunk/Forum/src/prc/bubulina/forum/data_access/TopicDAO.java 2010-05-18 10:02:35 UTC (rev 154)
+++ JSP/trunk/Forum/src/prc/bubulina/forum/data_access/TopicDAO.java 2010-05-18 10:37:52 UTC (rev 155)
@@ -83,7 +83,7 @@
List<Post> result = new LinkedList<Post>();
while (rs.next()) {
Post t = new Post(rs.getInt("post_id"), rs.getString("subject"), rs.getString("text"),
- rs.getInt("topic_id"), rs.getInt("user_id"));
+ rs.getInt("topic_id"), rs.getInt("user_id"), rs.getDate("date"));
result.add(t);
}
return result;
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-18 10:02:35 UTC (rev 154)
+++ JSP/trunk/Forum/src/prc/bubulina/forum/data_access/UserDAO.java 2010-05-18 10:37:52 UTC (rev 155)
@@ -144,7 +144,7 @@
List<Post> result = new LinkedList<Post>();
while (rs.next()) {
Post t = new Post(rs.getInt("post_id"), rs.getString("subject"), rs.getString("text"),
- rs.getInt("topic_id"), rs.getInt("user_id"));
+ rs.getInt("topic_id"), rs.getInt("user_id"), rs.getDate("date"));
result.add(t);
}
return result;
Modified: JSP/trunk/Forum/src/prc/bubulina/forum/dataclasses/Post.java
===================================================================
--- JSP/trunk/Forum/src/prc/bubulina/forum/dataclasses/Post.java 2010-05-18 10:02:35 UTC (rev 154)
+++ JSP/trunk/Forum/src/prc/bubulina/forum/dataclasses/Post.java 2010-05-18 10:37:52 UTC (rev 155)
@@ -1,21 +1,25 @@
package prc.bubulina.forum.dataclasses;
+import java.sql.Date;
+
public class Post {
public int post_id;
public String subject;
public String text;
public int topic_id;
public int user_id;
+ public Date date;
- public Post(int post_id, String subject, String text, int topic_id, int user_id) {
+ public Post(int post_id, String subject, String text, int topic_id, int user_id, Date date) {
this.post_id = post_id;
this.subject = subject;
this.text = text;
this.topic_id = topic_id;
this.user_id = user_id;
+ this.date = date;
}
public String toString() {
- return "ID: " + post_id + " Subject: " + subject + " Text: " + text + " TopicID: " + topic_id + " UserID: " + user_id;
+ return "ID: " + post_id + " Subject: " + subject + " Text: " + text + " TopicID: " + topic_id + " UserID: " + user_id + " Date: " + date;
}
}
\ No newline at end of file
Modified: JSP/trunk/Forum/src/prc/bubulina/forum/test/Test.java
===================================================================
--- JSP/trunk/Forum/src/prc/bubulina/forum/test/Test.java 2010-05-18 10:02:35 UTC (rev 154)
+++ JSP/trunk/Forum/src/prc/bubulina/forum/test/Test.java 2010-05-18 10:37:52 UTC (rev 155)
@@ -63,7 +63,7 @@
u.email = "hor...@gm...";
userdao.update(u);
- userdao.delete("zozo");
+ //userdao.delete("zozo");
ForumThread thread = threaddao.add("thread1");
System.out.println(thread);
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
