📄 index.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<jsp:useBean id="connDB" scope="page" class="beans.connDB"/>
<jsp:useBean id="chStr" scope="page" class="beans.chStr"/>
<jsp:include page="safe.jsp"/>
<%
ResultSet rs=connDB.executeQuery("select * from tb_foodinfo order by foodid Desc");
%>
<html>
<head>
<title>订餐网</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../CSS/style.css" rel="stylesheet">
<script src="../JS/check.jsp"></script>
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0" background="../Images/bg.gif">
<tr>
<td>
<table width="777" height="609" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td valign="top">
<jsp:include page="Top.jsp"/>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableBorder_LTR">
<tr>
<td height="30" align="center" bgcolor="#eeeeee">≡≡≡ <span class="word_grey"><a href="food_UPIMG.jsp">添加餐品信息</a></span> ≡≡≡</td>
</tr>
</table>
<table width="100%" height="396" border="0" cellpadding="0" cellspacing="0" class="tableBorder_LBR">
<tr>
<td width="26%" height="395" valign="top"><table width="100%" border="0" cellspacing="-2" cellpadding="-2">
<tr>
<td width="55%" height="82" align="center" class="word_grey"> <img src="../Images/reg.gif" width="84" height="54"></td>
<td width="45%" align="left" class="word_grey">餐品管理</td>
</tr>
<tr>
<td height="112" colspan="2" valign="top" class="word_grey"><ul>
<li> 添加餐品信息：点击“添加餐品信息”超链接可以进行餐品信息的添加。</li>
<li>修改餐品信息：点击每条餐品信息后面的“修改”按钮可以修改餐品信息。</li>
<li>删除餐品信息：点击每条餐品信息后面的“删除”按钮可以删除餐品信息。</li>
<li>推荐餐品：如果想推荐餐品，可以点击指定餐品后的“修改”按钮。</li>
<li>是否新品：如果想将餐品信息发布到新品上架中，可以点击指定餐品后的“修改”按钮。</li>
</ul></td>
</tr>
<tr align="center">
<td colspan="2" valign="middle" class="word_grey"></td>
</tr>
</table></td>
<td width="5" valign="top" background="../Images/Cen_separate.gif"></td>
<td width="73%" 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>
<td width="18%" height="27" align="center">
餐品号</td>
<td width="36%" align="center">名称</td>
<td width="20%" align="center">餐厅</td>
<td width="8%" align="center">新品否</td>
<td width="8%" align="center">推荐否</td>
<td width="5%" align="center">修改</td>
<td width="5%" align="center">删除</td>
</tr>
<%
String str=(String)request.getParameter("Page");
if(str==null){
str="0";
}
int pagesize=10;
rs.last();
int RecordCount=rs.getRow();
//out.println(String.valueOf(RecordCount));
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++){
String foodid=rs.getString("foodid");
String foodName=rs.getString("foodName");
String type=rs.getString("type");
String newfood=rs.getInt("newfood")==0 ? "否":"是";
String commend=rs.getInt("commend")==0 ? "否":"是";
%>
<tr style="padding:5px;">
<td height="24" align="center"><%=foodid%></td>
<td align="center"><a href="food_detail.jsp?foodid=<%=foodid%>"><%=foodName%></a></td>
<td align="center"><%=type%></td>
<td align="center"><%=newfood%></td>
<td align="center"><%=commend%></td>
<td align="center"><a href="food_modify.jsp?foodid=<%=foodid%>"><img src="../Images/modify.gif" width="15" height="15"></a></td>
<td align="center"><a href="food_del.jsp?foodid=<%=foodid%>"><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">当前页数：[<%=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>
<jsp:include page="copyright.jsp"/>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -