📄 index.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<jsp:useBean id="conndb" scope="page" class="beans.connDB"/>
<jsp:useBean id="chstr" scope="page" class="beans.chStr"/>
<HTML>
<HEAD>
<TITLE>Site Title</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
//-->
</script>
</HEAD>
<BODY BGCOLOR=#FFFFFF LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0 onLoad="MM_preloadImages('../../web/images/but_login_r.gif')">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="334" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="189" height="334" valign="top" background="../../web/images/side_back.jpg">
<table width="100%" height="516" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="516" valign="top" background="../../web/images/home_side.jpg">
<%if(session.getAttribute("Username")==null){%>
<form name="form1" method="post" action="login_deal.jsp">
<table width="100%" height="70" border="0" cellpadding="1" cellspacing="1">
<tr>
<td height="5" colspan="2" bgcolor="#000000">用户登录</td>
</tr>
<tr>
<td width="39%" valign="middle"><font size="2">用户名:</font></td>
<td width="61%" valign="top"><input name="username" type="text" id="username" size="11"></td>
</tr>
<tr>
<td valign="middle"><font size="2">密码:</font></td>
<td><input name="password" type="password" id="password" size="11"></td>
</tr>
<tr>
<td height="16">
<div align="right"> </div></td>
<td><a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image10','','../../web/images/but_login_r.gif',1)"><img src="../../web/images/but_login.gif" name="Image10" width="65" height="14" border="0" onClick="form1.submit()"></a></td>
</tr>
</table>
<p> </p></form>
<%}else{%>
<br>
<table width="100%" height="70" border="0" cellpadding="1" cellspacing="1">
<tr>
<td valign="middle" class="smbold"><div align="center"><font size="2"><%=session.getAttribute("Username")%>你好</font></div></td>
</tr>
<tr>
<td width="100%" valign="middle" class="smbold"><div align="center"><font size="2">欢迎进入网上书店</font></div></td>
</tr>
<tr>
<td valign="middle"><div align="center"><font size="2"><a href="../user/modify.jsp">修改信息</a></font></div></td>
</tr>
<tr>
<td valign="middle"><div align="center"><font size="2"><a href="myinterest.jsp">我感兴趣的书</a></font></div></td>
</tr>
</table>
<br>
<%}
String categoryname="";
ResultSet rs_category=conndb.executeQuery("select * from categorydata");%>
<table width="99%" border="0" cellspacing="3" cellpadding="3">
<%while(rs_category.next()){
categoryname=rs_category.getString("categoryname");
%>
<tr>
<td height="17" valign="middle">
<font size="2"><img src="../../web/images/3dots.gif" width="6" height="9">
<a href="books.jsp?categoryname=<%=categoryname%>"><%=categoryname%></a></font>
</td>
</tr>
<%}%>
</table>
</td>
</tr>
</table></td>
<td valign="top" bgcolor="#FFFFFF">
<table width="100%" height="518" border="0">
<tr>
<td height="50%"><table width="100%"><tr>
<td height="14" colspan="6"><b><font size="2">新书上架</font></b></td>
</tr></table>
<%
ResultSet rs_newbook=conndb.executeQuery("select * from bookdata where status=0 and commend=1");
int pagesize=4;int maxPage=0;int Page=0;
if(!rs_newbook.next()){%>
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0" align="center"><%out.println("无新书发布");%></td>
</tr>
</table>
<%}else{
String str=(String)request.getParameter("Page");
if(str==null){str="0";}
rs_newbook.last();
int recordcount=rs_newbook.getRow();
maxPage=(recordcount%pagesize==0)?(recordcount/pagesize):(recordcount/pagesize+1);
Page=Integer.parseInt(str);
if(Page<1){Page=1;}
else{if(((Page-1)*pagesize+1)>recordcount){Page=maxPage;}}
rs_newbook.absolute((Page-1)*pagesize+1);
for(int i=1;i<=pagesize;i++){
String bookid=rs_newbook.getString("bookid");
String bookname=rs_newbook.getString("bookname");
String publisher=rs_newbook.getString("publisher");
String author=rs_newbook.getString("author");
float price=rs_newbook.getFloat("price");
String cover=rs_newbook.getString("cover");
if((i%2)!=0){%>
<table width="100%">
<tr><td width="70" rowspan="5" align="center"><img src="../../web/cover/<%=cover%>"></td>
<td width="337"><table width="100%">
<tr>
<td valign="middle" bgcolor="E0E0E0"><font size="2">书号：<a href="book_detail.jsp?bookid=<%=bookid%>"><%=bookid%></a></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">书名：<%=bookname%></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">出版社：<%=publisher%></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">作者：<%=author%></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">定价：<%=price%></font></td>
</tr>
<%if(session.getAttribute("Username")!=null){%>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0">
<font size="2"> [<a href="../shopcart/cart_add.jsp?bookid=<%=bookid%>">购买</a>]</font>
</td>
</tr><%}%>
</table></td>
<%}else{%>
<td width="70" rowspan="5" align="center"><img src="../../web/cover/<%=cover%>"></td>
<td width="301"><table width="100%">
<tr>
<td valign="middle" bgcolor="E0E0E0"><font size="2">书号：<a href="book_detail.jsp?bookid=<%=bookid%>"><%=bookid%></a></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">书名：<%=bookname%></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">出版社：<%=publisher%></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">作者：<%=author%></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">定价：<%=price%></font></td>
</tr>
<%if(session.getAttribute("Username")!=null){%>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2"> [<a href="../shopcart/cart_add.jsp?bookid=<%=bookid%>">购买</a>]</font></td>
</tr>
<%}%>
</table></td>
</tr>
</table>
<br>
<%}try{if(!rs_newbook.next()){break;}}catch(Exception e){}}}%>
<table width="100%">
<tr valign="top">
<td > </td>
<td width="15%" ><font size="2">当前页：<%=Page%>/<%=maxPage%></font></td>
<%if(Page>1){%>
<td width="15%" ><font size="2"><a href="newbook.jsp?page=<%=Page-1%>">上一页</a>
<%}if(Page<maxPage){%>
<a href="newbook.jsp?page=<%=Page+1%>">下一页</a></font></td>
<%}%>
</tr>
</table> </td>
</tr>
<tr>
<td height="50%"><table width="100%"><tr>
<td colspan="6"><b><font size="2">特价图书</font></b></td>
</tr></table>
<%
ResultSet rs_cheapbook=conndb.executeQuery("select * from bookdata where status=1 and commend=1");
int pagesize1=4;int maxPage1=0;int Page1=0;
if(!rs_cheapbook.next()){%>
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0" align="center"><%out.println("无特价书发布");%></td>
</tr>
</table>
<%}else{
String str1=(String)request.getParameter("Page1");
if(str1==null){str1="0";}
rs_cheapbook.last();
int recordcount1=rs_cheapbook.getRow();
maxPage1=(recordcount1%pagesize1==0)?(recordcount1/pagesize1):(recordcount1/pagesize1+1);
Page1=Integer.parseInt(str1);
if(Page1<1){Page1=1;}
else{if(((Page1-1)*pagesize1+1)>recordcount1){Page1=maxPage1;}}
rs_cheapbook.absolute((Page1-1)*pagesize1+1);
for(int i=1;i<=pagesize1;i++){
String bookid=rs_cheapbook.getString("bookid");
String bookname=rs_cheapbook.getString("bookname");
String publisher=rs_cheapbook.getString("publisher");
String author=rs_cheapbook.getString("author");
float price=rs_cheapbook.getFloat("price");
String cover=rs_cheapbook.getString("cover");
if((i%2)!=0){%>
<table width="100%">
<tr><td width="70" rowspan="5" align="center"><img src="../../web/cover/<%=cover%>"></td>
<td width="337"><table width="100%">
<tr>
<td valign="middle" bgcolor="E0E0E0"><font size="2">书号：<a href="book_detail.jsp?bookid=<%=bookid%>"><%=bookid%></a></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">书名：<%=bookname%></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">出版社：<%=publisher%></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">作者：<%=author%></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">定价：<%=price%></font></td>
</tr>
<%if(session.getAttribute("Username")!=null){%>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2"> [<a href="../shopcart/cart_add.jsp?bookid=<%=bookid%>">购买</a>]</font></td>
</tr>
<%}%>
</table></td>
<%}else{%>
<td width="70" rowspan="5" align="center"><img src="../../web/cover/<%=cover%>"></td>
<td width="301"><table width="100%">
<tr>
<td valign="middle" bgcolor="E0E0E0"><font size="2">书号：<a href="book_detail.jsp?bookid=<%=bookid%>"><%=bookid%></a></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">书名：<%=bookname%></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">出版社：<%=publisher%></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">作者：<%=author%></font></td>
</tr>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2">定价：<%=price%></font></td>
</tr>
<%if(session.getAttribute("Username")!=null){%>
<tr>
<td width="162" valign="middle" bgcolor="E0E0E0"><font size="2"> [<a href="../shopcart/cart_add.jsp?bookid=<%=bookid%>">购买</a>]</font></td>
</tr>
<%}%>
</table></td>
</tr>
</table>
<br>
<%}try{if(!rs_cheapbook.next()){break;}}catch(Exception e){}}}%>
<table width="100%">
<tr valign="top">
<td > </td>
<td width="15%" ><font size="2">当前页：<%=Page1%>/<%=maxPage1%></font></td>
<%if(Page1>1){%>
<td width="15%" ><font size="2"><a href="newbook.jsp?page=<%=Page1-1%>">上一页</a>
<%}if(Page1<maxPage1){%>
<a href="newbook.jsp?page=<%=Page1+1%>">下一页</a></font></td>
<%}%>
</tr>
</table> </td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
<div align="center"></div>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="1%" height="19" valign="top" background="../../web/images/link_bar_hold.jpg"><img src="../../web/images/link_bar_hold.jpg" width="9" height="23"></td>
<td width="99%" background="../../web/images/link_bar_hold.jpg"><div align="center">:
<a href="#">License Agreemen</a>t : <a href="#">Jobs</a> : <a href="#">Site
Map</a> :</div></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td height="34" bgcolor="#000000"><div align="center">
<p class="smWhite">2003 Copyright Information or webmaster information</p>
</div></td>
</tr>
</table>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -