📄 untitled-1.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!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">
<!--
.STYLE8 {color: #0000FF}
.style3 {font-size: 36px}
.style4 { font-family: "华文琥珀";
color: #FF0000;
}
.style7 {font-size: 12px}
.style2 {font-size: 14px}
.style81 {font-family: "华文彩云";
font-size: 18px;
}
.STYLE86 {color: #FF0000}
.STYLE87 {color: #0000FF; font-weight: bold; }
-->
</style>
</head>
<body>
<table width="1007" height="937" border="0" cellspacing="0" bordercolor="#666666">
<tr>
<td height="102" colspan="2" background="images/1.jpg" bgcolor="#00FF00"><div align="center" class="STYLE1 STYLE2 style1">
<div align="center" class="style3 style4">欢迎来到KingStar网上书店</div></td>
</tr>
<tr bgcolor="#999999">
<td height="36" colspan="2" bgcolor="#CC99CC"><table width="1021" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#3399FF"><div align="center"><a href="login.jsp">首页</a></div></td>
<td bgcolor="#3399FF"><div align="center"><a href="/newbooks">新书上市</a> </div></td>
<td bgcolor="#3399FF"><div align="center"><a href="/hotsales">畅销推荐</a> </div></td>
<td bgcolor="#3399FF"><div align="center"><a href="/giftbook/">礼品图书</a> </div></td>
<td bgcolor="#3399FF"><div align="center"><a href="/browser">分类浏览</a></div></td>
<td bgcolor="#3399FF"><div align="center"><a href="/infos">在线阅读</a> </div></td>
<td bgcolor="#3399FF"><div align="center"><a href="/bookpl">图书热评</a> </div></td>
<td bgcolor="#3399FF"><div align="center"><a href="../注册页面/张明星/tssl">图书拾零</a></div></td>
<td bgcolor="#3399FF"><div align="center"><a href="/gbook">顾客留言</a></div></td>
<td bgcolor="#3399FF"><div align="center"><a href="123">购物车管理</a></div>
<div align="center"></div></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#999999">
<td width="235" height="180" bgcolor="#000000"><table width="99%" height="174" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="30"><font style="color: #CC9933; font-size: 14px"><strong>专业书店</strong></font></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=考试"><font style="font-size: 13px">考试书店</font></a></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=建筑书店"><font style="font-size: 13px">建筑科技</font></a></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=法律书店"><font style="font-size: 13px">法律书店</font></a></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=计算机"><font style="font-size: 13px">计算机书店</font></a></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=医学书店"><font style="font-size: 13px">医学书店</font></a></td>
</tr>
</table></td>
<td width="768" height="553" rowspan="3" bgcolor="#00FFFF"><div align="center">
<p class="STYLE8"><strong>KingStar书店图书列表</strong></p>
<table width="787" border="0">
<tr>
<td width="130"><div align="center" class="STYLE86">图书名称</div></td>
<td width="120"><div align="center" class="STYLE86">作者</div></td>
<td width="130"><div align="center" class="STYLE86">图书类别</div></td>
<td width="130"><div align="center" class="STYLE86">出版社</div></td>
<td width="124"><div align="center" class="STYLE86">单价</div></td>
<td colspan="2"><div align="center" class="STYLE86">选择</div></td>
</tr>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:book");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select b_name,b_author,b_class,b_press,b_price from b_book";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next){%>
rs.getString("b_name");
<tr>
<td><%=rs.getString("b_name");%></td>
<td><%=rs.getString("b_author");%></td>
<td><%=rs.getString("b_class");%></td>
<td><%=rs.getString("b_press");%></td>
<td>￥<%=rs.getString("b_price");%></td>
<td width="59"><div align="center">购买</div></td>
<td width="64">详细资料</td>
</tr>
<%}
}
catch(Exception e){}
%>
</table>
<p class="STYLE87"> </p>
</div></td>
</tr>
<tr bgcolor="#999999">
<td height="137" bgcolor="#000000"><table width="100%" height="170" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="30"><font style="color: #CC9933; font-size: 14px"><strong>大众书店</strong></font></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=管理"><font style="font-size: 13px">经管书店</font></a></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=文学"><font style="font-size: 13px">文学书店</font></a></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=外语"><font style="font-size: 13px">外语书店</font></a></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=社科"><font style="font-size: 13px">社科书店</font></a></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=生活"><font style="font-size: 13px">生活书店</font></a></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=艺术"><font style="font-size: 13px">艺术书店</font></a></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#999999">
<td height="15" bgcolor="#000000"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="30"><font style="color: #CC9933; font-size: 14px"><strong>特色书店</strong></font></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=礼品书"><font style="font-size: 13px">礼品书</font></a></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=行业工具书"><font style="font-size: 13px">套装工具书</font></a></td>
</tr>
<tr>
<td height="20">·<a href="nsort.asp?sort_name=图书&nsort_name=培训光盘"><font style="font-size: 13px">管理培训</font></a></td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
<p> </p></td>
</tr>
<tr bgcolor="#999999">
<td height="39" colspan="2"> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -