dao.ContactUpdateQuery.java Source code

Introduction

Here is the source code for dao.ContactUpdateQuery.java

Source

/**
* 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.RegexStrUtil;

/**
 * This class implements ContactUpdateQuery
 *  Used by <code>Contact</code> bean
 * @author Smitha Gudur (smitha@redbasin.com)
 * @version $Revision: 1.1 $
 */
class ContactUpdateQuery {

    protected final Log logger = LogFactory.getLog(getClass());

    public void run(Connection conn, String fname, String lname, String mname, String dob, String title,
            String industry, String company, String pwebsite, String cwebsite, String blogsite, String city,
            String state, String country, String desc, String zipcode, String gender, String nickname,
            String designation, String bcity, String bstate, String bcountry, String bzipcode, String hphone,
            String cphone, String bphone, String yim, String aim, String msn, String icq, String loginId,
            String fax, String netphone, String relation, String email, String published, String usertag,
            String contactId, String street, String bstreet) throws BaseDaoException {

        /****  use UTC_TIMESTAMP after upgrading mysql **/

        // default date
        if (RegexStrUtil.isNull(dob)) {
            dob = "1970-01-01";
        }

        byte[] mytag = { ' ' };
        if (!RegexStrUtil.isNull(usertag)) {
            mytag = usertag.getBytes();
        }

        byte[] mydesc = { ' ' };
        if (!RegexStrUtil.isNull(desc)) {
            mydesc = desc.getBytes();
        }

        PreparedStatement query = null;
        String stmt = "update hdcontacts set ownerid=" + loginId + ", fname='" + fname + "', lname='" + lname
                + "', mname='" + mname + "', nickname='" + nickname + "', gender=" + gender + ", dob='" + dob
                + "', email='" + email + "', designation='" + designation + "', title='" + title + "', industry='"
                + industry + "', company='" + company + "', pwebsite='" + pwebsite + "', cwebsite='" + cwebsite
                + "', blogsite='" + blogsite + "', street='" + street + "', city='" + city + "', state='" + state
                + "', country='" + country + "', zipcode='" + zipcode + "',description=?, bstreet='" + bstreet
                + "', bcity='" + bcity + "', bstate='" + bstate + "', bcountry='" + bcountry + "', bzipcode='"
                + bzipcode + "', hphone='" + hphone + "', cphone='" + cphone + "', bphone='" + bphone
                + "', netphone='" + netphone + "', fax='" + fax + "', yim='" + yim + "', aim='" + aim + "', msn='"
                + msn + "', icq='" + icq + "', relation='" + relation + "', published='" + published
                + "', usertags=? where contactid=" + contactId + "";

        try {
            query = conn.prepareStatement(stmt);
            query.setBytes(1, mydesc);
            query.setBytes(2, mytag);
            query.executeUpdate();
        } catch (Exception e) {
            throw new BaseDaoException("Error occured, executing update hdcontacts " + stmt, e);
        }
    }
}