dao.PersonalinfoUpdateQuery.java Source code

Introduction

Here is the source code for dao.PersonalinfoUpdateQuery.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 util.RegexStrUtil;
import java.sql.Date;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

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

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

    // From MySQL 4.1.0 on, LONG and LONG VARCHAR map to the MEDIUMTEXT data type. 
    // Currently we are using mysql 4.0.21, so cannot use LONGVARCHAR

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

    public void run(Connection conn, String dob, String title, String ihave, String iwant, String industry,
            String company, String pwebsite, String cwebsite, String blogsite, String education, String city,
            String state, String country, String desc, String interests, String zipcode, int 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 photoLabel, String docLabel, String street, String bstreet, String zone)
            throws BaseDaoException {

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

        String stmt = "update usertab set dob='" + dob + "', title='" + title + "', ihave='" + ihave + "', iwant='"
                + iwant + "', industry='" + industry + "', company='" + company + "', pwebsite='" + pwebsite
                + "', cwebsite='" + cwebsite + "', blogsite='" + blogsite + "', education='" + education
                + "', city='" + city + "', state='" + state + "', country='" + country
                + "', description=?, interests='" + interests + "', zipcode='" + zipcode + "', designation='"
                + designation + "', gender=" + gender + ", nickname='" + nickname + "', bcity='" + bcity
                + "', bstate='" + bstate + "', bcountry='" + bcountry + "', bzipcode='" + bzipcode + "', hphone='"
                + hphone + "', bphone='" + bphone + "', cphone='" + cphone + "', yim='" + yim + "', aim='" + aim
                + "', msn='" + msn + "', icq='" + icq + "', photolabel='" + photoLabel + "', doclabel='" + docLabel
                + "', street='" + street + "', bstreet='" + bstreet + "', zone='" + zone + "' where loginid="
                + loginid + "";

        PreparedStatement query = null;
        try {
            query = conn.prepareStatement(stmt);
            query.setBytes(1, mydesc);
            query.executeUpdate();
        } catch (SQLException e) {
            throw new BaseDaoException("Error occured while executing update usertab, stmt = " + stmt, e);
        }
    }
}