receipts.jsp

来自「This project mainly deals with automatin」· JSP 代码 · 共 89 行

JSP
89 行
字号 
<%@ page  language="java" import="java.sql.*,javax.servlet.*,javax.servlet.http.*,java.io.*,java.util.*" %>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#20099CC">
<%! int b,a=1; %>
<form action="./rawrec_process.jsp "  name="form20"  method="post">
<% Class.forName("oracle.jdbc.driver.OracleDriver");
 Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:india","scott","tiger");
Statement stmt=con.createStatement();
 ResultSet rs=stmt.executeQuery("select max(sno) from raw_recieved where sno<40 ");
while(rs.next())
{
 a=rs.getInt(1);  } %><% a=a+1; %>



<% Class.forName("oracle.jdbc.driver.OracleDriver");
 Connection con2=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:india","scott","tiger");
Statement stmt2=con2.createStatement();
 ResultSet rs2=stmt2.executeQuery("select itemno from im_rawmaterial2 order by itemno ");
 %>

<div align="center">
  <p><strong><font color="#FFFFFF" size="5">INVENTORY CONTROL SYSTEM </font></strong></p>
  <p><font color="#FFFFFF" size="4"><strong>RAW RECEIPTS</strong></font> </p>
  <table width="53%" border="0">
    <tr> 
      <td width="32%"><strong><font color="#FFFFFF">S.No :</font></strong></td>
      <td width="68%"><strong><font color="#FFFFFF"> 
        <input type="text" name="sno" id="sno" value=<%=a%> readonly>
        </font></strong></td>
    </tr>
    <tr> 
      <td><strong><font color="#FFFFFF">Item No :</font></strong></td>
      <td><strong><font color="#FFFFFF"> <select name="itemno" id="itemno">

<%while(rs2.next())
{
 %>
<option value=<%=rs2.getInt(1)%>><%=rs2.getInt(1)%></option>
<%
}
%>
</select></font></strong></td>
    </tr>
    <tr> 
      <td><strong><font color="#FFFFFF">Qty Ordered :</font></strong></td>
      <td><strong><font color="#FFFFFF"> 
        <input type="text" name="qtyord" id="qtyord">
        </font></strong></td>
    </tr>
    <tr> 
      <td><strong><font color="#FFFFFF">Qty Received :</font></strong></td>
      <td><strong><font color="#FFFFFF"> 
        <input type="text" name="qtyrec" id="qtyrec">
        </font></strong></td>
    </tr>
    <tr> 
      <td><strong><font color="#FFFFFF">Date Of Receipt :</font></strong></td>
      <td><strong><font color="#FFFFFF"> 
        <input type="text" name="dateofrec" id="dateofrec">
        </font></strong></td>
    </tr>
    <tr> 
      <td><strong><font color="#FFFFFF">Receipt No:</font></strong></td>
      <td><strong><font color="#FFFFFF"> 
        <input type="text" name="recno" id="recno">
        </font></strong></td>
    </tr>
    <tr> 
      <td><strong><font color="#FFFFFF">Amount :</font></strong></td>
      <td><strong><font color="#FFFFFF"> 
        <input type="text" name="amount" id="amount">
        </font></strong></td>
    </tr>
  </table>
  <p> 
    <input type="submit" name="Submit" value="Submit">
    <input name="Reset" type="reset" id="Reset" value="Reset">
    <a href="Clerk.jsp">HOME </a></p>
  <p>&nbsp;</p>
</div>
</form>
</body>
</html>

receipts.jsp - 源码说明

本页面展示了「This project mainly deals with automating the tasks of Purchasing, maintaining,manfactioring and tra」中的 receipts.jsp 源码文件，采用 JSP 编程语言编写，共 89 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与manfactioring相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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