图书管理系统

图书管理系统

后端：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 getAllProducts() {
        List 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 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

    
    
    
    
    



    
    
    


    
    
    
    
    
    

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    


    
            

        

            
ID
            
名称
            
价格
            
描述
        
        

                
${product.id}
                
${product.name}
                
${product.price}
                
${product.description}
            
        
    

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