IGeekShop案例4-修改商品

比眉伴天荒 2024-04-17 14:05 35阅读 0赞

# IGeekShop案例4-修改商品 #

## 1 完成商品信息的回显 ##

### 1 修改list.jsp ###

<%@ page language="java" pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <HTML>
    <HEAD>
    <meta http-equiv="Content-Language" content="zh-cn">
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <link href="${pageContext.request.contextPath}/css/Style1.css"
        rel="stylesheet" type="text/css" />
    <script language="javascript"
        src="${pageContext.request.contextPath}/js/public.js"></script>
    <script type="text/javascript" src="${pageContext.request.contextPath }/js/jquery-1.11.3.min.js"></script>
    <script type="text/javascript">
                function addProduct(){
                    window.location.href = "${pageContext.request.contextPath}/adminAddProductUI";
                }
                function delProduct(pid){
                    var flag = confirm("你确认要删除吗？");
                    /* alert(pid); */
                    /* alert(flag); */
                    if(flag){
                        location.href="${pageContext.request.contextPath}/delProduct?pid="+pid;
                    }
                }
                function editProduct(pid){
                    /* alert(pid); */
                    location.href="${pageContext.request.contextPath}/adminEditProduct?pid="+pid;
                }
                
            </script>
    </HEAD>
    <body>
        <br>
        <form id="Form1" name="Form1"
            action="${pageContext.request.contextPath}/user/list.jsp"
            method="post">
            <table cellSpacing="1" cellPadding="0" width="100%" align="center"
                bgColor="#f5fafe" border="0">
                <TBODY>
                    <tr>
                        <td class="ta_01" align="center" bgColor="#afd1f3"><strong>商品列表</strong>
                        </TD>
                    </tr>
                    <tr>
                        <td class="ta_01" align="right">
                            <button type="button" id="add" name="add" value="添加"
                                class="button_add" onclick="addProduct()">
                                添加</button>
    
                        </td>
                    </tr>
                    <tr>
                        <td class="ta_01" align="center" bgColor="#f5fafe">
                            <table cellspacing="0" cellpadding="1" rules="all"
                                bordercolor="gray" border="1" id="DataGrid1"
                                style="BORDER-RIGHT: gray 1px solid; BORDER-TOP: gray 1px solid; BORDER-LEFT: gray 1px solid; WIDTH: 100%; WORD-BREAK: break-all; BORDER-BOTTOM: gray 1px solid; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: #f5fafe; WORD-WRAP: break-word">
                                <tr
                                    style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; HEIGHT: 25px; BACKGROUND-COLOR: #afd1f3">
    
                                    <td align="center" width="18%">序号</td>
                                    <td align="center" width="17%">商品图片</td>
                                    <td align="center" width="17%">商品名称</td>
                                    <td align="center" width="17%">商品价格</td>
                                    <td align="center" width="17%">是否热门</td>
                                    <td width="7%" align="center">编辑</td>
                                    <td width="7%" align="center">删除</td>
                                </tr>
                                
                                <c:forEach items="${productList }" var="product" varStatus="vs">
                                
                                    <tr onmouseover="this.style.backgroundColor = 'white'"
                                        onmouseout="this.style.backgroundColor = '#F5FAFE';">
                                        <td style="CURSOR: hand; HEIGHT: 22px" align="center"
                                            width="18%">${vs.count }</td>
                                        <td style="CURSOR: hand; HEIGHT: 22px" align="center"
                                            width="17%"><img width="40" height="45" src="${pageContext.request.contextPath }/${product.pimage }"></td>
                                        <td style="CURSOR: hand; HEIGHT: 22px" align="center"
                                            width="17%">${product.pname }</td>
                                        <td style="CURSOR: hand; HEIGHT: 22px" align="center"
                                            width="17%">${product.shop_price }</td>
                                        <td style="CURSOR: hand; HEIGHT: 22px" align="center"
                                            width="17%">
                                            ${product.is_hot==1?"是":"否" }</td>
                                        <td align="center" style="HEIGHT: 22px"><a
                                            href="javascript:void(0)" onclick="editProduct(${product.pid})">
                                                <img
                                                src="${pageContext.request.contextPath}/images/i_edit.gif"
                                                border="0" style="CURSOR: hand">
                                        </a></td>
            
                                        
                                        <td align="center" style="HEIGHT: 22px"><a href="javascript:void(0)" onclick="delProduct(${product.pid})"> <img
                                                src="${pageContext.request.contextPath}/images/i_del.gif"
                                                width="16" height="16" border="0" style="CURSOR: hand">
                                        </a></td>
                                    </tr>
                                </c:forEach>
                            </table>
                        </td>
                    </tr>
    
                </TBODY>
            </table>
        </form>
    </body>
    </HTML>

