📄 bookinfo0.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
import="java.util.*" pageEncoding="gb2312" errorPage="../error.jsp"%>
<!DOCTYPE HTML PUBLIC "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<title>图书信息</title>
<style type="text/css">
<!--
body {
background-color: #B9DAF9;
}
.STYLE3 {font-family: "宋体"; font-size: 18px; }
-->
</style>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<jsp:useBean id="myRs" scope="page" class="utils.DBManager" />
<%
String userid = (String) session.getAttribute("userid");
if (userid == null)
response.sendRedirect("../index.jsp?error=2");
%>
<%
String sql = null;
java.sql.ResultSet rs = null;
%>
<%
sql = "select * from book";
try {
rs = myRs.executeQuery(sql);
} catch (Exception e) {
e.printStackTrace();
}
%>
<body>
<table width="1024" border="0" align="center">
<tr>
<td>
<img src="MainImages/Top.jpg" width="1024" height="126">
</td>
</tr>
<tr>
<td>
<table width="1024" border="0" background="MainImages/bg01.gif">
<tr>
<td width="192" valign="top">
<table width="100%" height="160" border="0">
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="../Main.jsp">首页</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="BookInfo.jsp">图书信息</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="BookQuery.jsp">书号查询</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="BookQuery.jsp">书名查询</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="BookAdd.jsp">增加图书</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="BookDel.jsp">删除图书</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="BookMod.jsp">修改图书</a>
</div>
</td>
</tr>
</table>
</td>
<td width="822" align="center">
<%
out.println("<table align=\"center\" border=\"1\" width=\"800\">");
out
.println("<tr><td>编号<td>名称<td>作者<td>出版商<td>出版日期<td>售价<td>简介</tr>");
while (rs.next()) {
out.println("<tr><td><a href=\"Book.jsp?bookid="
+ rs.getString("bookid") + "\">"
+ rs.getString("bookid") + "</a><td>"
+ rs.getString("bookname") + "<td>"
+ rs.getString("auther") + "<td>"
+ rs.getString("publisher") + "<td>"
+ rs.getDate("pbdate") + "<td>" + rs.getFloat("price")
+ "<td>" + rs.getString("detail") + "</tr>");
}
out.println("</table>");
%>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<p align="center">
<img src="MainImages/bottom.gif" width="1024" height="80"
border="0" usemap="#Map">
</p>
</td>
</tr>
</table>
<map name="Map">
<area shape="rect" coords="521,49,605,70"
href="mailto:zhangxuebo1025@163.com" target="_blank">
</map>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -