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

📄 productpriceinsertlist.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">
</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" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="1" height="90%" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#616860" bordercolordark="#CCCCCC" bgcolor="#4c7171" class="text">
   <tr>
      <td valign="top" height="554" >
	 <br><br><blockquote> 
        <table width="88%" border="1" bordercolorlight="#000000" bordercolordark="#CCCCCC" cellpadding="0" cellspacing="0">
          <tr bgcolor="#949b93" class="text"> 
            <td width="64" height="37"> 
              <div align="center"><b>产品编号</b></div>
            </td>
            <td> 
              <div align="center"><b>产品名称</b></div>
            </td>
            <td> 
              <div align="center"><b>产品型号</b></div>
            </td>
            <td> 
              <div align="center"><b>产品分类</b></div>
            </td>
            <td> 
              <div align="center"><b>公司定价</b></div>
            </td>
            <td> 
              <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><a href="insertProductPrice.jsp?productId=<%=queryProduct.getProductId()%>&position=<%=position%>&curPage=<%=curPage%>">
	    	<%=queryProduct.getProductId()%></a>
	    </td>
            <td class="textb"><span class="textb"><%
            					if ((queryProduct.getProductName()!=null)&&(!queryProduct.getProductName().equals(""))) {
            						out.println(queryProduct.getProductName());}
            					else
            						{out.println("&nbsp;");} %></span></td>
            <td class="textb"><%
            				if ((queryProduct.getProductDesc()!=null)&&(!queryProduct.getProductDesc().equals(""))) {
            					out.println(queryProduct.getProductDesc());}
            				else
            					{out.println("&nbsp;");} %></td>
            <td class="textb"><%
            				if ((productClass.getClassDesc()!=null)&&(!productClass.getClassDesc().equals(""))) {
            					out.println(productClass.getClassDesc());}
            				else
            					{out.println("&nbsp;");} %> </td>
            <td class="textb"><div align="right"><%= queryProduct.doubleFormat(queryProduct.getRefPrice(),2) %></div></td>
            <td class="textb"><div align="center"><%
            				if ((dept.getDeptName()!=null)&&(!dept.getDeptName().equals(""))) {
            					out.println(dept.getDeptName());}
            				else
            					{out.println("&nbsp;");} %></div></td>
          </tr>
          <%
	}
%> 
        </table>
      
<p>
<%    if (totalPage==1/*position==0&&state==0*/){ %>
         页码 <%=curPage %>&nbsp/&nbsp<%=totalPage%>                     
<% } else if (position==0&&state==2){ %>
	<a href="ProductPriceInsertList.jsp?browseMode=next&position=<%=position%>&curPage=<%=curPage%>">下一页</a>&nbsp&nbsp&nbsp页码 <%=curPage %>&nbsp/&nbsp<%=totalPage%>
<% } else if (position>0&&state==-1){ %>
	<a href="ProductPriceInsertList.jsp?browseMode=previous&position=<%=position%>&curPage=<%=curPage%>">上一页</a>&nbsp&nbsp&nbsp&nbsp&nbsp页码 <%=curPage %>&nbsp/&nbsp<%=totalPage%>
<% } else if (position>0&&state==1){ %>
	<a href="ProductPriceInsertList.jsp?browseMode=previous&position=<%=position%>&curPage=<%=curPage%>">上一页</a>&nbsp&nbsp<a href="ProductPriceInsertList.jsp?browseMode=next&position=<%=position%>&curPage=<%=curPage%>">下一页</a>&nbsp&nbsp页码 <%=curPage %>&nbsp/&nbsp<%=totalPage%>
<% } else { %>
	<a href="ProductPriceInsertList.jsp?browseMode=next&position=<%=position%>&curPage=<%=curPage%>">下一页</a>&nbsp&nbsp&nbsp页码 <%=curPage %>&nbsp/&nbsp<%=totalPage%>
<% } %>	</blockquote>
</td>
</tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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