### 2 web层AdminEditProductServlet ###

package www.test.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 www.test.domain.Category;
    import www.test.domain.Product;
    import www.test.service.AdminProductService;
    
    public class AdminEditProductServlet extends HttpServlet {
    
        public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    
            // 获取数据
            String pid = request.getParameter("pid");
    //        System.out.println(pid);
            // 传递数据到service层
            AdminProductService service = new AdminProductService();
            Product product = null;
            try {
                product = service.editProduct(pid);
            } catch (SQLException e) {
                
                e.printStackTrace();
            }
            
    //        System.out.println(product);
            // 将数据传递给request域
            request.setAttribute("product", product);
            
            
            //获得所有的商品的类别数据
             List<Category> categoryList = null;
             try {
                categoryList =  service.findAllCategory();
            } catch (SQLException e) {
                
                e.printStackTrace();
            }
    //         System.out.println(categoryList);
            // 将获取到的categoryList存储到request域中
            request.setAttribute("categoryList", categoryList);
    
            request.getRequestDispatcher("/admin/product/edit.jsp").forward(request, response);
        }
    
        public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
            doGet(request, response);
        }
    
    }

### 3 service层AdminProductService ###

package www.test.service;
    
    import java.sql.SQLException;
    import java.util.List;
    
    import www.test.dao.AdminProductDao;
    import www.test.domain.Category;
    import www.test.domain.Product;
    
    public class AdminProductService {
    
        public List<Product> findAllProduct() throws SQLException {
    
             //因为没有复杂业务 直接传递请求到dao层
            AdminProductDao dao = new AdminProductDao();
            return dao.findAllProduct();
        }
    
        
        public List<Category> findAllCategory() throws SQLException {
            
            AdminProductDao dao = new AdminProductDao();
            return dao.finAllCategory();
             
        }
    
    
        // 添加商品
        public boolean addProduct(Product product) throws SQLException {
            AdminProductDao dao = new AdminProductDao();
            return dao.addProduct(product);
    
        }
    
    
        //删除数据
        public boolean delProduct(String pid) throws SQLException {
            AdminProductDao dao = new AdminProductDao();
            return dao.delProduct(pid);
        }
    
    
        // 修改数据
        public Product editProduct(String pid) throws SQLException {
            AdminProductDao dao = new AdminProductDao();
            return dao.editProduct(pid);
        }
    
       //保存修改后的数据
        public boolean editProductSave(Product product) throws SQLException {
            
            AdminProductDao dao = new AdminProductDao();
            return dao.editProductSave(product);
        }
    
    }

### 4 dao层AdminProductDao ###

