我的代码好像显示不了啊.
我在管理员页面里面有个按钮"显示所有用户信息"
就是管理员点击了那个按钮能显示数据库中的表里的信息,能以表格显示最好,不用表格,只要能显示到页面就好..
有什么方法吗?[code=JSP]<body>
<form action="servlet/ListUser">
<table><tr><td><input type="submit" name="ListTable" value="显示所有用户信息"></td></tr></table></form>
</body>[/code]下面的是servlet
ListUser.java
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
DBConn conn = new DBConn();
conn.getConn();
conn.ListUser();
conn.closeConn();
}code]
DBConn.java
[code=Java]public void ListUser() { try { stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from users");
while (rs!=null && rs.next()) {
System.out.print("<tr><td>姓名=" + rs.getString("userName")
+ "</td>");
System.out.print("<td>密码=" + rs.getString("userPwd")
+ "</td></tr>");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} }
我在管理员页面里面有个按钮"显示所有用户信息"
就是管理员点击了那个按钮能显示数据库中的表里的信息,能以表格显示最好,不用表格,只要能显示到页面就好..
有什么方法吗?[code=JSP]<body>
<form action="servlet/ListUser">
<table><tr><td><input type="submit" name="ListTable" value="显示所有用户信息"></td></tr></table></form>
</body>[/code]下面的是servlet
ListUser.java
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
DBConn conn = new DBConn();
conn.getConn();
conn.ListUser();
conn.closeConn();
}code]
DBConn.java
[code=Java]public void ListUser() { try { stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from users");
while (rs!=null && rs.next()) {
System.out.print("<tr><td>姓名=" + rs.getString("userName")
+ "</td>");
System.out.print("<td>密码=" + rs.getString("userPwd")
+ "</td></tr>");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} }
重新贴一次ListUser.java
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
DBConn conn = new DBConn();
conn.getConn();
conn.ListUser();
conn.closeConn();
}
public void ListUser() { try { stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from users");
while (rs!=null && rs.next()) {
System.out.print("<tr><td>姓名=" + rs.getString("userName")
+ "</td>");
System.out.print("<td>密码=" + rs.getString("userPwd")
+ "</td></tr>");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} }
1.首先DBConn.java类中的public void ListUser()返回值是空,应该返回一个list才对
修改如下:
public List ListUser() { try {
List<Users> list=new ArrayList<List>();
Users user=null;
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from users");
while (rs.next()) {
user=new Users();
user.setName(rs.getString("name"));
user.setXXX(rs.getString("XXX"));
.
.
list.add(user);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}2.在servlet中要接收这个方法的返回值。如
List<Users> list=conn.ListUser();
if(list.size!=0)
{
request.setAttribute("userList",list);
}
conn.closeConn();
3.在页面显示<table border="1">
<c:forEach items="${userList}" var="item">
<tr><td>${itme.name}</td><td>${itme.xxx}</td>.....</tr>
</c:forEach>
</table>O了!
只有属性和set,get方法。
思路非常清晰..我现在去试试.