使用JMeter测试一下有无数据库连接池的性能：
1.下载JMeter
2.无连接池的servlet
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); out .println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">"); out.println("<HTML>"); out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>"); out.println(" <BODY>"); out.print(" This is "); out.print(this.getClass()); out.println(", using the GET method"); out.println("test 1000 add"); DBManager db=new DBManager(); db.getConnection(); db.addUser("persia", "persia"); out.println(" </BODY>"); out.println("</HTML>"); out.flush(); out.close(); }
有连接池的servlet情况：
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); out .println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">"); out.println("<HTML>"); out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>"); out.println(" <BODY>"); out.print(" This is "); out.print(this.getClass()); out.println(", using the GET method"); out.println("test 1000 add"); DBManagerByPool dbp=new DBManagerByPool(); try { dbp.addUser("persia", "persia"); } catch (NamingException e) { // TODO Auto-generated catch block e.printStackTrace(); } out.println(" </BODY>"); out.println("</HTML>"); out.flush(); out.close(); }
3.JMeter测试配置：
（1）默认新建的测试计划里面新建线程组
线程数5，循环1000
（2）设置HTTP请求默认值
（3）添加（sampler里面）2个HTTP请求分别对应有无连接池
（4）添加监听器--聚合报告
（5）运行--启动
4.测试结果：
Label # Samples Average Median 90% Line Min Max Error % Throughput KB/sec无连接池池 5000 88 44 89 17 1012 0 35.57680677 7.052823998连接池 5000 50 45 68 10 236 0 35.59098836 7.194662686总体 10000 69 45 78 10 1012 0 71.14247704 14.24239042
发现无连接池的平均反应时间为88毫秒，而有连接池的平均反应时间为50毫秒。
