📄 shujixinxichaxun.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="sql2005_book.jsp"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE1 {
font-family: "方正胖头鱼简体";
color: #99FF00;
font-size: 36px;
}
.STYLE3 {
color: #669900;
font-size: 16px;
}
-->
</style>
</head>
<%
request.setCharacterEncoding("GBK");
String bookid = request.getParameter("bookid");
String sql = "{call get_bookInfo(?)}";
cstmt=conn.prepareCall(sql);
cstmt.setString(1,bookid);
rs = cstmt.executeQuery();
%>
<body>
<div align="center">
<center>
<marquee align = "center" direction="left" behavior = scroll width="70%">
<p align=center class="STYLE8 STYLE9 STYLE1">查询结果如下：
<p>
</marquee>
</center>
<table width="848" height="49" border="1">
<tr>
<th width="69" height="43" scope="col"><span class="STYLE3">书籍编号</span></th>
<th width="129" class="STYLE3" scope="col">书籍名称</th>
<th width="96" class="STYLE3" scope="col">书籍作者</th>
<th width="51" class="STYLE3" scope="col">页数</th>
<th width="51" class="STYLE3" scope="col">价格</th>
<th width="98" class="STYLE3" scope="col">书籍类别</th>
<th width="171" class="STYLE3" scope="col">出版社名称</th>
<th width="131" class="STYLE3" scope="col">入库时间</th>
</tr>
<%
String bid,bname,bauthor,bpage,bprice,bsort,bpress,bget_time;
while(rs.next())
{
bid = rs.getString(1);
bname = rs.getString(2).trim();
bauthor = rs.getString(3).trim();
bpage = rs.getString(4).trim();
bprice = rs.getString(5).trim();
bsort = rs.getString(6).trim();
bpress = rs.getString(7).trim();
bget_time = rs.getString(8).trim();
out.println("<tr>");
out.println("<td>"+bid+"</td>");
out.println("<td>"+bname+"</td>");
out.println("<td>"+bauthor+"</td>");
out.println("<td>"+bpage+"</td>");
out.println("<td>"+bprice+"</td>");
out.println("<td>"+bsort+"</td>");
out.println("<td>"+bpress+"</td>");
out.println("<td>"+bget_time+"</td>");
out.println("</tr>");
}
rs.close();
cstmt.close();
conn.close();
%>
</table>
<p> </p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -