jsp 頁面
<%=session.getAttribute("users")%>
取出的結果是:
[table.admin.UserInfo@1f4cdd2, table.admin.UserInfo@f4ca49, table.admin.UserInfo@10c94a7, table.admin.UserInfo@f3770c, table.admin.UserInfo@cbf92, table.admin.UserInfo@f549de, table.admin.UserInfo@1c4a2d3, table.admin.UserInfo@9e0c2d, table.admin.UserInfo@318293, table.admin.UserInfo@739aa3]
邏輯層
public ArrayList getUserList() throws Exception{
ArrayList userLists = new ArrayList();
try {
conn = DatabaseConnection.getConnection();
String sql = "select * from t_user_info";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()) {
UserInfo users = new UserInfo();
users.setUser_id(rs.getInt("user_id"));
System.out.println("getUserList...."+users.getUser_id());
users.setUser_name(rs.getString("user_name"));
System.out.println("getUserList...."+users.getUser_name());
users.setUser_sex(rs.getInt("user_sex"));
users.setUser_mail(rs.getString("user_mail"));
users.setUser_tel(rs.getString("user_tel"));
users.setUser_address(rs.getString("user_address"));
users.setUser_create_time(rs.getString("user_create_time"));
users.setUser_rank(rs.getString("user_rank_id"));
users.setUser_dept(rs.getString("user_dept_id"));
userLists.add(users);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
throw e;
}finally{
if(rs != null){
rs.close();
}
if(ps != null){
ps.close();
}
if(conn != null){
conn.close();
}
}
return userLists;
}
控制層
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws ServletException, IOException {
HttpSession session = request.getSession();
UserInfo userInfo = new UserInfo();
searchAllHandle handle = new searchAllHandle();
try {
ArrayList users = handle.getUserList();
session.setAttribute("users", users);
request.getRequestDispatcher("serchUserList.jsp").forward(request, response);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
uj5u.com熱心網友回復:
可能是因為你的物體類沒有toString()方法uj5u.com熱心網友回復:
怎么寫物體類toString()方法? 麻煩寫一下,謝謝了
uj5u.com熱心網友回復:
@Override
public String toString() {
return "UserInfo{" +
"user_id=" + user_id +
", user_name='" + user_name + '\'' +
", user_sex=" + user_sex +
", user_tel='" + user_tel + '\'' +
", user_address='" + user_address + '\'' +
", user_creae_time='" + user_creae_time + '\'' +
", user_rank_id='" + user_rank_id + '\'' +
", user_dept_id='" + user_dept_id + '\'' +
'}';
}
這是按照你的欄位寫的 你復制過去應該是沒問題的
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/9676.html
標籤:Java相關
上一篇:JSON入門到精通
