petlist.jsp

宠物网站jsp

<%@ page contentType="text/html; charset=GB2312" import="java.util.*,cn.wy.Pet.Pet,cn.wy.factory.PetBuy" %>
<jsp:useBean id="str" scope="page" class="cn.wy.StrFormat"/>
<%
    PetBuy pb = new PetBuy();
    List lPetAll = new ArrayList();    
    String goPage = "" ;
    String downPage = "" ;
    String keyword = "";
    if (request.getParameter("key") != null)
    {
        keyword = String.valueOf(request.getParameter("key"));
        if (keyword.indexOf("\'") >= 0 | keyword.indexOf("-") >= 0)
        {
            out.print("<script>alert('请不要乱注！');history.go(-1)</script>");
            return ;            
        }
    }
    //总的页数
    int pageCount = 0;
    int petCount = pb.QueryPageCount("select count(*) from shoppingpet where spifsale = 0 and (spbreed like '%"+keyword+"%' or SPRemark like '%keyword%')");
    int managerPetPageNo = 12;
    if (petCount % managerPetPageNo > 0)
        pageCount = petCount / managerPetPageNo + 1;
    else
        pageCount = petCount / managerPetPageNo ;

    int pageNo = 1; //显示分页的第几页
    try{
        pageNo = Integer.valueOf(request.getParameter("pageNo")).intValue();
    }catch(Exception e)
    {pageNo = 1;}
    //如果有这个页，就把记录查询出来

    if (pageNo > 1)
    {
        int pageAdd = pageNo - 1;
        goPage = "<a href=\"ctrladmin?page=petList.jsp?pageNo=" + pageAdd +"\">上页</a>";
    }else
    {
        goPage = "";
        pageNo = 1 ; 
    }
    if(pageNo < pageCount)
    {
        int pageMinus = pageNo + 1 ;
        downPage ="<a href=\"ctrladmin?page=petList.jsp?pageNo=" + pageMinus + "\">下页</a>";
    }else
    {
        downPage = "";
        if (pageNo > pageCount)
            pageNo = 1 ; 
    }
    if (pageNo <= pageCount)
    {
        lPetAll = pb.QueryPetAll(pageNo,managerPetPageNo,keyword,"");
    }
    Iterator iter = lPetAll.iterator();
