?? 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 + -