01: /*
02: * Copyright (c) JForum Team
03: * All rights reserved.
04: *
05: * Redistribution and use in source and binary forms,
06: * with or without modification, are permitted provided
07: * that the following conditions are met:
08: *
09: * 1) Redistributions of source code must retain the above
10: * copyright notice, this list of conditions and the
11: * following disclaimer.
12: * 2) Redistributions in binary form must reproduce the
13: * above copyright notice, this list of conditions and
14: * the following disclaimer in the documentation and/or
15: * other materials provided with the distribution.
16: * 3) Neither the name of "Rafael Steil" nor
17: * the names of its contributors may be used to endorse
18: * or promote products derived from this software without
19: * specific prior written permission.
20: *
21: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT
22: * HOLDERS AND CONTRIBUTORS "AS IS" AND ANY
23: * EXPRESS OR IMPLIED WARRANTIES, INCLUDING,
24: * BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
25: * MERCHANTABILITY AND FITNESS FOR A PARTICULAR
26: * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
27: * THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE
28: * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
29: * EXEMPLARY, OR CONSEQUENTIAL DAMAGES
30: * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
31: * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA,
32: * OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
33: * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER
34: * IN CONTRACT, STRICT LIABILITY, OR TORT
35: * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
36: * ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
37: * ADVISED OF THE POSSIBILITY OF SUCH DAMAGE
38: *
39: * Created on 24/05/2004 01:07:39
40: * The JForum Project
41: * http://www.jforum.net
42: */
43: package net.jforum.dao.sqlserver;
44:
45: import java.sql.PreparedStatement;
46: import java.sql.ResultSet;
47: import java.sql.SQLException;
48:
49: import net.jforum.JForumExecutionContext;
50: import net.jforum.entities.PrivateMessage;
51: import net.jforum.exceptions.DatabaseException;
52: import net.jforum.util.DbUtils;
53: import net.jforum.util.preferences.SystemGlobals;
54:
55: /**
56: * @author Andre de Andrade da Silva - andre.de.andrade@gmail.com
57: * @version $Id: SqlServerPrivateMessageDAO.java,v 1.11 2007/03/03 18:33:46 rafaelsteil Exp $
58: */
59: public class SqlServerPrivateMessageDAO extends
60: net.jforum.dao.generic.GenericPrivateMessageDAO {
61: /**
62: * @see net.jforum.dao.PrivateMessageDAO#selectById(net.jforum.entities.PrivateMessage)
63: */
64: public PrivateMessage selectById(PrivateMessage pm) {
65: PreparedStatement p = null;
66: ResultSet rs = null;
67: try {
68: p = JForumExecutionContext
69: .getConnection()
70: .prepareStatement(
71: SystemGlobals
72: .getSql("PrivateMessageModel.selectById"),
73: ResultSet.TYPE_SCROLL_INSENSITIVE,
74: ResultSet.CONCUR_UPDATABLE);
75:
76: p.setInt(1, pm.getId());
77:
78: rs = p.executeQuery();
79: if (rs.next()) {
80: pm = this .getPm(rs);
81: }
82:
83: return pm;
84: } catch (SQLException e) {
85: throw new DatabaseException(e);
86: } finally {
87: DbUtils.close(rs, p);
88: }
89: }
90: }
|