图书管理系统mfc+sql_JavaWeb实现增删查改(图书信息管理)之查询功能实现

数据库使用的是SqlServer，开发工具使用IDEA

此次实现的是增删查改，以图书信息管理为例，结构如下↓

接下来，就是项目，代码：↓index.jsp

图书管理系统主页

-----------------------书籍信息列表------------------------

编号 书名 作者 库存 价格 出版社 操作 ${book1.id} ${book1.name} ${book1.author} ${book1.number} ${book1.price} ${book1.pub} 删除 修改 没有任何书籍，可以点击选择 这里 添加书籍 /books/add">添加书籍信息

-----------------------------------------------------------

对应的servlet——bookList.java↓

package BookSystem.CRUD;import BookSystem.Other.Books;import BookSystem.Other.DButil;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.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;import java.util.ArrayList;import java.util.List;@WebServlet("/books/lst")public class BookList extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { List books = new ArrayList<>(); Connection conn = null; Statement stmt = null; ResultSet rs = null; try { conn = new DButil().getConnection(); stmt = conn.createStatement(); rs = stmt.executeQuery("select book_id, book_name, author, number , price , pub from BookInfo"); while (rs.next()) { Books books1 = new Books(rs.getInt(1), rs.getString(2), rs.getString(3), rs.getInt(4),rs.getFloat(5),rs.getString(6)); books.add(books1); } } catch (Exception ex) { ex.printStackTrace(); } finally { DButil.close(conn, stmt, rs); } req.setAttribute("aaa