📄 books_management.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<jsp:useBean scope="page" id="books" class="dlut.Books" />
<jsp:useBean scope="page" id="sorts" class="dlut.Sorts" />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel=stylesheet type=text/css href="../lib/book.css">
<title>欢迎光临Books Online</title>
<style type="text/css">
<!--
.STYLE1 {color: #000000}
-->
</style>
</head>
<body bgcolor="#F4FFFE">
<div align="center">
<form name="form1" action="delete_book.jsp" method="post" target="_self">
<table width="95%" border="0" cellpadding="0" cellspacing="1">
<tr bgcolor="#0066FF">
<td width="5%" height="20" align="center" bgcolor="#CCFF00"><span class="STYLE1">选中</span></td>
<td width="15%" height="20" align="center" bgcolor="#CCFF00"><span class="STYLE1">图书类别</span></td>
<td width="30%" height="20" align="center" bgcolor="#CCFF00"><span class="STYLE1">图书名称</span></td>
<td width="15%" height="20" align="center" bgcolor="#CCFF00"><span class="STYLE1">作者</span></td>
<td width="25%" height="20" align="center" bgcolor="#CCFF00"><span class="STYLE1">出版社</span></td>
<td width="10%" height="20" align="center" bgcolor="#CCFF00"><span class="STYLE1">修改</span></td>
</tr>
<%
ResultSet rs = books.showBooks();
while(rs.next())
{
//显示数据
long l_BookID = rs.getLong("BookID");
String s_BookName = rs.getString("BookName");
String s_Pub = rs.getString("Pub");
String s_Author = rs.getString("Author");
long l_SortID = rs.getLong("SortID");
sorts.setSortID(l_SortID);
if(sorts.init())
{
%>
<tr>
<td width="5%" height="20" align="center"><input type="checkbox" name="DeleteID" value='<%=l_BookID%>'></td>
<td width="15%" height="20" align="left"> <%=sorts.getSortName()%></td>
<td width="30%" height="20" align="left"> <a href="../normal/book_detail.jsp?BookID=<%=l_BookID%>" target="_self"><font color="#0000FF"><%=s_BookName%></font></a></td>
<td width="15%" height="20" align="left"> <%=s_Author%></td>
<td width="25%" height="20" align="left"> <%=s_Pub%></td>
<td width="10%" height="20" align="center"><a href="modify_book_form.jsp?BookID=<%=l_BookID%>" target="_self"><font color="#0000FF">修改</font></a></td>
</tr>
<%
}
}
%>
</table>
<p><a href="javascript:form1.submit()" target="_self"><font color="#0000FF">删除选中的图书</font></a> <a href="add_book_form.jsp" target="_self"><font color="#0000FF">添加新图书</font></a></p>
</form>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -