用户管理系统——查询所有用户

cstm.dao

/** * 查询所有用户 */public List<Customer> findAll(){try {String sql="select * from t_customer";return qr.query(sql, new BeanListHandler<Customer>(Customer.class));} catch (SQLException e) {// TODO Auto-generated catch blockthrow new RuntimeException(e);}}

cstm.service

public List<Customer> findAll(){return customerDao.findAll();}

cstm.servlet

public String findAll(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {List<Customer> list=customerService.findAll();request.setAttribute("cstmList", list);return "f:/list.jsp";}