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

📄 queryproduct.jsp

📁 (Java+SQL)-大型企业JAVA的ERP系统
💻 JSP
字号:
<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>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<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>
              <form method="post" action="ProductQuery.jsp">
                
          <table border="0" bordercolorlight="#000000" bordercolordark="#CCCCCC">
            <tr> 
              <td valign="top" height="15"> <b> 
                <input type="hidden" name="queryMode" value="1"/>
                <span class="textb"> 产品编号:</span> <br>
                </b></td>
              <td valign="top" height="15"> 
                <input type="text" name="productId" />
                &nbsp; &nbsp; &nbsp; </td>
            </tr>
            <tr> 
              <td valign="top" height="15"><b><span class="textb">产品名称:</span> 
                <br>
                </b></td>
              <td valign="top" height="15"> 
                <input type="text" name="productName" />
              </td>
            </tr>
            <tr> 
              <td valign="top"><b><span class="textb">产品英文名:</span> <br>
                </b></td>
              <td valign="top"> 
                <input type="text" name="productEName" />
              </td>
            </tr>
            <tr> 
              <td valign="top"><b><span class="textb">产品类别:</span> <br>
                </b></td>
              <td valign="top"> 
                <select name="classId">
                  <option value="">所有</option>
                  <%
		productClass.query("","");
		while(productClass.next()== 1 ) {
%>
                  <option value="<%=productClass.getClassId()%>"> <%=productClass.getClassDesc()%> 
                  </option>
                  <%
		}
%>
                </select>
              </td>
            </tr>
            <tr> 
              <td valign="top"><b><span class="textb">产品产地: </span><br>
                </b></td>
              <td valign="top"> 
                <input type="text" name="productAddress" />
              </td>
            </tr>
            <tr> 
              <td valign="top"><b><span class="textb">主营部门: </span> </b> </td>
              <td valign="top"> 
                <select name="deptId">
                  <option value="">所有</option>
                  <%
		dept.query("","");
		while(dept.next()== 1 ) {
%>
                  <option value="<%=dept.getDeptId()%>"> <%=dept.getDeptName()%> 
                  </option>
                  <%
		}
%>
                </select>
              </td>
            </tr>
            <tr align="center"> 
              <td valign="top" colspan="2"> 
                <input type="submit" name="Submit" value="提交">
                <input type="reset" name="Submit2" value="重置">
              </td>
            </tr>
          </table>
        </form>
           
      </blockquote>
    </td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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