java web实现商品添加源代码
时间: 2023-11-12 13:07:44 浏览: 39
以下是一个简单的Java Web实现商品添加的示例代码:
商品实体类:
```java
public class Product {
private int id;
private String name;
private double price;
private String description;
// getter和setter方法省略
}
```
商品DAO类:
```java
public class ProductDAO {
private Connection conn;
public ProductDAO(Connection conn) {
this.conn = conn;
}
public boolean addProduct(Product product) {
String sql = "INSERT INTO products (name, price, description) VALUES (?, ?, ?)";
try (PreparedStatement ps = conn.prepareStatement(sql)) {
ps.setString(1, product.getName());
ps.setDouble(2, product.getPrice());
ps.setString(3, product.getDescription());
int result = ps.executeUpdate();
return result > 0;
} catch (SQLException e) {
e.printStackTrace();
return false;
}
}
}
```
商品服务类:
```java
public class ProductService {
private ProductDAO productDAO;
public ProductService(ProductDAO productDAO) {
this.productDAO = productDAO;
}
public boolean addProduct(Product product) {
return productDAO.addProduct(product);
}
}
```
商品添加页面(add_product.jsp):
```html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>添加商品</title>
</head>
<body>
<h1>添加商品</h1>
<form action="add_product" method="post">
<label>名称:</label>
<input type="text" name="name"><br>
<label>价格:</label>
<input type="text" name="price"><br>
<label>描述:</label>
<textarea name="description"></textarea><br>
<input type="submit" value="添加">
</form>
</body>
</html>
```
添加商品的Servlet类(AddProductServlet.java):
```java
public class AddProductServlet extends HttpServlet {
private ProductService productService;
@Override
public void init() throws ServletException {
super.init();
try {
// 初始化数据库连接
Connection conn = ...;
ProductDAO productDAO = new ProductDAO(conn);
productService = new ProductService(productDAO);
} catch (SQLException e) {
e.printStackTrace();
}
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// 获取表单数据
String name = req.getParameter("name");
double price = Double.parseDouble(req.getParameter("price"));
String description = req.getParameter("description");
// 封装成商品对象
Product product = new Product();
product.setName(name);
product.setPrice(price);
product.setDescription(description);
// 调用商品服务类添加商品
boolean result = productService.addProduct(product);
if (result) {
// 添加成功,重定向到商品列表页面
resp.sendRedirect("product_list.jsp");
} else {
// 添加失败,返回错误信息
resp.getWriter().write("添加商品失败");
}
}
@Override
public void destroy() {
super.destroy();
// 关闭数据库连接
}
}
```
以上代码仅供参考,实际实现中可能需要根据具体情况进行适当调整和扩展。