📄 zwm.jsp
字号:
<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%@ page import="java.lang.*,java.util.*,java.sql.*" %>
<html>
<title>小小的太阳</title>
<body style="color: #FFFF">
<jsp:useBean id="DbLink" scope="page" class="MyBook.DbLink" />
<%
String GLCS = (String) request.getParameter("GLCS");
String YHM = (String) request.getParameter("YHM");
DbLink.DbLink("sa","123456","MyDataBase");
%>
<div align="center">
<table border="3" borderColor="#ffffff" borderColorDark="#ffffff" borderColorLight="#ffffff" cellSpacing="0" height="1008" style="BORDER-BOTTOM-COLOR: #ffffff; BORDER-BOTTOM-STYLE: solid; BORDER-LEFT-COLOR: #ffffff; BORDER-LEFT-STYLE: solid; BORDER-RIGHT-COLOR: #ffffff; BORDER-RIGHT-STYLE: solid; BORDER-TOP-COLOR: #ffffff; BORDER-TOP-STYLE: solid" width="892">
<tbody>
<tr>
<td align="middle" bgColor="#ccccff" height="1" width="80%" colspan="2">
<%@ include file="head.html" %>
</td>
</tr>
<tr>
<td align="center" bgcolor="#fccccc" height="1" width="80%" colspan="2">
<jsp:include page="head.jsp" />
</jsp:include>
</td>
</tr>
<tr>
<td align="middle" bgColor="#ccffff" height="25" width="40%">
<font size="5" color="#FF00FF" face="华文行楷">
大众宝物书店
</font>
<font size="3" color="#00FF00">
（
<a href="BWSD.jsp?YHM=<%= YHM %>&GLCS=<%= GLCS %>">
我要买书
</a>）
</font>
</td>
<td align="middle" bgColor="#ccffff" height="25" width="40%">
<font color="#FF00FF" face="楷体_GB2312" size="4">
<java>
</font>
<font size="5" color="#FF00FF" face="华文行楷">
论坛集
</font>
<font size="3" color="#00FF00">（<a href="LTan.jsp?YHM=<%= YHM %>&GLCS=<%= GLCS %>">进入论坛</a>）</font>
</td>
</tr>
<font color="#000000">
<tr>
<td align="middle" bgColor="#ccffff" height="520" width="40%" colspan="1">
<table border="1" width="97%" height="90%" bordercolorlight="#f308080" style="border-style: solid" bordercolordark="#f308080" bordercolor="#f308080" cellspacing="1" cellpadding="0" >
<tr>
<td align="left" height="1" width="30%">书 名</td>
<td align="left" height="1" width="23%">作 者</td>
<td align="left" height="1" width="30%">出版社</td>
<td align="left" height="1" width="17%">价 格</td>
</tr>
<%
ResultSet rs = DbLink.DbQuery("select SM,ZZ,CBS,JG from Book");
for(int i=1;i<=20;i++)
{
if (rs.next())
{
String SM =rs.getString("SM");
String ZZ =rs.getString("ZZ");
String CBS =rs.getString("CBS");
float JG = rs.getFloat("JG");
out.println("<tr><td align=\"left\" height=\"1\" width=\"30%\">"
+ SM
+"</td><td align=\"left\" height=\"1\" width=\"23%\">"
+ZZ
+"</td><td align=\"left\" height=\"1\" width=\"30%\">"
+CBS
+"</td><td align=\"left\" height=\"1\" width=\"17%\">"
+JG+
"</td></tr> ");
}
else
{
out.println("<tr><td height=\"1\" colspan=\"4\"> </td></tr>");
}
}
rs.close();
%>
<td align="right" height="1" width="100%" colspan="4">...
<a href="MoreBWSD.jsp?YHM=<%= YHM %>&GLCS=<%= GLCS %>"> More</a>
</td>
</table>
</td>
<td align="middle" bgColor="#ccffff" height="520" width="40%" colspan="1" >
<table border="1" width="90%" height="85%" bordercolorlight="#808080" >
<td align="left" width="80%" height="1">
</td>
</table>
</td>
</tr>
</font>
<tr>
<td align="middle" bgColor="#ccccff" height="1" width="80%" colspan="2">
<%@ include file = "botton.html" %>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -