001: /*
002: * Copyright (c) JForum Team
003: * All rights reserved.
004: *
005: * Redistribution and use in source and binary forms,
006: * with or without modification, are permitted provided
007: * that the following conditions are met:
008: *
009: * 1) Redistributions of source code must retain the above
010: * copyright notice, this list of conditions and the
011: * following disclaimer.
012: * 2) Redistributions in binary form must reproduce the
013: * above copyright notice, this list of conditions and
014: * the following disclaimer in the documentation and/or
015: * other materials provided with the distribution.
016: * 3) Neither the name of "Rafael Steil" nor
017: * the names of its contributors may be used to endorse
018: * or promote products derived from this software without
019: * specific prior written permission.
020: *
021: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT
022: * HOLDERS AND CONTRIBUTORS "AS IS" AND ANY
023: * EXPRESS OR IMPLIED WARRANTIES, INCLUDING,
024: * BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
025: * MERCHANTABILITY AND FITNESS FOR A PARTICULAR
026: * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
027: * THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE
028: * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
029: * EXEMPLARY, OR CONSEQUENTIAL DAMAGES
030: * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
031: * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA,
032: * OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
033: * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER
034: * IN CONTRACT, STRICT LIABILITY, OR TORT
035: * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
036: * ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
037: * ADVISED OF THE POSSIBILITY OF SUCH DAMAGE
038: *
039: * Created on 08/07/2007 11:29:41
040: * The JForum Project
041: * http://www.jforum.net
042: */
043: package net.jforum.dao.generic;
044:
045: import java.sql.PreparedStatement;
046: import java.sql.ResultSet;
047: import java.sql.SQLException;
048: import java.sql.Timestamp;
049: import java.util.ArrayList;
050: import java.util.Date;
051: import java.util.List;
052:
053: import net.jforum.JForumExecutionContext;
054: import net.jforum.dao.ModerationLogDAO;
055: import net.jforum.entities.ModerationLog;
056: import net.jforum.entities.User;
057: import net.jforum.exceptions.DatabaseException;
058: import net.jforum.util.DbUtils;
059: import net.jforum.util.preferences.SystemGlobals;
060:
061: public class GenericModerationLogDAO extends AutoKeys implements
062: ModerationLogDAO {
063: public void add(ModerationLog log) {
064: PreparedStatement p = null;
065:
066: try {
067: p = this .getStatementForAutoKeys("ModerationLog.addNew");
068: p.setInt(1, log.getUser().getId());
069: p.setString(2, log.getDescription());
070: p.setString(3, log.getOriginalMessage());
071: p
072: .setTimestamp(4, new Timestamp(System
073: .currentTimeMillis()));
074: p.setInt(5, log.getType());
075: p.setInt(6, log.getPostId());
076: p.setInt(7, log.getTopicId());
077: p.setInt(8, log.getPosterUser().getId());
078:
079: this
080: .setAutoGeneratedKeysQuery(SystemGlobals
081: .getSql("ModerationLog.lastGeneratedModerationLogId"));
082:
083: int logId = this .executeAutoKeysQuery(p);
084:
085: log.setId(logId);
086: } catch (SQLException e) {
087: throw new DatabaseException(e);
088: } finally {
089: DbUtils.close(p);
090: }
091: }
092:
093: public List selectAll(int start, int count) {
094: List l = new ArrayList();
095:
096: String sql = SystemGlobals.getSql("ModerationLog.selectAll");
097:
098: PreparedStatement p = null;
099: ResultSet rs = null;
100:
101: try {
102: p = JForumExecutionContext.getConnection()
103: .prepareStatement(sql);
104: p.setInt(1, start);
105: p.setInt(2, count);
106:
107: rs = p.executeQuery();
108:
109: while (rs.next()) {
110: l.add(this .makeLog(rs));
111: }
112:
113: return l;
114: } catch (SQLException e) {
115: throw new DatabaseException(e);
116: } finally {
117: DbUtils.close(rs, p);
118: }
119: }
120:
121: protected ModerationLog makeLog(ResultSet rs) throws SQLException {
122: ModerationLog log = new ModerationLog();
123:
124: log.setId(rs.getInt("log_id"));
125: log.setDescription(this .readDesriptionFromResultSet(rs));
126: log.setOriginalMessage(this
127: .readOriginalMessageFromResultSet(rs));
128: log.setType(rs.getInt("log_type"));
129: log.setDate(new Date(rs.getTimestamp("log_date").getTime()));
130: log.setPostId(rs.getInt("post_id"));
131: log.setTopicId(rs.getInt("topic_id"));
132:
133: User user = new User();
134: user.setId(rs.getInt("user_id"));
135: user.setUsername(rs.getString("username"));
136:
137: log.setUser(user);
138:
139: User posterUser = new User();
140: posterUser.setId(rs.getInt("post_user_id"));
141: posterUser.setUsername(rs.getString("poster_username"));
142:
143: log.setPosterUser(posterUser);
144:
145: return log;
146: }
147:
148: protected String readDesriptionFromResultSet(ResultSet rs)
149: throws SQLException {
150: return rs.getString("log_description");
151: }
152:
153: protected String readOriginalMessageFromResultSet(ResultSet rs)
154: throws SQLException {
155: return rs.getString("log_original_message");
156: }
157:
158: public int totalRecords() {
159: int total = 0;
160:
161: PreparedStatement p = null;
162: ResultSet rs = null;
163:
164: try {
165: p = JForumExecutionContext
166: .getConnection()
167: .prepareStatement(
168: SystemGlobals
169: .getSql("ModerationLog.totalRecords"));
170:
171: rs = p.executeQuery();
172:
173: if (rs.next()) {
174: total = rs.getInt(1);
175: }
176: } catch (SQLException e) {
177: throw new DatabaseException(e);
178: } finally {
179: DbUtils.close(rs, p);
180: }
181:
182: return total;
183: }
184: }
|