%> 
<table width="841" height="175" border="1" align="center" cellspacing="0" bordercolor="#000000">
  <tr height="18" >
    <td height="25" colspan="14" align="center" bordercolor="#E3E4EF"><strong><font size="+2">宠物列表</font></strong> </td>
  </tr>
  
  <tr>
    <td width="59"  height="21" align="center" bgcolor="#00CC99"><div align="center">编号</div></td>
    <td width="59"  align="center" bgcolor="#00CC99"><div align="center">品种名称</div></td>
    <td width="59"   align="center" bgcolor="#00CC99"><div align="center">出产地</div></td>
    <td width="59"   align="center" bgcolor="#00CC99"><div align="center">年龄</div></td>
    <td width="59"   align="center" bgcolor="#00CC99"><div align="center">入库时间</div></td>
    <td width="59"   align="center" bgcolor="#00CC99"><div align="center">购入价￥</div></td>
    <td width="59"  align="center" bgcolor="#00CC99"><div align="center">出售价￥</div></td>
    <td width="59"  align="center" bgcolor="#00CC99"><div align="center">操作员</div></td>
    <td width="62"   align="center" bgcolor="#00CC99"><div align="center">宠物说明信息</div></td>
    <td width="97"  align="center" bgcolor="#00CC99">浏 / 评</td>
    <td width="47"   align="center" bgcolor="#00CC99"><div align="center">修改</div></td>
    <td width="47"  align="center" bgcolor="#00CC99"><div align="center">删除</div></td>
    <td width="55"  align="center" bgcolor="#00CC99"><div align="center">出售</div></td>
  </tr>
  <%       
      String id = "";
      String isShopping = "出售";      
      boolean isPet = false;
      while(iter.hasNext())
      {
          Pet p = (Pet)iter.next();
          //SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日");
          isPet = true ;
          id = String.valueOf(p.getSpetid());           
          String spDate = String.valueOf(p.getSpdate());
          String canSpStr = "";
          if(!p.isSpcansp()){
              canSpStr = "bgcolor=\"#F4718E\"";
              isShopping = "出售";   
          }
          else
              isShopping = "<a href=\"ctrladmin?petShoping=" + id +"\" >出售</a>";
           
   %>
  <script language="javascript" type="text/javascript">
function affirm()
{
	if (window.confirm("警告：确定要删除该宠物的所有信息吗？删除以后不可以恢复。"))
            return true;
        else
            return false;
}
</script>
  <tr <%=canSpStr%>>
    <td align="center" valign="center" bordercolor="#009900"><%=id%></td>
    <td align="left" valign="center" bordercolor="#009900"><a title="<%=p.getSpbreed()%>" href="ctrladmin?page=../petInfo.jsp?id=<%=id%>&is=m"><%=str.subStr(p.getSpbreed(),6).replaceAll(keyword,"<font color=\"red\">"+keyword+"</font>")%></a></td>
    <td align="left" valign="center" bordercolor="#009900"><%=String.valueOf(p.getSparea())%></td>
    <td align="center" valign="center" bordercolor="#009900"><%=String.valueOf(p.getSpBirthDate())%>月</td>
    <td align="left" valign="center" bordercolor="#009900"><%=spDate%></td>
    <td align="center" valign="center" bordercolor="#009900"><%=String.valueOf(p.getSpprice())%></td>
    <td align="center" valign="center" bordercolor="#009900"><%=String.valueOf(p.getSpsellprice())%></td>
    <td align="center" valign="center" bordercolor="#009900"><%=String.valueOf(p.getUName())%></td>
    <td align="left" valign="center" bordercolor="#009900"><a href="#" title="<%=p.getSpremark()%>"><%=str.subStr(p.getSpremark(),26).replaceAll(keyword,"<font color=\"red\"><b>"+keyword+"</b></font>")%></a></td>
    <td align="center" valign="center" bordercolor="#009900"><%=p.getCCount()%>/<a  title="点击即可管理该宠物的评论信息" href="ctrladmin?page=petCommeet.jsp?petid=<%=String.valueOf(p.getSpetid())%>">评<%=p.getCommentCont()%></a></td>
    <td align="center" valign="center" bordercolor="#009900"><a href="ctrladmin?delPet=<%=id + "&pNo=" + pageNo %>" onclick="return affirm()" >删除</a></td>
    <td align="center" valign="center" bordercolor="#009900"><a href="ctrladmin?petEdit=<%=id + "&pNo=" + pageNo %>" >修改</a></td>
    <td align="center" valign="center" bordercolor="#009900"><%=isShopping%></td>
</tr><font color="FF0000"></font>
  <%       
       }
        if (!isPet){
  %>
  <tr> 
      <td height="43" colspan="13" > 
          <br>还没有宠物信息! <br>
        <a href="ctrladmin?page=addPet.jsp">点这里添加宠物</a> <br><br>
  <td width="7">  </tr>
  <%
        System.out.println("没有啊 1");
        }
  %>
  <tr align="top">
    <td height="10" colspan="13"  align="left" valign="top" bordercolor="#000000"><font color="#FF0000"> 表格背景为红色的表示没有在网站上出售 </font></td>
  </tr>
  <tr align="top">
    <td height="10" colspan="13"  align="left" valign="top" bordercolor="#000000"><table width="828" height="27" border="0">
      <tr>
        <td width="516" height="23"><form action="ctrladmin?page=petList.jsp" name="form1" id="form1">
          当前页:<%=lPetAll.size()%>条&nbsp;&nbsp;共：<%=petCount%>条&nbsp;&nbsp;<%=pageNo%>/<%=pageCount%>&nbsp;&nbsp; <a href="ctrladmin?page=petList.jsp?pageNo=1">第一页</a>&nbsp; <%=goPage%>&nbsp; <%=downPage%>&nbsp; <a href="ctrladmin?page=petList.jsp?pageNo=<%=pageCount%>">尾页</a> &nbsp;&nbsp;转到：
          <select name="page" onchange="document.form1.submit()">
            <%
                  for (int i=1;i<=pageCount; i++){
                  %>
            <option value="<%="petList.jsp?pageNo=" + String.valueOf(i)%>" <%=(pageNo == i)? "selected":""%> >第<%=i%>页
              <%
                  }
                  %>
              </option>
          </select>
        </form></td>
        <td width="302"><form action="ctrladmin?page=petList.jsp" method="post" name="find" id="find">
            <div align="right">查找宠物：
              <input type="text" maxlength="20" value="<%=keyword%>" size="10" name="key" />
                <input type="submit" value="查找" name="butt" />
            </div>
        </form></td>
      </tr>
    </table></td>
  </tr>
</table>