struts中jsp怎么显示数据库的数据

[iwillfling]

已经在ACTION中完成数据库的连接

[silver_zhao]

从一个javabean中的返回一个集合（例如：ArrayList）在前天利用这个集合进行循环，显示就可以了

[许飘大叔]

public static List queryUser(Connection conn,String name) throws MyException {
List list = new ArrayList();
String sql = "select * from user where username = '" + name + "'";
Statement statement = null;
ResultSet rs = null;
try {
statement = conn.createStatement();
rs = statement.executeQuery(sql);
while (rs.next()) {
String username = rs.getString("username");
String password = rs.getString("password");
User user = new User(username, password);
System.out.println("userName:" + username + "password:"
+ password);
list.add(user);
}
} catch (Exception ex) {
ex.printStackTrace();
throw new MyException("获取用户列表出错!");
} finally {
try {
if (rs != null) {
rs.close();
}
if (statement != null) {
statement.close();
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
return list;
}

在页面上显示用struts的标签。集合用<logic:iterate id="user" name="userList">
<tr> <td><bean:write name="user" property="userName"/></td>
<td><bean:write name="user" property="userPasword"/></td>
<td><a href="/Test/register.do?method=load&username=<bean:write name="user" property="userName"/>">修改</a></td>
</tr>
</logic:iterate>

对象用<bean:write name="user" property="userName"/>

[PowerAMD3794]

建议lz把数据库相关的代码另外封装

[zzxiaoma]

在action里面返回一个结果集,然后session.setAttribute("name","结果集");

然后在jsp里面循环输出

[hmily247]

在action里面返回一个结果集,然后session.setAttribute("name","结果集");
上面是把他村在session里面了，
如果只是用页面跳转后显示，就requeset.setAttribute("name","结果集");