helpers.database.DBPrivnoteManager.java Source code

Introduction

Here is the source code for helpers.database.DBPrivnoteManager.java

Source

/**
 *
 *  BibSonomy-Webapp - The webapplication for Bibsonomy.
 *
 *  Copyright (C) 2006 - 2011 Knowledge & Data Engineering Group,
 *                            University of Kassel, Germany
 *                            http://www.kde.cs.uni-kassel.de/
 *
 *  This program is free software; you can redistribute it and/or
 *  modify it under the terms of the GNU General Public License
 *  as published by the Free Software Foundation; either version 2
 *  of the License, or (at your option) any later version.
 *
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program; if not, write to the Free Software
 *  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 */

package helpers.database;

import helpers.constants;

import java.sql.SQLException;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

@Deprecated
public class DBPrivnoteManager extends DBManager {

    private final static Log log = LogFactory.getLog(DBPrivnoteManager.class);

    /**
     * Sets the private note of a users bibtex entry.
     * 
     * @param bean used to get the note, the hash and the user name
     * @return <code>true</code> if exactly one database row got updated
     */
    public static boolean setPrivnoteForUser(final String privnote, final String username, final String hash) {
        DBContext c = new DBContext();
        try {
            if (c.init()) { // initialize database
                // prepare Statement
                c.stmt = c.conn.prepareStatement("UPDATE bibtex SET privnote = ? WHERE user_name = ? AND simhash"
                        + constants.INTRA_HASH + " = ?");
                c.stmt.setString(1, privnote);
                c.stmt.setString(2, username);
                c.stmt.setString(3, hash);
                return c.stmt.executeUpdate() == 1; // return true, if exactly one row got updated 
            }
        } catch (SQLException e) {
            /*
             * TODO: first attempt to do logging when exceptions are thrown - code "stolen" from Jens'
             * Database backend classes
             */
            log.fatal("could not set the private not for the user " + e.getMessage());
        } finally {
            c.close(); // close database connection
        }
        return false;
    }
}