jsp图书管理系统源码

<%@ page import="java.sql.*" %>
<%
    String bookName = request.getParameter("bookName");
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/library", "username", "password");
        String sql = "SELECT * FROM books WHERE name LIKE ?";
        pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, "%" + bookName + "%");
        rs = pstmt.executeQuery();
%>
<table border="1">
    <tr>
        <th>ID</th>
        <th>Name</th>
        <th>Author</th>
    </tr>
<%
        while (rs.next()) {
%>
    <tr>
        <td><%= rs.getInt("id") %></td>
        <td><%= rs.getString("name") %></td>
        <td><%= rs.getString("author") %></td>
    </tr>
<%
        }
%>
</table>
<%
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        try { if (rs != null) rs.close(); } catch (Exception e) {}
        try { if (pstmt != null) pstmt.close(); } catch (Exception e) {}
        try { if (conn != null) conn.close(); } catch (Exception e) {}
    }
%>