<%@page import="javabean.JDBCBean"%> <%@page import="java.sql.ResultSet"%> <%@page import="javabean.Admin"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> bookedit <% JDBCBean db = new JDBCBean(); int id = Integer.parseInt(request.getParameter("id")); ResultSet resultSet = null; ResultSet librarySet = null; ResultSet bookSortSet = null; String sql = "select * from books where id=" +id ; resultSet = db.executeQuery(sql); resultSet.next(); String name = resultSet.getString("name"); String author = resultSet.getString("author"); int library_id = resultSet.getInt("library_id"); int sort_id = resultSet.getInt("sort_id"); String position = resultSet.getString("position"); int status = resultSet.getInt("status"); String description = resultSet.getString("description"); db.close(); // 获取图书馆列表 JDBCBean db2 = new JDBCBean(); String librarySql = "select * from library"; librarySet = db2.executeQuery( librarySql ); // 获取书籍分类 JDBCBean db3 = new JDBCBean(); String bookSortSql = "select * from book_sort"; bookSortSet = db3.executeQuery( bookSortSql ); %>
<%-- 隐藏id --%> class="layui-hide">
required lay-verify="required" placeholder="请输入书名" autocomplete="off" class="layui-input">
required lay-verify="required" placeholder="请输入作者" autocomplete="off" class="layui-input">
required lay-verify="required" placeholder="请输入位置编号" autocomplete="off" class="layui-input">
> >
<% // 关闭资源 bookSortSet.close(); librarySet.close(); resultSet.close(); db.close(); %>