📄 scanbook.jsp
字号:
<%@ page language="java" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DBbookscan" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'scanbook.jsp' starting page</title>
<link rel="stylesheet" type="text/css" href="../css/admin.css">
</head>
<body leftMargin=0 topMargin=0 BGCOLOR="#FFCCCC">
<TABLE class=navi cellSpacing=1 align=center border=0>
<TBODY>
<TR>
<TH colSpan=2>当前位置:系统管理>>图书信息管理>>图书预览</TH></TR>
<TR>
<TD align=right>[<A href="bookinfo.jsp">所有图书</A>] [<A href="addbook.jsp">新增图书</A>] [<A href="index.jsp">回首页</A>]</TD>
</TR>
</TBODY>
</TABLE><br>
<%
try{
ResultSet rs1=null;
String id=request.getParameter("ID");
String strsql="select * from bookinfo where BookNo='"+id+"'";
rs1=DBbookscan.executeQuery(strsql);
rs1.next();
String no=rs1.getString("BookNo");
String name=rs1.getString("BookName");
String zuozhe=rs1.getString("Author");
String lei=rs1.getString("BookClass");
String pub=rs1.getString("Publish");
String pic=rs1.getString("Pictrue");
String con=rs1.getString("Content");
String pri=rs1.getString("Price");
String shu=rs1.getString("Amount");
String yushu=rs1.getString("Leav_number");
String tim=rs1.getString("RegTime");
String spri=rs1.getString("SalePrice");
%>
<form action="bookinfo.jsp" method=post name=fanform>
<TABLE class=list cellSpacing=1 align=center>
<tr>
<th colspan=3 align=center><font size=3>该书信息预览如下：</font></th>
</tr>
<tr>
<td align=center>
<img src="../upload/<% out.print(pic);%>" border=0>
</td>
<td>
<font face="华文楷体" size=3>书号：</font> <% out.print(no);%>
<br>
<font face="华文楷体" size=3>书名：</font> <% out.print(name);%>
<br>
<font face="华文楷体" size=3>作者：</font> <% out.print(zuozhe);%>
<br>
<font face="华文楷体" size=3>出版：</font> <% out.print(pub);%>
<br>
<font face="华文楷体" size=3>所属分类：</font> <% out.print(lei);%>
<br>
<font face="华文楷体" size=3>总数：</font> <% out.print(shu);%> 册
<br>
<font face="华文楷体" size=3>余数：</font> <% out.print(yushu);%> 册
<br>
<font face="华文楷体" size=3>上架时间：</font> <% out.print(tim);%>
<br>
<font face="华文楷体" size=3>原价：</font> ￥<% out.print(pri);%>
<br>
<font face="华文楷体" size=3>半岛价：</font> ￥<% out.print(spri);%>
<br>
<font face="华文楷体" size=3>介绍：</font> <% out.print(con);%>
</td>
</tr>
<tr>
<td colspan=3 align=center><input type=submit value=返 回></td>
</tr>
</table>
</form>
<br>
<%
}catch(Exception e){out.print(e);}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -