欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

用servlet更新mysql数据不成功,没有报错,只是无法更新~求大神指点

程序员文章站 2022-04-09 14:35:09
...
mysqlservlet

这是更新的函数,在productdaoimpl类里:
public int updateProduct(Product product){
int flag = 0;
DBConnect conn = null;
PreparedStatement pstmt = null;

//update statement    String sql = "update productinfo set productnumber=?,productvalue=?  where productname=?";    try {//connect DB    conn = new DBConnect() ;    pstmt = conn.getConnection().prepareStatement(sql) ;    pstmt.setString(1, product.getProductnumber());    pstmt.setString(2, product.getProductvalue());    pstmt.setString(3, product.getProductname());//update    pstmt.executeUpdate();    flag = 1;    pstmt.close();    } catch (Exception e) {    e.printStackTrace();    } finally {    conn.close();    }    return flag;

}

updateServlet的代码:
package jspservlet.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import jspservlet.dao.ProductDAO;
import jspservlet.dao.impl.ProductDAOImpl;
import jspservlet.vo.Product;

public class ProductUpdateServlet extends HttpServlet {

 public void doGet(HttpServletRequest req, HttpServletResponse res)    throws IOException, ServletException{     this.doPost(req, res); } public void doPost(HttpServletRequest req, HttpServletResponse res)            throws IOException, ServletException{        Product product = new Product();        product.setProductname(req.getParameter("productname"));        ProductDAO dao=new ProductDAOImpl();        int flag = 0;        int flag2 = 1;        try {            flag2 = dao.queryByProductName(product);        } catch (Exception e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        if (flag2 == 1) {            res.sendRedirect("./errorRegister.jsp");        } else {        try {            flag = dao.updateProduct(product);        } catch (Exception e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        if( flag == 1) {            //session是干嘛的?            HttpSession session = req.getSession();            session.setAttribute("productname", product.getProductname());            res.sendRedirect("./success.jsp");        } else {            res.sendRedirect("./error.jsp");        }         } } 

}

JSP页面:



Delete Product





the name of the product you want to update:

    
productname :

the number and price of the product you want to change to:

productnumber :
productvalue :
相关标签: mysql servlet