?? index.jsp
字號(hào):
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.wgh.DB.connDB"%>
<jsp:include page="safe.jsp"/>
<%
connDB conn=new connDB();
ResultSet rs=conn.executeQuery("select * from tb_goods order by INTime Desc");
%>
<html>
<head>
<title>Go購電子商城后臺(tái)管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../CSS/style.css" rel="stylesheet">
</head>
<body onLoad="clockon(bgclock)">
<table width="777" height="192" border="0" align="center" cellpadding="0" cellspacing="0" class="tableBorder">
<tr>
<td>
<jsp:include page="banner.jsp"/>
<table width="777" height="288" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="182" valign="top"><table width="100%" height="431" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" background="../images/manage_02.gif"><jsp:include page="navigation.jsp"/></td>
</tr>
</table></td>
<td align="center" valign="top"><table width="100%" height="120" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" background="../images/manage_03.gif"><table width="100%" height="36" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="98%" align="right"><a href="superType.jsp">[ <img src="../images/list.gif" width="11" height="13"> 大分類信息管理]</a> <a href="subType.jsp">[ <img src="../images/list.gif" width="11" height="13"> 小分類信息管理]</a> <a href="goods_add.jsp">[ <img src="../images/list.gif" width="11" height="13"> 添加商品信息]</a></td>
<td width="2%"> </td>
</tr>
</table></td>
</tr>
</table>
<table width="92%" height="192" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<table width="100%" height="14" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="13" align="center"> </td>
</tr>
</table>
<table width="100%" height="48" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolordark="#CCCCCC" bordercolorlight="#FFFFFF">
<tr bgcolor="#eeeeee">
<td width="22%" height="24" align="center">商品名稱</td>
<td width="40%" align="center">簡介</td>
<td width="11%" align="center">是否新品</td>
<td width="11%" align="center">是否特價(jià)</td>
<td width="8%" align="center">修改</td>
<td width="8%" align="center">刪除</td>
</tr>
<%
String str=(String)request.getParameter("Page");
if(str==null){
str="0";
}
int pagesize=10;
rs.last();
int RecordCount=rs.getRow();
int maxPage=0;
maxPage=(RecordCount%pagesize==0)?(RecordCount/pagesize):(RecordCount/pagesize+1);
int Page=Integer.parseInt(str);
if(Page<1){
Page=1;
}else{
if(Page>maxPage){
Page=maxPage;
}
}
rs.absolute((Page-1)*pagesize+1);
for(int i=1;i<=pagesize;i++){
int ID=rs.getInt("ID");
String goodsName=rs.getString("goodsName");
String introduce=rs.getString("introduce");
String newgoods=rs.getInt("newgoods")==0 ? "否":"是";
String sale=rs.getInt("sale")==0 ? "否":"是";
%>
<tr style="padding:5px;">
<td height="20" align="center"><a href="goods_detail.jsp?ID=<%=ID%>"><%=goodsName%></a></td>
<td align="center"><%=introduce%></td>
<td align="center"><%=newgoods%></td>
<td align="center"><%=sale%></td>
<td align="center"><a href="goods_modify.jsp?ID=<%=ID%>"><img src="../images/modify.gif" width="15" height="15"></a></td>
<td align="center"><a href="goods_del.jsp?ID=<%=ID%>"><img src="../images/del.gif" width="16" height="16"></a></td>
</tr>
<%
try{
if(!rs.next()){break;}
}catch(Exception e){}
}
%>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right">當(dāng)前頁數(shù)：[<%=Page%>/<%=maxPage%>]
<%if(Page>1){%>
<a href="index.jsp?Page=1">第一頁</a> <a href="index.jsp?Page=<%=Page-1%>">上一頁</a>
<%
}
if(Page<maxPage){
%>
<a href="index.jsp?Page=<%=Page+1%>">下一頁</a> <a href="index.jsp?Page=<%=maxPage%>">最后一頁 </a>
<%}
%>
</td>
</tr>
</table> </td>
</tr>
</table>
<table width="100%" height="46" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="../images/manage_06.gif"> </td>
</tr>
</table></td>
</tr>
</table>
<table width="777" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="54" align="center"><jsp:include page="copyright.jsp"/></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -