MyJavawebProject/src/com/servlet/SearchallServlet.java

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.dao.StuDao;
import com.dao.StuDaoImpl;
import com.entity.Stu;

/**
 * Servlet implementation class SearchallServlet
 */
@WebServlet("/SearchallServlet")
public class SearchallServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request, response);
	}
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		
		StuDao ud = new StuDaoImpl();//定义数据库操作类的对象
		List<Stu> stuAll = ud.getStuAll();//获取到所有的对象并且存储到list里
		request.setAttribute("stuAll", stuAll);
		
		//求和
		int sum = ud.sum();
		request.setAttribute("sum", sum);
		
		//求平均
		int avg = ud.avg();
		request.setAttribute("avg", avg);
		
		request.getRequestDispatcher("/mgrall.jsp").forward(request, response);
	}
}