全查员工操作

<a href="FindAllServlet">查看所有员工信息</a>

FindAllServlet.java

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        EmpDao ed = new EmpDao();
        List<Emp> list = ed.getAll();

        response.setContentType("text/html;charset=utf-8");
        PrintWriter out = response.getWriter();

        out.println("<table border='1' width='600'>");
        out.println("<tr><th>编号</th><th>姓名</th><th>工资</th></tr>");

        for (Emp e : list){
            out.println("<tr>" +
                    "<th>"+e.getEmpno()+"</th>" +
                    "<th>"+e.getEname()+"</th>" +
                    "<th>"+e.getSal()+"</th>" +
                    "</tr>");
        }
        out.println("</table>");
    }

EmpDap.java

//查询所有员工的方法
    public List<Emp> getAll(){
        List<Emp> list = new ArrayList<Emp>();

        try(Connection conn = DBUtils.getConn()){

            String sql = "select empno,ename,sal from emp";
            PreparedStatement ps = conn.prepareStatement(sql);
            ResultSet rs = ps.executeQuery();

            while (rs.next()){
                //循环中实例化对象
                Emp e = new Emp();
                //为这个对象的各个属性赋值
                e.setEmpno(rs.getInt(1));
                e.setEname(rs.getString(2));
                e.setSal(rs.getDouble(3));
                //循环中将赋好值的对象加入list集合
                list.add(e);

            }

        } catch (Exception e) {
            e.printStackTrace();
        }
        return list;
    }