package www.test.dao;
    
    import java.sql.SQLException;
    import java.util.List;
    
    import org.apache.commons.dbutils.QueryRunner;
    import org.apache.commons.dbutils.handlers.BeanHandler;
    import org.apache.commons.dbutils.handlers.BeanListHandler;
    
    import www.test.domain.Category;
    import www.test.domain.Product;
    import www.test.utils.C3P0Utils;
    
    public class AdminProductDao {
    
        public List<Product> findAllProduct() throws SQLException {
            
            QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
            String sql = "select * from product";
            List<Product> productList = qr.query(sql, new BeanListHandler<Product>(Product.class));
            return productList;
        }
    
        public List<Category> finAllCategory() throws SQLException {
            QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
            String sql = "select * from category";
            List<Category> categoryList = qr.query(sql, new BeanListHandler<Category>(Category.class));
            return categoryList;
        }
    
        //添加数据
        public boolean addProduct(Product product) throws SQLException {
            QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
            String sql = "insert into product values(?,?,?,?,?,?,?,?,?,?)";
            Object[] params = {product.getPid(),product.getPname(),product.getMarket_price(),product.getShop_price(),product.getPimage(),product.getPdate(),product.getIs_hot(),product.getPdesc(),product.getPflag(),product.getCid()};
            int num = qr.update(sql, params);
            if(num>0){
                return true;
            }else{
                return false;
            }
            
        }
    
        // 删除数据
        public boolean delProduct(String pid) throws SQLException {
            QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
            String sql = "delete from product where pid=?";
            int num = qr.update(sql, pid);
            if(num>0){
                return true;
            }else{
                return false;
            }
        }
    
        //修改数据
        public Product editProduct(String pid) throws SQLException {
            QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
            String sql = "select * from product where pid=?";
            Product product = qr.query(sql, new BeanHandler<Product>(Product.class),pid);
            return product;
        }
    
        public boolean editProductSave(Product product) throws SQLException {
            QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
            String sql = "update product set pname=?,market_price=?,shop_price=?,pimage=?,pdate=?,is_hot=?,pdesc=?,pflag=?,cid=? where pid=?";
            int num = qr.update(sql, product.getPname(),product.getMarket_price(),
                    product.getShop_price(),product.getPimage(),product.getPdate(),product.getIs_hot(),
                    product.getPdesc(),product.getPflag(),product.getCid(),product.getPid());
            System.out.println(num);
            if(num>0){
                return true;
            }else{
                return false;
            }
        }
    }

### 5 修改edit.jsp代码 ###

<%@ page language="java" pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <HTML>
        <HEAD>
            <meta http-equiv="Content-Language" content="zh-cn">
            <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
            <LINK href="${pageContext.request.contextPath}/css/Style1.css" type="text/css" rel="stylesheet">
            <script type="text/javascript" src="${pageContext.request.contextPath }/js/jquery-1.11.3.min.js"></script>
            <script type="text/javascript">
            $(function(){
                //获得当前回显的product的cid
                $("#cid option[value='${product.cid }']").prop("selected",true);
            });
            
            //页面加载完毕后 确定那个option被选中
            /* window.onload = function(){
                //获得当前回显的product的cid
                var cid = "${product.cid }";
                //获得所有的<select name="cid">下的option
                var options = document.getElementById("cid").getElementsByTagName("option");
                //比较每一个option的value与cid
                for(var i=0;i<options.length;i++){
                    if(cid==options[i].value){
                        options[i].selected = true;
                    }
                }
            } */
            
            </script>
        </HEAD>
        
        <body>
            
            <form id="userAction_save_do" name="Form1" action="${pageContext.request.contextPath}/adminEditProductSave" method="post" >
            
                
                <input type="hidden" name="pid" value="${product.pid }">
                
                <table cellSpacing="1" cellPadding="5" width="100%" align="center" bgColor="#eeeeee" style="border: 1px solid #8ba7e3" border="0">
                    <tr>
                        <td class="ta_01" align="center" bgColor="#afd1f3" colSpan="4"
                            height="26">
                            <strong><STRONG>编辑商品</STRONG>
                            </strong>
                        </td>
                    </tr>
    
                    <tr>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            商品名称：
                        </td>
                        <td class="ta_01" bgColor="#ffffff">
                            <input type="text" name="pname" value="${product.pname }" id="userAction_save_do_logonName" class="bg"/>
                        </td>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            是否热门：
                        </td>
                        <td class="ta_01" bgColor="#ffffff">
                            
                            <select name="is_hot">
                                <option value="${product.is_hot }">${product.is_hot==1?"是":"否" }</option>
                            </select>
                        </td>
                    </tr>
                    <tr>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            市场价格：
                        </td>
                        <td class="ta_01" bgColor="#ffffff">
                            <input type="text" name="market_price" value="${product.market_price }" id="userAction_save_do_logonName" class="bg"/>
                        </td>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            商城价格：
                        </td>
                        <td class="ta_01" bgColor="#ffffff">
                            <input type="text" name="shop_price" value="${product.shop_price} " id="userAction_save_do_logonName" class="bg"/>
                        </td>
                    </tr>
                    <tr>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            商品图片：
                        </td>
                        <td class="ta_01" bgColor="#ffffff" colspan="3">
                            <input type="file" name="upload" />
                        </td>
                    </tr>
                    <tr>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            所属分类：
                        </td>
                        <td class="ta_01" bgColor="#ffffff" colspan="3">
                            <select id="cid"  name="cid">
                                <c:forEach items="${categoryList }" var="category">
                                    <option value="${category.cid }">${category.cname } </option>
                                </c:forEach>
                            </select>
                        </td>
                    </tr>
                    <tr>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            商品描述：
                        </td>
                        <td class="ta_01" bgColor="#ffffff" colspan="3">
                            <textarea name="pdesc" rows="5" cols="30">
                                ${product.pdesc}
                            </textarea>
                        </td>
                    </tr>
                    <tr>
                        <td class="ta_01" style="WIDTH: 100%" align="center"
                            bgColor="#f5fafe" colSpan="4">
                            <button type="submit" id="userAction_save_do_submit" value="确定" class="button_ok">
                                确认
                            </button>
    
                            <FONT face="宋体">       </FONT>
                            <button type="reset" value="重置" class="button_cancel">重置</button>
    
                            <FONT face="宋体">       </FONT>
                            <INPUT class="button_ok" type="button" onclick="history.go(-1)" value="返回"/>
                            <span id="Label1"></span>
                        </td>
                    </tr>
                </table>
            </form>
        </body>
    </HTML>

