Java+JSP+Mysql+Tomcat实现Web图书管理系统

以下是一个简化的Java+JSP+MySQL+Tomcat实现的Web图书管理系统的核心代码示例。这个例子展示了如何连接数据库、执行查询以及处理用户的添加图书的请求。

// BookDAO.java
import java.sql.*;
 
public class BookDAO {
    private Connection conn = null;
    private PreparedStatement pstmt = null;
 
    public BookDAO() {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/book_db", "username", "password");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
 
    public boolean addBook(Book book) {
        try {
            String sql = "INSERT INTO books (title, author, isbn, published_year) VALUES (?, ?, ?, ?)";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, book.getTitle());
            pstmt.setString(2, book.getAuthor());
            pstmt.setString(3, book.getIsbn());
            pstmt.setInt(4, book.getPublishedYear());
            return pstmt.executeUpdate() > 0;
        } catch (SQLException e) {
            e.printStackTrace();
            return false;
        } finally {
            try {
                if (pstmt != null) pstmt.close();
                if (conn != null) conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}
 
// Book.java
public class Book {
    private String title;
    private String author;
    private String isbn;
    private int publishedYear;
 
    // Getters and Setters
    public String getTitle() {
        return title;
    }
 
    public void setTitle(String title) {
        this.title = title;
    }
 
    public String getAuthor() {
        return author;
    }
 
    public void setAuthor(String author) {
        this.author = author;
    }
 
    public String getIsbn() {
        return isbn;
    }
 
    public void setIsbn(String isbn) {
        this.isbn = isbn;
    }
 
    public int getPublishedYear() {
        return publishedYear;
    }
 
    public void setPublishedYear(int publishedYear) {
        this.publishedYear = publishedYear;
    }
}
 
// addBook.jsp
<%@ page import="com.example.BookDAO, com.example.Book" %>
<%
    String title = request.getParameter("title");
    String author = request.getParameter("author");
    String isbn = request.getParameter("isbn");
    String publishedYear = request.getParameter("publishedYear");
 
    Book book = new Book();
    b