日期:2014-05-17  浏览次数:20763 次

登录成功后的界面如何根据用户名来获得用户其他信息
<%
String admin = (String)session.getAttribute("admin"); try {

String sql = "select admin_id,admin_psw.amin_sex from admin where admin_id='"+admin+"'";
ResultSet rs = sqlbean.executeQuery(sql);
if (rs.next() ){

out.println("你好,"+admin);}
}
catch (Exception ee) {
ee.printStackTrace();
}

%>

上面代码是登录成功后的界面里的。 通过String admin = (String)session.getAttribute("admin"); 获得登录成功后的用户Id,如何加代码使得登录成功后的界面获得该用户的admin_psw和amin_sex

------解决方案--------------------
http://topic.csdn.net/u/20120416/10/939c4ac5-08e4-4e3e-992e-2eb1b342e44e.html?seed=593705115&r=78258070#r_78258070
那边已经回答了、给你写个demo看看
Java code
public List<LinkDTO> queryUser(String name) {
        conn = ConnDB.getConn();
        List<LinkDTO> list = new ArrayList<LinkDTO>();
        String sql = "select  Id,NickName,Others from tb_link where UserName = ?";
        try {
            ps = conn.prepareStatement(sql);
            ps.setString(1, name);
            rs = ps.executeQuery();
            while (rs.next()) {
                LinkDTO ldto = new LinkDTO();
                ldto.setId(rs.getInt("Id"));
                ldto.setOthers(rs.getString("Others"));
                ldto.setNickname(rs.getString("NickName"));
                list.add(ldto);
                     [color=#FF0000]session.setAttribute("user",ldto);[/color]
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            ConnDB.closeConn(conn);
        }
        return list;
    }

------解决方案--------------------
你不是都写了么,稍微加两句。。。

if (rs.next() ){
out.println(rs.getString("admin_psw"));//获取admin_psw
out.println(rs.getString("amin_sex "));//获取amin_sex 
out.println("你好,"+admin);
}

还有你的sql有点问题,改一下
String sql = "select admin_id,admin_psw,admin_sex from admin where admin_id='"+admin+"'";
------解决方案--------------------
你应该有个admin的实体类

String sql = "select admin_id,admin_psw.amin_sex from admin where admin_id='"+admin+"'";
ResultSet rs = sqlbean.executeQuery(sql);
if (rs.next() ){
//查询数据信息存在在实体类中,具体admin方法已实际为准
admin bean=new admin();
bean.setId(rs.getString("admin_id"));
bean.setPsw(rs.getString("admin_psw));
bean.setSex(rs.getString("admin_sex"));
out.println("你好,"+admin);}
}
//将admin放在session中,取出时${admin.id}即可
request.setArrtibutre("admin",admin);
------解决方案--------------------
看着想新手
if (rs.next() ){
out.println(rs.getString("admin_psw"));//获取admin_psw
out.println(rs.getString("amin_sex "));//获取amin_sex 
out.println("你好,"+admin);
}这样就行了,不用看别的什么了 javabean 你现在用不到 demo什么的你也....
------解决方案--------------------
用 rs.getString("admin_sex") 就可以获取了!
request.setSession()放到这里
登录后你可以把得到的放到session 里面 然后 request.getSession()取出来就可以了