request.setAttribute("sum",sum);
   request.setAttribute("sumpages",sumpages);
   // 转发
   request.getRequestDispatcher("./index.jsp").forward(request,response);
 }

}

 

Juitl工具：JdbcUtil

package cn.csdn.customer.util;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSourceFactory;

import java.sql.PreparedStatement;

public class JdbcUtil {
 /* 声明dataSource对象 */
 private static DataSource dataSource;
 static {
  try {
   Properties properties = new Properties();
   // 加载驱动 
   InputStream is = JdbcUtil.class.getClassLoader().getResourceAsStream("config/dbcp.properties");
   //从流中读取属性列表
   properties.load(is);
   dataSource = BasicDataSourceFactory.createDataSource(properties);
  } catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }
 /*获取连接对象*/
 public static Connection getConn() throws SQLException{
  
  return dataSource.getConnection();
 }
 /*释放资源*/
 public static void release(ResultSet rs,PreparedStatement pstmt,Connection conn){
  
  if(rs!=null){
   try {
    rs.close();
   } catch (SQLException e) {