## 2 完成修改后的保存操作 ##

### 1 修改edit.jsp代码 ###

<%@ page language="java" pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <HTML>
        <HEAD>
            <meta http-equiv="Content-Language" content="zh-cn">
            <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
            <LINK href="${pageContext.request.contextPath}/css/Style1.css" type="text/css" rel="stylesheet">
            <script type="text/javascript" src="${pageContext.request.contextPath }/js/jquery-1.11.3.min.js"></script>
            <script type="text/javascript">
            $(function(){
                //获得当前回显的product的cid
                $("#cid option[value='${product.cid }']").prop("selected",true);
            });
            
            //页面加载完毕后 确定那个option被选中
            /* window.onload = function(){
                //获得当前回显的product的cid
                var cid = "${product.cid }";
                //获得所有的<select name="cid">下的option
                var options = document.getElementById("cid").getElementsByTagName("option");
                //比较每一个option的value与cid
                for(var i=0;i<options.length;i++){
                    if(cid==options[i].value){
                        options[i].selected = true;
                    }
                }
            } */
            
            </script>
        </HEAD>
        
        <body>
            
            <form id="userAction_save_do" name="Form1" action="${pageContext.request.contextPath}/adminEditProductSave" method="post" >
            
                
                <input type="hidden" name="pid" value="${product.pid }">
                
                <table cellSpacing="1" cellPadding="5" width="100%" align="center" bgColor="#eeeeee" style="border: 1px solid #8ba7e3" border="0">
                    <tr>
                        <td class="ta_01" align="center" bgColor="#afd1f3" colSpan="4"
                            height="26">
                            <strong><STRONG>编辑商品</STRONG>
                            </strong>
                        </td>
                    </tr>
    
                    <tr>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            商品名称：
                        </td>
                        <td class="ta_01" bgColor="#ffffff">
                            <input type="text" name="pname" value="${product.pname }" id="userAction_save_do_logonName" class="bg"/>
                        </td>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            是否热门：
                        </td>
                        <td class="ta_01" bgColor="#ffffff">
                            
                            <select name="is_hot">
                                <option value="${product.is_hot }">${product.is_hot==1?"是":"否" }</option>
                            </select>
                        </td>
                    </tr>
                    <tr>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            市场价格：
                        </td>
                        <td class="ta_01" bgColor="#ffffff">
                            <input type="text" name="market_price" value="${product.market_price }" id="userAction_save_do_logonName" class="bg"/>
                        </td>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            商城价格：
                        </td>
                        <td class="ta_01" bgColor="#ffffff">
                            <input type="text" name="shop_price" value="${product.shop_price} " id="userAction_save_do_logonName" class="bg"/>
                        </td>
                    </tr>
                    <tr>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            商品图片：
                        </td>
                        <td class="ta_01" bgColor="#ffffff" colspan="3">
                            <input type="file" name="upload" />
                        </td>
                    </tr>
                    <tr>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            所属分类：
                        </td>
                        <td class="ta_01" bgColor="#ffffff" colspan="3">
                            <select id="cid"  name="cid">
                                <c:forEach items="${categoryList }" var="category">
                                    <option value="${category.cid }">${category.cname } </option>
                                </c:forEach>
                            </select>
                        </td>
                    </tr>
                    <tr>
                        <td width="18%" align="center" bgColor="#f5fafe" class="ta_01">
                            商品描述：
                        </td>
                        <td class="ta_01" bgColor="#ffffff" colspan="3">
                            <textarea name="pdesc" rows="5" cols="30">
                                ${product.pdesc}
                            </textarea>
                        </td>
                    </tr>
                    <tr>
                        <td class="ta_01" style="WIDTH: 100%" align="center"
                            bgColor="#f5fafe" colSpan="4">
                            <button type="submit" id="userAction_save_do_submit" value="确定" class="button_ok">
                                确认
                            </button>
    
                            <FONT face="宋体">       </FONT>
                            <button type="reset" value="重置" class="button_cancel">重置</button>
    
                            <FONT face="宋体">       </FONT>
                            <INPUT class="button_ok" type="button" onclick="history.go(-1)" value="返回"/>
                            <span id="Label1"></span>
                        </td>
                    </tr>
                </table>
            </form>
        </body>
    </HTML>

