?? productsearch.jsp
字號:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@page import="com.qyg.shop.product.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
ProductManageDAO dao=new ProductManageDAO();
int currentPage=1;//當前頁數(shù)
int pageSize=5;//在此設定每頁的大小
int pageCount=0;//頁面總數(shù)
String adminName=null;//管理員名
String adminId=null;//管理員ID
String action=null;//獲得頁面方法，delete,update,add,search四種
String name=null;//要查詢的商品名稱
List<Product> products=null;//查詢到的商品信息
//session驗證，防止非法進入
if(session.getAttribute("adminName")!=null){
adminName=session.getAttribute("adminName").toString();
adminId=session.getAttribute("adminId").toString();
}
else{
out.print("請勿非法登陸，<a href='/qygshop/manage/Login.jsp' target='_parent'>點此進入</a>");
out.close();
}
//session驗證完
/*刪除得到的ID的對象*/
if((action=request.getParameter("action"))!=null){
if(action.equals("delete")){
//out.print(request.getParameter("id"));//測試用
int id=Integer.parseInt(request.getParameter("id"));
dao.delete(id);
}
}
/*刪除完*/
/*得到總頁數(shù)pageCount及用戶信息*/
if ((name = request.getParameter("name")) != null){
//out.print(name);//測試
session.setAttribute("name",name);
}
if(session.getAttribute("name")!=null){
int number = dao.getTotalProductsByName(session.getAttribute("name").toString());//得到查到用戶總數(shù)
pageCount = number % pageSize == 0 ? number / pageSize : number
/ pageSize + 1;//得到總頁數(shù)，另一種算法(number+pageSize-1)/pageSize;
products = dao.getProdutsByName(session.getAttribute("name").toString());
}
/*得到總結(jié)束完*/
//得到URL傳來的參數(shù)
if(request.getParameter("page")!=null) currentPage=Integer.parseInt(request.getParameter("page"));
currentPage=currentPage<1?1:currentPage;
currentPage=currentPage>pageCount?pageCount:currentPage;
//得到URL傳來的參數(shù)完
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'ProductSearch.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<link rel="stylesheet" href="css/common.css" type="text/css"></link>
</head>
<BODY bgcolor="#D9EAFC">
<br><br><!-- 查詢提交模塊 -->
<form action="manage/ProductSearch.jsp" method="get">
<div align="center" id="search">
請輸入要查找的商品名<input type="text" name="name"/> <input type="submit" value="查詢"/>
</div>
</form>
<!-- 查詢模塊完 -->
<!-- 分頁跳轉(zhuǎn)鏈接 -->
<div align="center" id="pageButton">
<%
if (currentPage > 1) {
%>
<a href="manage/ProductSearch.jsp?page=1">首 頁</a>
<a href="manage/ProductSearch.jsp?page=<%=currentPage -1%>">上一頁</a>
<%
}
%>
<%
if (currentPage < pageCount) {
%>
<a href="manage/ProductSearch.jsp?page=<%=currentPage +1%>">下一頁</a>
<a href="manage/ProductSearch.jsp?page=<%=pageCount%>">末 頁</a>
<%
}
%>
第<%=currentPage%>頁/共<%=pageCount%>頁
</div>
<!-- 分頁跳轉(zhuǎn)完 -->
<table border="1" cellpadding="1" width="98%" class="datalist">
<tr>
<th scope="col">商品編號</th>
<th width="130" scope="col">圖片預覽</th>
<th scope="col">商品名稱</th>
<th scope="col">商品類型</th>
<th scope="col">商品價格</th>
<th colspan="2">操作</th>
</tr>
<!-- 實現(xiàn)分頁源碼 -->
<%
Iterator<Product> it=products.iterator();
for(int i=0;i<pageSize*(currentPage-1);i++)
{
it.next();
}
for(int i=0;i<pageSize&&it.hasNext();i++)
{
Product product=it.next();
out.print("<tr>");
out.print("<td>"+product.getProduct_id()+"</td>");
out.print("<td><img src='img/products/"+product.getProduct_image()+"' width='130' height='70'/></td>");
out.print("<td>"+product.getProduct_name()+"</td>");
out.print("<td>"+product.getProduct_cId()+"</td>");
out.print("<td>"+product.getProduct_price()+"</td>");
out.print("<td><a href='manage/Product.jsp?action=delete&id="+product.getProduct_id()+"'>刪除</a></td>");
out.print("<td><a href='manage/ProductEdit.jsp?action=update&id="+product.getProduct_id()+"'>修改</a></td>");
}
%>
<!-- 實現(xiàn)分頁源碼完 -->
</table>
<script language="javascript">
var rows = document.getElementsByTagName('tr');
for (var i=0;i<rows.length;i++){
rows[i].onmouseover = function(){ //鼠標在行上面的時候
this.className += 'altrow';
}
rows[i].onmouseout = function(){ //鼠標離開時
this.className = this.className.replace('altrow','');
}
}
</script>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -