commonaction.java

来自「tbuy1.1.5是在netbeans环境下用JSF技术编写的一个论坛tbuy1」· Java 代码 · 共 68 行

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

package biz.tbuy.user;

import biz.tbuy.user.bean.BaseBean;
import biz.tbuy.common.logs.Elog;
import biz.tbuy.common.pool.ProxyConn;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @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 CommonAction extends BaseBean{
    
    public CommonAction() {}
    
    /**
     * 获取user信息，包含UserModel, UserinfoModel,返回类型为ArrayList,
     * List中包含Map, 可以像这样获取数据<br>
     * map.get("user") 获取UserModel<br>
     * map.get("userinfo") 获取UserinfoModel<br>
     * 该方法并非获取特定ID的信息，而是获取包含该id字串的所有用户信息，
     * 主要用于搜索用户.
     * @param id
     * @return userObj
     */ 
    @SuppressWarnings("unchecked")
    public static List<Map<String, Object>> getUserObjectById(String id) { 
        List<Map<String, Object>> userObj = new ArrayList<Map<String, Object>>();
        String sql = "select * from user, userinfo " +
                "where user.u_id=userinfo.u_byUser " +
                "and u_id like '%" + id + "%'";
        ProxyConn myConn = getConn();
        try {
            PreparedStatement ps = myConn.prepareStatement(sql);
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                UserModel user = new UserModel();
                UserinfoModel userinfo = new UserinfoModel();
                user = UserAction.getUser(rs);
                userinfo = UserinfoAction.getUserinfo(rs);
                Map map = new HashMap<String, Object>(2);
                map.put("user", user);
                map.put("userinfo", userinfo);
                userObj.add(map);
            }
        } catch (Exception e) {
            Elog.log("Exception:CommonAction:getUserObjectById:" + e.getMessage());
        } finally {
            myConn.close();
        }
        return userObj;
    }
}