?? main.jsp
字號(hào):
<%@ 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>無(wú)標(biāo)題文檔</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;
}
.STYLE85 {
font-family: "華文彩云";
font-size: 18px;
color: #0000FF;
font-weight: bold;
}
.STYLE86 {color: #FF0000}
.STYLE87 {
color: #FF0000;
font-size: 24px;
font-weight: bold;
}
.STYLE93 {color: #000000}
.STYLE94 {font-size: 16px; font-weight: bold;}
-->
</style>
</head>
<body>
<script language="javascript">
function openScript(url,name,width,height){
var win=window.open(url,name,'width='+width+',height='+height+',resizeable=1,srollbars=yes,menubar=no,status=yes');
}</script>
<%! String u_name=new String();
String name=new String();
String author=new String();
String bookclass=new String();
String press=new String();
String price=new String();
String choice=new String();
String search_txt=new String();
int i;
String ToPage;
%>
<%
u_name=request.getParameter("name");
ToPage=request.getParameter("ToPage");
int PageSize=10;//設(shè)置每張網(wǎng)頁(yè)顯示7條記錄
int ShowPage=1;//設(shè)置欲顯示的頁(yè)數(shù)
int RowCount=0;//ResultSet記錄筆數(shù)
int PageCount=0;//ResultSet記錄的分頁(yè)
String search_txt="";
String select="";
System.out.println("正在連接數(shù)據(jù)庫(kù)");
String sql="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:book");
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
%>
<table width="1007" height="816" border="0" align="center" 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">歡迎來(lái)到KingStar網(wǎng)上書(shū)店</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">首頁(yè)</a></div></td>
<td bgcolor="#3399FF"><div align="center"><a href="/newbooks">新書(shū)上市</a> </div></td>
<td bgcolor="#3399FF"><div align="center"><a href="/hotsales">暢銷推薦</a> </div></td>
<td bgcolor="#3399FF"><div align="center"><a href="/giftbook/">禮品圖書(shū)</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">圖書(shū)熱評(píng)</a> </div></td>
<td bgcolor="#3399FF"><div align="center"><a href="../注冊(cè)頁(yè)面/張明星/tssl">購(gòu)物車管理</a></div></td>
<td bgcolor="#3399FF"><div align="center"><a href="/gbook">顧客留言</a></div></td>
<td bgcolor="#3399FF"><div align="center"><a href="manager.jsp">管理員入口</a></div>
<div align="center"></div></td>
</tr>
</table>
<table width="1032" border="0">
<tr>
<td width="120" bgcolor="#3399FF"><div align="center"><span class="STYLE8">在線購(gòu)書(shū)</span></div></td>
<td width="150" bgcolor="#3399FF"><div align="center"><span class="STYLE8"><a href="myCar.jsp">我的購(gòu)物車</a></span></div></td>
<td width="120" bgcolor="#3399FF"><div align="center"><span class="STYLE8"><a href="login.jsp">登陸/注冊(cè)</a></span></div></td>
<td width="624" bgcolor="#3399FF"> </td>
</tr>
</table> </td>
</tr>
<tr>
<td width="235" height="72" bgcolor="#FF66FF">
<p><span class="STYLE85">你好!<%=u_name %></span></p>
<p class="style2"><a href="show_user.jsp">個(gè)人信息</a> <% session.setAttribute("u_name",u_name); %></p>
</td>
<form id="form2" name="form2" method="post" action="booktdb.jsp">
<label> <span class="STYLE86">圖書(shū)搜索：</span>
<select name="select" size="1" id="select">
<option>書(shū)籍名稱</option>
<option>書(shū)籍作者</option>
<option>書(shū)籍價(jià)格</option>
<option>出版社</option>
</select>
</label>
<input name="search_txt" type="text" id="search_txt" size="40" />
<a href="main1.jsp">高級(jí)搜索 </a>
</form> </td>
</tr>
<%
if(request.getParameter("select")!=null&&!request.getParameter("select").equals(""))
{
select=new String(request.getParameter("select").trim().getBytes("8859_1"));
}
System.out.println("a");
if(request.getParameter("search_txt")!=null&&!request.getParameter("search_txt").equals(""))
{
search_txt=new String(request.getParameter("search_txt").trim().getBytes("8859_1"));
}
if(search_txt!=null&&!search_txt.equals(""))
{
System.out.println("b");
if(select==null)
{
sql="select b_name,b_author,b_class,b_press,b_price from b_book where b_name like '%"+search_txt+"%'";
sql=sql+" or b_author like'%"+search_txt+"%'";
sql=sql +" or b_press like'%"+search_txt+"%'";
sql=sql+" or b_price like'%"+search_txt+"%'";
sql=sql+"order by b_no";
}
else{
System.out.println("c");
sql="select b_name,b_author,b_class,b_press,b_price from b_book where";
sql=sql+"b_name like'%"+search_txt+"%'";
sql=sql+"b_author like'%"+search_txt+"%'";
sql=sql+"b_press like'%"+search_txt+"%'";
sql=sql+"b_price like'%"+search_txt+"%'";
System.out.println("e");
sql=sql+"order by b_no";
}
}
else
{
System.out.println("f");
sql="select b_name,b_author,b_class,b_press,b_price from b_book order by b_no";
}
ResultSet rs=st.executeQuery(sql);
rs.last();
System.out.println("g");
RowCount=rs.getRow();//取得rs記錄筆數(shù)
PageCount=((RowCount% PageSize)==0?
(RowCount/PageSize):(RowCount/PageSize)+1);
//計(jì)算顯示的頁(yè)數(shù)
//判斷是否可正確取得ToPage參數(shù)
//可取得則表示JSP網(wǎng)頁(yè)應(yīng)顯示特定分頁(yè)記錄的語(yǔ)句
if(ToPage!=null)
{
//取得指定顯示的分頁(yè)數(shù)
ShowPage=Integer.parseInt(ToPage);
//先面的if語(yǔ)句將判斷用戶輸入的頁(yè)數(shù)是否正確
if(ShowPage>PageCount)
{
//判斷指定頁(yè)數(shù)是否大于總頁(yè)數(shù),是則設(shè)置顯示最后一頁(yè)
ShowPage=PageCount;
}
else if(ShowPage<=0)
{
//若指定頁(yè)數(shù)<0則設(shè)置顯示第一頁(yè)的記錄
ShowPage=1;
}
}
rs.absolute((ShowPage-1)*PageSize+1);
//計(jì)算欲顯示頁(yè)的第一筆記錄位置
%>
<tr bgcolor="#999999">
<td height="553" bgcolor="#000000"><table width="99%" height="400" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="30"><font style="color: #CC9933; font-size: 14px"><strong>圖書(shū)分類</strong></font></td>
</tr>
<tr>
<td height="20"><a href="main2.jsp">·<font style="font-size: 13px">建筑科技類</font></a></td>
</tr>
<tr>
<td height="20"><a href="main2.jsp">·<font style="font-size: 13px">法律類</font></a></td>
</tr>
<tr>
<td height="20"><a href="main2.jsp">·<font style="font-size: 13px">計(jì)算機(jī)類</font></a></td>
</tr>
<tr>
<td height="20"><a href="main2.jsp">·<font style="font-size: 13px">醫(yī)學(xué)類</font></a></td>
</tr>
<tr>
<td height="20"><a href="main2.jsp">·<font style="font-size: 13px">經(jīng)管類</font></a></td>
</tr>
<tr>
<td height="20"><p><a href="main2.jsp">·<font style="font-size: 13px">文學(xué)類</font></a></p> </td>
</tr>
<tr>
<td height="30"><font style="color: #CC9933; font-size: 14px"><strong>大眾書(shū)店</strong></font></td>
</tr>
<tr>
<td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=圖書(shū)&nsort_name=管理"><font style="font-size: 13px">經(jīng)管書(shū)店</font></a></span></td>
</tr>
<tr>
<td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=圖書(shū)&nsort_name=文學(xué)"><font style="font-size: 13px">文學(xué)書(shū)店</font></a></span></td>
</tr>
<tr>
<td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=圖書(shū)&nsort_name=外語(yǔ)"><font style="font-size: 13px">外語(yǔ)書(shū)店</font></a></span></td>
</tr>
<tr>
<td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=圖書(shū)&nsort_name=社科"><font style="font-size: 13px">社科書(shū)店</font></a></span></td>
</tr>
<tr>
<td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=圖書(shū)&nsort_name=生活"><font style="font-size: 13px">生活書(shū)店</font></a></span></td>
</tr>
<tr>
<td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=圖書(shū)&nsort_name=藝術(shù)"><font style="font-size: 13px">藝術(shù)書(shū)店</font></a></span></td>
</tr>
<tr>
<td height="30"><font style="color: #CC9933; font-size: 14px"><strong>特色書(shū)店</strong></font></td>
</tr>
<tr>
<td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=圖書(shū)&nsort_name=禮品書(shū)"><font style="font-size: 13px">禮品書(shū)</font></a></span></td>
</tr>
<tr>
<td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=圖書(shū)&nsort_name=行業(yè)工具書(shū)"><font style="font-size: 13px">套裝工具書(shū)</font></a></span></td>
</tr>
<tr>
<td height="20"><span class="STYLE86">·<a href="nsort.asp?sort_name=圖書(shū)&nsort_name=培訓(xùn)光盤(pán)"><font style="font-size: 13px">管理培訓(xùn)</font></a></span></td>
</tr>
<tr>
<td height="10"><div align="left">
<p> </p>
<p> </p>
</div></td>
</tr>
</table></td>
<td height="553" rowspan="3" bgcolor="#00FFFF"><table width="790" height="48" border="0">
<tr>
<td width="776"><div align="center">
<p class="STYLE87">書(shū)籍信息</p>
<table width="790" border="0">
<tr>
<td colspan="7">
<span class="STYLE93">
<%
if(search_txt!=null&&!search_txt.equals(""))
{
%>
<span class="STYLE94">以下是包含關(guān)鍵字<%=search_txt%>的所有信息
<%
}
else
{
%>
以下是所有信息
<%
}
%>
</span></span>
<p align="left" class="STYLE8">共:<%=RowCount%>
條 共<%=PageCount%>頁(yè) 當(dāng)前頁(yè)為第<%=ShowPage%>頁(yè)</p> </td>
</tr>
<tr>
<td width="126"><div align="center" class="STYLE86 STYLE86">書(shū)籍名稱</div></td>
<td width="125"><div align="center" class="STYLE86 STYLE86">書(shū)籍作者</div></td>
<td width="124"><div align="center" class="STYLE86 STYLE86">所屬分類</div></td>
<td width="118"><div align="center" class="STYLE86 STYLE86">出版社</div></td>
<td width="109"><div align="center" class="STYLE86 STYLE86">單價(jià)</div></td>
<td colspan="2"><div align="center" class="STYLE86 STYLE86">選擇</div></td>
</tr>
<%
while(i<PageSize&&!rs.isAfterLast())
{
%>
<tr>
<td><span class="STYLE8 STYLE86"><%=rs.getString("b_name")%></span></td>
<td><span class="STYLE8 STYLE86"><%=rs.getString("b_author")%></span></td>
<td><span class="STYLE8 STYLE86"><%=rs.getString("b_class")%></span></td>
<td><span class="STYLE8 STYLE86"><%=rs.getString("b_press")%></span></td>
<td><span class="STYLE8 STYLE86"><%=rs.getFloat("b_price")%></span></td>
<td width="66"><div align="center"><span class="STYLE8 STYLE86"><a href="#" onclick="openScript('addcar.jsp','pur',300,250)">購(gòu)買</a></span></div></td>
<td width="98"><span class="STYLE8 STYLE86"><a href="11">詳細(xì)資料</a></span></td>
<% i++;
rs.next();
}%>
</tr>
<%
rs.close();
%>
<tr>
<td colspan="7"><table width="790" border="0">
<tr>
<td> </td>
<%
if(ShowPage!=1)
{
%>
<td><a href=main.jsp?Topage=<%=1%>>第一頁(yè)</a></td>
<td><a href=main.jsp?ToPage=<%=ShowPage-1%>>上一頁(yè)</a> </td>
<%
}
if(ShowPage!=PageCount)
{
%>
<td><a href=main.jsp?ToPage=<%=ShowPage+1%>>下一頁(yè)</a></td>
<td><a href=main.jsp?ToPage=<%=PageCount%>>最后頁(yè)</a></td>
</tr>
<%
}
}
catch(Exception e){}
%>
</table></td>
</tr>
</table>
</div></td>
</tr>
</table>
<table width="790" border="0">
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<p> </p></td>
</tr>
<tr bgcolor="#999999">
<td height="39" colspan="2"><img src="images/bb1.jpg" width="168" height="46" /><img src="images/bb2.jpg" width="166" height="45" /><img src="images/bb3.jpg" width="171" height="45" /><img src="images/bb4.jpg" width="168" height="45" /><img src="images/wing_20.jpg" width="172" height="46" /><img src="images/bb.jpg" width="177" height="45" /></td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -