⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 productlist.jsp

📁 (Java+SQL)-大型企业JAVA的ERP系统
💻 JSP
字号:
<jsp:useBean id="queryProduct" class="src.wuyang.Production" scope="session"/>
<jsp:useBean id="productClass" class="src.wuyang.ProductClass" scope="page" />
<jsp:useBean id="dept" class="src.wuyang.Department" scope="page" />
<jsp:useBean id="global" class="src.com.MyGlobal" scope="session"/>

<% if (global.isLogined == false) {
%>
<jsp:forward page="../pub/DBErr.jsp" > 
	<jsp:param name="rtcode" value="-4" />
</jsp:forward>
<%	}
%>


<html>
<head>
<title>产品列表</title>
<link rel="stylesheet" href="css.css" type="text/css">
</head>

<% 
	int position,state,curPage,totalPage;    
	int numInOnePage = queryProduct.getNumInOnePage();
	queryProduct.listPage(request);
	
	position = queryProduct.listPosition;
        state = queryProduct.state;
        curPage = queryProduct.curPage;
        totalPage = queryProduct.totalPage;

%>

<body bgcolor=#949b93><table width="100%" border="1" height="90%" bordercolorlight="#616860" bordercolordark="#CCCCCC" bgcolor="#4c7171" cellpadding="0" cellspacing="0">
  <tr> 
    <td valign="top">
      <blockquote><br>
        <br>
        <table border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" width="750" cellpadding="0" cellspacing="0">
          <tr bgcolor="#949b93"> 
            <td class="text"> 
              <div align="center"><b>产品编号</b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>产品名称</b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>产品英文名</b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>产品产地</b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>产品类别</b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>产品单位</b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>安全库存量</b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>公司定价</b></div>
            </td>
            <td class="text"> 
              <div align="center"><b>主营部门</b></div>
            </td>
          </tr>
          <%
for(int listCount = 0; listCount < numInOnePage && (queryProduct.next() > 0) ; listCount++) {
		productClass.load(queryProduct.getClassId());
		dept.load(queryProduct.getDeptId());
%>
          <tr> 
            <td class="textb"><%= queryProduct.getProductId() %></td>
            <td class="textb" align="center"><%
            				if ((queryProduct.getProductName()!=null)&&(!queryProduct.getProductName().equals(""))) {
            					out.println(queryProduct.getProductName());}
            				else
            					{out.println("&nbsp;");} %></td>
            <td class="textb" align="center"><%
            				if ((queryProduct.getProductEName()!=null)&&(!queryProduct.getProductEName().equals(""))) {
            					out.println(queryProduct.getProductEName());}
            				else
            					{out.println("&nbsp;");} %></td>
            <td class="textb" align="center"><%
            				if ((queryProduct.getProductAddress()!=null)&&(!queryProduct.getProductAddress().equals(""))) {
            					out.println(queryProduct.getProductAddress());}
            				else
            					{out.println("&nbsp;");} %></td>
            <td class="textb" align="center"><%
            				if ((productClass.getClassDesc()!=null)&&(!productClass.getClassDesc().equals(""))) {
            					out.println(productClass.getClassDesc());}
            				else
            					{out.println("&nbsp;");} %> </td>
            <td class="textb" align="center"><%
            				if ((queryProduct.getUnit()!=null)&&(!queryProduct.getUnit().equals(""))) {
            					out.println(queryProduct.getUnit());}
            				else
            					{out.println("&nbsp;");} %></td>
            <td class="textb" align="right"><%out.println(queryProduct.getAttenQuantity());%></td>
            <td class="textb" align="right"><%out.println(queryProduct.getRefPrice());%></td>
            <td class="textb" align="center"><%
            				if ((dept.getDeptName()!=null)&&(!dept.getDeptName().equals(""))) {
            					out.println(dept.getDeptName());}
            				else
            					{out.println("&nbsp;");} %></td>
          </tr>
          <%
	}
%>
        </table>
        <p> 
          <%    if (position==0&&state==0){ %>
          <span class="textb">页码</span> <%=curPage %>&nbsp<span class="textb">/</span>&nbsp<%=totalPage%> 
          <% } else if (position==0&&state==2){ %>
          <a href="ProductList.jsp?browseMode=next&position=<%=position%>&curPage=<%=curPage%>"><span class="textb">下一页</span></a><span class="textb">&nbsp&nbsp&nbsp页码</span> 
          <%=curPage %>&nbsp<span class="textb">/</span>&nbsp<%=totalPage%> 
          <% } else if (position>0&&state==-1){ %>
          <a href="ProductList.jsp?browseMode=previous&position=<%=position%>&curPage=<%=curPage%>"><span class="textb">上一页</span></a><span class="textb">&nbsp&nbsp&nbsp&nbsp&nbsp页码</span> 
          <%=curPage %>&nbsp<span class="textb">/</span>&nbsp<%=totalPage%> 
          <% } else if (position>0&&state==1){ %>
          <span class="textb"><a href="ProductList.jsp?browseMode=previous&position=<%=position%>&curPage=<%=curPage%>">上一页</a>&nbsp&nbsp<a href="ProductList.jsp?browseMode=next&position=<%=position%>&curPage=<%=curPage%>">下一页</a>&nbsp&nbsp页码</span> 
          <%=curPage %>&nbsp<span class="textb">/</span>&nbsp<%=totalPage%> 
          <% } %>
      </blockquote>
    </td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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