### 2 web层AdminEditProductSaveServlet ###

package www.test.web;
    
    import java.io.IOException;
    import java.lang.reflect.InvocationTargetException;
    import java.sql.SQLException;
    import java.text.SimpleDateFormat;
    import java.util.Date;
    import java.util.Map;
    import java.util.UUID;
    
    import javax.servlet.ServletException;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    
    import org.apache.commons.beanutils.BeanUtils;
    
    import www.test.domain.Product;
    import www.test.service.AdminProductService;
    
    public class AdminEditProductSaveServlet extends HttpServlet {
    
        public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    
             //解决乱码问题
            request.setCharacterEncoding("UTF-8");
            //获取数据
            Map<String, String[]> parameterMap = request.getParameterMap();
            //使用BeanUtils进行子映射封装
            Product  product = new Product();
            try {
                BeanUtils.populate(product, parameterMap);
            } catch (IllegalAccessException | InvocationTargetException e) {
                
                e.printStackTrace();
            }
            //此位置Product已经封装完毕----将表单的数据封装完毕
            //手动设置表单中没有数据
    
            //2）private String pimage;
            product.setPimage("products/1/c_0033.jpg");
           //3）private String pdate;//上架日期
            SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
            String pdate = format.format(new Date());
            product.setPdate(pdate);
            //4）private int pflag;//商品是否下载 0代表未下架
            product.setPflag(0);
           System.out.println(product);
            // 3 传递数据给service层
            AdminProductService service = new AdminProductService();
            boolean isSuccess = true;
            try {
                isSuccess = service.editProductSave(product);
            } catch (SQLException e) {
                
                e.printStackTrace();
            }
            System.out.println(isSuccess);
            //将处理结果存储到request域中
            request.setAttribute("isSuccess", isSuccess);
             //跳转到列表页面
            //response.sendRedirect(request.getContextPath()+"/adminProductList");
            request.getRequestDispatcher("/adminProductList").forward(request, response);
        }
    
        public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
            doGet(request, response);
        }
    
    }

### 3 service层AdminProductService ###

### 4 dao层AdminProductDao ###

