以下是一个简化的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