userinfoaction.java

tbuy1.1.5是在netbeans环境下用JSF技术编写的一个论坛tbuy1.1.5是在netbeans环境下用JSF技术编写的一个论坛

/*
 * 作者: 胡李青
 * qq: 31703299
 * Copyright (c) 2007 huliqing
 * 主页 http://www.tbuy.biz/
 * 你可以免费使用该软件，未经许可请勿作用于任何商业目的
 */

package biz.tbuy.user;

import biz.tbuy.common.logs.Elog;
import biz.tbuy.common.pool.ProxyConn;
import biz.tbuy.user.bean.BaseBean;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
/**
 * @author huliqing
 * <p><b>qq：</b>31703299
 * <p><b>E-mail：</b><a href="mailto:[e-mail]">[e-mail]</a>
 * <p><b>Homepage：</b><a href="http://www.tbuy.biz/">http://www.tbuy.biz/</a>
 */
public class UserinfoAction extends BaseBean{
    
    public UserinfoAction() {
    }

    /**
     * 添加用户信息
     * @param userinfo 用户信息
     * @return true 添加成功，否则false;
     */
    public static boolean addUserinfo(UserinfoModel userinfo) {
        boolean isOk = false;
        String sql = "insert into userinfo " +
                "(u_byUser, u_email, u_im, u_phone, u_address, u_homepage) " +
                "values (?, ?, ?, ?, ?, ?)";
        ProxyConn myConn = getConn();
        try {
            PreparedStatement ps = myConn.prepareStatement(sql);
            ps.setString(1, userinfo.getByUser());
            ps.setString(2, userinfo.getEmail());
            ps.setString(3, userinfo.getIm());
            ps.setString(4, userinfo.getPhone());
            ps.setString(5, userinfo.getAddress());
            ps.setString(6, userinfo.getHomepage());
            isOk = ps.executeUpdate() > 0;
        } catch (Exception e) {
            Elog.log("Exception:UserinfoAction:addUserinfo:" + e.getMessage());
        } finally {
            myConn.close();
        }
        return isOk;
    }
    
    /**
     * 获取用户的详细资料
     * @param id 用户的id
     */ 
    public static UserinfoModel getUserinfoById(String id) {
        UserinfoModel userinfo = null;
        String sql = "select * from userinfo where u_byUser=?";
        ProxyConn myConn = getConn();
        try {
            PreparedStatement ps = myConn.prepareStatement(sql);
            ps.setString(1, id);
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
               userinfo = getUserinfo(rs); 
            }
        } catch (Exception e) {
            Elog.log("Exception:UserinfoAction:getUserinfoById:" + e.getMessage());
        } finally {
            myConn.close();
        }
        return userinfo;
    }
    
    /**
     * 更新用户详细信息
     * @param userinfo
     * @return true 更新成功，否则false
     */
    public static boolean updateUserinfo(UserinfoModel userinfo) {
        boolean isOk = false;
        String sql = "update userinfo set " +
                "u_sex=?,   u_birthday=?, u_email=?,    u_im=?, " +
                "u_phone=?, u_address=?,  u_homepage=?  " +
                "where u_byUser=?";
        ProxyConn myConn = getConn();
        try {
            PreparedStatement ps = myConn.prepareStatement(sql);
            ps.setInt(1, userinfo.getSex());
            ps.setDate(2, userinfo.getBirthday());
            ps.setString(3, userinfo.getEmail());
            ps.setString(4, userinfo.getIm());
            ps.setString(5, userinfo.getPhone());
            ps.setString(6, userinfo.getAddress());
            ps.setString(7, userinfo.getHomepage());
            ps.setString(8, userinfo.getByUser());
            isOk = ps.executeUpdate() > 0;
        } catch (Exception e) {
            Elog.log("Exception:UserinfoAction:updateUserinfo:" + e.getMessage());
        } finally {
            myConn.close();
        }
        return isOk;
    }
    
    /**
     * 获取用户的详细资料
     * @param rs
     * @return userinfo
     */
    public static UserinfoModel getUserinfo(ResultSet rs) {
        UserinfoModel userinfo = null;
        try {
            userinfo = new UserinfoModel();
            userinfo.setAddress(rs.getString("u_address"));
            userinfo.setBirthday(rs.getDate("u_birthday"));
            userinfo.setByUser(rs.getString("u_byUser"));
            userinfo.setEmail(rs.getString("u_email"));
            userinfo.setHomepage(rs.getString("u_homepage"));
            userinfo.setIm(rs.getString("u_im"));
            userinfo.setNum(rs.getInt("u_num"));
            userinfo.setPhone(rs.getString("u_phone"));
            userinfo.setSex(rs.getInt("u_sex"));
        } catch (Exception e) {
            Elog.log("Exception:UserinfoAction:getUserinfo:" + e.getMessage());
        }
        return userinfo;
    }
}