package www.test.dao;
    
    import java.sql.SQLException;
    import java.util.List;
    
    import org.apache.commons.dbutils.QueryRunner;
    import org.apache.commons.dbutils.handlers.BeanHandler;
    import org.apache.commons.dbutils.handlers.BeanListHandler;
    
    import www.test.domain.Category;
    import www.test.domain.Product;
    import www.test.utils.C3P0Utils;
    
    public class AdminProductDao {
    
        public List<Product> findAllProduct() throws SQLException {
            
            QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
            String sql = "select * from product";
            List<Product> productList = qr.query(sql, new BeanListHandler<Product>(Product.class));
            return productList;
        }
    
        public List<Category> finAllCategory() throws SQLException {
            QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
            String sql = "select * from category";
            List<Category> categoryList = qr.query(sql, new BeanListHandler<Category>(Category.class));
            return categoryList;
        }
    
        //添加数据
        public boolean addProduct(Product product) throws SQLException {
            QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
            String sql = "insert into product values(?,?,?,?,?,?,?,?,?,?)";
            Object[] params = {product.getPid(),product.getPname(),product.getMarket_price(),product.getShop_price(),product.getPimage(),product.getPdate(),product.getIs_hot(),product.getPdesc(),product.getPflag(),product.getCid()};
            int num = qr.update(sql, params);
            if(num>0){
                return true;
            }else{
                return false;
            }
            
        }
    
        // 删除数据
        public boolean delProduct(String pid) throws SQLException {
            QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
            String sql = "delete from product where pid=?";
            int num = qr.update(sql, pid);
            if(num>0){
                return true;
            }else{
                return false;
            }
        }
    
        //修改数据
        public Product editProduct(String pid) throws SQLException {
            QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
            String sql = "select * from product where pid=?";
            Product product = qr.query(sql, new BeanHandler<Product>(Product.class),pid);
            return product;
        }
    
        //保存修改后的数据
        public boolean editProductSave(Product product) throws SQLException {
            QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
            String sql = "update product set pname=?,market_price=?,shop_price=?,pimage=?,pdate=?,is_hot=?,pdesc=?,pflag=?,cid=? where pid=?";
            int num = qr.update(sql, product.getPname(),product.getMarket_price(),
                    product.getShop_price(),product.getPimage(),product.getPdate(),product.getIs_hot(),
                    product.getPdesc(),product.getPflag(),product.getCid(),product.getPid());
            System.out.println(num);
            if(num>0){
                return true;
            }else{
                return false;
            }
        }
    }

## 3 总结 ##

此项目采用DAO设计模式，DAO(Data Access Objects)设计模式是属于J2EE体系架构中的数据层的操作。

### 一、为什么要用DAO? ###

比较在JSP页面中使用JDBC来连接数据库，这样导致了JSP页面中包含了大量的HTML代码和JSP代码，将显示和功能代码混在一起，难以维护。并且在JSP页面中使用JDBC代码，必须导入相应的"java.sql.\*"包。基于使得JSP页面专注于数据的表现的思想，我们只是希望JSP主要负责数据的显示，而不需要关注数据的来源和途径。同时在JSP进行JDBC操作，重复编码太多。如，不同的页面连接同一个数据库时需要在每个页面中都进行JDBC编码。

DAO设计模式提供了一种通用的模式，来简化大量的代码，增强程序的可移植性。

### 二、DAO组成 ###

在这个模式中DAO主要完成数据的操作，客户端依靠DAO接口进行操作，服务端要将接口进行具体实现。DAO的主要组成由以下几个部分组成。

1、DatabaseConnection：专门负责数据库打开与关闭操作的类。
    
        2、VO：主要由属性、setter、getter方法，VO类中的属性与数据表中的字段相对应。每一个VO对象相当于表中的一条记录。
    
        3、DAO接口：主要定义数据库操作的接口，定义数据库的原子性操作，如增删改，按ID查询。
    
        4、Impl：DAO的具体实现类，完成具体的数据库操作，但是不负责数据库的打开和关闭，接口类的名称首字母用“I”，表示其是一个接口。
    
        5、Proxy：代理实现类。主要完成数据库的打开和关闭，并调用Impl类对象(真实对象类)的操作，之所以增加代理类是为了以后的拓展，如果一个程序可以A-B，那么中间最好加一个过渡，使用A-C-B的形式，可以有效减少程序的耦合度，使开发结构更加清晰。
    
        6、Factory：工厂类，通过工厂类取得一个DAO的实例化对象，编写工厂类也是为了降低代码的耦合度，工厂类产生实例的方法通常是静态函 数，这样一来就可以通过工厂类名直接生成实例。

### 题外 ###

不删除表单中的enctype获取不到数据。

<input type="hidden" name="pid" value="${product.pid }">