petlore.jsp

宠物网站jsp

<%@ page contentType="text/html; charset=GB2312" import="java.util.*,cn.wy.Pet.Lore,cn.wy.factory.LoreBuy" %>
<%
    LoreBuy pb = new LoreBuy();
    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 = cn.wy.factory.ThingsBuy.queryCount("select count(*) from Lore where ntitle like '%"+ keyword+"%' or ntext 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=petLore.jsp?pageNo=" + pageAdd +"\">上页</a>";
    }else
    {
        goPage = "";
        pageNo = 1 ; 
    }
    if(pageNo < pageCount)
    {
        int pageMinus = pageNo + 1 ;
        downPage ="<a href=\"ctrladmin?page=petLore.jsp?pageNo=" + pageMinus + "\">下页</a>";
    }else
    {
        downPage = "";
        if (pageNo > pageCount)
            pageNo = 1 ; 
    }
    if (pageNo <= pageCount)
    {
        lPetAll = pb.queryLoreAll(pageNo,managerPetPageNo,keyword,"");
    }
    Iterator iter = lPetAll.iterator();
%> 

<script language="javascript" type="text/javascript">
function affirm()
{
	if (window.confirm("警告：确定要删除该充物知识和评论有信息吗？删除以后不可以恢复。"))
            return true;
        else
            return false;
}
</script>


<table width="800" height="152" border="1" align="center" cellspacing="0" bordercolor="#000000">
  <tr height="18" >
    <td height="25" colspan="9" align="center" bordercolor="#E3E4EF"><strong><font size="+2">宠物知识</font></strong> </td>
  </tr>
  
  <tr>
    <td width="55"  height="21" align="center" bgcolor="#00CC99"><div align="center">编号</div></td>
    <td width="302"  align="center" bgcolor="#00CC99"><div align="center">标题</div></td>
    <td width="132"   align="center" bgcolor="#00CC99"><div align="center">发布时间</div></td>
    <td width="85"  align="center" bgcolor="#00CC99"><div align="center">操作员</div></td>
    <td width="62"   align="center" bgcolor="#00CC99"><div align="center">点击次</div></td>
    <td width="56"  align="center" bgcolor="#00CC99">评论</td>
    <td width="69"   align="center" bgcolor="#00CC99"><div align="center">编辑</div></td>
    <td width="42"  align="center" bgcolor="#00CC99"><div align="center">删除</div></td>
  </tr>
  <%       
      String id = "";
      String isShopping = "出售";      
      boolean isPet = false;
      while(iter.hasNext())
      {
          Lore p = (Lore)iter.next();
          //SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日");
          id = String.valueOf(p.getLoreID());
   %>

  <tr>
    <td height="24" align="center" valign="center" bordercolor="#009900">&nbsp;<%=p.getLoreID()%></td>
    <td align="left" valign="center" bordercolor="#009900"><%=p.getNTitle().replaceAll(keyword,"<font color=\"red\">"+keyword+"</font>")%></td>
    <td align="left" valign="center" bordercolor="#009900">&nbsp;<%=p.getNDateTime()%></td>
    <td align="center" valign="center" bordercolor="#009900">&nbsp;<%=p.getUName()%></td>
    <td align="left" valign="center" bordercolor="#009900">&nbsp; <%=p.getNCount()%> </td>
    <td align="left" valign="center" bordercolor="#009900"><a  title="点击即可管理该新闻的评论信息" href="ctrladmin?page=loreCommeet.jsp?newsid=<%=id%>">评论<%=p.getCommentCount()%></a></td>
    <td align="center" valign="center" bordercolor="#009900"><a href="ctrladmin?editLoreID=<%=id + "&pNo=" + pageNo %>" >编辑</a></td>
    <td align="center" valign="center" bordercolor="#009900"><a href="ctrladmin?delLore=<%=id + "&pNo=" + pageNo %>" onclick="return affirm()" >删除</a></td>
  </tr><font color="FF0000"></font>
  <%       
       }
        if (lPetAll.size() < 1){
  %>
  <tr> 
      <td height="43" colspan="8" > 
          <br>还没有宠物宠物知识! <br>
        <a href="ctrladmin?page=addLore.jsp">点这里添加宠物</a> <br><br>
  <td width="1">  </tr>
  <%
        System.out.println("没有啊 1");
        }
  %>
  <tr align="top">
    <td height="31" colspan="8"  align="left" valign="top" bordercolor="#000000"><table width="828" height="27" border="0">
      <tr>
        <td width="516" height="23"><form action="ctrladmin?page=petLore.jsp" name="form1" id="form1">
          当前页:<%=lPetAll.size()%>条&nbsp;&nbsp;共：<%=petCount%>条&nbsp;&nbsp;<%=pageNo%>/<%=pageCount%>&nbsp;&nbsp; <a href="ctrladmin?page=petLore.jsp?pageNo=1">第一页</a>&nbsp; <%=goPage%>&nbsp; <%=downPage%>&nbsp; <a href="ctrladmin?page=petLore.jsp?pageNo=<%=pageCount%>">尾页</a> &nbsp;&nbsp;转到：
          <select name="page" onchange="document.form1.submit()">
            <%
                  for (int i=1;i<=pageCount; i++){
                  %>
            <option value="<%="petLore.jsp?pageNo=" + String.valueOf(i)%>" <%=(pageNo == i)? "selected":""%> >第<%=i%>页
              <%
                  }
                  %>
              </option>
          </select>
        </form></td>
        <td width="302"><form action="ctrladmin?page=petLore.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>