recfinigoods.jsp

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

JSP
92 行
字号 
<%@ 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 a=1;%>
<form action="./FinRec_Process.jsp " name="form118" 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 fin_recieved2 ");
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 itemnumber from im_finigoods ");
 %>

<% Class.forName("oracle.jdbc.driver.OracleDriver");
 Connection con3=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:india","scott","tiger");
Statement stmt3=con3.createStatement();
 ResultSet rs3=stmt3.executeQuery("select deptname from dept_det ");
 %>



<div align="center"> 
  <p><strong><font color="#FFFFFF" size="5">INVE</font><font color="#FFFFFF" size="5">NTORY 
    CONTROL SYSTEM </font></strong></p>
  <p><font color="#FFFFFF"><strong><font size="4">RECEIPTS(FINISHED GOODS)</font></strong></font></p>
  <strong><font color="#FFFFFF"></font></strong> 
  <table width="62%" border="0">
    <tr> 
      <td width="33%"><div align="right"><font color="#FFFFFF"><strong>S.No :</strong></font></div></td>
      <td width="67%"><input type="text" name="sno" value=<%=a%> readonly></td>
    </tr>
    <tr> 
      <td><div align="right"><font color="#FFFFFF"><strong>Item No :</strong></font></div></td>
      <td><select name="itemnumber" id="itemnumber">

<%while(rs2.next())
{
 %>
<option value=<%=rs2.getInt(1)%>><%=rs2.getInt(1)%></option>
<%
}
%>
</select></font></strong></td>
    </tr>
    <tr> 
      <td><div align="right"><font color="#FFFFFF"><strong>Qty Received :</strong></font></div></td>
      <td><input type="text" name="qtyrec"></td>
    </tr>
    <tr> 
      <td><div align="right"><font color="#FFFFFF"><strong>Date Of Receipt :</strong></font></div></td>
      <td><input type="text" name="dateofrec"></td>
    </tr>
    <tr> 
      <td><div align="right"><font color="#FFFFFF"><strong>From Dept Name :</strong></font></div></td>
      <td><select name="fdname"  id="fdname" >

<%while(rs3.next())
{
 %>
<option value=<%=rs3.getString(1)%>><%=rs3.getString(1)%></option>
<%
}
%>
</select></font></strong></td>
    </tr>
    <tr> 
      <td><div align="right"><font color="#FFFFFF"><strong>Receipt No :</strong></font></div></td>
      <td><input type="text" name="recno"></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><strong><font size="4"></font></strong></p>
  <p>&nbsp; </p>
</div>
</form>
</body>
</html>

recfinigoods.jsp - 源码说明

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

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

⌨️ 快捷键说明

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