HTML Java-CSDN博客

本文链接：https://blog.csdn.net/qq_45151366/article/details/124721534

本文介绍了如何在Web应用中实现商品添加功能，包括HTML表单设计、Servlet（如Add和Addproduct）的使用，以及商品添加DAO层的SQL操作。同时，展示了查询商品的Servlet（findAllProductServlet）和数据库访问。

摘要由CSDN通过智能技术生成

查询页面
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>title</title>
</head>
<body>
<form action="findAll" method="get">
<input type="submit" value="查询">
</form>
</body>
</html>

添加页面
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>title</title>
</head>
<body>
    <h1>数据库查询操作：</h1>
    <form action="add" method="post">
        <p>商品编号：<input type="text" name="pid"></p>
        <p>商品名称：<input type="text" name="pname"></p>
        <p>单价：<input type="text" name="price"></p>
        <p>商品描述：<input type="text" name="pdesc"></p>
        <input type="submit" value="添加">
    </form>
</body>
</html>





添加商品
package com.qiku.web;

import com.qiku.dao.ProductDao;
import com.qiku.entity.Product;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
@WebServlet(name="addproduct",urlPatterns = "/add")
public class Add extends HttpServlet {
   private ProductDao productDao = new ProductDao();

    @Override
    protected void doGet (HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        try {
            Product product = new Product();
            product.setPid("32");
            product.setPname("大概是");
            product.setPrice(22.2);
            product.setPdesc("阿萨德个风格");
            int add = productDao.add(product);
            if(add>0){
                System.out.println("添加商品成功");
            }else{
                System.out.println("添加失败");
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

添加商品dao层

/    添加商品
    public int add(Product product) throws SQLException {
        QueryRunner qr=new QueryRunner(DruidUtils.dataSource);
        String sql="insert into product (pid,pname,price,pdesc)values(?,?,?,?)";
        int update= qr.update(sql,product.getPid(),product.getPname(),product.getPrice(),product.getPdesc());
        return update;
    }

查询商品dao层

package com.qiku.web;

import com.qiku.dao.ProductDao;
import com.qiku.entity.Product;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.List;

@WebServlet(name="findAllProductServlet",urlPatterns = "/findAllProduct")
public class FindAllProductServlet extends HttpServlet {
    //由于我们需要访问ProductDao中的方法，所有将其作为成员变量
    private ProductDao productDao = new ProductDao();

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        try {
            //执行查询所有商品的操作
            List<Product> allProduct = productDao.findAllProduct();
            //将allProduct 写出到页面上
            resp.setContentType("text/html;charset=utf-8");
            PrintWriter writer = resp.getWriter();
            for (Product p : allProduct) {
                writer.println(
                        "<h3>" + p.getPname() + "\t" + p.getPrice() + "\t" + p.getPdesc() + "</h3>");
            }
            writer.println("");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}