📄 find_spxx.jsp

📁 web版的进销存系统
💻 JSP
字号:
<%@page contentType="text/html; charset=GBK" language="java"  errorPage="" %>
<jsp:useBean id="list1" scope="page" class="jxc.web.Lists" />

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">

<title></title>

<link rel="stylesheet" href="../other/customer.css">
</head><body>

<% String selfweb="find_spxx"; %>

      <table width="100%" cellspacing="1" >
        <tr> 
          <td height="100%" colspan="2"> 
		     <table width="100%" cellspacing="1" bgcolor="#86c2fe"> 
              <tr bgcolor="#D8EBF5" class="big_b"> 
                <td class="small" width="35%"> <div align="center">物品类别</div></td>
                <td class="small" width="40%"> <div align="center">物品名称</div></td>
                <td class="small" width="35%"> <div align="center">物品编号</div></td>
              </tr>
<%
  int PageSize=15;
  int ShowPage=1;
  int PageCount=0;

  String Page=request.getParameter("page");
  String wptypeID=request.getParameter("id");//得到传递的物品类别ID
  if (Page!=null)
  {
    ShowPage=Integer.parseInt(Page);
  }
 list1.setPageSize(PageSize);
 list1.setPage(ShowPage);
 if(wptypeID != null)
 {
 if(wptypeID.equals("all"))
 {
 list1.setSql("wpb");
 }
 else
 {
 list1.setSql("wpb where wppath like '%," + wptypeID + "%,'");
 }
 }
 else
 {
 list1.setSql("wpb");
 }
  if (list1.excute()){ 
   ShowPage=list1.getPage();
   PageCount=list1.getPageCount();
   PageSize=list1.getPageSize();  
   
				for (int i=0;i<PageSize;i++){ 
					
						String Color="#Ffffff";//"#F4F4E0";
						  if (i % 2==0)
							Color="#F6f6f6"; 
						  
					if (i<list1.getListCount()) {
						list1.setRow(i);
						String id=list1.getString("id");																							
					%>
              <tr bgcolor=<%=Color%> > 
                <td class='small' ><%=list1.getString("wptypename")%></td>
                <td class='small' ><%=list1.getString("wpname")%></td>
                <td class='small' ><%=list1.getString("wpbh")%></td>
             </tr>                
 				 <%              
  						}else{
  				 %>
              <tr bgcolor=<%=Color%> > 
                <td class='small' >&nbsp;  </td>
                <td class='small' >&nbsp;  </td>
                <td class='small' >&nbsp;  </td>			   
              </tr> 
				  <%
					}

	} 
	 }
		  %>
			  
			  </table></td>
        </tr>
        <tr> 
          <td class="small" width="23%" > 
            <div align="left">[<%=ShowPage%>/<%=PageCount%>页] </div> <div align="left"> [共<%=list1.getRecordCount()%>条记录 每页<%=PageSize%>条]</div>
          </td>
          <td class="small" width="77%" > 
            <div align="right" >
            <a href="<%=selfweb%>.jsp?">第一页 </a>
			<% if (ShowPage==1)
               out.println("<img  border='0' src='../images/1-prev.gif'>");  
			   else {
			    %>
			<a href="<%=selfweb%>.jsp?page=<%=ShowPage-1%>"><img border="0" src="../images/1-prev.gif"> </a>
                <% }
				 if (ShowPage==PageCount)
                 out.println("<img border='0' src='../images/1-next.gif'>");  
                 else {%>
			<a href="<%=selfweb%>.jsp?page=<%=ShowPage+1%>"><img border="0" src="../images/1-next.gif"> </a>
           <% } %>
			<a href="<%=selfweb%>.jsp?page=<%=PageCount%>">最后一页 </a>
            </div>
          </td>
        </tr>
      </table>
</body></html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -