完成对超市商品的增删改查1、新建一个web工程名为shop2、新建数据库商品表goods字段有：编号 商品名 商品种类 商品价格 单位 更新时间说明：商品种类有： 蔬菜、乳制品、肉蛋、饮料、零食、主食单位有： 斤、袋、箱、包等3、编写dao entity servlet jsp html 等实现商品管理：1新增商品java代码

import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException;

public class GoodsDao { private String url = "jdbc:mysql://localhost:3306/shop"; private String username = "root"; private String password = "password";

public boolean addGoods(Goods goods) {
    try {
        Connection connection = DriverManager.getConnection(url, username, password);
        String sql = "INSERT INTO goods (name, category, price, unit, updated_at) VALUES (?, ?, ?, ?, ?)";
        PreparedStatement statement = connection.prepareStatement(sql);
        statement.setString(1, goods.getName());
        statement.setString(2, goods.getCategory());
        statement.setDouble(3, goods.getPrice());
        statement.setString(4, goods.getUnit());
        statement.setTimestamp(5, goods.getUpdatedAt());
        
        int rowsInserted = statement.executeUpdate();
        if (rowsInserted > 0) {
            return true;
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return false;
}

}

Entity代码：

public class Goods { private int id; private String name; private String category; private double price; private String unit; private Timestamp updatedAt;

// getters and setters

}

Servlet代码：

import java.io.IOException; import java.sql.Timestamp; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;

@WebServlet("/addGoods") public class AddGoodsServlet extends HttpServlet { private static final long serialVersionUID = 1L;

protected void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    String name = request.getParameter("name");
    String category = request.getParameter("category");
    double price = Double.parseDouble(request.getParameter("price"));
    String unit = request.getParameter("unit");
    Timestamp updatedAt = new Timestamp(System.currentTimeMillis());

    Goods goods = new Goods();
    goods.setName(name);
    goods.setCategory(category);
    goods.setPrice(price);
    goods.setUnit(unit);
    goods.setUpdatedAt(updatedAt);

    GoodsDao goodsDao = new GoodsDao();
    boolean success = goodsDao.addGoods(goods);

    if (success) {
        response.sendRedirect("success.jsp");
    } else {
        response.sendRedirect("error.jsp");
    }
}

}

JSP代码：

<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>Add Goods</title>
</head>
<body>
    <h1>Add Goods</h1>
    <form action="addGoods" method="post">
        <label for="name">Name:</label>
        <input type="text" id="name" name="name" required><br><br>
        
        <label for="category">Category:</label>
        <select id="category" name="category" required>
            <option value="蔬菜">蔬菜</option>
            <option value="乳制品">乳制品</option>
            <option value="肉蛋">肉蛋</option>
            <option value="饮料">饮料</option>
            <option value="零食">零食</option>
            <option value="主食">主食</option>
        </select><br><br>
        
        <label for="price">Price:</label>
        <input type="number" id="price" name="price" step="0.01" required><br><br>
        
        <label for="unit">Unit:</label>
        <input type="text" id="unit" name="unit" required><br><br>
        
        <input type="submit" value="Add">
    </form>
</body>
</html>

HTML代码