Java tutorial
/** * Copyright (c) 2001-2012 "Redbasin Networks, INC," [http://redbasin.org] * * This file is part of Redbasin OpenDocShare community project. * * Redbasin OpenDocShare 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 3 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, see <http://www.gnu.org/licenses/>. */ package dao; import java.sql.Connection; import java.sql.PreparedStatement; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import util.MyUtils; import util.RegexStrUtil; /** * This class implements ColMesageAddQuery * This class is used by <code>ColMessage</code> bean * @author Smitha Gudur (smitha@redbasin.com) * @version $Revision: 1.2 $ */ class ColMessageAddQuery { protected final Log logger = LogFactory.getLog(getClass()); // private volatile MyUtils myutils; /** * This method is not called by spring. * It adds a message to collabrum topic * @param conn the connection passed to this. * @param tid the thread id * @param mid the message id * @param message the message * @param topic the topic or the subject * @param ownerid the owner id * @exception BaseDaoException */ public void run(Connection conn, String tid, String mid, String message, String topic, String ownerid) throws BaseDaoException { // need to assign a value to new byte as sql statement will not work byte[] msg = { ' ' }; if (!RegexStrUtil.isNull(message)) { msg = message.getBytes(); } byte[] mytopic = { ' ' }; if (!RegexStrUtil.isNull(topic)) { mytopic = topic.getBytes(); } PreparedStatement query = null; int rid = 0; try { String stmt = "insert into collmessages values (" + rid + ", " + tid + ", " + mid + ", " + ownerid + ", CURRENT_TIMESTAMP(), ?, ?, 0, 0)"; logger.info("stmt = " + stmt + " topic = " + topic + " message = " + message); query = conn.prepareStatement(stmt); query.setBytes(1, mytopic); query.setBytes(2, msg); query.executeUpdate(); } catch (Exception e) { logger.warn("Error occured while executing collmessages addquery", e); throw new BaseDaoException("Error occured while executing collmessages addquery", e); } } /* public void setmyutils(MyUtils utils) { this.myutils = utils; } */ }