图书管理系统

图书管理系统

后端：java+servlet+JSTL+Jsp

前端：html5+css3

数据库：mysql

服务器：tomcat

数据库：

// mysql  1.创建数据库表：
CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    description TEXT
);

// 2.创建一个Java类`Product`来表示商品：

//java
public class Product {
    private int id;
    private String name;
    private double price;
    private String description;

    // 构造方法、getter和setter方法省略
}

//3.创建一个`DBUtil`类来连接数据库：
// java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBUtil {
    private static final String URL = "jdbc:mysql://localhost:3306/product_management";
    private static final String USER = "root";
    private static final String PASSWORD = "your_password";

    public static Connection getConnection() {
        Connection conn = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");   // Java 8 以后使用 com.mysql.cj.jdbc.Driver
            conn = DriverManager.getConnection(URL, USER, PASSWORD);
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }
}

//4.创建一个`ProductDao`类来操作数据库：

//java
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

public class ProductDao {
    public List<Product> getAllProducts() {
        List<Product> products = new ArrayList<>();
        String sql = "SELECT * FROM products";
        try (Connection conn = DBUtil.getConnection();
             PreparedStatement pstmt = conn.prepareStatement(sql);
             ResultSet rs = pstmt.executeQuery()) {
            while (rs.next()) {
                Product product = new Product();
                product.setId(rs.getInt("id"));
                product.setName(rs.getString("name"));
                product.setPrice(rs.getDouble("price"));
                product.setDescription(rs.getString("description"));
                products.add(product);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return products;
    }

    // 其他增删查方法省略
}

//5.创建一个`ProductServlet`类来处理用户请求：

//jsp
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.util.List;

@WebServlet("/product")
public class ProductServlet extends HttpServlet {
    private ProductDao productDao = new ProductDao();

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        List<Product> products = productDao.getAllProducts();
        req.setAttribute("products", products);
        req.getRequestDispatcher("/product_list.jsp").forward(req, resp);
    }

    // 新增
     public void addProduct(Product product) {
    String sql = "INSERT INTO products (name, price, description) VALUES (?, ?, ?)";
    try (Connection conn = DBUtil.getConnection();
         PreparedStatement pstmt = conn.prepareStatement(sql)) {
        pstmt.setString(1, product.getName());
        pstmt.setDouble(2, product.getPrice());
        pstmt.setString(3, product.getDescription());
        pstmt.executeUpdate();
    } catch (Exception e) {
        e.printStackTrace();
    }
}
//删除
public void deleteProduct(int id) {
    String sql = "DELETE FROM products WHERE id = ?";
    try (Connection conn = DBUtil.getConnection();
         PreparedStatement pstmt = conn.prepareStatement(sql)) {
        pstmt.setInt(1, id);
        pstmt.executeUpdate();
    } catch (Exception e) {
        e.printStackTrace();
    }
}
//修改
public void updateProduct(Product product) {
    String sql = "UPDATE products SET name = ?, price = ?, description = ? WHERE id = ?";
    try (Connection conn = DBUtil.getConnection();
         PreparedStatement pstmt = conn.prepareStatement(sql)) {
        pstmt.setString(1, product.getName());
        pstmt.setDouble(2, product.getPrice());
        pstmt.setString(3, product.getDescription());
        pstmt.setInt(4, product.getId());
        pstmt.executeUpdate();
    } catch (Exception e) {
        e.printStackTrace();
    }
}

}


//6.创建一个JSP页面`product_list.jsp`来显示商品列表：

//

//jsp
<form action="/product" method="post">
    <input type="hidden" name="action" value="add">
    <input type="text" name="name" placeholder="名称">
    <input type="number" name="price" placeholder="价格">
    <input type="text" name="description" placeholder="描述">
    <input type="submit" value="添加">
</form>
<table border="1">
    <!-- 省略其他代码 -->
</table>
<form action="/product" method="post">
    <input type="hidden" name="action" value="delete">
    <input type="number" name="id" placeholder="ID">
    <input type="submit" value="删除">
</form>
<form action="/product" method="post">
    <input type="hidden" name="action" value="update">
    <input type="number" name="id" placeholder="ID">
    <input type="text" name="name" placeholder="名称">
    <input type="number" name="price" placeholder="价格">
    <input type="text" name="description" placeholder="描述">
    <input type="submit" value="修改">
</form>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>商品列表</title>
</head>
<body>
    <table border="1">
        <tr>
            <th>ID</th>
            <th>名称</th>
            <th>价格</th>
            <th>描述</th>
        </tr>
        <c:forEach items="${products}" var="product">
            <tr>
                <td>${product.id}</td>
                <td>${product.name}</td>
                <td>${product.price}</td>
                <td>${product.description}</td>
            </tr>
        </c:forEach>
    </table>
</body>
</html>

以上就是一个基本的关于图书管理系统的代码，希望可以帮到你，喜欢的朋友可以点赞+关注。