web層代碼如下：

package beyondwsq.web;import java.io.IOException;
import java.sql.SQLException;
import java.util.List;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import beyondwsq.domain.Product;
import beyondwsq.service.AdminProductService;public class AdminProductListServlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {//傳遞請求到service層AdminProductService service = new AdminProductService();List<Product> productList = null;try {productList = service.findAllProduct();//獲取所有的數據} catch (SQLException e) {e.printStackTrace();}//獲取數據完畢request.setAttribute("productList", productList);//將productList放到request域當中request.getRequestDispatcher("/admin/product/list.jsp").forward(request, response);;//轉發到該頁面(list.jsp)下;這里是服務器內部地址，不需要寫web應用的名稱//到list.jsp頁面中取出數據}public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request, response);}
}

service層方法如下：

package beyondwsq.service;import java.sql.SQLException;
import java.util.List;import beyondwsq.dao.AdminProductDao;
import beyondwsq.domain.Product;public class AdminProductService {//查詢所有的商品public List<Product> findAllProduct() throws SQLException {//因為沒事啥復雜業務，所以直接傳遞請求到dao層AdminProductDao dao = new AdminProductDao();return dao.findAllProduct();//需要事務控制，拋到service層，不需要事務控制直接拋到web層}}

dao層代碼如下：

package beyondwsq.dao;import java.sql.SQLException;
import java.util.List;import javax.activation.DataSource;import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.taglibs.standard.tag.common.sql.DataSourceUtil;import beyondwsq.domain.Product;
import beyondwsq.utils.DataSourceUtils;public class AdminProductDao {//進行數據庫訪問,public List<Product> findAllProduct() throws SQLException {QueryRunner runner = new QueryRunner(DataSourceUtils.getDataSource());//不需要事務控制直接傳參String sql = "select *from product";//進行sql訪問List<Product> productList = runner.query(sql, new BeanListHandler<Product>(Product.class));//查詢Query方法return productList;//拋給service}}

domain代碼：

package beyondwsq.domain;public class Product {/*`pid` varchar(32) NOT NULL,`pname` varchar(50) DEFAULT NULL,`market_price` double DEFAULT NULL,`shop_price` double DEFAULT NULL,`pimage` varchar(200) DEFAULT NULL,`pdate` date DEFAULT NULL,`is_hot` int(11) DEFAULT NULL,`pdesc` varchar(255) DEFAULT NULL,`pflag` int(11) DEFAULT NULL,`cid` varchar(32) DEFAULT NULL,*//*	數據庫web17下創建表的代碼如下:CREATE TABLE `product` (`pid` VARCHAR(50) NOT NULL,`pname` VARCHAR(50) DEFAULT NULL,`market_price` DOUBLE DEFAULT NULL,`shop_price` DOUBLE DEFAULT NULL,`pimage` VARCHAR(200) DEFAULT NULL,`pdate` DATE DEFAULT NULL,`is_hot` INT(11) DEFAULT NULL,`pdesc` VARCHAR(255) DEFAULT NULL,`pflag` INT(11) DEFAULT NULL,`cid` VARCHAR(32) DEFAULT NULL,PRIMARY KEY (`pid`))*/private String pid;private String pname;private double market_price;private double shop_price;private String pimage;private String pdate;private int is_hot;private String pdesc;private int pflag;public String getPid() {return pid;}public void setPid(String pid) {this.pid = pid;}public String getPname() {return pname;}public void setPname(String pname) {this.pname = pname;}public double getMarket_price() {return market_price;}public void setMarket_price(double market_price) {this.market_price = market_price;}public double getShop_price() {return shop_price;}public void setShop_price(double shop_price) {this.shop_price = shop_price;}public String getPimage() {return pimage;}public void setPimage(String pimage) {this.pimage = pimage;}public String getPdate() {return pdate;}public void setPdate(String pdate) {this.pdate = pdate;}public int getIs_hot() {return is_hot;}public void setIs_hot(int is_hot) {this.is_hot = is_hot;}public String getPdesc() {return pdesc;}public void setPdesc(String pdesc) {this.pdesc = pdesc;}public int getPflag() {return pflag;}public void setPflag(int pflag) {this.pflag = pflag;}public String getCid() {return cid;}public void setCid(String cid) {this.cid = cid;}private String cid;
}	

utils代碼如下：

package beyondwsq.utils;import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;import javax.sql.DataSource;import com.mchange.v2.c3p0.ComboPooledDataSource;public class DataSourceUtils {private static DataSource dataSource = new ComboPooledDataSource();private static ThreadLocal<Connection> tl = new ThreadLocal<Connection>();// 直接可以獲取一個連接池public static DataSource getDataSource() {return dataSource;}public static Connection getConnection() throws SQLException{return dataSource.getConnection();}// 獲取連接對象public static Connection getCurrentConnection() throws SQLException {Connection con = tl.get();if (con == null) {con = dataSource.getConnection();tl.set(con);}return con;}// 開啟事務public static void startTransaction() throws SQLException {Connection con = getCurrentConnection();if (con != null) {con.setAutoCommit(false);}}// 事務回滾public static void rollback() throws SQLException {Connection con = getCurrentConnection();if (con != null) {con.rollback();}}// 提交并且 關閉資源及從ThreadLocall中釋放public static void commitAndRelease() throws SQLException {Connection con = getCurrentConnection();if (con != null) {con.commit(); // 事務提交con.close();// 關閉資源tl.remove();// 從線程綁定中移除}}// 關閉資源方法public static void closeConnection() throws SQLException {Connection con = getCurrentConnection();if (con != null) {con.close();}}public static void closeStatement(Statement st) throws SQLException {if (st != null) {st.close();}}public static void closeResultSet(ResultSet rs) throws SQLException {if (rs != null) {rs.close();}}
}

c3p0-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config><default-config><property name="user">root</property><property name="password">wsq</property><property name="driverClass">com.mysql.jdbc.Driver</property><property name="jdbcUrl">jdbc:mysql:///web17</property></default-config> 
</c3p0-config>