📄 admin_viewallbooks.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../ch.jsp" %>
<%@ include file="checkadmin.jsp"%>
<jsp:useBean id="viewbook" class="conndb.DbConnBean" scope="page" />
<%
String sql="select * from book";
int temp=-2;
temp=viewbook.select(sql);
Connection conn=viewbook.getConn();
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
String color="#FEEFF7";
int id=0;
%>
<!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">
<title>当前库中所有图书信息</title>
<style type="text/css">
<!--
body,td,th {
font-size: 13px;
}
body {
background-image: url(../images/R6C.GIF);
}
-->
</style>
</head>
<body>
<% if(temp==0){out.println("对不起,库中还没有图书,请<a href=admin_addnewbook.jsp><b>录入新书</b></a>.");}else{ %>
图书馆里所有图书信息
<table width="72%" border="0" cellspacing="0">
<tr>
<td><div align="right"><a href="searchbook.jsp">图书查询</a></div></td>
</tr>
</table>
<table width="80%" border="1" cellpadding="0" cellspacing="0" bordercolor="#00CC00">
<tr bgcolor="#00CCCC">
<td width="5%" align="center"><strong> 序号</strong></td>
<td width="37%" align="center"><strong> 书名</strong></td>
<td width="21%" align="center"><strong> 图书编号 </strong></td>
<td width="14%" align="center"><strong> 分类 </strong></td>
<td width="9%" align="center"><strong> 库存量 </strong></td>
<td width="14%" align="center">操作</td>
</tr>
<%
while(rs.next()){
String ids=rs.getString(1);
String booktitle=rs.getString(2);
String bookid=rs.getString(3);
String booktype=rs.getString(4);
int quantity=rs.getInt(5);
id++;
if(color=="#FEEFF7"){color="#F2FDF4";}
else{color="#FEEFF7";}
%> <tr bgcolor=<%=color%>>
<td align="center"><%=id%></td>
<td align="left"><%=booktitle%></td><td align="left"><%=bookid%></td><td align="left"><%=booktype%></td><td align="left"><%=quantity%></td>
<td align="center"> <a href="admin_changebook.jsp?ids=<%=ids%>">修改 </a><a href="admin_delbook.jsp?ids=<%=ids%>">删除 </a> </td>
</tr>
<%}}%>
<tr bgcolor="#99FFCC">
<td colspan="6"><center>当前库中一共有相关图书<%= id %>种
</center></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -